How to reload the page?

venkat6134 · February 24, 2011, 6:49am

Hi all,
I have a web page, in this page i included the php page by using the include().
But this php page is having a form with some fields and submit button…
After submitting of the page, i want to show the user submitted data in the same page.
But it is not working at first time, why?
When i submit the form again, it will display errors and now it is showing the user data…

I used to store it in the database first, and then i display it in the page…
for that i used, header(_) function to redirect to this page, that is also not showing at first time, why?

Is there any wrong with me…

Help regarding the redirection as well as the refreshing the page, to show the user submitted data…

Thanking you…

DarthGuido · February 24, 2011, 8:16am

With you, I hope not
With your code most probably yes. Please post it here.

venkat6134 · February 24, 2011, 8:58am

Thank you for your reply,

http://www.rfcables.org/products/157.html

You can submit the comment in this page, after clicking the ‘add comment’ button in this page, you can’t see the posted comment on this page for first time, and you submit the second time by clicking the ‘add comment’ button, it shows alert message with earlier submitted comment…
means, it is inserting the data in the database at first time, but it is not showing…

Here displaying page is including the comments page…

DarthGuido · February 24, 2011, 9:03am

Without seeing the code, I can’t tell you what’s wrong.

venkat6134 · February 24, 2011, 9:17am

When i run this as separate page, by calling the name,it is showing the newly added comment…
but when i include it in another page, it is not showing the recently submitted one at first time, why?

This is example.php


&lt;?php
//connect to your database

//query comments for this page of this article
$inf = "SELECT * FROM `test_table` WHERE page = '".stripslashes($_SERVER['REQUEST_URI'])."' ORDER BY time ASC";
 $info = mysql_query($inf);
     if(!$info) die(mysql_error());

   $info_rows = mysql_num_rows($info);
if($info_rows &gt; 0) {
   echo '&lt;h5&gt;Comments:&lt;/h5&gt;';
   echo '&lt;table width="95%"&gt;';

 while($info2 = mysql_fetch_object($info)) {
echo '&lt;tr&gt;';
echo '&lt;td&gt;"'.stripslashes($info2-&gt;subject).'" by:  &lt;b&gt;' .stripslashes($info2-&gt;username).'&lt;/b&gt;&lt;/td&gt; &lt;td&gt;&lt;div align="right"&gt;'.date('h:i:s a', $info2-&gt;time).' on '.$info2-&gt;date.'&lt;/div&gt;&lt;/td&gt;';
echo '&lt;/tr&gt;&lt;tr&gt;';
echo '&lt;td colspan="2"&gt; '.stripslashes($info2-&gt;comment).' &lt;/td&gt;';
echo '&lt;/tr&gt;';
echo '&lt;tr&gt;&lt;td colspan="2"&gt;&lt;hr&gt;&lt;/td&gt;&lt;/tr&gt;';
}//end while

echo '&lt;/table&gt;';
//echo '&lt;hr width="95%" noshade&gt;';
} else echo 'No comments for this page. Feel free to be the first &lt;br&gt;';

if(isset($_POST['submit'])) {
		$username1=addslashes($_POST['username']);
		$contact=addslashes($_POST['contact']);
		$subject=addslashes($_POST['subject']);
		$comment=addslashes($_POST['comment']);
 
//try to prevent multiple posts and flooding...
$c = "SELECT * from `test_table` WHERE ip = '".$_SERVER['REMOTE_ADDR']."'";
  $c2 = mysql_query($c);
     while($c3 = mysql_fetch_object($c2)) {
      $difference = time() - $c3-&gt;time;
     if($difference &lt; 300) $error.='&lt;u&gt;&lt;b&gt;ALERT:&lt;/u&gt; '.$c3-&gt;username.', You have already commented earlier; if you have a question, try the forums!&lt;/b&gt;&lt;BR&gt;';
      } //end while
if($_POST['check'] == $_SESSION['check'])
	 {
//add comment
$q ="INSERT INTO `test_table` (article_id, page, date, time, username, ip, contact, subject, comment) VALUES ('".$_GET['id']."', '".$_POST['page']."', '".$_POST['date']."', '".$_POST['time']."', '".addslashes(htmlspecialchars($_POST['username']))."', '".$_SERVER['REMOTE_ADDR']."', '".addslashes(htmlspecialchars($_POST['contact']))."', '".addslashes(htmlspecialchars($_POST['subject']))."', '".addslashes(htmlspecialchars(nl2br($_POST['comment'])))."')";

$q2 = mysql_query($q);
  if(!$q2) die(mysql_error());

//refresh page so they can see new comment
header('Location: http://' . $_SERVER['HTTP_HOST'] . $_POST['page']);
	 }
}// else {  //display form
?&gt;
&lt;legend&gt;Post a comment&lt;/legend&gt;
&lt;div style="font-size:13px; color:#cc0000; margin-top:10px; margin-left:15px"&gt;&lt;?php echo @$error; ?&gt;&lt;/div&gt;&lt;br/&gt;
&lt;form name="comments" action="&lt;?php $_SERVER['PHP_SELF']; ?&gt;" method="post"&gt;

