?? ??(2)
??? ???? PHP ??? ???????.
???? ????? ??????? ???? ??? ? ?? ??? ?? ??????? ???? ????.
<?php
$link = mysqli_connect("localhost","root","root","joke");
if (!$link) {
die("連接失敗: " . mysqli_connect_error());
}
?>??? ??? ???? ??????? ??? ?? ???? ? ??? ???? ??? ?? ? ????. ???? ??? ??? ?? ??? ? ????. ?? ?? ??? config.php? ???? ??? ??? ???? ???.
?? ??? ??? ?? ?? ????? ??? ?? ?? ????. ?? ??? ?????.
??? ???? ? ?? ?? ??? ???? ??????? ???? ???? ????. ?? ?? ? ?? ????.
<?php
if($_POST){
date_default_timezone_set("PRC"); //設(shè)置時(shí)區(qū)
$author = isset($_POST['author'])?$_POST['author']:""; //獲取表單傳遞過來的值
$content = isset($_POST['content'])?$_POST['content']:"";
$cid = isset($_POST['cid'])?$_POST['cid']:"";
require 'fileupload.class.php'; //引用類文件
$upobj=new FileUpload(); //實(shí)例化調(diào)用類
$ret=$upobj->upload('pic');
if($ret==1){
$creat_time = date("Y-m-d H:i:s");
?>date_default_timezone_set() ??? ???? ???? "PRC"? ?? ???? ?????.
?? ??? ???? ??? ?? ??? ??? ?? ??? ???. ??? ??? ?? ??? ??? ? ????.
?? ??? insert into ?? ???? ??? ???? ??????? ???? ????
<?php
if($author && $content && $creat_time && $cid){
$sql ="insert into list(author,content,creat_time,image,cid) values('$author','$content','$creat_time','{$upobj->newpath}',$cid)";
$rel = mysqli_query($link,$sql);
if($rel) {
echo "添加成功" . "<br/><br/>";
echo "<a href='list.php'>跳轉(zhuǎn)至列表頁面</a>";
}
}else {
echo "添加失敗" . "<br/><br/>";
echo "<a href='add.php'>跳轉(zhuǎn)至添加頁面</a>";
}
}
?>?? insert ?? ??? ?? insert ?? ???? ?? ?? $rel ??? ???? $rel? ?? ???? ???? ???? ??? ??? ??? ?????.
??? ??? ??? ???????.
