Prepopulating form fields with MySQL data

Gary_Kambic

Hello Guys,

I'm not sure where to find info on trying to prepopulate form fields with data from a record contained in my MySQL data. Any suggestions would be most appreciated.

Basically, I have a standard form that my client fills out each time they want to subscribe to my service. After the first subscription I place all their contact information into a MySQL DB table record.

What I would like to do is have a login where they login with their e-mail address, then when they click on subscribe, the form would be prepopulated with the information from their record in the database table.

Let me know if you need any more information.

Thanks again in advance for the help,

Gary

webdes03

Load all of the data from your database before the table is displayed, then set value attributes for the firld with the variable from the database. So if you set a cookie or session variable with the id of the record in the database that contains that users information, you can then pull all of the info for that record, and throw it into the form.

Hope that makes sense.

LordShryku

Pretty basic

<?php
// connect
$connect = mysql_connect("", "", "");
mysql_select_db("", $connect);

// query
$sql = "SELECT field1, 
               field2
        FROM   table
        WHERE  email = '".$emailAddress."'";

$result = mysql_query($sql);

// if we have rows, fetch them
if(mysql_num_rows($result) > 0) {
   $row = mysql_fetch_array($result);
}
?>

<html>
<head>
</head>
<body>
<form>
Field 1: <input type="text" name="field1" value="<?=$row['field1']?>">
<br />
Field 2: <input type="text" name="field2" value="<?=$row['field2']?>">
<br />
<input type="submit">
</form>
</body>
</html>

HTH

Gary_Kambic

Hey, thanks for the help. I'll give it a try. Seems pretty straight forward like you said.

Thanks,

Gary

Gary_Kambic

Hello,

I tried it and it works great except for one little tweak I hope you can help me with.

I have a select field as follows:

<tr>
<td height="25" align="right" valign="middle" bgcolor="#CCCCCC"><font color="#FF0000" face="Verdana, Arial, Helvetica, sans-serif" size="2"><strong>*</strong></font><font color="#000000" face="Verdana, Arial, Helvetica, sans-serif" size="2">Agency</font> </td>
<td align="right"><select name="agencytype" value="<?php print($agency_type);?>" size="1">
<option selected>< --------------------------------------------- Select ---------------------------------------------- ></option>
<option value="INFO1">INFO1 </option>
<option value="INFO2">INFO2 </option>
<option value="INFO3">INFO3 </option>
<option value="INFO4">INFO4 </option>
<option value="INFO5">INFO5 </option>
<option value="INFO6">INFO7 </option>
<option value="INFO8">INFO8 </option>
</select></td>
</tr>

I placed the statement value="<?php print($agency_type);?>"

and it doesn't display. Am I placing it incorrectly or do I have to something else to override the select pull-down default?

Thanks much,

Gary

LordShryku

No, you should put it in an option tag

<select name="agencytype">
<? 
// make sure it exists
if(isset($agency_type)) {
?>
  <option value="<?=$agency_type?>"><?=$agency_type?></option>
<?
}
?>

Gary_Kambic

Thanks, it worked great!