MySQL Query: How can I add a user to my MySQL database with PHP

Question

How can I add a user to my MySQL database with PHP. This doesn't add a user.

mysql_query("INSERT INTO users (name, password, realname) 
            VALUES ('$myusername', '$mypassword', '$myrealname'");

What seems to be the problem with my query?

Johan · Accepted Answer · 2011-05-28 19:36:28Z

6

You forgot the closing bracket for VALUES

mysql_query("INSERT INTO users (name, password, realname) 
            VALUES ('$myusername', '$mypassword', '$myrealname')");

Johan

77.4k28 gold badges204 silver badges346 bronze badges

answered Jan 20, 2011 at 23:34

Dr.Molle

117k16 gold badges200 silver badges206 bronze badges

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

Comments

Marko · Accepted Answer · 2011-01-20 23:48:36Z

1

By the way, this code looks dangerous. You escaped everything before to prevent SQL injection, or you are in a very save environment?

answered Jan 20, 2011 at 23:48

Marko

5221 gold badge4 silver badges18 bronze badges

Bat_Programmer · Accepted Answer · 2011-01-20 23:35:11Z

-1

Your double quotes should be after the closing bracket.

answered Jan 20, 2011 at 23:35

Bat_Programmer

6,85110 gold badges60 silver badges70 bronze badges