data needs save in notepad to refresh

Ducca

Hi all, hope someone can help,
I have a form that inputs to the database then reads the data in php,my problem is the table displayed in the browser shows all the current data but not the new inputted data,
now if i go into the php script in notepad and press save when i go to the browser and refresh the new data appears
see code below
thanks for any help
Code:

<HTML>
<HEAD>
<LINK REL=stylesheet TYPE="text/css" HREF="wmd.css">
<TITLE>Inserting Data into a Database</TITLE>
</HEAD>
<BODY><center>

<?php

// Set the variables for the database access:

$host="localhost";
$user="Paul";
$password="";
$database = "auction";
$TableName = "auctiondata";

$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");

$db = mysql_select_db($database,$connection)
or die ("Couldn't select database");

$Query = "SELECT * FROM $TableName";

//print ("The query is:<BR>$Query<P>\n");

if (mysql_db_query ($database, $Query, $connection))

{
print ("Current items Available!<BR>\n");

}
else
{
print ("sorry !!auction Id already in use<BR>\n");
}

$query = "SELECT * FROM auctionData";
$result = mysql_query($query)
or die ("Couldn't execute query.");

/ Display results in a table /

print ("<TABLE BORDER=1 WIDTH=\"95%\" CELLSPACING=2 CELLPADDING=2 ALIGN=CENTER>\n");
print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
print ("<th ALIGN=CENTER VALIGN=TOP>AuctionId</th>\n");
print ("<th ALIGN=CENTER VALIGN=TOP>Name</th>\n");
print ("<th ALIGN=CENTER VALIGN=TOP>Item</th>\n");
print ("<th ALIGN=CENTER VALIGN=TOP> Item Description</th>\n");
print ("<th ALIGN=CENTER VALIGN=TOP>Startprice</th>\n");
print ("<th ALIGN=CENTER VALIGN=TOP>Startdate</th>\n");
print ("<th ALIGN=CENTER VALIGN=TOP>Expiresdate</th>\n");
print ("</TR>\n");

while ($row = mysql_fetch_array($result))

{
$auctionId = $row['auctionId'];
$userId = $row['userId'];
$item = $row['item'];
$itemDesc = $row['itemDesc'];
$startPrice = $row['startPrice'];
$startDate = $row['startDate'];
$expiresDate = $row['expiresDate'];

print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$auctionId</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$userId</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$item</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$itemDesc</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$startPrice</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$startDate</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$expiresDate</TD>\n");
print ("</TR>\n");
}
mysql_close ($connection);
echo "</table>\n";
?>
</center>
</body>
</html>

Norman_Graham

Hi Ducca

Yeah, well, if you're writing code in notepad and are testing it at the same time, you have to press save otherwise the browser looks at the version of the code from the last time you pressed save. So what's the problem with that?

Norm

Ducca

thanks for your reply,
the data is input via a form in html, the php then sends it to the database it then extracts it from the database and displays it in a table,
obviously if your writing scripts in notepad and change something you have to save your changes,
i,m not changing anything just using the form then reading the data, all the code works,
if i have 10 entries in a table, in mysql database
i then submit a new entry, the new entry isn,t shown in the table
p.s its in the database because you can see it in mysql,
but the table won,t display it unless i go to the script and press save, this is obviously a bug nothing to do with writing the script because the script hasn,t changed,it just isn,t doing its job properly,it should just display all entries in the table when you press submit,
i,m using

xitami,
mysql,
php
i,ve used the php refresh method it refreshes the page but doesn,t bring up the last entry,
hope thats clearer
thanx again

weekender

i'm guessing you're using internet explorer, right?

what's happening is when you reload your php script (to see the new data) the browser is looking at the last modified date of the script and thinking "the last modified date hasn't changed, therefore the script hasn't changed, therefore load up the cached output (for speed)". So when you save the script again (in notepad) the last modified date is updated (although you haven't changed anything), and the browser discards its cached output and fetches the php again.

note - some text editors (such as textpad) are clever enough to not bother re-saving a file that you haven't made changes to - notepad is not, though!

adam

Ducca

Cheers weekender, glad someone understands my problem,
and yeah it is explorer
so would you recommend i use another texteditor, can you recommend any
thanks again your a star 🙂
i.m going hunting on the net for a free download

laserlight

hehe, I suspected the same, but it couldnt understand why a text editor was involved.

The solution is simply to force the browser to refresh the page.

Ducca

Laserlight, i tried all that it refreshes the page, but not the data unless i,ve not done it right, but you can see it refresh after the time i tell it ie number of seconds, but data doesn,t change
cheers
Ducca

To refresh i put this in the head tags

cheers for your help

laserlight

You'll need to force the refresh on your web browser.

Not sure how to in Internet Explorer, though.

dnast

The expires META tag might fix your problem.

<META name="Expires" content="Mon, 01 Jan 2000 00:00:01 GMT"> or anything before now should stop the browser from caching your page.

Ducca

Cheers Dnast,
thanks for your help
Tried your suggestion
But still doesn,t workDucca🙁