Php and Mysql no table added

Question

i am new to php and mysql. i am now having online tutorials for this topic. i use wamp and already created various databases without tables in it yet. now i created a file createTable.php with these line of codes:

<?php
mysql_connect("localhost", "admin", "1admin") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
mysql_query("CREATE TABLE example(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
name VARCHAR(30), 
age INT)")
 or die(mysql_error());  

echo "Table Created!";
?>

in this code i create a table named example. now when i check inside phpmyAdmin in wamp the example table is not added on the test database. what's the problem with my code? or is it the WAMP?

Please, don't use mysql_* functions to write new code. They are no longer maintained and the community has begun deprecation process. See the red box? Instead you should learn about prepared statements — NullPoiиteя
– NullPoiиteя, Commented Oct 23, 2012 at 7:18
and use either PDO or MySQLi. If you can't decide which, this article will help you. If you pick PDO, here is good tutorial. Also see Why shouldn't I use mysql functions in PHP? — NullPoiиteя
– NullPoiиteя, Commented Oct 23, 2012 at 7:19
Also post any error messages, and ensure that your SQL works in MySQL console. — Devraj
– Devraj, Commented Oct 23, 2012 at 7:19
@NullPointer is totally right... First please check that your DB connection is effectively made. — Laurent Brieu
– Laurent Brieu, Commented Oct 23, 2012 at 7:22

Prem · Accepted Answer · 2012-10-23 07:31:56Z

1

I tried your code and see its running, just make some changes it it. while you using wamp then try this code.

<?php 
    mysql_connect("localhost", "root", ""); 
    mysql_select_db("test"); 
    mysql_query("CREATE TABLE example( id INT NOT NULL AUTO_INCREMENT,  PRIMARY KEY(id), name VARCHAR(30),  age INT)");    
    echo "Table Created!"; 
?>

answered Oct 23, 2012 at 7:31

Prem

7073 silver badges10 bronze badges

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

1 Comment

clydewinux Over a year ago

thanks so much this code works.. :-) should i use mysql or mysqli?

SRIRAM · Accepted Answer · 2012-10-23 07:25:16Z

0

mysql_connect("localhost", "admin", "1admin") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
mysql_query("CREATE TABLE 'example'(
'id'    INT   NOT NULL AUTO_INCREMENT, 
'name'  VARCHAR(30), 
'age'   INT,
 PRIMARY KEY('id'))
  ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;")
 or die(mysql_error());

echo "Table Created!";

answered Oct 23, 2012 at 7:25

SRIRAM

1,8982 gold badges17 silver badges18 bronze badges

Collectives™ on Stack Overflow

Php and Mysql no table added

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related