[Resolved] Refreshing a page after UPDATE

James0816

Is this really that hard??? I'm at wits end here. I have coded and coded, wiped it all out and coded some more. I'm not hitting on any combination that will work. Can someone please assist me in this to save my sanity?

Very simple....I have a page displaying information from my retrieved record. I want to update the info. I click submit...it updates the record. BUT....the page goes back to displaying the old data. I have to do a manual refresh of the screen to get it to display the new data. It should be displaying the changed information.

How in the world do I get this to work properly?

Here's my very simple plain vanilla code:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>
<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
<title>Update Test Page</title>
<?php
mysql_connect("localhost", "<id>", "<pw>") or die("Failure to communicate with database");
mysql_select_db("<db>");
$query = "SELECT name from <table> where sname='Bob'";
$result = mysql_query($query);
$parr=mysql_fetch_array($result);
?>
</head>

<body bgcolor="#ffffff">
<form name="form" method="POST" action="<?php echo $SERVER['PHP_SELF']; ?>">


<table width="616" border="1" cellspacing="2" cellpadding="0">
<tr>
<td width="120"></td>
<td width="120"></td>
<td width="120"><input type="text" name="tst" value="<?php echo $parr['name'] ?>"></td>
<td width="120"></td>
<td width="120"></td>
</tr>
<tr>
<td width="120"></td>
<td width="120"><input type="submit" name="Test1"></td>
<td width="120"></td>
<td width="120"><input type="reset" name="Test2"></td>
<td width="120"></td>
</tr>
</table>
</form>
</body>
</html>
<?php
if($POST['Test1']) {
$query = "UPDATE <table> set name='$tst' where sname='Bob'";
$result = mysql_query($query);
echo "It Worked";
} elseif($_POST['Test2']) {
echo "you have chosen to reset the form";
}
?>

<?php if (false) { ?><?php } ?>

devinemke

why would you expect to see the new data? you are doing your update query after your select query. think about your logic here:

you are fetching the data
you are displaying the data in a form
you are updating the data

you need to do step 3 before you do step 1

The_Chancer

Try:

<?php
if($_POST['Test1']) {
$query = "UPDATE <table> set name='$tst' where sname='Bob'";
$result = mysql_query($query);
echo "It Worked";
} elseif($_POST['Test2']) {
echo "you have chosen to reset the form";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>
<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
<title>Update Test Page</title>
<?php
mysql_connect("localhost", "<id>", "<pw>") or die("Failure to communicate with database");
mysql_select_db("<db>");
$query = "SELECT name from <table> where sname='Bob'";
$result = mysql_query($query);
$parr=mysql_fetch_array($result);
?>
</head>

<body bgcolor="#ffffff">
<form name="form" method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<!--
<form name="form" method="POST">
-->
<table width="616" border="1" cellspacing="2" cellpadding="0">
<tr>
<td width="120"></td>
<td width="120"></td>
<td width="120"><input type="text" name="tst" value="<?php echo $parr['name'] ?>"></td>
<td width="120"></td>
<td width="120"></td>
</tr>
<tr>
<td width="120"></td>
<td width="120"><input type="submit" name="Test1"></td>
<td width="120"></td>
<td width="120"><input type="reset" name="Test2"></td>
<td width="120"></td>
</tr>
</table>
</form>
</body>
</html>


<?php if (false) { ?><!-- Mock Content
"Updt/screenname" html {Label}
"Updt/st" text {}
--><?php } ?>

Your update was at the end - so it gets done AFTER you have selected the data and echoed it out.

James0816

makes sense...however...how can you update the record without first fetching the data you need to update. you can't update what you don't have as yet. so wouldn't you have to fetch it first, then display it on the screen to be seen and of course update according to any changes that were made?

What would be logical coding then?

devinemke

how can you update the record without first fetching the data you need to update. you can't update what you don't have as yet.

sure you can. you don't need the old value of a field to update that field. you only need to know which field it is, what the new data should be and which record it is. here's a very simplified example, let say you are looking at id #7 from a table:

// assuming already connected to db

if (isset($_POST['submit']))
{
	mysql_query("UPDATE table SET name = '" . $_POST['name'] . " WHERE id = 7");
}

$result = mysql_query('SELECT name FROM table WHERE id = 7');
$name = mysql_result($result, 0);

echo '
<form action="' . $_SERVER['PHP_SELF'] . '" method="POST">
name: <input type="text" name="name" value="' . $name . '"><br>
<input type="submit" name="submit" value="submit">
</form>
';

James0816

chance.....modified the code as you provided and it still does the same thing. table gets updated, message about updating appears...however data does not change to reflect new information unless page is manually refreshed.

James0816

dev...tried to get your code into mine and that didn't work at all...wouldn't even update the record.

James0816

Just tried several other ways and still nothing. The recordset gets updated and I thought the <?php echo $_SERVER['PHP_SELF']; ?> command was supposed to reload the page but it doesn't appear to do so. If it is reloading, then it is keeping the current values instead of grabbing new ones according to the the SELECT statement.

devinemke

post your new code

James0816

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>
<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
<title>Updating Test Page</title>
<?php
mysql_connect("localhost", "<id>", "<pw>") or die("Failure to communicate with database");
mysql_select_db("<db>");
$query = "SELECT name from <table> where id=13";
$result = mysql_query($query);
$parr=mysql_fetch_array($result);
?>

</head>

<?php
mysql_connect("localhost","<id>","<pw>") or die("Could not communicate with database");
mysql_select_db("<db>");

// assuming already connected to db

if ($POST['submit'])
{
mysql_query("UPDATE <table> SET name = '" . $POST['name'] . " WHERE id = 13");
}

$result = mysql_query('SELECT name FROM <table> WHERE id = 13');
$name = mysql_result($result, 0);

echo '
<form action="' . $_SERVER['PHP_SELF'] . '" method="POST">
name: <input type="text" name="name" value="' . $name . '"><br>
<input type="submit" name="submit" value="submit">
</form>
';

devinemke

James0816, the example i gave was just that: an example. you can't just paste that directly into your code as my example used different table/field names. again, it was simply an example to illustrate the basic logic. see updated "example" below which hopefully more closely follows your data structure:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
<title>Updating Test Page</title> 
</head>
<body bgcolor="#ffffff">

<?php 
mysql_connect("localhost", "<id>", "<pw>") or die("Failure to communicate with database"); 
mysql_select_db("<db>"); 

if (isset($_POST['submit'])) 
{ 
	$result = mysql_query("UPDATE <table> SET name = '" . $_POST['name'] . " WHERE sname = 'Bob'");
	if ($result) {echo 'sname Bob update successful';}
	else {echo 'sname Bob update FAILED';} 
} 

$result = mysql_query("SELECT name FROM <table> WHERE sname = 'Bob'");
$name = mysql_result($result, 0); 
?>

<br>
<br>
The following form displays the "name" field from the database record where sname = "Bob"<br>
<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST">
name: <input type="text" name="name" value="<? echo $name; ?>"><br>
<input type="submit" name="submit" value="submit"> 
</form> 

</body>
</html>

James0816

sry...knew it was just a sample...and i did modify it several times....but after seeing your post...i think i see where I may have goofed. let me go back to the drawing board.

James0816

had to tweak a wee bit but it does appear to be doing what I am looking for it to do.....for now.....until I actually apply it to a working copy of the page not the test page.

thx greatly!