// default form action is add
$formAction = "addpost.php?add=1";
$submitText = "Enter Message";
// delete function
if ($_GET["del"]) {
$delID = $_GET["del"];
// delete from post table
$sql="delete from wd_post where p_id = $delID";
$delRes=mysql_query($sql) or die ("Delete Function Error: ".mysql_error());
}
else if ($_GET["add"]) {
// add the bulletin info to the table
extract($_POST); // get the variables from the post array
//$msg = addslashes($msg);
$user = $_SESSION["userId"];
$addPost = "insert into wd_post ( p_user,p_message) values ('$user','$msg')";
$postResult = mysql_query($addPost) or die ("Error in adding Officer Message: ". mysql_error());
}
else if ($_GET["query"]) {
// get message from database
$getID = $_GET["query"];
//$msg = addslashes($msg);
$getPost = "select * from wd_post where p_id = $getID";
print $getPost." ";
$getResult = mysql_query($getPost) or die ("Error in Retrieving Officer Message: ". mysql_error());
$getRow = mysql_fetch_array($getResult);
extract($getRow);
//foreach($getRow as $k => $v) {
// print $k." => ".$v." ";
//}
// change form action so update is performed instead of add
$formAction = "addpost.php?update=$p_id";
$submitText = "Update Message";
}
else if ($_GET["update"]) {
$up_id = $_GET["update"];
$upMsg = $_POST["msg"];
$upPost = "update wd_post set p_message = '$upMsg' where p_id = $up_id";
$updateResult = mysql_query($upPost) or die ("Error in Updating Officer Message: ". mysql_error());
}
// give the page so they can enter a bulletin
?>
FORMAT KEY
LINE BREAK: Type <br> where you want the line break to appear.
Ex. Typing: "Line1<br>Line2" would look like: Line1 Line2
BOLD: Type <b> before and </b> after the word(s) you want to be bold.