PHP - Finishing A Discussion Board?

Hello all

I have a php and jquery/ajax call I am using to create a file/send an email. I get all the contents from my textboxes but I want a message to display on the screen afterwards being success or fail. In my .ajax call My call is exiting right before the ‘success:’  part. Why is my call not succeeding? Any tips/help will be appreciated

Thank you

Html page just a form with a submit button
$(document).ready(function () {
    var form = $("#formData");
    
    $(form).on("submit", function (event) {
        event.preventDefault();
        $.ajax({
            type: "post",
            url: "file.php",
            data: $(this).serialize(),
            beforeSend: function () {
                $("#status").html('<span style="color:red;">Loading everything actually creating a .TXT file of contents...</span>')  //--works
            },
            success: function (data) { 
                var responseMsgType = "alert-" + data.type;
                var responseMsgText = data.message;
                // message below
                var alertBox = '<div class="alert ' + responseMsgType + ' alert-dismissable"><button type="button" class="close" ' +
                    'data-dismiss="alert" aria-hidden="true">&times;</button>' + responseMsgText + '</div>';
                if (responseMsgType && responseMsgText) {
                    $(form).find(".successArea").html(alertBox);
                    $(form)[0].reset();
                }
            }
        });
        return false;
    });
<?php
$controls = array('txtName' => 'Name', 'txtEmail' => 'Email', 'txtSubject' => 'Subject', 'txtMessage' => 'Message');
try {
	if(count($_POST)==0) { throw new \Exception ('Contact Form Message is empty'); }

	$headers = array('Content-Type: text/plain; charset="UTF-8";',
					 'From: ' . $email,
					 'Reply-To: ' . $email,
					 'Return-Path: ' .$email);

	$emailMessage = "You have a new message from your contact form" . PHP_EOL;
	$emailMessage .= "-------------------------------------------------------" . PHP_EOL;

	foreach($_POST as $key => $value){
        if(isset($controls[$key])) {
            $emailMessage .= "$controls[$key]: $value". PHP_EOL;
        }
    }
$mailMsg = "email6.txt";
	if(file_exists($filename) == false) {
		$fh = fopen($mailMsg, "w");
		fwrite($fh, $headers);
		fwrite($fh, $emailMessage);
		fclose($fh);
	} else {
		$fhexists = fopen($filename, "a");
		fwrite($fhexists, $content);
		fclose($fhexists);
	}

	$responseMessage = array("type" => "success", "message" => $successMessage);
}
catch (\Exception $ex) {
	$responseMessage = array("type" => "errorM", "message" => $errorMessage);
}
if(!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
	$encodedJSON = json_encode($responseMessage);
	header("Content-Type: application/json");
	echo $encodedJSON;
} else {
	echo $responseMessage["message"];
}

 

Hi all, I'm very new to the wonderful world of php, so I'd appreciate any and all help in the matter. I've greatly simplified the code below to hopefully help you in helping me. Thanks!

Ok, so I'm integrating a very simple message board feature into my site. The basic idea is that people post a comment, and have the option of replying to existing comments. I'm definitely not looking for a complete forum; just something that allows users to post and reply.

I've tackled the posting bit easily enough. I have a form. Users fill in the form and the message, along with user information, is sent to a MySQL database. The information includes the username(Poster), the message(Message), an id that corresponds to the topic in question(Messid), a unique ID code for the message itself (ID), and a number of other variables like date and rank.

I then use a while statement to bring up all of the messages that pertain to a particular topic; The output will only show messages that share the same Messid, and they are arranged in terms of descending ID:
Code: [Select]
<?
while($row = mysql_fetch_array($resultcomments))
  {
    $poster=$row['Poster'];
  $message= $row['Message'];
 $ID=$row['ID'];

echo $message.$poster.$ID;

}


 So far, so good. What I want is for users to be able to click on any one of the particular messages, and post a response comment that will appear directly below the message to which it responds. Any ideas how I might go about such a task?

So far, I've created a new MySQL table that corresponds to these "subcomments". Each subcomment has a "subID" that corresponds to the ID of the message to which it responds. By including a while statement within the while statement above, I can successfully list all of the subcomments that correspond to a message directly below it. The problem, of course, is that I have to insert the subID values manually in php_my_admin. I'm hoping there's a way for php to automatically detect the ID value of the message in question...

Many many thanks for any assistance I can get. Once this revolution in communication makes me a billionaire, I will be certain to reward you most properly. Thanks again.

Right I want to make a request to my db to check the no. of rows it has.
If it has changed, refresh the chat page.
else wait.
I have tried to check for last db update, that never worked as well.
Well here is my code.

Code: [Select]
//this is my refresh script below
$result = mysql_query("SELECT * FROM chatmessages");
$num_rows = mysql_num_rows($result);
echo "$num_rows Rows\n";

while(0){
$num_rows_temp = mysql_num_rows($result);
if ($num_rows  != $num_rows_temp){
$$num_rows=$num_rows_temp;
echo "<script>";
echo "window.location.replace('chatlog.php')";
echo "</script>";
}else{
sleep(2);
}
}
I assume $num_rows  != $num_rows_temp is wrong as  it does not seem to do anything. Any help would be welcome. thanks.

hi guys, the problem is, is that all of the code works fine, however im trying to post the user to the leader board (leaders.xml) however it just isnt adding to the xml page and im not too sure why.

I  attached all 3 files that you may need to see to figure it out.  Hope you can really help, I would really appreciate it.

Okay this section is the index where the user enters their user name
Code: [Select]
<?php
session_name("elearning_Test");
session_start();
$_SESSION['score'] = 0;
$_SESSION['correct'] = array(); 
$_SESSION['wrong'] = array();
$_SESSION['finished'] = 'no'; 
$_SESSION['num'] = 0;
require_once ('functions.php');
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title>Forensics E-learning Package</title>
    <script type="text/javascript" src="start.js"></script>

<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<div id="wrapper">
<div id="header">
<div id="toplinks">

</div>
</div>
<div id="menu">
<ul>
<li><a class="selected" href="home.html">Home</a></li>
<li><a href="initialquiz.php">Initial Quiz</a></li>
<li><a href="about.php">About</a></li>
            <li><a href="leaderboard.php">Leader Board</a></li>

</ul>
  </div>
<div id="content">
<div id="main">
<h1>Forensics E-Learning Package</h1><BR />
          <h2>Start The Test</h2>
          <form id="questionBox" method="post" action="home.php">
<label for="username">Create A Username:</label><br />
<input type="text" id="username" name="username" value="Username" />
<p id="exp">Username must be between 3 and 10 characters in length</p></li>
</ul>
<p><input type="hidden" name="register" value="TRUE" />
<input type="submit" id="submit" value="Register And Take The Test" /></p>
</form>

<p id="helper"><?php if(isset($_SESSION['error'])) echo $_SESSION['error']; ?></p>

</div>
<div id="right">
<h2>Right Menu</h2>
<div class="rightitem">
<ul>
<li><a class="selected" href="home.html">Home</a></li>
<li><a href="initialquiz.php">Initial Quiz</a></li>
<li><a href="about.php">About</a></li>
            <li><a href="leaderboard.php">Leader Board</a></li>
</ul>
</div>
</div>
  </div>
<div class="clearbottom"></div>
<div id="footer">
<p id="legal">&nbsp;</p>
</div>
</div>
</div>
</body>
</html>


This section is the leaderboardpage
Code: [Select]
<?php
session_name("elearning_Test");
session_start();

include_once('functions.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title>Forensics E-learning Package</title>

<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<div id="wrapper">
<div id="header">
<div id="toplinks">

</div>
</div>
<div id="menu">
<ul>
<li><a class="selected" href="index.php">Home</a></li>
<li><a href="index.php">Initial Quiz</a></li>
<li><a href="index.php">About</a></li>

</ul>
  </div>
<div id="content">
<div id="main">
        <h1>Leader Board</h1>
        <h2>Top Scorers</h2>
       

<?php
echo "Welcome to the Leaderboard " . $_SESSION['user']; ?><BR /><BR />
<?php
showLeaders('leaders.xml',20); ?><BR /><BR />


   
       
        </div>
<div id="right">
<h2>Right Menu</h2>
<div class="rightitem">
<ul>
<li><a class="selected" href="index.php">Home</a></li>
<li><a href="index.php">Initial Quiz</a></li>
<li><a href="index.php">About</a></li>
</ul>
</div>
</div>
  </div>
<div class="clearbottom"></div>
<div id="footer">
<p id="legal">&nbsp;</p>
</div>
</div>
</div>
</body>
</html>

And finally this section is the functions page.

Code: [Select]

<?php

// shuffle answers
function shuffle_assoc($array) {

  $keys = array_keys($array);
  shuffle($keys);
  $shuffled = array();
  foreach ($keys as $key)
    $shuffled[$key] = $array[$key];

  return $shuffled;
} 
  
  
 // leader board section
function showLeaders($file,$limit,$group = null) { 
$leaders = array();

// Load the xml file and place all users and associated 
  // scores into the 'leaders' array.
  $xml = simplexml_load_file($file);
  foreach($xml->user as $user) 
{
  $name = (string)$user->name;
  $score = (string)$user->score;
  $leaders[$name] = $score;
  }
 
  // Sort the leaders array numerically, highest scorers first.
  arsort($leaders,SORT_NUMERIC);
 
  // Initialise our $counter variable to '1'.
  $counter = 1;
 
  // Start a html ordered list to hold the leaders.
  $output = "<ul class=\"leaders\">\n";
 
  // Loop through the 'leaders' array and wrap each username and score
  // in <li> tags. If the user is the current $_SESSION['user'], wrap
  // the name/score in <strong> tags too.
  foreach ($leaders as $key => $value) 
{
  // Check that $counter is less than $limit.
  if ($counter <= $limit)
{
  if ($key == $_SESSION['user'])
{
  $output .= "<li><strong>$key:</strong> $value/20</li>\n";
  }
else 
{
  $output .= "<li>$key: $value/20</li>\n";
  }
  // Check to see if $group parameter has been passed.
  // If it has, create separate lists according to the $group variable.
  if ($group) 
{
  // Use the modulus operator(%) to create new sub-list.
  if($counter % $group == 0) 
{
  $output .= "</ul>\n<ul class=\"leaders\">\n";
  }
  }
  }
  // Increment the $counter.
  $counter++;
  }
  // End the ordered list.
  $output .= "</ul>\n";
 
  // Print out the ordered list.
echo $output;
 }
 
function showAnswers($answers,$questions) { 
for($x = 0; $x< count($answers); $x++) {
if ($x % 2 == 0) { 
  $output = "<div class=\"qanda clear\">\n";
} else { 
$output = "<div class=\"qanda\">";
   }
  $output .= '<h4>Question' . ($x+1) . ': ' . $questions[$x] . '</h4>'; 
$output .= "<ol>\n";
  for ($y = 0;$y< count($answers[$x]); $y++) {
  if (($answers[$x][$y] === $answers[$x][0]) && (in_array($answers[$x][$y],$_SESSION['correct']))) {
  $output .= "<li class=\"correctuser\">{$answers[$x][$y]} (Correct!)</li>\n";
  } else if ($answers[$x][$y] === $answers[$x][0]) {
  $output .= "<li class=\"correct\">{$answers[$x][$y]}</li>\n";
  } else if (in_array($answers[$x][$y],$_SESSION['wrong'])) {
  $output .= "<li class=\"wrong\">{$answers[$x][$y]} (Woops!)</li>\n";
  } else { 
  $output .= "<li>{$answers[$x][$y]}</li>\n";
}
}
$output .= "</ol></div>\n";
echo $output;
}
}
?>

Thanks guys for your help.  Just really need another pair of eyes on this as i cant see why.

Lance