PHP Mysqli query constantly returns false

Question

I am trying to create the database tables with the mysqli interface in PHP, however the query call always returns false and the database remains empty (no tables). I don't know what's wrong with this function, I also checked to make sure the database connection was successful and it was.

$connection->query('CREATE TABLE IF NOT EXISTS users (
name VARCHAR(20) NOT NULL,
hash VARCHAR NOT NULL
)');

This is where showing mysqli errors is very helpful.

IncredibleHat
– IncredibleHat

2017-12-17 18:11:52 +00:00
Commented Dec 17, 2017 at 18:11 — IncredibleHat
– IncredibleHat, Commented Dec 17, 2017 at 18:11
You need to define a size/length for the hash varchar

Mark Baker
– Mark Baker

2017-12-17 18:12:46 +00:00
Commented Dec 17, 2017 at 18:12 — Mark Baker
– Mark Baker, Commented Dec 17, 2017 at 18:12

RamC · Accepted Answer · 2017-12-17 18:27:55Z

4

Your query has a syntax error and hence it is returning as false.

You had missed to add the varchar size of the hash column.

corrected query

$connection->query('CREATE TABLE IF NOT EXISTS users (
    name VARCHAR(20) NOT NULL,
    hash VARCHAR(255) NOT NULL
)');

edited Dec 17, 2017 at 18:27

answered Dec 17, 2017 at 18:15

RamC

1,2851 gold badge11 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP Mysqli query constantly returns false

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related