Form data not showing up - could use some help

m0untaind0g

Hi there,
I have a script where the administrator of the site can add / edit / delete records. Here's how its works: basically the admin selects a user from a drop down menu and hits submit. This goes to a page where it queries the DB and returns some basic info - name, email address and so forth.

For example: You selected Jim Shoe - his email address is gym@jim.com, lives at 123 Downing St. and so forth.

The problem I am having is when the user returns to this "hub" page from editing a record or adding record it comes back blank. How can I get to show the information again? Are sessions and cookies the answer? Any insight on how to do this is appreciated.

Thanks Craig

nemonoman

You have to write the data into the form if you want it to show up.

Instead of, say

You'd want to say

Kudose

You will need to modify this to fit your needs but it works properly.

Code provided by http://www.spechal.com

<? 
session_start();
$username = $_SESSION['username@spechal.com'];
include('dbinfo.inc.php');
include('css.php');
?>
<html>
<head>
<title>.::Spechal Developments presents KC Events::.</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<? if(isset($_POST['fname'])){
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$phone = $_POST['phone'];
$email1 = $_POST['email1'];
$email2 = $_POST['email2']; 
if($phone == '' || $email1 == '' || $email2 == '' || $fname == '' || $lname == ''){ 
echo "Error.  Please fill out all required fields. <br>"; 
?> <form>
<input type="button" value="<-Back" onclick="history.back();">
</form>
<? } elseif($email1!=$email2){
echo "Error.  Email addresses do not match. <br>"; 
?> <form>
<input type="button" value="<-Back" onclick="history.back();">
</form>
<? } else {
if (getenv ("HTTP_X_FORWARDED_FOR")) { 
  $ip = getenv ("HTTP_X_FORWARDED_FOR"); 
} else { 
  $ip = getenv ("REMOTE_ADDR"); 
}
$email = $_POST['email1'];
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$phone = $_POST['phone'];
mysql_query("UPDATE calendar_users SET fname='$fname', lname='$lname', phone='$phone', email='$email', ip='$ip' WHERE username='$username'") or die(mysql_error());
echo "<center><font face='Tahoma' size='2'><b>Information updated.  Please <a href='index.php'>re-login.</a></b></font></center>";
session_destroy();
}} else { 
$q = mysql_query("SELECT * FROM calendar_users WHERE username='$username'") or die(mysql_error());
extract(mysql_fetch_array($q));
?>
<form action="<?=$PHP_SELF?>" method="post" name="editinfo">
  <table width="75%" border="0" align="center">
  <tr><td><img src="images/banner.gif" height="100" width="685"></td></tr></table>
     <table width="75%" border="0" align="center">
	<tr> 
      <td width="23%" height="25"><strong><font size="2" face="Tahoma">First Name: 
        </font></strong></td>
      <td width="77%"><strong><font size="2" face="Tahoma"> 
        <input name="fname" type="text" id="fname" size="24" maxlength="12" value=<?=$fname?>>
        * </font></strong></td>
    </tr>
    <tr> 
      <td><strong><font size="2" face="Tahoma">Last Name: </font></strong></td>
      <td><strong><font size="2" face="Tahoma"> 
        <input name="lname" type="text" id="lname" size="24" maxlength="24" value=<?=$lname?>>
        * </font></strong></td>
    </tr>
    <tr> 
      <td><strong><font size="2" face="Tahoma">Valid Email Address:</font></strong></td>
      <td><strong><font size="2" face="Tahoma"> 
        <input name="email1" type="text" id="email1" size="24" maxlength="63" value=<?=$email?>>
        * </font></strong></td>
    </tr>
    <tr> 
      <td><strong><font size="2" face="Tahoma">Confirm Email Address:</font></strong></td>
      <td><strong><font size="2" face="Tahoma"> 
        <input name="email2" type="text" id="email2" size="24" maxlength="63"  value=<?=$email?>>
        * </font></strong></td>
    </tr>
    <tr> 
      <td><strong><font size="2" face="Tahoma">Phone Number</font></strong></td>
      <td><strong><font size="2" face="Tahoma"> 
        <input name="phone" type="text" id="phone" size="24" maxlength="18"  value=<?=$phone?>>
        * </font></strong></td>
    </tr><tr><td>  <?
  if (getenv("HTTP_X_FORWARDED_FOR")) { 
    $ip = getenv("HTTP_X_FORWARDED_FOR"); 
} else { 
    $ip = getenv("REMOTE_ADDR"); 
} 
?><input type="hidden" name="ip" value="<?= $ip ?>">
        <font size="2" face="Tahoma"><strong>&nbsp;*required</strong></font></td>
    </tr>
	<tr><td><input type="image" src="images/submit.jpg" value="Submit Form"></td><td></td></tr>
  </table>

</form>

</body>
</html>
<? } ?>

