<?php
header("Content-type: text/html; charset=UTF-8");
require('../wx/connect.php');
//把信息入库,在入库之前对所有的信息进行校验
if(!(isset($_POST['title'])&&(!empty($_POST['title'])))){
echo"alert('标题不能为空');window.localhost.href='zeng.php'";
}
$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('祝福语发布成功');window.localhost.href='zeng.php' $dateline
$result = mysql_query($sql);
if ($result){
echo "alert('恭喜你');window";
}else{
echo"alert('sorry');/*history.go(-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();
这个是数据库用户名没权限