Bldg a FORUM - the FORM doesn't display - WHY?

Scotty13 · August 12, 2012

Trying to build a forum. My two Tables that I built for this forum are good.

When I test in my browsers?

I click on a topic from my index.php

It goes to section.php?id=36 (script below)

If I click on my type="submit" value="Take Off With A Different Conversation" button.

I get this ?ERROR: You do not exist in the system.? from new_topic.php (script below).

I?m following some tuts online and watched them over and over and its just not working, could you PLEASE HELP ME!

Sorry for all the script, but I didnt want to leave anything out.

_________________________________________________________________________________________ section.php __________________________________________

<?php

session_start();

include_once ("../wi_class_files/agoTimeFormat.php");

$myAgoObject = new convertToAgo;

include_once "../scripts/connect_to_mysql.php"; // Connect to the database

// Get the section ID from the url variable coming in

if (isset($_GET['id']) && $_GET['id'] != "") {

$sid = preg_replace('#[^0-9]#i', '', $_GET['id']); // filter all characters except numbers for security

} else {

echo "ERROR: Variables to run this script have been removed from the URL.";

exit();

}

// Query the database for that section id, make sure it exists and get the section title

$sql = mysql_query("SELECT * FROM forum_sections WHERE id='$sid' LIMIT 1");

$numRows = mysql_num_rows($sql);

if ($numRows < 1) {

echo "ERROR: That section does not exist you have tampered with our URLs.";

exit();

}

while($row = mysql_fetch_array($sql)){

$sectionTitle = $row["title"];

}

// Use the section ID to query the "forum_posts" table in the database to get all the threads for this section

$sql = mysql_query("SELECT * FROM forum_posts WHERE type='a' AND section_id='$sid' ORDER BY date_time DESC LIMIT 25");

$dynamicList = "";

$numRows = mysql_num_rows($sql);

