Updating records

Tezread

I have developed a multipage form that carries out an insert but im stuck on how to incorporate the same approach for updating the record. At the top of each of my forms at present is:

[php

session_start();
require_once('common_functions.php');
$_SESSION['form1_data']='';

\php]

and my formhandler is:

[php

include("connect.php");
session_start();
require_once('common_functions.php');
$SESSION['form1_data'] = $POST;

// build main query from form 1
$sql = "INSERT INTO quality_info SET quality_id = NULL ";
foreach ($_SESSION['form1_data'] as $col =>$val ){
if($col <> 'submit'){
$sql .=", $col = '$val' ";
}
}
//////////////////////////////////
mysql_query($sql, $connection) or die(mysql_error());

//get last insert id
$sql ="select LAST_INSERT_ID() as id from quality_info";
$result = mysql_query($sql, $connection) or die(mysql_error());
$row=mysql_fetch_array($result);
$id = $row['id'];

\php]

I would like to be able to search for a record then have the form show with all the correspoding fields populated so they can be edited. Does this make sense?

devinemke

run a SELECT query on your table using the primary key field (id) then loop thru the fields of the result set and use the values to pre-populate the form. how that is exactly done will depend on the type of data.

for a text field:

echo '<input type="text" name="' . $field_name . '" value="' . $field_value . '">';

for a list (like for ENUM) store the choices in an array:

echo '<select name="' . $field_name . '">';
foreach ($array as $value)
{
	echo '<option value="' . $field_value . '"';
	if ($value == $field_value) {echo ' selected';}
	echo '></option>';
}
echo '</select>';

(for a list you could also use radio buttons, for a SET field you could have the select list allow multiple selections)

for a boolean field:

echo '<input type="checkbox" name="' . $field_name . '" value="Y"';
if ($field_value) {echo ' checked';}
echo '>';

these are just examples (without knowing anything about your exact data structure)