[RESOLVED] Refresh information on submit

Smudly

Hi all,

I've created a support ticket system for users that have questions while on my site. The questions are stored inside a database. On my admin page, I access this information, and show it to the screen, where I can then answer the question. It all works great, except one problem.

The unanswered question that displays on the top of the page is supposed to be replaced with a new question upon hitting Submit. Also, the number of support tickets left is supposed to update (where it says Number of Tickets🙂

What do I need to change to my code to make it update the new question and new total of tickets when I hit submit?

Thanks.

<?php
session_start();

include_once('../inc/nav.php');

$submit = $_POST['submit'];
if(isset($_SESSION['username'])){  

include_once('../inc/connect.php');

$supportsql = "SELECT * FROM `support` WHERE `answered`='no' ORDER BY `date` DESC"; 

$result = mysql_query($supportsql);
$row = mysql_fetch_assoc($result);
$num = mysql_num_rows($result); 

$username = $row['username'];



$i = 0;
while ($i < $num) {

$user = mysql_result($result,$i,"username");
$message = mysql_result($result,$i,"message");
$number = mysql_result($result,$i,"number");
// echo "<br /><div align='center' id='question'><strong>".ucfirst($user)."<br /></strong>".$message."<br /></div>";

$i++;
}
echo "<br /><center>Number of Tickets: ".$num."</center>";
echo "<br /><div align='center' id='question'><strong>".ucfirst($user)."<br /></strong>".$message."<br /></div>";
// Find Their Email Address

$emailsql = "SELECT email FROM users WHERE username='$username'";
$emailresult = mysql_query($emailsql);
$erow = mysql_fetch_assoc($emailresult);

$email = $erow['email'];


if ($submit){

$answer = $_POST['answer'];

$signature = "If you have anymore questions, feel free to ask! \nThank You,\n<html><a href='http://www.daobux.com'>Daobux Team</a></html>";
$usermail = ucfirst($username);
mail("$email", "Reply: $message", "
Hello $usermail,\n
$answer\n
$signature
");

$answeredsql = "UPDATE `support` SET `answered`='yes' WHERE number='$number'";
mysql_query($answeredsql);



}


}

?>

<html>
<head>
<title>Support Tickets</title>
<style>
#question{
	width: 500px;
	background-color: #cccccc;
	border-style: solid;
	border-width: 2px;
	margin-left: auto;
	margin-right: auto;
	}
</style>
</head>
<body OnLoad="document.supportticket.answer.focus();">

<center>
<h1>Answer Queries:</h1>
<form name="supportticket" action="supportticket.php" method="POST">
<textarea rows="8" cols="50" name="answer"></textarea><br />
<input type="submit" name="submit" value="Submit">
</form>
<br />
<?php echo $error; ?>
</center>

</body>
</html>

Nanashi

Does it work if you refresh the page after pressing the submit button?
If it does, then you can always use Javascript to refresh the page afterpressing the submitbutton.

Just put it at the bottom of this statement,

if ($submit){

Here is the code to use:

<script type="text/javascript">
	window.location.reload()
</script>

Regards
/Nanashi

Smudly

After I submit, and try refreshing the page, it tries to resend the data. So doing it this way wouldn't work.

Nanashi

Then use a redirection-script instead, the JavaScript would look like this instead,

<SCRIPT language="JavaScript">
<!--
window.location="http://www.example.com/filename.php";
//-->
</SCRIPT>

Regards
/Nanashi

Smudly

That is an awesome idea! I tried placing that code inside my <head>, but now the page just keeps redirecting. How do I have it redirect ONLY when the submit button is pressed? (I'm not sure if I am able to place javascript code inside php).

***EDIT:

I searched around a bit, and created a variable in my php script that is set to 1, if the page is submitted. This variable is transferred into my javascript, along with an if statement to determine if the value is equal to 1. It is all working now thanks much!

var javago = "<?= $javago ?>";
if (javago==1)
  {
  window.location="supportticket.php";
  }
//-->

Nanashi

Hmh, you could have done it like this too,

<?php
if ($submit){ 

//Your code

?>
<SCRIPT language="JavaScript">
<!--
window.location="supportticket.php";
//-->
</SCRIPT>
<?php
}
?>

But the way you did it works too I guess, anyways, you're welcome.

Regards
/Nanashi