How to create a MySQL table in PHP?

Question

I am trying to create a cars table in MySQL, here is my code:

<?php

$sql = "CREATE TABLE cars (
    regnr varchar(10),
    make varchar(30),
    yearmodel int,
    mileage int
)";

if (mysqli_query($connection, $sql)) {
    echo '<p>Table created</p>';
} else {
    echo '<p>Failed: check the sql: ';
    echo $sql;
}

?>

But it resulted in an error:

Connection ok
Failed: check the sql: CREATE TABLE cars ( regnr varchar(10), make varchar(30), yearmodel int, mileage int)

How can I make this code works?

You're not setting `$connection` in this script. Are you including it? — Jay Blanchard, Jul 23 '20 at 16:52
Try showing the actual error - `mysqli_error($connection);` to see why it failed. — Nigel Ren, Jul 23 '20 at 17:01
@JayBlanchard Yeah I have included it in another file this is a snippet without the code include 'test1.php' — Chi Le, Jul 23 '20 at 17:04
Then your problem is in your connection. You should always specify a database. — Jay Blanchard, Jul 23 '20 at 17:05

score 0 · Answer 1 · answered Jul 23 '20 at 17:27

0

You could try it like this. Replace _DATABASE_ with the name of the database you want to create the table in

$sql = "CREATE TABLE _DATABASE_.cars (
    regnr varchar(10),
    make varchar(30),
    yearmodel int,
    mileage int
)";

answered Jul 23 '20 at 17:27

Hendrik

167
7

How to create a MySQL table in PHP?

1 Answers1