[1062] PHP7入門
<?php
require "loginheader.php";
require_once 'header.php';
$page_title = '管理頁面';
$op = isset($_REQUEST['op']) ? filter_var($_REQUEST['op']) : '';
$sn = isset($_REQUEST['sn']) ? (int) $_REQUEST['sn'] : 0;
switch ($op) {
case 'insert':
$sn = insert_article();
header("location: index.php?sn={$sn}");
exit;
case 'delete_article':
delete_article($sn);
header("location: index.php");
exit;
case "article_form":
//sumi add 加入TOPIC
list_topic();
break;
case "modify_article":
//sumi add 加入TOPIC
list_topic();
show_article($sn);
break;
case 'update':
update_article($sn);
header("location: index.php?sn={$sn}");
exit;
case 'add_focus':
add_focus($sn);
header("location: index.php?sn={$sn}");
exit;
case 'remove_focus':
remove_focus($sn);
header("location: index.php?sn={$sn}");
exit;
default:
$op = "";
break;
}
require_once 'footer.php';
/*************函數區**************/
//儲存文章
function insert_article()
{
//sumi add topic_sn
//ellen add sort
global $db;
$title = $db->real_escape_string($_POST['title']);
$content = $db->real_escape_string($_POST['content']);
$username = $db->real_escape_string($_POST['username']);
$topic_sn = $db->real_escape_string($_POST['sel_topic_sn']);
$sort = $db->real_escape_string($_POST['sort_num']);
$sql = "INSERT INTO `article` (`title`, `content`, `username`, `create_time`, `update_time`,`topic_sn`,`sort`) VALUES ('{$title}', '{$content}', '{$username}', NOW(), NOW(),'{$topic_sn}','{$sort}')";
$db->query($sql) or die($db->error);
$sn = $db->insert_id;
upload_pic($sn);
$content = "完成文章新增，請看：<br>http: //stu.tncomu.tn.edu.tw/~tad1062/index.php?sn=$sn";
send_now('[email protected]', '新增文章通知', $content);
return $sn;
}
function delete_article($sn)
{
global $db;
$sql = "DELETE FROM `article` WHERE sn='{$sn}' and username='{$_SESSION['username']}'";
$db->query($sql) or die($db->error);
if (file_exists("uploads/cover_{$sn}.png")) {
unlink("uploads/cover_{$sn}.png");
unlink("uploads/thumb_{$sn}.png");
}
}
//更新文章
function update_article($sn)
{
//sumi add topic_sn
//ellen add sort
global $db;
$title = $db->real_escape_string($_POST['title']);
$content = $db->real_escape_string($_POST['content']);
$username = $db->real_escape_string($_POST['username']);
$topic_sn = $db->real_escape_string($_POST['sel_topic_sn']);
$sort = $db->real_escape_string($_POST['sort_num']);
$sql = "update `article` Set `title`='{$title}', `content`= '{$content}',`update_time`=NOW() ,`topic_sn` ='{$topic_sn}',`sort` ='{$sort}' WHERE sn='{$sn}' ";
$db->query($sql) or die($db->error);
upload_pic($sn);
return $sn;
}
//上傳團片
function upload_pic($sn)
{
if (isset($_FILES)) {
require_once 'class.upload.php';
$foo = new Upload($_FILES['pic']);
if ($foo->uploaded) {
// save uploaded image with a new name
$foo->file_new_name_body = 'cover_' . $sn;
$foo->file_overwrite = true;
$foo->image_resize = true;
$foo->image_convert = png;
$foo->image_x = 1200;
$foo->image_ratio_y = true;
$foo->Process('uploads/');
if ($foo->processed) {
$foo->file_new_name_body = 'thumb_' . $sn;
$foo->file_overwrite = true;
$foo->image_resize = true;
$foo->image_convert = png;
$foo->image_x = 400;
$foo->image_ratio_y = true;
$foo->Process('uploads/');
}
}
}
}
//將文章加入精選，focus欄位變為 1
function add_focus($sn)
{
global $db;
$sql = "UPDATE `article` SET `focus`='1' WHERE `sn`='{$sn}'";
$db->query($sql) or die($db->error);
return $sn;
}
//將文章移除精選，focus欄位變回 0
function remove_focus($sn)
{
global $db;
$sql = "UPDATE `article` SET `focus`='0' WHERE `sn`='{$sn}'";
$db->query($sql) or die($db->error);
return $sn;
}