PHP開發(fā) 新聞發(fā)布系統(tǒng)之發(fā)布PHP頁面
創(chuàng)建 new_post.php ?文件
接收?new.html 頁面?zhèn)鬟^來的數(shù)據(jù)，將數(shù)據(jù)保存到數(shù)據(jù)庫中
代碼如下
<?php
header("content-type:text/html;charset=utf8");
$title=$_POST['title'];
$content=$_POST['content'];
$time=date("y-m-d H:i:s");
$conn=mysqli_connect("localhost","root","root","News");
mysqli_set_charset($conn,'utf8'); //設(shè)定字符集
if($conn){
$sql= "insert into new(title,content,cre_time) values('$title','$content','$time')";
$que=mysqli_query($conn,$sql);//執(zhí)行sql語句
if($que){
echo "<script>alert('發(fā)布成功，返回新聞列表頁');location.href='new_list.php';</script>";
}else{
echo "<script>alert('發(fā)布失敗');location='" . $_SERVER['HTTP_REFERER'] . "'</script>";
exit;
}
}
else{
die("數(shù)據(jù)庫連接失敗" .mysqli_connect_error());
}
?>提示：上面代碼中$time=是獲取當(dāng)前的時間
當(dāng)我們發(fā)布新聞成功之后會返回新聞列表頁new_list.php
