/* * Created on 2012-4-6 * * To change the template for this generated file go to * 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 "发表成功"; } ?>
用户:
标题:
内容:
sql语句
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 ;
不知道是哪里出了问题,一直插入不进数据。。
------解决方案-------------------- $sql="insert into message(id,user,title,content,lastdate)" . "values('','$_POST[user]','$_POST[title]','$_POST[content]',now())";