m0untaind0g

Basically I included a this:
echo "
<form action='client_info.php'method='post'>
<input type='button' name='submit' value='Back' onclick='history.back();'></button>
<input type='hidden' name='$user_id' />
<input type='hidden' name='PHPSESSID' value=''.session_id().''>
</form>";

It works great on my Mac, however, when I test it on Windows box (IE 6.0) it freaks out with a "Warning: Page Had Expired" any suggestions?

nemonoman

The method proposed by Kudose might reasonably be assumed to generate that message. It is the IE message when a no-cache page has been submitted. The submit button on the previous page has pushed data to the database. It is now up to the programmer...you...to create a new page showing the results of that push. If you haven't populated input and other elements with data, there's not going to be any data in those elements.

If you want data to appear on the returned page, populate those areas by adding the submitted data to the page elements. YOu have to do this work, IE isn't programmed to respond to a guess that you meant for the data to be retained after a submit.

m0untaind0g

Its not an issue of doing the work. I am just not exaclty sure what I need to do. Seems to me there has to be an easy solution to this problem and its something I am not seeing or understanding.

Here is the code:
<?
$POST["user_id"];
$POST["name"];

include '../include/dbadmin.php';

$query = "SELECT * FROM users WHERE name='$name' ";
$msg = "<span style='color:red'>Could find update record</span>";
$result = mysql_query($query, $db) or die ($msg);

echo("<table width='100%' cellpadding='5' id='result_table'>");

while($row = mysql_fetch_array($result))
{
$HTTP_SESSION_VARS['user_id'] = '$result';
if(isset($HTTP_SESSION_VARS['user_id']))
{

echo ("<tr>");
echo ("<td>You have selected client: <b>".$row[name]."</b></td>");
echo ("</tr>");
echo ("<tr>");
echo ("<td>Username / Email: <a href='mailto:$row[username]'> ".$row[username]."</a></td>");
echo ("</tr>");
echo ("<tr>");
echo ("<td>Client Infoformation:<br />
Age <b>".$row[age]."</b><br />
Address: <b>".$row[address]."</b><br />
City: <b>".$row[city]."</b><br />
State: <b>".$row[state]."</b><br />
Zip: <b>".$row[zip]."</b>
<p>Phone: <b>".$row[phone]."</b></p></td>");
echo ("</tr>");
echo ("<tr>");
echo ("<td>What would you like to do?
<ul>
<li>Edit their contact information</li>
<li><a href='client_info_add.php?user_id=$row[0]$user_id'>Add</a> a training Log</li>
<li><a href='client_training_results.php?user_id=$row[0]$user_id'>View</a> thier MOST current training log</li>
<li><a href='javascript:confirmdelete(\"$row[0]$user_id\")'>Delete</a> this user</li>
</ul>");
echo ("<tr>");
echo ("</table>");
}
}
?>

Kudose

chage it to:

$result = $POST['user_id'];
$name = $POST['name'];