how to create an edit form

weiwei

<?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 iteminfomation WHERE ID='$id'");
$sql1=mysql_query("SELECT NameOfTools,Brand FROM listofitem WHERE ID='$id'");
$information1=mysql_fetch_array($sql1);
$information=mysql_fetch_array($sql);

echo "<table border='1'>";
echo "<tr><td >NameOfTools</th><td >Brand</th><td>date</th></tr>";

echo"<tr><td>{$information1['NameOfTools']}</td>
<td>{$information1['Brand']}</td>
<td>{$information['Date']}</td>";
echo "</table>";
}

rincewind456

Do you have a question?

weiwei

yes. i juz forget to type my question. Acording to the code that i had post jus now, i would ike to create a form to edit the information that had display.But i dont know how to do it. Can u give mea help

weiwei

yes. i juz forget to type my question. Acording to the code that i had post now, i would ike to create a form to edit the information that had display.But i dont know how to do it. Can u give me help
<?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 iteminfomation 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'>NamaOfTools</th><td>JBrand</th><>Date</th></tr>";

echo"<tr><td>{$information1['NameOfTools']}</td>
<td>{$information1['Brand']}</td>
<td>{$information['Date']}</td>";
echo "</table>";
}

weiwei

i wish to create form to edit the information display by the code here .how to do it ?

<?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']);

echo "<table border='1'>";
echo "<tr><td >NameOfTools</th><td >Brand</th><td>date</th></tr>";

echo"<tr><td>{$information1['NameOfTools']}</td>
<td>{$information1['Brand']}</td>
<td>{$information['Date']}</td>";
echo "</table>";
}

ragedigital

echo"<form method='POST' name='toolForm' action='processform.php'>";

echo "<tr><td><input type='text' name='informationNameOfTools' value='".$information1['NameOfTools']."'></td>";

echo "<td> <input type='text' name='informationBrand' value='".$information1['Brand']."'></td>";

echo "<td><input type='text' name='informationDate' value='".$information['Date']."'></td>";

echo "<input type='submit' value='Hit Me!'></form></table>";

weiwei

sorry , i am new in PHP so that i am not well understanding in the code u had had submit. Can it be more detail?

ragedigital

This has more to do with FORMs in HTML than PHP.

In order to edit the data you already have, you have to create a FORM and import the data into the FORM using PHP and MySQL. You will then submit it to another page for processing or entry back into the database.

I created the FORM based upon the information you provided. I didn't create the processing page.

Did this clear anything up?

weiwei

yes i know about the creating of the form but i dont know how was the processing page.That is most difficult to me. Can you please help me?

ragedigital

Since the FORM uses the POST method, you will access the variables that are being passed by using $_POST.

So, if you want to update your database by using the POST'd variables use something like this:

<?php

$result = mysql_query("UPDATE listofitem SET NameOfTools = '".$_POST['informationNameOfTools']."', Brand = '".$_POST['informationBrand']."' WHERE ID='".$_POST['id']."'");

?>

You would have to create a similar query for the other TABLE.

Just create some HTML based upon whether the EDIT was successful...

<html>
<head>
</head>
<body>


if($result)
    echo 'You successfully EDITed your material";

</body>
</html>

EDIT: I had to do some EDITs because this page kept refreshing for some odd reason...

weiwei

Thanks a lot .I will try it out. I still have another question, is that i had create a html form and i want to insert the data in to my database using this form. my coding did not run any error but when i submit the new data, i seen like nothing appear in my data base. Below is my code can u check for me what is wrong?

<?php
require("config.php");
?>
<HTML>
<HEAD>
<TITLE>INSERT Data via PHP</TITLE>
</HEAD>
<BODY>
<?php
if (!isset($POST['submit'])) {
?>
<form action="" method="post">
<Table cellspacing =2 cellPadding =6 align=center border=1>
<TD>NameOfTools</TD>
<TD><Input name=NameOfTools></TD>
<TD>Brand</TD>
<TD><INPUT name=Brand</TD></TR>
</TR>
</TABLE>
<?php
} else {
$NameOfTools = $POST['NameOfTools'];
$Brand = $_POST['Brand'];
mysql_query("INSERT INTO listofitem (NameOfTools, Brand) VALUES ('$NameOfTools', '$Brand')");
echo "Success! Your favourite colour has been added!";
}

ragedigital

It may have to do with your single quotes around the TABLE name, try this:

mysql_query("INSERT INTO listofitem (NameOfTools, Brand) VALUES ('".$_POST['NameOfTools']."', '".$_POST['Brand']."')");

It also alleviates having to assign your POST variables.

So you can delete these 2 lines:

$NameOfTools = $POST['NameOfTools'];
$Brand = $POST['Brand'];

weiwei

i had try it but still seen like not responding