Problem with MySQL Page Refresh

**Y-aji** · 11:38 PM

Hello all:

I have not been online for some time, I know, however, all the help i have received has not been for nothing. I am still working restlessly with web and have maticulously worked my way from plain html (2yrs ago), to css driven html(1yr ago), to php(6m ago), and now php w/ mysql functionality (i feel like I'm playing WoW and leveling up or something.)

Anyway, to the question:

I have been designing database driven websites for a few months, now and continuously run into the same problem. When I delete something, or change something, or add something, I have to manually refresh the page to get the updated information. I have tried header and my server gets really p****d off about it.
Any suggestions on updating a page without the use of header, or a solution for my code that will evade the need to refresh all-together?

Much thanks,

Keith

**NullPointer** · 11-14-2007, 05:29 PM

Maybe try a javascript refresh

**frost** · 11-14-2007, 09:35 PM

Are you deleting/changing/adding your database through AJAX or iframes?

If so, I can see how you would run across this issue. You could fix that with a refresh using a JavaScript refresh as NullPointer mentioned or an AJAX request.

If not, how are you getting this problem? Generally your PHP script will run the MySQL queries and do all of its processing at the beginning of the script, and all of the display/output stuff is done near the end of the script.

**amw_drizz** · 11-17-2007, 11:29 AM

i use javascript refresh for my sites when users modify their info, that parses through the same page, just refresh at the end with a passed var that skips the code of going to the mysql to insert or edit data

**metho** · 05:53 PM

This is a problem with your logic. When writing a script for a page that includes a form, which changes db records AND that page is displaying those records, you have to accommodate potential changes to the records in your logic.

For E.G

PHP Code:


			
<?php
//includes here


//PAGE VARS (GET & declare vars used out of form processing)
//include page var validation here as well

//FORM PROCESSING
//process your forms before pulling records for output to the webpage
//update/overwrite any session vars before proceeding to page processing


//PAGE PROCESSING
//pull your records from the db AFTER form processing

//HTML Output

?>
<html ...>