setting_addan.php

是个关于网格编程的程序

<?PHP
//*****************************************
//       id: setting_addan
//       EasyTalk V3.0 2008.5.6 20:50
//       by 仙踪云影
//*****************************************

define('is_admin_path', 'yes');
require_once '../common.php';
$smarty->template_dir = "templates";     
$smarty->compile_dir = "templates_c"; 
if ($admin_login !="yes" || $isadmin!=1)
header("Location: admin_login.php");
$anntitle = $_POST["anntitle"];
$annbody = $_POST["annbody"];
$webaddr = $_POST["webaddr"];
if ($webaddr=="setting_addan.php?add")
{
$datetime = time();
if ($anntitle =="")
{echo "公告标题为空,不能添加！";
}
else
{
$query = "INSERT INTO ".$DBprefix."announ (announ_title,announ_body,announ_time) VALUES ('$anntitle','$annbody','$datetime')";  
$result = mysql_query($query); 
}
header("Location: setting_addan.php");
}
if ($webaddr=="setting_addan.php?edit")
{ 
$addid = $_POST["addid"];
$new_title = $_POST["new_title"];
$new_body = $_POST["new_body"];
$query = "UPDATE ".$DBprefix."announ SET announ_title = '$new_title' , announ_body='$new_body' where announ_id='$addid'"; 
mysql_query($query); 
header("Location: setting_addan.php");
}
if ($webaddr=="setting_addan.php?del")
{ 
$addid = $_POST["addid"];
$query = "DELETE FROM ".$DBprefix."announ WHERE announ_id='$addid'";
mysql_query($query); 
header("Location: setting_addan.php");
}
$query = "select announ_id,announ_title,announ_body from ".$DBprefix."announ order by announ_id desc";
$result=mysql_query($query);
while ($data=@mysql_Fetch_array($result)) {
$id=$data['announ_id'];
$title=$data['announ_title'];
$body=$data['announ_body'];
$array[] = array("id"=>$id,"title"=>$title,"body"=>$body);
}
$smarty->assign("anounc", $array);
unset($array);
mysql_free_result($result);
$smarty->display("setting_addan.htm"); 
?>