We help IT Professionals succeed at work.
Get Started

PHP Website / MySQL Database Delay

214 Views
Last Modified: 2012-05-11
Hello,

I have a simple web app built in PHP.  

There is a data entry form (for entering numeric values).  When the user clicks submit, and INSERT statement is executed, and the user is automatically directed (via HTML redirect) to the grid view of said data.

We ran this system off of an older Mandriva 2007 server, and it worked perfectly.  Data was immediately entered into the database, and upon viewing the Grid, the data was there.

We've migrated to a new server, and found the following:  
-After inserting and redirecting to the grid, the new data is not on the grid
-I immediately check the MySQL database, and see the data is inserted
-If I continuously refresh the PHP grid, within 30-45 seconds, the data appears.

I need to make this data show up immediately.  Since the data is in the database, immediately after clicking submit, I'm not sure why the data wouldn't immediately show up on the PHP grid.

I am populating the grid with a simple SELECT statement, that worked perfectly on the last server.

Any thoughts, is there anything about the newer MySQL or Apache (PHP) that would explain this, perhaps a setting I need to change?

Thanks
Comment
Watch Question
Software Developer
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 8 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE