PHP MySQL: Editing data


php mysql basic step by step tutorial - part 13: 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: db.inc.php for connection database

<?
//file include for database connection
//db.inc.php
//database connection
mysql_connect("localhost","root","admin");

// database selection
mysql_select_db("employees");
?>

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">
      <?
      include"db.inc.php";//database connection
      $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>
php mysql list edit data

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 choose 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>
      <?
      include "db.inc.php";//database connection
      $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="<? echo "$row[employees_number]"?>">
        <tr>        
          <td>Name</td>
          <td>
            <input type="text" name="name" 
        size="20" value="<? echo "$row[name]"?>">
          </td>
        </tr>
        <tr>
          <td>Address</td>
          <td>
            <input type="text" name="address" size="40" 
          value="<? 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>
php mysql form edit

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:

<?
//edit_data.php
include "db.inc.php";
$order = "UPDATE data_employees 
          SET name='$name', 
              address='$address' 
          WHERE 
	      employees_number='$id'";
mysql_query($order);
header("location:edit.php");
?>


Series this article:
PHP MySQL: Connecting to Database Use mysql_connect()
PHP MySQL: Making Database Use mysql_create_db()
PHP MySQL: Making Table
PHP MySQL: The Data Type of Field
PHP MySQL: Char and Varchar Data Type
PHP MySQL: Data Type of Date
PHP MySQL: MySQL Syntax Orders
PHP MySQL: Inserting Data
PHP MySQL: Creating Form Insert Data
PHP MySQL: Display Data
PHP MySQL: mysql_fetch_row() Function
PHP MySQL: mysql_fetch_array() Function
PHP MySQL: Editing data
PHP MySQL: Deleting data
PHP MySQL: Adding Field Table
PHP MySQL: Editing Field Table
PHP MySQL: Deleting Field Table

Bookmark and Share Tag: mysql, database, data, edit Category: PHP Database Post : March 02nd 2008 Read: 176,853

advertisements


blog comments powered by Disqus