Updating Data into MySQL Database using php and html. Data can be executed by the SQL UPDATE statement mysql_query PHP function to update to MySQL tables.

Here is a simple example to update the record to the Employees table. To update any tables required by the use of conditional clauses found record. The following example uses the primary key matching employee records in the table.

Example

Try the following example to understand the update. You need to provide the number of employees update the employee’s Salary.


<html>

 <head>
 <titl>Update a Record in MySQL Database</title>
 </head>

 <body>
 <?php if(isset($_POST['update'])) 
{ $dbhost = 'localhost:3036'; 
$dbuser = 'root'; 
$dbpass = 'rootpassword'; 
$conn = mysql_connect($dbhost, $dbuser, $dbpass); 
if(! $conn ) { die('Could not connect: ' 
. mysql_error()); } $emp_id = $_POST['emp_id']; 
$emp_salary = $_POST['emp_salary'];
$sql = "UPDATE employee ". "SET emp_salary = $emp_salary ". "WHERE emp_id = $emp_id" ; 
mysql_select_db('test_db'); $retval = mysql_query( $sql, $conn ); 
if(! $retval ) { die('Could not update data: ' . mysql_error()); } echo "Updated data successfully\n"; mysql_close($conn); }else { ?>


<form method = "post" action = "<?php $_PHP_SELF ?>">
<table width = "400" border =" 0" cellspacing = "1" cellpadding = "2">
<tr>
<td width = "100">Employee ID</td>
<td><input name = "emp_id" type = "text" id = "emp_id"></td>
 </tr>
<tr>
<td width = "100">Employee Salary</td>
<td><input name = "emp_salary" type = "text" id = "emp_salary"></td>
 </tr>
<tr>
<td width = "100"> </td>
<td> </td>
 </tr>
<tr>
<td width = "100"> </td>
<td>
 <input name = "update" type = "submit" id = "update" value = "Update">
 </td>
 </tr>
 </table>
 </form&amp;gt
 <?php } ?>
 </body>
</html>