» » Php Mysql Editing data 


In editing the data, you can use the syntax as follow:


UPDATE name_table SET field1=new_value, field2=new_value, ...
WHERE condition1,condition2, ...



For example, we will try to edit one of the data from data_employees table:



file: edit.php for connection database




<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table>
<tr>
<td align="center">EDIT DATA</td>
</tr>
<tr>
<td>
<table border="1">
<?php
mysql_connect("localhost","root","");//database connection
mysql_select_db("employees");

$order = "SELECT * FROM data_employees";
$result = mysql_query($order);
while ($row=mysql_fetch_array($result)){
echo ("<tr><td>$row[name]</td>");
echo ("<td>$row[employees_number]</td>");
echo ("<td>$row[address]</td>");
echo ("<td><a href=\"edit_form.php?id=$row[employees_number]\">Edit</a></td></tr>");
}

?>
</table>
</td>
</tr>
</table>
</body>
</html>










The picture above is edit.php file where this file will show overall data in the table, then there is edit menu in the last column.



If you click the edit menu, it will bring the program to execute edit_form.php file. Edit_form.php file will show a form to edit the data which have been selected in the previous form. The mechanism is that the user chooses one of the data that will be edited in the first form (edit.php file) by clicking the edit menu in the right column. You can see edit_form.php program file as follow:




<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Form Edit Data</title>
</head>

<body>
<table border=1>
<tr>
<td align=center>Form Edit Employees Data</td>
</tr>
<tr>
<td>
<table>
<?php
mysql_connect("localhost","root","");//database connection
mysql_select_db("employees");
$id=$_REQUEST['id'];

$order = "SELECT * FROM data_employees where employees_number='$id'";
$result = mysql_query($order);
$row = mysql_fetch_array($result);
?>
<form method="post" action="edit_data.php">
<input type="hidden" name="id" value="<?php echo "$row[employees_number]"?>">
<tr>
<td>Name</td>
<td>
<input type="text" name="name"
size="20" value="<?php echo "$row[name]"?>">
</td>
</tr>
<tr>
<td>Address</td>
<td>
<input type="text" name="address" size="40"
value="<?php echo "$row[address]"?>">
</td>
</tr>
<tr>
<td align="right">
<input type="submit"
name="submit value" value="Edit">
</td>
</tr>
</form>
</table>
</td>
</tr>
</table>
</body>
</html>








Result:









By clicking the edit button, the program goes to the fourth program, edit_data.php file, which brings three variable such as $id variable which contains of employees number data, $name variable which contains of employees name data, and $address variable which contains of employees address. In order to know whether the data is already change or not, the program is re-instructed to edit.php file with the order of header (“location:edit.php”). Here is the edit_data.php program file:




<?php
mysql_connect("localhost","root","");//database connection
mysql_select_db("employees");

$name=$_REQUEST['name'];
$address=$_REQUEST['address'];
$id=$_REQUEST['id'];
//echo $name;
$order = "UPDATE data_employees SET name='$name', address='$address' WHERE employees_number='$id'";
mysql_query($order);
header("location:edit.php");
?>




























2:32 AM




Unknown


























































0
comments:
        
















Post a Comment



















        

      







Subscribe to:
Post Comments (Atom)















 





Top





Blogger Template