&lt;input type="hidden" name="page" value="&lt;?php echo($_SERVER['REQUEST_URI']); ?&gt;"&gt;
&lt;input type="hidden" name="date" value="&lt;?php echo(date("F j, Y.")); ?&gt;"&gt;
&lt;input type="hidden" name="time" value="&lt;?php echo(time()); ?&gt;"&gt;

&lt;table width="90%" border="0" cellspacing="0" cellpadding="0"&gt;
   &lt;tr&gt;
      &lt;td&gt;&lt;div align="right"&gt;Name:   &lt;/div&gt;&lt;/td&gt;
       &lt;td&gt;&lt;input name="username" type="text" size="30" value="&lt;?php echo @$username1; ?&gt;"&gt;&lt;/td&gt;
   &lt;/tr&gt;&lt;tr&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;div align="right"&gt;Email:   &lt;/div&gt;&lt;/td&gt;
      &lt;td&gt;&lt;input type="text" name="contact" size="30" value="&lt;?php echo @$contact; ?&gt;"&gt;&lt;/td&gt;
    &lt;/tr&gt;&lt;tr&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;
    &lt;td&gt;&lt;div align="right"&gt;Subject:   &lt;/div&gt;&lt;/td&gt;
    &lt;td&gt;&lt;input type="text" name="subject" size="30" value="&lt;?php echo @$subject; ?&gt;"&gt;&lt;/td&gt;
    &lt;/tr&gt;&lt;tr&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;div align="right"&gt;Comment:   &lt;/div&gt;&lt;/td&gt;
      &lt;td&gt;&lt;textarea name="comment" cols="45" rows="10" wrap="VIRTUAL"&gt;&lt;?php echo @$comment; ?&gt;&lt;/textarea&gt;&lt;/td&gt;
    &lt;/tr&gt;
	&lt;tr&gt;&lt;td&gt;&lt;div align="right"&gt;&lt;img src="math_captchas.php"&gt;&lt;/div&gt;&lt;/td&gt;
	&lt;td&gt;&lt;input type="text" name="check" size="5" maxlength="2" &gt;&lt;/td&gt;&lt;/tr&gt;
	&lt;tr&gt;&lt;td&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;/td&gt;
      &lt;td colspan="2"&gt;&lt;input type="reset" value="Reset Fields"&gt;
        &lt;input type="submit" name="submit" value="Add Comment"&gt;&lt;/td&gt;
    &lt;/tr&gt;
  &lt;/table&gt;
&lt;/form&gt;

Tell me where the problem is?
Thanking you.

DarthGuido · February 24, 2011, 9:26am

You select and display the comments from the database first, and then check if a new comment has been posted and add it to the database. Switch those two things around.
Why do you have the redirect?

Mandes · February 24, 2011, 9:24am

I cant see whats not working, I posted a comment and it appeared

venkat6134 · February 24, 2011, 9:32am

Thanks Mandes.
It appears, but not first time submission…

Thanks Guido2004;

You select and display the comments from the database first, and then check if a new comment has been posted and add it to the database. Switch those two things around.
Why do you have the redirect?

Am also doing this only…

First retrieving the comments from database, after submission…
or Can you explain how to do this…

Mandes · February 24, 2011, 9:37am

Yeah, as Guido has pointed its the order in which you are doing things on submission thats your problem.

On form submission you need to

Save the data to the database
THEN
reload from the database and display comments

As a finer point not related to your problem consider using CSS for your page layout, not tables.

venkat6134 · February 24, 2011, 9:46am

