php为什么数据库连接正确，却插入不了数据

Question

<?php
header("Content-type: text/html; charset=UTF-8");
require('../wx/connect.php');
//把信息入库,在入库之前对所有的信息进行校验
if(!(isset($_POST['title'])&&(!empty($_POST['title'])))){
echo"alert(&#39;标题不能为空&#39;);window.localhost.href=&#39;zeng.php&#39;";
}
$title = $_POST['title'];
$description = $_POST['description'];
$word = $_POST['word'];
$dateline = time();
$sql ="insert into article(title,description,word) values('$title', '$description', '$word')";
//var_dump($sql);在这里var_dump是可以输出上个网页输入的内容
// echo $insertsql;
//alert(&#39;祝福语发布成功&#39;);window.localhost.href=&#39;zeng.php&#39; $dateline
$result = mysql_query($sql);
if ($result){
echo "alert(&#39;恭喜你&#39;);window";
}else{
echo"alert(&#39;sorry&#39;);/*history.go(-1);*/";
}
?>

Answer 1

看看你网页的代码：
$sql="insert into 'test'('id','title','dates','contents')values(null,'$title',now(),'$content')";
mysql_query($sql);
echo "插入成功";
你这个代码插入成功失败都会显示成功，没有真正判断是否插入成功，一般应该这样写：
$sql="insert into test(id,title,dates,contents)values(null,'$title',now(),'$content')";
if (mysql_query($sql)) echo "插入成功";
else echo "插入失败，SQL:$sql
错误：".mysql_error();