any body can give me a starting code to create the edit form?

weiwei

i would like to create a form to edit the below display information. i had find a lot of example to refr but still dont know how to start. Can anybody give a help?
Below is my code. How do i start with the below code to create a edit form ?

<?php

// check if id is passed to this routine
if (isset($GET['id'])) {
// if yes: remove harmful tags and save the passed id in variable $id
$id = strip_tags($GET['id']);

//required file for database connection
require("config.php");
echo "<table border='1'>";
// construct SQL statement
$sql = mysql_query("SELECT *FROM listofitem WHERE ID='$id'");
//$sql1=mysql_query("SELECT NamaPeralatan,Jenama FROM listofitem WHERE ID='$id'");
//$information1=mysql_fetch_array($sql1);
$information=mysql_fetch_array($sql);

echo "<table border='1'>";
echo "<tr><td bgcolor='#CCCCFF'>Nama Peralatan</th><td bgcolor='#CCCCFF'>Jenama</th><td bgcolor='#CCCCFF'>Tahun Dibekalkan</th></tr>";

echo"<tr><td>{$information['Name']}</td>
<td>{$information['Brand']}</td>
<td>{$information['Date']}</td>

echo "</table>";
}

mjax

<?
//required file for database connection
require("config.php");

// should we save data?
if($_POST['action'] == 'save']) {
	// is this an existing object?
	if(is_numeric($_POST['id'])) {
		// yes, so update it
		mysql_query("
			UPDATE 
				listofitem 
			SET 
				Name = '".mysql_real_escape_string($_POST['Name'])."', 
				Brand = '".mysql_real_escape_string($_POST['Brand'])."', 
				Date = '".mysql_real_escape_string($_POST['Date'])."'
			WHERE
				ID = '".mysql_real_escape_string($_POST['id'])."'
		") || die("SQL error: ".mysql_error());
	} else {
		// no, add a new row
		mysql_query("
			INSERT INTO
				listofitem 
			SET 
				Name = '".mysql_real_escape_string($_POST['Name'])."', 
				Brand = '".mysql_real_escape_string($_POST['Brand'])."', 
				Date = '".mysql_real_escape_string($_POST['Date'])."'
		") || die("SQL error: ".mysql_error());
	}

// redirect to list view
header("Location: index.php");
exit;
}

// fetch details for this object
$row = mysql_fetch_array(mysql_query("SELECT * FROM listofitem WHERE ID='".mysql_real_escape_string($_REQUEST['id'])."'"));
?>
<html>
<body>
	<form method="post">
		<input type="hidden" name="id" value="<?=$_REQUEST['id']?>">
		<table>
			<tr>
				<td>Nama Peralatan:</td> 
				<td><input type="text" name="Name" value="<?=htmlentities($row['Name'])?>"></td> 
			</tr>
			<tr>
				<td>Jenama:</td> 
				<td><input type="text" name="Brand" value="<?=htmlentities($row['Brand'])?>"></td> 
			</tr>
			<tr>
				<td>Tahun Dibekalkan:</td> 
				<td><input type="text" name="Date" value="<?=htmlentities($row['Date'])?>"></td> 
			</tr>
		</table>
		<input type="submit">
	</form>
</body>
</html>

Save this as edit.php and call is as edit.php?id=XXX or just call edit.php to add a new item.

weiwei

sir thanks ur help.you are my angel . can i know what is the meaning of 'action' in the below line. Is it i need to replace with another thing ?
if($_POST['action'] == 'save']) {

mjax

Sorry, my bad. Just add this inside the form tags, best after the hidden ID tag:

<input type="hidden" name="action" value="save">

weiwei

Sir is it add like this?