SQL query into phpmyadmin - error in syntax

Question

I'm trying to create an email validation for user registration.

I am following step by step instructions but i am bogged down in something that should be quite simple.

I am supposed to insert the following into a database using a MySql query:

mysql_query("INSERT INTO users (username, password, email, hash) VALUES(
'". mysql_escape_string($name) ."',
'". mysql_escape_string(md5($password)) ."',
'". mysql_escape_string($email) ."',
'". mysql_escape_string($hash) ."') ") or die(mysql_error());

I am using WAMP server. I went to my database, selected the table, inserted the above after selecting the SQL tab, clicked go and got the response:

"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_query("INSERT INTO users (username, password, email, hash) VALUES( '". m' at line 1"

I can never seem to insert queries into the phpMyAdmin databases without getting some sort of error. I'm hoping someone can shed some light on this to give me an outside view.

Needless to say, i would be grateful for any input. I am new to this and at my wits end.

You are mixing PHP and SQL. MySQL only understand the SQL part and you are trying to force PHP down its throat. Separate your SQL from the PHP — codingbiz
– codingbiz, Commented Oct 29, 2012 at 22:39
@MatM yeah I am noticing it now that the title has been changed. My bad :) — bikedorkseattle
– bikedorkseattle, Commented Oct 29, 2012 at 22:52

Mat M · Accepted Answer · 2012-10-30 00:01:26Z

1

As Prash said, mysql_query and mysql_escape_string are php functions beside their names. When pasting into the SQL tab of phpMyAdmin, you should remove the mysql_query() which represents PHP call to MySQL db and convert mysql_escape_string calls to the computed values of variables ($...). It should give you something like:

INSERT INTO users (username, password, email, hash) VALUES(
'SampleName',
md5('SamplePassword'),
'[email protected]',
'SampleHash')

You need to escape by yourself if there are special chars in values)

edited Oct 30, 2012 at 0:01

answered Oct 29, 2012 at 22:48

Mat M

1,93426 silver badges31 bronze badges

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

Comments

purpletree · Accepted Answer · 2012-10-29 22:33:57Z

1

You can't use PHP functions in SQL. Run the PHP code instead

answered Oct 29, 2012 at 22:33

purpletree

1,9633 gold badges20 silver badges32 bronze badges

Collectives™ on Stack Overflow

SQL query into phpmyadmin - error in syntax

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related