I can’t get you…
In my code,
first selecting the data from database and displaying them…
and after submitting the form only, i am inserting the new one…

Is it correct or not?

Mandes · February 24, 2011, 9:57am

How can your page display the new data, when you are only posting it to the database after you have written the page ?

you must post the new data to the database
THEN
retrieve the contents of the database for display

I cant make it any clearer my friend

Mandes · February 24, 2011, 10:16am


&lt;?php 
//connect to your database 
 
 
 
//FIRST WE ADD ANY NEW COMMENTS TO THE DATABASE
 
if(isset($_POST['submit'])) { 
        $username1=addslashes($_POST['username']); 
        $contact=addslashes($_POST['contact']); 
        $subject=addslashes($_POST['subject']); 
        $comment=addslashes($_POST['comment']); 
 
//try to prevent multiple posts and flooding... 
$c = "SELECT * from `test_table` WHERE ip = '".$_SERVER['REMOTE_ADDR']."'"; 
  $c2 = mysql_query($c); 
     while($c3 = mysql_fetch_object($c2)) { 
      $difference = time() - $c3-&gt;time; 
     if($difference &lt; 300) $error.='&lt;u&gt;&lt;b&gt;ALERT:&lt;/u&gt; '.$c3-&gt;username.', You have already commented earlier; if you have a question, try the forums!&lt;/b&gt;&lt;BR&gt;'; 
      } //end while 
if($_POST['check'] == $_SESSION['check']){ 
  //add comment 
 $q ="INSERT INTO `test_table` 
            (article_id, page, date, time, username, ip, contact, subject, comment) 
             VALUES 
            ('".$_GET['id']."', '".$_POST['page']."', '".$_POST['date']."', '"
               .$_POST['time']."', '".addslashes(htmlspecialchars($_POST['username']))."', '"
               .$_SERVER['REMOTE_ADDR']."', '".addslashes(htmlspecialchars($_POST['contact']))."', '"
               .addslashes(htmlspecialchars($_POST['subject']))."', '"
               .addslashes(htmlspecialchars(nl2br($_POST['comment'])))."')"; 
 
$q2 = mysql_query($q); 
  if(!$q2) die(mysql_error()); 
 
     } 
} 
 
 
//THEN WE READ THE DATABASE AND DISPLAY COMMENTS
 
//query comments for this page of this article 
$inf = "SELECT * FROM `test_table` WHERE page = '".stripslashes($_SERVER['REQUEST_URI'])."' ORDER BY time ASC"; 
 $info = mysql_query($inf); 
     if(!$info) die(mysql_error()); 
 
   $info_rows = mysql_num_rows($info); 
if($info_rows &gt; 0) { 
   echo '&lt;h5&gt;Comments:&lt;/h5&gt;'; 
   echo '&lt;table width="95%"&gt;'; 
 
 while($info2 = mysql_fetch_object($info)) { 
echo '&lt;tr&gt;'; 
echo '&lt;td&gt;"'.stripslashes($info2-&gt;subject).'" by:  &lt;b&gt;' .stripslashes($info2-&gt;username).'&lt;/b&gt;&lt;/td&gt; &lt;td&gt;&lt;div align="right"&gt;'.date('h:i:s a', $info2-&gt;time).' on '.$info2-&gt;date.'&lt;/div&gt;&lt;/td&gt;'; 
echo '&lt;/tr&gt;&lt;tr&gt;'; 
echo '&lt;td colspan="2"&gt; '.stripslashes($info2-&gt;comment).' &lt;/td&gt;'; 
echo '&lt;/tr&gt;'; 
echo '&lt;tr&gt;&lt;td colspan="2"&gt;&lt;hr&gt;&lt;/td&gt;&lt;/tr&gt;'; 
}//end while 
 
echo '&lt;/table&gt;'; 
//echo '&lt;hr width="95%" noshade&gt;'; 
} else echo 'No comments for this page. Feel free to be the first &lt;br&gt;'; 
 
 
 
 
 
 
 
 
 
 
 
//display form
?&gt; 
&lt;legend&gt;Post a comment&lt;/legend&gt; 
&lt;div style="font-size:13px; color:#cc0000; margin-top:10px; margin-left:15px"&gt;&lt;?php echo @$error; ?&gt;&lt;/div&gt;&lt;br/&gt; 
&lt;form name="comments" action="&lt;?php $_SERVER['PHP_SELF']; ?&gt;" method="post"&gt; 
 
&lt;input type="hidden" name="page" value="&lt;?php echo($_SERVER['REQUEST_URI']); ?&gt;"&gt; 
&lt;input type="hidden" name="date" value="&lt;?php echo(date("F j, Y.")); ?&gt;"&gt; 
&lt;input type="hidden" name="time" value="&lt;?php echo(time()); ?&gt;"&gt; 
 
&lt;table width="90%" border="0" cellspacing="0" cellpadding="0"&gt; 
   &lt;tr&gt; 
      &lt;td&gt;&lt;div align="right"&gt;Name:   &lt;/div&gt;&lt;/td&gt; 
       &lt;td&gt;&lt;input name="username" type="text" size="30" value="&lt;?php echo @$username1; ?&gt;"&gt;&lt;/td&gt; 
   &lt;/tr&gt;&lt;tr&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt; 
    &lt;tr&gt; 
      &lt;td&gt;&lt;div align="right"&gt;Email:   &lt;/div&gt;&lt;/td&gt; 
      &lt;td&gt;&lt;input type="text" name="contact" size="30" value="&lt;?php echo @$contact; ?&gt;"&gt;&lt;/td&gt; 
    &lt;/tr&gt;&lt;tr&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt; 
    &lt;td&gt;&lt;div align="right"&gt;Subject:   &lt;/div&gt;&lt;/td&gt; 
    &lt;td&gt;&lt;input type="text" name="subject" size="30" value="&lt;?php echo @$subject; ?&gt;"&gt;&lt;/td&gt; 
    &lt;/tr&gt;&lt;tr&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt; 
    &lt;tr&gt; 
      &lt;td&gt;&lt;div align="right"&gt;Comment:   &lt;/div&gt;&lt;/td&gt; 
      &lt;td&gt;&lt;textarea name="comment" cols="45" rows="10" wrap="VIRTUAL"&gt;&lt;?php echo @$comment; ?&gt;&lt;/textarea&gt;&lt;/td&gt; 
    &lt;/tr&gt; 
    &lt;tr&gt;&lt;td&gt;&lt;div align="right"&gt;&lt;img src="math_captchas.php"&gt;&lt;/div&gt;&lt;/td&gt; 
    &lt;td&gt;&lt;input type="text" name="check" size="5" maxlength="2" &gt;&lt;/td&gt;&lt;/tr&gt; 
    &lt;tr&gt;&lt;td&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt; 
    &lt;tr&gt; 
      &lt;td&gt;&lt;/td&gt; 
      &lt;td colspan="2"&gt;&lt;input type="reset" value="Reset Fields"&gt; 
        &lt;input type="submit" name="submit" value="Add Comment"&gt;&lt;/td&gt; 
    &lt;/tr&gt; 
  &lt;/table&gt; 
&lt;/form&gt;

venkat6134 · February 24, 2011, 10:20am

Thank you, i got it now…
But now another problem is;
‘reset fields’ button is not resetting the fields…
and after successful insertion, i want to remove the data in the text fields, if it is having any errors it will show upto the successful insertion…

how to do this?

Mandes · February 24, 2011, 10:31am

The reset is working, the function of the reset is to return the field back to the default value, since you are writing the value field each time you output the form these are the default values.

Dont believe me ! Try changing one field then clicking reset, it will go back to your writen default value.

You only need to be entering these default values if there was an error with the data entered, so just add an if statement to check the validity of the entry.

If the entry was good you dont write the values, if the entry contained errors you do rewrite the values.

venkat6134 · February 24, 2011, 10:45am

At first time, it is resetting the fields…(means before form submitted)
Then how to reset to default values as null/empty after successful insertion?

And also,
i want to add an image for the verification…
that image is not displaying, why?

Mandes · February 24, 2011, 10:57am

I explained the reset back in the previous post and told you how to sort the problem. The first time isnt a problem for you as you are writing blank data to the fields therefore the reset takes it back to blank. Reread my answer.

For the image, you cannot just bolt together pieces of code found from the internet and expect it all to work, you have to have some understanding of basic principles.
We would need to see the code your using for the image BUT since this thread is now offtopic I suggest you repost another thread about the verification image once youve sorted the reset problem

venkat6134 · February 24, 2011, 11:10am

Thank you for all…
This problem is solved…