Field Name + Data

RynMan

Hey guys

I'm guessing this is probably pretty simple for anyone who's not a PHP rookie.

I have my database, and I'd like to be able to create a page with a form, whereby the user can modify the values for that particular record in the database.

I'd imagine I'll use the 'mysql_query' function to call the query based on the ID carried across from the previous page. From there, I'm a little stuck. I'd like this page to have all of the fields from the query (*), and the value currently in the database in the fields, for that particular ID.

I noticed the 'mysql_fetch_field' function, but how do I then have the data for that field and the specified record (in the query) as well?

Thanks for any help you can provide!

devinemke

a simple example (with no real form validation)

<?php
mysql_connect('host', 'user', 'password') or exit(mysql_error());
mysql_select_db('dbname') or exit(mysql_error());

if (!isset($_POST['submit']))
{
	if (isset($_GET['id']) && $_GET['id']) {$id = (int) $_GET['id'];} else {exit('no ID passed');}
	$result = mysql_query('SELECT name, email FROM table WHERE id = ' . mysql_real_escape_string($id)) or exit(mysql_error());
	if (mysql_num_rows($result))
	{
		$row = mysql_fetch_assoc($result);
		$row = array_map('htmlspecialchars', $row);

	echo '
	<form action="" method="post">
	name: <input type="text" name="row[name]" value="' . $row['name'] .  '"><br>
	email: <input type="text" name="row[email]" value="' . $row['email'] .  '"><br>
	<input type="hidden" name="id" value="' . $id . '">
	<input type="submit" name="submit" value="update">
	</form>		
	';
}
else
{
	echo 'no rows found matching ' . $id;
}
}
else
{
	foreach ($_POST['row'] as $key => $value)
	{
		$value = trim($value);
		if ($value != '') {$sql[] = $key . " = '" . mysql_real_escape_string($value) . "'";} else {$sql[] = $key . ' = NULL';}
	}

$result = mysql_query('UPDATE table SET ' . implode(', ', $sql) . ' WHERE id = ' . mysql_real_escape_string($_POST['id'])) or exit(mysql_error());
echo 'row ' . $_POST['id'] . ' updated';
}
?>