if ($numRows < 1) {

$dynamicList = "There are no threads in this section yet. You can be the first to post.";

} else {

while($row = mysql_fetch_array($sql)){

$thread_id = $row["id"];

$post_author = $row["post_author"];

$post_author_id = $row["post_author_id"];

$date_time = $row["date_time"];

$convertedTime = ($myAgoObject -> convert_datetime($date_time));

$whenPost = ($myAgoObject -> makeAgo($convertedTime));

$thread_title = $row["thread_title"];

$dynamicList .= '<img src="style/threadPic.jpg" width="26" height="18" alt="Topic" /> ' . $post_author . ' - <a href="view_thread.php?id=' .

$thread_id . '">' . $thread_title . '</a> - ' . $whenPost . '<br />';

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title><?php echo $sectionTitle; ?> Work & Trip Forum</title>

travel, tips, heard, tips, suggestions, nightmares, anniversary, retirement, birthday, party, heard, rumor, chat, gossip" />

</head>

<body>

<?php include_once("template_header.php"); ?>

</div>

<tr>

<div id="breadcrumbs"><a href="http://www.**********.com">Return Home: **********</a> ← <a

href="http://************.com/root/forum/index.php">Return: Work & Trip Topics</a></div>

</form>

<br />

_________________________________________________________________________________________ new_topic.php _____________________________________

<?php

session_start();

include_once "../scripts/connect_to_mysql.php"; // Connect to the database

// Check to see if the user is logged in with session variables

if (!isset($_SESSION['userloca']) || $_SESSION['userloca'] == "") {

echo "You'll need to check in first before you can post anything on your Work & Trip Forum.";

exit();

} else {

// Assume they are a tktedmembers because they have a locator session variable set

// Check the database to be sure that their ID, locator, and email session variables all match in the database

$u_id = mysql_real_escape_string($_SESSION['id']);

$u_name = mysql_real_escape_string($_SESSION['username']);

$u_email = mysql_real_escape_string($_SESSION['useremail']);

$u_loca = mysql_real_escape_string($_SESSION['userloca']);

$sql = mysql_query("SELECT * FROM myMembers WHERE id='$u_id' AND username='$u_name' AND email='$u_email' AND locator='$u_loca'");

$numRows = mysql_num_rows($sql);

if ($numRows < 1) {

echo "ERROR: You do not exist in the system.";

exit();

}

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

/////////////////////////////

// Check to make sure the URL variables of "sid" and "title" are set

if (!isset($_POST['forum_id']) || $_POST['forum_id'] == "" || !isset($_POST['forum_title']) || $_POST['forum_title'] == "") {

echo "Important variables are missing";

exit();

} else {

// Acquire the variables and proceed to show them a form for creating a new topic

$forum_section_id = preg_replace('#[^0-9]#i', '', $_POST['forum_id']);

$forum_section_title = preg_replace('#[^A-Za-z 0-9]#i', '', $_POST['forum_title']);

}

///////////////////////////////////////////////////////////////////////////////////////////////////

$sql = mysql_query("SELECT * FROM forum_sections WHERE id='$forum_section_id' AND title='$forum_section_title'");

$numRows = mysql_num_rows($sql);

if ($numRows < 1) {

echo "ERROR: That section does not exist.";

exit();

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title><?php echo $sectionTitle; ?>Work & Trip Forum</title>

<!--

function validateMyForm ( ) {

var isValid = true;

if ( document.form1.post_title.value == "" ) {

alert ( "Please type in a title for this topic" );

isValid = false;

} else if ( document.form1.post_title.value.length < 10 ) {

alert ( "Your title must be at least 10 characters long" );

isValid = false;

} else if ( document.form1.post_body.value == "" ) {

alert ( "Please type in your topic body." );

isValid = false;

}

return isValid;

}

//-->

</script>

</head>

<body>

<?php include_once("template_header.php"); ?>

<tr>

<div id="breadcrumbs"><a href="http://www.**********.com">Return Home: **********</a> ← <a

href="http://***********.com/root/forum/index.php">Return: Work & Trip Forum</a> ← <a href="section.php?id=<?php echo $forum_section_id; ?>"><?php echo

$forum_section_title; ?></a></div>

<h2>Creating a new topic in the <em><?php echo $forum_section_title; ?></em>Work & Trip Form</h2>

Announcer:<br /><input name="topic_author" type="text" disabled="disabled" maxlength="64" style="width:96%;" value="<?php echo $u_name; ?>" />

Announcement Title:<br /><input name="post_title" type="text" maxlength="64" style="width:96%;" /><br /><br />

Tell Us What Happen Today... <span class="smtext"> (Use only fictitious names if describing a passenger)

</span><br />

<br />

Please type in your topic body:<br /><textarea name="post_body" rows="15" style="width:96%;"></textarea>

</form>

________________________________________________________________________________________________________________________________________________

Scotty13

jcbones · August 12, 2012

You need to find out why:

$u_id = mysql_real_escape_string($_SESSION['id']);
     $u_name = mysql_real_escape_string($_SESSION['username']);
     $u_email = mysql_real_escape_string($_SESSION['useremail']);
     $u_loca = mysql_real_escape_string($_SESSION['userloca']);
     $sql = mysql_query("SELECT * FROM myMembers WHERE id='$u_id' AND username='$u_name' AND email='$u_email' AND locator='$u_loca'");
     $numRows = mysql_num_rows($sql);
     if ($numRows < 1) {
       echo "ERROR: You do not exist in the system.";
        exit();
     }

This database query doesn't work. Try looking at your session variables, and finding why they do not match what is in the database.

echo '<pre>' . print_r($_SESSION,true) . '</pre>';

Additionally, please put your code inside of the [ code ] ... [ /code ] blocks provided, they make reading it much easier.

Sign In

Bldg a FORUM - the FORM doesn't display - WHY?

Recommended Posts

Scotty13

Link to comment

Share on other sites

jcbones

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information