:::
form;
return $main;
}
//儲存新聞
function save_news($sn=""){
//過濾外面傳來的變數
$op=isset($_POST['op'])?$_POST['op']:"";
$password=isset($_POST['password'])?$_POST['password']:"";
$news_title=isset($_POST['news_title'])?check_input($_POST['news_title']):"";
$news_content=isset($_POST['news_content'])?check_input($_POST['news_content']):"";
$author=isset($_POST['author'])?check_input($_POST['author']):"";
$ip=isset($_POST['ip'])?check_input($_POST['ip']):"";
$post_time=isset($_POST['post_time'])?check_input($_POST['post_time']):"";
$status=isset($_POST['status'])?check_input($_POST['status']):"";
$cate_title=isset($_POST['cate_title'])?check_input($_POST['cate_title']):"";
$cate_sn=isset($_POST['cate_sn'])?intval($_POST['cate_sn']):"";
//接收使用者輸入密碼，失敗轉回發布頁
if(empty($password) or $password!=_POST_PASSWD){
// 產生 cookie
// setcookie('news_title',$news_title);
// setcookie('news_content',$news_content);
// 產生 session，以記住剛剛使用者輸入的資料，避免需要重打
$_SESSION['news_title']=$news_title;
$_SESSION['news_content']=$news_content;
$_SESSION['author']=$author;
$_SESSION['status']=$status;
$_SESSION['cate_sn']=$cate_sn;
//轉回編輯頁面，並用 get 方式，傳遞 $op 以便顯示密碼有誤的訊息
header("location:{$_SERVER['PHP_SELF']}?op=passwd_error");
exit;
}else{
// nl2br()將換行符號轉換為
標籤 //$news_content=nl2br($news_content); // 發布正確，剛剛輸入的內容無需在記住，因此清空之。 session_destroy(); } link_db(); //新增分類 if(empty($cate_sn) and !empty($cate_title)){ $sql="insert into eznews_cate (cate_title) values('$cate_title')"; mysql_query($sql) or die($sql."
".mysql_error()); $cate_sn=mysql_insert_id(); }elseif(!empty($cate_sn) and !empty($cate_title)){ //修改分類 $sql="update eznews_cate cate_title='$cate_title' where cate_sn='$cate_sn'"; mysql_query($sql) or die($sql."
".mysql_error()); } //存到資料庫 if($sn){ $sql="update eznews set cate_sn='$cate_sn', news_title='$news_title', news_content='$news_content', ip='$ip', author='$author', post_time='$post_time', status='$status' where sn='$sn'"; }else{ $sql="insert into eznews (cate_sn,news_title, news_content, ip, author, post_time,status) values('$cate_sn','$news_title', '$news_content', '$ip', '$author', '$post_time', '$status')"; } mysql_query($sql) or die($sql."
".mysql_error()); } //替特殊符號加入反斜線 function check_input($value){ if (!get_magic_quotes_gpc()){ $value = addslashes($value); } return $value; } ?> ```
MarkDown
7. 置頂、計數器與 join
標籤 //$news_content=nl2br($news_content); // 發布正確，剛剛輸入的內容無需在記住，因此清空之。 session_destroy(); } link_db(); //新增分類 if(empty($cate_sn) and !empty($cate_title)){ $sql="insert into eznews_cate (cate_title) values('$cate_title')"; mysql_query($sql) or die($sql."
".mysql_error()); $cate_sn=mysql_insert_id(); }elseif(!empty($cate_sn) and !empty($cate_title)){ //修改分類 $sql="update eznews_cate cate_title='$cate_title' where cate_sn='$cate_sn'"; mysql_query($sql) or die($sql."
".mysql_error()); } //存到資料庫 if($sn){ $sql="update eznews set cate_sn='$cate_sn', news_title='$news_title', news_content='$news_content', ip='$ip', author='$author', post_time='$post_time', status='$status' where sn='$sn'"; }else{ $sql="insert into eznews (cate_sn,news_title, news_content, ip, author, post_time,status) values('$cate_sn','$news_title', '$news_content', '$ip', '$author', '$post_time', '$status')"; } mysql_query($sql) or die($sql."
".mysql_error()); } //替特殊符號加入反斜線 function check_input($value){ if (!get_magic_quotes_gpc()){ $value = addslashes($value); } return $value; } ?> ```
