FAQs about mysql data insertion

Question about mysql data insertion: conn. php & lt ;? Php/* & nbsp; * Createdon2012-4-5 & nbsp; * Tochangethetemplateforthisgeneratedfilegoto & nbsp; * Window-Prefe ask for a mysql data insertion problem

Conn. php

/*
* Created on 2012-4-5 4-5
*
* To change the template for this generated file go
* Window-Preferences-PHPeclipse-PHP-Code Templates
*/

$ Conn = @ mysql_connect ("localhost", "root", "") or die ("database link error ");
Mysql_select_db ("bbs", $ conn );
Mysql_query ("set names 'gbk'"); // use GBK Chinese encoding;
?>





Add. php

/*
* Created on 2012-4-6
*
* To change the template for this generated file go
* Window-Preferences-PHPeclipse-PHP-Code Templates
*/
Include ("conn. php ");
If ($ _ POST ['submit ']) {
$ SQL = "insert into message (id, user, title, content. lastdate )".
"Values ('', '$ _ POST [user]', '$ _ POST [title]', '$ _ POST [content]', now ())";
Mysql_query ($ SQL );
Echo "published successfully ";
}
?>





SQL statement

Create table 'message '(
'Id' tinyint (1) not null auto_increment,
'User' varchar (25) not null,
'Title' varchar (50) not null,
'Content' tinytext not null,
'Lastdate' date not null,
Primary key ('id ')
) ENGINE = InnoDB default charset = gbk AUTO_INCREMENT = 1;

I don't know what went wrong. I can't insert data until now ..




------ Solution --------------------
$ SQL = "insert into message (id, user, title, content, lastdate )".
"Values ('', '$ _ POST [user]', '$ _ POST [title]', '$ _ POST [content]', now ())";

Content and lastdate are written.