$dbh=mysql_connect ("localhost", "quick4_testuser", "just4pass") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("quick4_qsc"); //VARS $_SESSION['now']=date("Y")."-".date("m")."-".date("d")." ".date("H:i:s"); $_SESSION['current_article_id']; $_SESSION['this_article_id']; write_head(); get_current(); if ($_POST['submit_new_article']) write_insert(); else if ($_POST['update_article']) write_update(); else if ($_POST['create_new_article']){ $_SESSION['this_article_id']=""; write_main(); } else{ if ($_POST['article_id']) $_SESSION['this_article_id']=$_POST['article_id']; else $_SESSION['this_article_id']=$_SESSION['current_article_id']; write_main(); } write_foot(); function get_current(){ $sql="SELECT article_id FROM ARTICLES WHERE `cat` = '1'"; $result = mysql_query($sql) or die(mysql_error()); $num_results = mysql_num_rows($result); for($a=0;$a<$num_results;$a++){ $row = mysql_fetch_array($result); $_SESSION['current_article_id']=$row["article_id"]; } //end get results } ?> function write_head(){ ?>
|
$sql="SELECT article_id, title, cat FROM ARTICLES"; $result = mysql_query($sql) or die(mysql_error()); $num_results = mysql_num_rows($result); for($a=0;$a<$num_results;$a++){ $row = mysql_fetch_array($result); if ($row["cat"]==1) $s="Arshele "; else if ($row["cat"]==2) $s="Party Planning "; else $s="Technology "; if ($_SESSION['this_article_id']==$row["article_id"]) echo $s.$row["title"]." "; else{ ?> ','index.php')"> echo $s.$row["title"]." ".$row["created"]; ?> } ?> } //end get results ?> |
ARTICLE $sql="SELECT * FROM ARTICLES WHERE `article_id` = '{$_SESSION['this_article_id']}'"; $result = mysql_query($sql) or die(mysql_error()); $num_results = mysql_num_rows($result); for($a=0;$a<$num_results;$a++){ $row = mysql_fetch_array($result); $_SESSION['article_id']=$row["article_id"]; $_SESSION['author']=$row["author"]; $_SESSION['title']=$row["title"]; $_SESSION['body']=$row["body"]; $_SESSION['created']=$row["created"]; $_SESSION['modified']=$row["modified"]; $_SESSION['cat']=$row["cat"]; } //end get results ?> RESPONSES TO CURRENT ARTICLE $sql="SELECT * FROM RESPONSES_APPROVED WHERE `article_id` = '{$_SESSION['this_article_id']}'"; $result = mysql_query($sql) or die(mysql_error()); $num_results = mysql_num_rows($result); for($a=0;$a<$num_results;$a++){ $row = mysql_fetch_array($result); echo "".$row["title"].""; ?> echo "By: ".$row["author"]; ?> echo "Email: "; if ($row["email"]) echo $row["email"]; else echo "(none)"; ?> echo "Originally Submitted At: ".$row["created"]; ?> echo "Modified at: ".$row["modified"]; ?> if ($row["note_author"]) echo "Note: "."". " By: ".$row["note_author"]." ".$row["note_time"]; else echo "Note: (None)"; ?> &v=1&">Edit Response | &v=3&">Remove Response } //end get results ?> |
$sql="SELECT `response_id`, `title` FROM RESPONSES WHERE `article_id` = '{$_SESSION['this_article_id']}'"; $result = mysql_query($sql) or die(mysql_error()); $num_results = mysql_num_rows($result); for($a=0;$a<$num_results;$a++){ $row = mysql_fetch_array($result); echo "".$row["title"]." "; } //end get results ?> |