mysqlinsertphp
if($action == ‘insert’){ //接收數據 $title = empty($_post[‘subject’]) ? ” : $_post[‘subject’]; $content = empty($_post[‘content’]) ? ” : $_post[‘content’]; $user_id = $_session[‘myuser’][‘id’]; $create_ad = time(); $summary = empty($_post[‘summary’]) ? ” : $_post[‘summary’]; $category_id = empty($_post[‘category_id’]) ? ” : $_post[‘category_id’]; $cover = empty($_post[‘cover’]) ? ‘mr.jpg’ : $_post[‘cover’]; $state = empty($_post[‘submit’]) ? ” : $_post[‘submit’]; $is_delete = 0; $tags = ”; //驗證 if($category_id == ” || $title == ” || $content = ” || $summary == ”){ header(‘refresh : 2 ; url = article.php?a=add’); echo ‘輸入的信息有誤，請重新輸入’; exit; } //入庫 $sql = “insert into tn_article values(null, ‘$title’,’$content’, $user_id, $create_ad, ‘$summary’, $category_id, ‘$cover’, ‘$state’, ‘$is_delete’, ‘$tags’)”; //獲取頁面 if($dao ->query($sql)){ header(‘location:article.php?a=list’); exit; } else{ header(‘refresh : 2; url = article.php?a=add’); echo ‘添加失敗’; exit; }}
