PHP Create table does nothing

Asked Feb 15 '21 at 17:28

Active Feb 15 '21 at 17:53

Viewed 23 times

I can't create a table from PHP code. Every time I check in phpMyAdmin, I can see the database but not the table. I've tried different solutions but no one worked.

$con = mysqli_connect('localhost', 'root', '', 'dbprova');

mysqli_query($con, "CREATE TABLE Employees 
(employee_id INT, first_name VARCHAR(50), last_name  VARCHAR(50)");

edited Feb 15 '21 at 17:53

nbk

45,398
8
30
47

asked Feb 15 '21 at 17:28

Max

try check for error like in the example https://www.php.net/manual/en/mysqli.query.php – Anurat Chapanond Feb 15 '21 at 17:47
2

You have a typo. Enable error checking and you will see the error similar to "Syntax error near". Hint: count your brackets – Dharman Feb 15 '21 at 17:54
1

there is missing a parentheses at the end of the command – nbk Feb 15 '21 at 17:55

PHP Create table does nothing

0 Answers0