Why cannot I insert records using the insert statement in php? Code:
$ Connec = mysql_connect ('localhost', 'root', 'root'); if (! $ Connec) {die ('could not connect :'. mysql_error ();} mysql_query ("set names 'utf8'"); mysql_select_db ('guestbook', $ connec); $ SQL = "insert into yl (title, author, email, content, ip, 'date') values ('Haha ', 'php', '2017 @ qq.com', 'who', '2017. 1.1.1 ', '2014-5-6') "; echo $ SQL; mysql_query ($ SQL) or die ('failed ');
I just learned how to write code in the book after learning php. Why can't I succeed ??? Tutorial
Reply to discussion (solution)
$ SQL = "insert into yl (title, author, email, content, ip, 'date') values ('haha', 'php', '2017 @ qq.com ', 'whe', '2017. 1.1.1 ', '2014-5-6 ')";
The escape character of the date field is not a single quotation mark, but the character above the tab key.
Thank you for solving this problem. you are right, but I did not match the table column name.