PHP/MYSQL: table was not created in wamp server

Question

when I run this php file in my wamp server it connects to database, selects database but not create table . the output is this:

connected to database succussfully.
connected to database store_db succussfully.
table users was not created.

what is the problem???

php code:

<?php
$sql='CREATE TABLE users
(
PID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(PID),
NAME CHAR(20),
PASSWORD CHAR(15),
)';

mysql_connect("localhost","root","") or die('could not connect to database.');
echo 'connected to database succussfully.<br>';

mysql_select_db('store_db') or die('database store_db not found.');
echo 'connected to database store_db succussfully.<br>';

mysql_query($sql) or die('table users was not created');
echo 'table users was created in database store_db succussfully.<br>';

?>

Community · Accepted Answer · 2023-11-17 20:38:18Z

3

<?php
$sql='CREATE TABLE users
(
PID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(PID),
NAME CHAR(20),
PASSWORD CHAR(15),
)';

remove the comma after PASSWORD CHAR(15),

in the event of an error, you can always retrieve errors using mysql_error().

however. you should not be using the old mysql functions. much better and more secure options exist in the PDO and MySQLi extensions.

edited Nov 17, 2023 at 20:38

CommunityBot

11 silver badge

answered Feb 11, 2014 at 22:49

castis

8,2144 gold badges45 silver badges66 bronze badges

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

Comments

tomtam · Accepted Answer · 2014-02-11 22:49:53Z

1

Your $sql:

$sql='CREATE TABLE users
(
PID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(PID),
NAME CHAR(20),
PASSWORD CHAR(15),
)';

should be:

$sql='CREATE TABLE users
(
PID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(PID),
NAME CHAR(20),
PASSWORD CHAR(15)
)';

You should remove comma right after PASSWORD CHAR(15)

answered Feb 11, 2014 at 22:49

tomtam

212 silver badges7 bronze badges

Comments

sud_shan · Accepted Answer · 2014-02-11 22:53:03Z

0

To get the proper error message always use below code so that you can figure out exact error in future.

mysql_query($sql) or die(mysql_error());

answered Feb 11, 2014 at 22:53

sud_shan

3033 silver badges12 bronze badges

1 Comment

sud_shan Over a year ago

Instead of guessing just use code similar to above ,so that you may figure out exact error.

Quixrick · Accepted Answer · 2014-02-11 22:54:37Z

0

Make sure the MySQL user you are attempting to create the table with has permissions to do so. (e.g. the user has been granted the 'CREATE' privileges for that database.)

answered Feb 11, 2014 at 22:54

Quixrick

3,2101 gold badge16 silver badges17 bronze badges

Collectives™ on Stack Overflow

PHP/MYSQL: table was not created in wamp server

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related