$db=mysql_connect('localhost','root','','news1');$query="insert into news (title,author,datetime,content)values('$title','$author','$datetime','$content')";
$result=mysql_query($query);if($result){
echo mysql_affected_rows()."row(s) insert into database.";}
else{
echo "An error has occurred.The item was not added.";}输入相关的值之后,输出的结果总是An error has occurred.The item was not added 是什么原因应该怎么修改呢?谢谢~
$db = mysql_select_db('news1',$conn);还是An error has occurred.The item was not added 而且用了这两个mysql_free_result($result);
mysql_close($db);
还出现了Warning: mysql_free_result() expects parameter 1 to be resource;Warning: mysql_close() expects parameter 1 to be resource,= =
谢谢~
mysql_select_db('news1', $db) or die ('数据库连接失败');
........
是$datetime变量好像有问题,把这个变量去掉了就行了。
谢谢啦~我第一次写,学到了很多东西\(≧▽≦)/