A PHP bulletin board creatively titled Jake's Bulletin Board, circa 2003. (My first full coding project ever – complete with bugs and security holes and horrendous style!)
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

41 lines
1.2 KiB

$conn = mysql_connect ($sqlServer, $sqlUsername, $sqlPassword)
or die ("Uh oh! I could not connect to server $sqlServer.");
mysql_select_db ($sqlDatabase)
or die ("Uh oh! I could not connect to database $sqlDatabase");
$time = date("Y-m-d g:i:s");
$query = "INSERT INTO jbb_topics (forumID, userID, subject, description, firstPost, postTime, lastPostTime, lastPostUserID) VALUES ('$forumID','$ck_userID','$subject','$desc','$firstPost','$time','$time','$ck_userID')";
$result = mysql_query ($query)
or die ($query);
$query2 = "SELECT * FROM jbb_topics WHERE topicID = '$topicID'";
$result2 = mysql_query ($query2)
or die ($query2);
$query3 = "SELECT * FROM jbb_forums WHERE forumID = '$forumID'";
$result3 = mysql_query ($query3)
or die ($query3);
$topic = mysql_fetch_object($result2);
$forum = mysql_fetch_object($result3);
$topicID = $topic->topicID;
echo "<CENTER>Thank you for posting. Now returning to \"$forum->name\".<BR><A HREF=\"index.php?act=topiclist&forumID=$forumID\">(Click here if you do not wish to wait.)</A></CENTER>";
echo "<meta http-equiv=\"refresh\" content=\"5; url=index.php?act=topiclist&forumID=$forumID\>";