PHP Script working perfect in FF but not IE

Doc324

I am an experienced ASP/MS SQL programmer, but somewhat new to PHP. I am having an issue with the following code in IE. In FF it works flawlessly. The issue in IE is that when you edit the data and submit, it effects the database but continues to display the old information. Almost like the variables arent being refreshed. Its odd. Any help would be much appreciated.

if ($trigger=="" && $action=="updateC") {
$sql = "UPDATE users set email='".$POST['email']."',emergContact='".$POST['emergContact']."',
emergPhone='".$POST['emergPhone']."',dept='".$POST['dept']."',
firstName='".$POST['firstName']."',lastName='".$POST['lastName']."' WHERE username='".$SESSION['user']."'";
$message = "Update successful.";
mysql_query($sql);
header("Location:http://evilempire/empire/profile.php?message=".$message);
} else {
$sql = "SELECT
firstName,lastName,emergContact,emergPhone,email,lastLogin,dept,tcNumber
FROM users where username = '".$SESSION['user']."'";
$result = mysql_query($sql)
or die("SELECT Error: ".mysql_error());

	if(!$result) die("Query Failed.");

	$row = mysql_fetch_assoc($result);

	$firstName=$row['firstName'];
	$lastName=$row['lastName'];
	$emergContact=$row['emergContact'];
	$emergPhone=$row['emergPhone'];
	$email=$row['email'];
	$lastLogin=$row['lastLogin'];
	$dept=$row['dept'];
	$tcNumber=$row['tcNumber'];
}

[/color]

ClarkF1

It's not something simple like the way the browser cache works is it???

BTW, to make it easier you can put

around the code which displays it in different colours like in code editors.

Doc324

It could be a cache problem but I am unsure, because I do not have the experience with PHP. Basically this page does a few things. It displays a users info, displays loginInfo, allows the user to change their password, as well as allows the user to update their user info. I use triggers and action var's to handle the information but I cant figure out where the error is. After it runs the update query,it displays the data correctly. If I navigate away from that page and come back, it displays the old data. Even though the proper data is stored in the MySQL DB. I cant figure it out.

Doc324

If this helps better explain what I am experiencing...

If you click on the profile link, it loads the users information (first name, last name, email...). If you click "update this info", it loads the form to update the information. Once you change something, then hit submit, it updates the information and takes you back to the original page. If you click "update this info" again, the information that is displayed by default is the old info, not the new. What did I do wrong?

ClarkF1

After updating the info in IE, flush the cache (Tools -> Internet Options -> Delete) and then hit the update info button again

I don't have any MySQL experience so beyond that I can't help. There may be a way to force it to read from the database each time. If it's working in Firefox it's obviously updating the database okay.

Ludichrist

try sending this header

header("Cache-control: private");

dewen

Also, make sure the http proxy works well with browser(If your browser access web thru proxy). I had experience with it before.

Doc324

Ludichrist wrote:
try sending this header
header("Cache-control: private");

Would I put that at the top of the page?

Ludichrist

Doc324 wrote:
Would I put that at the top of the page?

It just has to be before any output is sent, otherwise you'll get an error. I generally make it the first line of the file after the <? tag. If there are any blank lines or spaces before the <? tag, you'll get an error.

Doc324

It didnt fix it. I wonder if this other glitch is caused by the same factor. I have this code to display the servers current time....

<?php print date('l, F jS Y, g:i A'); ?>

In Mozilla it always displays accurately, in IE it will display accurately on one page, but then 4 hrs off in the next. WTF is wrong with IE????

Doc324

Could it be the way the webserver is configured? It is an intranet webserver for a warehouse.

Ludichrist

I can't see the problem being your browser. PHP doesn't even know what a browser is. It just parses php code and passes it to the webserver to send to the browser. In this case, PHP is printing the date and passing it to whatever your webserver is as an html document. By the time it reaches your browser, it already has the date on it.

Doc324

Then how can it work fine in mozilla and not IE? Thats the part I dont understand and I am slamming my head off of the desk. I tested it on more than one machine and its the same issues.

Doc324

<?php
header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
?>

The code above fixed my problem. Thank god!!!