Updating Data into MySQL Database

Hello dear readers! welcome back to another section of our tutorial on PHP. In this section of our PHP tutorial, we will be studying about how to Update Data into MySQL Database.

Data can be updated into MySQL tables by executing SQL UPDATE statement using PHP mysql_query function.

Following below is a very simple example to update records into employee table. To update a record in any table, it is required to locate that record by using a conditional clause. Below example makes use of primary key to match a record in employee table.


Try the following example below to understand update operation. You need to provide an employee ID to update an employee salary.

      <title>Update a Record in MySQL Database</title>
         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" ;
            $retval = mysql_query( $sql, $conn );
            if(! $retval ) {
               die('Could not update data: ' . mysql_error());
            echo "Updated data successfully\n";
         }else {
               <form method = "post" action = "<?php $_PHP_SELF ?>">
                  <table width = "400" border =" 0" cellspacing = "1" 
                     cellpadding = "2">
                        <td width = "100">Employee ID</td>
                        <td><input name = "emp_id" type = "text" 
                           id = "emp_id"></td>
                        <td width = "100">Employee Salary</td>
                        <td><input name = "emp_salary" type = "text" 
                           id = "emp_salary"></td>
                        <td width = "100"> </td>
                        <td> </td>
                        <td width = "100"> </td>
                           <input name = "update" type = "submit" 
                              id = "update" value = "Update">

Alright guys! This is where we are rounding up for this tutorial post. In our next tutorial guide, we will be discussing about how to Delete Data from MySQL Database using PHP.

Feel free to ask your questions where necessary and i will attend to them as soon as possible. If this tutorial was helpful to you, you can use the share button to share this tutorial.

Follow us on our various social media platforms to stay updated with our latest tutorials. You can also subscribe to our newsletter in order to get our tutorials delivered directly to your emails.

Thanks for reading and bye for now.