Php cannot submit data to the database. php database mysql
Include ("connection. php ");
If (isset ($ _ POST ["sub"]) {
$ Title = $ _ POST ['title'];
$ Con = $ _ POST ['con '];
$ SQL = "insert into 'new' ('id', 'title', 'dates', 'contents') values (null, '$ title', now (), '$ con ')";
Mysql_query ($ SQL );
Echo "inserted successfully"; // data is not input to the database after submission
} Else {
Echo "insertion failed". mysql_error ();
}
?>
Reply to discussion (solution)
Mysql_query ($ SQL) or die (mysql_error (); // whether an error is reported
An error is reported. I know that the id cannot be null, but my phpmyadmin does not automatically increment. what should I do?
Mysql_query ($ SQL) or die (mysql_error (); // whether an error is reported
Yes, but how can we solve the problem without incremental items?
The id is the primary key, and the inserted data is auto-incrementing ..
Auto_increment attribute
Thank you for finding out that the new phpmyadmin version is A_ I and the problem has been solved.