PHP update syntax error for SQL query

Asked Aug 06 '18 at 13:20

Active Aug 06 '18 at 17:22

Viewed 34 times

Below is my code I have check many times to ensure that is no error but the chrome keep give me an error:

Fatal error: Uncaught exception 'mysqli_sql_exception' with message '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 '@gmail.com, Account_Title=Mr, Account_Dob=2018-08-09, Account_Phone1=123, Accoun' at line 1' in C:\wamp64\www\TAO\UserProfileupdate.php on line 15

May I know what is this mean by ?

$sql = "UPDATE account_info 
  SET Account_Email=$email, Account_Title=$title, Account_Dob=$dob,
      Account_Phone1=$phoneno, Account_Phone2=$sphoneno,
      Account_Home_No=$homeno, Account_Office_No=$officeno";

edited Aug 06 '18 at 17:22

The Impaler

38,638
7
30
65

asked Aug 06 '18 at 13:20

game symbol

1

Learn to use parameters rather than munging query strings with constant values. – Gordon Linoff Aug 06 '18 at 13:20
Use prepared statements. The issues will be solved. Strings in SQL need to be quoted is the short answer. – user3783243 Aug 06 '18 at 13:21
Those are strings, not integers and they require to be quoted. – Funk Forty Niner Aug 06 '18 at 13:21
You also probably want a `WHERE` clause or all your records will be updated. – user3783243 Aug 06 '18 at 13:22
omg.....I look at this query for an hour now only I know that this small mistake I make...... – game symbol Aug 06 '18 at 13:23
thanks so much....!!! – game symbol Aug 06 '18 at 13:24

PHP update syntax error for SQL query

0 Answers0