Edit form, data not re-fill

nuttynibbles

im doing a edit profile page. the page would pull out data frm mysql and populate the forms respectively.

user will edit and update their profile. The page would then validate the value in the form. if there's an error, it would prompt the user. when this happen, the form do not retain the newly entered value but instead re-display what is pull out from the database.. how do i retain the newly entered value in the textbox?

here is my code:

<?php
//extract customer info
$query = "SELECT * FROM advertiser_test WHERE status='Enabled' AND cid='$cid'";
$result = mysql_query($query,$conn);
$rs = mysql_fetch_assoc($result);
...
//process logic

//update db

?>
<html>
..
<body>
<input name="txtEmail" type="text" id="txtEmail" value=<?php echo $rs['email']?> >
</body>
</html>

i understand that the reason is because when the re-page load, it would pull out user info frm mysql n re-display it into the text box.. so is there a way around it?

nuttynibbles

erm, doesn't anyone encounter this situation b4?😕

bradgrafelman

Where is $cid ever defined?

Also, try verifying that the SQL query succeeded:

$result = mysql_query($query,$conn) or die('MySQL error: ' . mysql_error() . '<br>Query: ' . $query);

nuttynibbles

well is actually
$query = "SELECT * FROM advertiser_test WHERE status='Enabled' AND cid=$_SESSION['cid']";

i save the customer id into a session when login

bradgrafelman

So did you try making the change I noted above? If so, was the error message displayed?

Also, you should make sure that display_errors is set to On and error_reporting is set to E_ALL because you should be getting this error message:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

Why? Because your syntax for referencing an item in an array is invalid. I normally concatenate when I use arrays in strings:

echo 'Your name is: ' . $_SESSION['name'] . ' !';

though you can also use this syntax:

echo "Your name is: $_SESSION[name]!";

Make sure you don't combine the two, though, as this is not correct:

echo "Don't ever do this: " . $_SESSION[name];

For more information on this syntax, see this manual page.

nuttynibbles

hi, i do not have problem extracting value out from database.. ok let me give u my senario..
1)user would use the edit page to update his profile.
2)user key in data and submit. (e.g: ahpabet in numeric field, which is incorrect)
3)system would validate the value in the text field.
4)since is wrong to key in alpabet in numeric field, the system would prompt the user w the following fields w error.
5)when this happen, the value the user keyed in earlier(the alphabet) could not be retain in the textbox. instead it would show what is in the database because i did a select statement at the very top of the page(did this so i could extract and populate the text box w data).
6)so how do i retain the value in the text box? =)

ahundiak

If the validation fails then don't pull the data from the database. instead, use whatever the user posted and feed it back into the form along with an indication of what went wrong.

jkurrle

What you could do is have two seperate variables for each value part of the <input> line. The first variable name is what you pull from the database, the second is passed back from the referring script.

Use an if/else to evaluate if the passback is set. If it is, use that variable in the <input> line. If not, use the database variable instead.

Does this make sense?

schwim

Hi there nuttynibbles.

I solved this problem by doing the following on a form input system I wrote:

When submitting the form, it placed the data into session variables. If any of the data got rejected, it sent them back to the submission page where it used a simple if statement to determine whether a session value existed, and if it did exist, it populated the data with that instead of the default values.

<INPUT TYPE='text' NAME='name_last' SIZE='25' MAXLENGTH='40'");

			if(ISSET($_SESSION['name_last'])){

			 	echo(" value='".$_SESSION['name_last']."'");

			 }else{
                                    echo(" value='".$row['name_last']."'");
                             }

			 echo(">

You can find the script here if you want to see it live. It has some good examples, since I had to deal with a lot of different types of form elements.

thanks,
json