require_once("functions.php");
global $action,$userinfo;
chkuserlogin($userinfo);
$userinfo['userlevel']=1;
$table="announcements";
fheader();
?>
|
Announcement
Maintenance
|
function flist() {
global $action,$url,$table,$sql,$recperpage,$search,$navinfo,$userinfo,$recperpage,$search;
$searchfor = initobj("searchfor");
$searchvalue = initobj("searchvalue");
$arrsearch = Array("Announcement"=>"announcement");
$condition = ($searchfor!="") ? "where $searchfor like '%$searchvalue%'" : "";
$sql = "select * from $table $condition";
?>
|
|
|
|
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
if (is_array($row)) {
?>
|
ID
|
Announcement
|
|
$ct = 0;
do {
$id = $row['id'];
$announcement = $row['announcement'];
$ct++;
if ($ct % 2 == 0)
$bgcolor = "white";
else
$bgcolor = "";
?>
|
=$id?>
|
=$announcement?>
|
if ($userinfo['userlevel']==1) { ?>
Delete
} ?>
|
} while ($row = mysql_fetch_array($result));
} else {
?>
|
No record is available.
|
} ?>
|
|
|
|
}
function fform() {
global $userinfo,$table,$uid,$url,$ptr,$id,$announcement,$link;
if ($uid != 0) {
$sql = "select * from $table where id=$uid";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$id = $row['id'];
$announcement = $row['announcement'];
$action = "saveedit";
$label = "UPDATE RECORD";
} else {
$action = "saveadd";
$label = "ADD RECORD";
}
?>
|
|
}
function fsave() {
global $action,$table,$ptr;
$id = initobj("id");
$announcement = initobj("_announcement");
$link = initobj("_link");
if ($action=="saveadd") {
$row = fetcharray("select * from $table where announcement='$announcement'");
if (!is_array($row)) {
$sql = "insert into announcements (announcement) values ";
$sql.= "('$announcement')";
mysql_query($sql);
}
} elseif ($action=="saveedit") {
$sql = "update announcements set announcement='$announcement' ";
$sql.= "where id=$id";
mysql_query($sql);
}
flist();
}
function fdelete() {
global $table,$uid;
mysql_query("delete from $table where id=$uid");
flist();
}
switch ($action)
{
case "formadd":
fform();
break;
case "formedit":
fform();
break;
case "saveadd":
fsave();
break;
case "saveedit":
fsave();
break;
case "delete":
fdelete();
break;
default:
flist();
break;
}
?>
ffooter() ?>