Creating a table using mysqli and php

Question

The table is not created in the database Users and there is no error message at all. PhpMyAdmin is set to allow no password, just to be clear on that point.

CREATE TABLE Users(
    ID string(255) NOT NULL,
    FirstName string(255) NOT NULL,
    Surname string(255) NOT NULL,
    DOB date(10) NOT NULL
)

does the query work if you run it directly in MySQL (e.g. via WorkBench)? — ADyson
– ADyson, Commented Sep 25, 2017 at 8:55
Mysql does not know "string". You will have to use "varchar". The date field does not need a defined length. You can leave that out. The create table query will work like this: CREATE TABLE Users( ID varchar(255) NOT NULL, FirstName varchar(255) NOT NULL, Surname varchar(255) NOT NULL, DOB date NOT NULL ) — S.Gartmeier
– S.Gartmeier, Commented Sep 25, 2017 at 8:57
Thanks @ADyson for suggesting I run it separately, as it did give an error, I just didn't know what the error was. — Sir Dog Man Thing
– Sir Dog Man Thing, Commented Sep 25, 2017 at 9:06

Ashish Patel · Accepted Answer · 2020-08-07 13:10:21Z

3

your query should be like this.

$mySql = CREATE TABLE Users(
         ID VARCHAR(255) NOT NULL,
         FirstName VARCHAR(255) NOT NULL,
         Surname VARCHAR(255) NOT NULL,
         DOB date NOT NULL
    )";

MySQL can't understand string. pass varchar instead of a string.
you don't need to assign the length of date.

edited Aug 7, 2020 at 13:10

answered Sep 25, 2017 at 9:02

Ashish Patel

6335 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Creating a table using mysqli and php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related