0
Write a PHP Program to insert a record into MYSQL database

Mumbai University > information technology > sem 4> Web Programming

Marks: 10M

Year : May16

0  upvotes
0

PHP Program to insert a record into MYSQL database

Data can be entered into MySQL tables by executing SQL INSERT statement through PHP function mysql_query. Below a simple example to insert a record into employee table.

Example

The following example to insert record into employee table.

<?php
   $dbhost = 'localhost:3036';
       $dbuser = 'root';
   $dbpass = 'rootpassword';
       $conn = mysql_connect($dbhost, $dbuser, $dbpass);
       
       if(! $conn ) {
      die('Could not connect: ' . mysql_error());
   }

   $sql = 'INSERT INTO employee '.
          '(emp_name,emp_address, emp_salary, join_date) '.
          'VALUES ( "guest", "XYZ", 2000, NOW() )';
          
       mysql_select_db('test_db');
       $retval = mysql_query( $sql, $conn );

   if(! $retval ) {
          die('Could not enter data: ' . mysql_error());
       }
       
       echo "Entered data successfully\n";
       
       mysql_close($conn);
?>

In real application, all the values will be taken using HTML form and then those values will be captured using PHP script and finally they will be inserted into MySQL tables.

While doing data insert its best practice to use function get_magic_quotes_gpc() to check if current configuration for magic quote is set or not. If this function returns false then use function addslashes() to add slashes before quotes.

Example

This example by putting this code into add_employee.php, this will take input using HTML Form and then it will create records into database.

<html>

   <head>
      <title>Add New Record in MySQL Database</title>
   </head>

   <body>
      <?php
         if(isset($_POST['add'])) {
                $dbhost = 'localhost:3036';
            $dbuser = 'root';
                $dbpass = 'rootpassword';
            $conn = mysql_connect($dbhost, $dbuser, $dbpass);

            if(! $conn ) {
                   die('Could not connect: ' . mysql_error());
                }
                
                if(! get_magic_quotes_gpc() ) {
                   $emp_name = addslashes ($_POST['emp_name']);
                   $emp_address = addslashes ($_POST['emp_address']);
                }else {
                   $emp_name = $_POST['emp_name'];
                   $emp_address = $_POST['emp_address'];
                }
                
                $emp_salary = $_POST['emp_salary'];
                
                $sql = "INSERT INTO employee ". "(emp_name,emp_address, emp_salary, 
               join_date) ". "VALUES('$emp_name','$emp_address',$emp_salary, NOW())";
                   
                mysql_select_db('test_db');
                $retval = mysql_query( $sql, $conn );

            if(! $retval ) {
                   die('Could not enter data: ' . mysql_error());
                }
                
                echo "Entered 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 Name</td>
                        <td><input name = "emp_name" type = "text" 
                           id = "emp_name"></td>
                     </tr>

                     <tr>
                        <td width = "100">Employee Address</td>
                        <td><input name = "emp_address" type = "text" 
                           id = "emp_address"></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 = "add" type = "submit" id = "add" 
                              value = "Add Employee">
                        </td>
                     </tr>

                  </table>
               </form>

            <?php
         }
      ?>

   </body>
</html>
0  upvotes
Please log in to add an answer.

Next up

Read More Questions

If you are looking for answer to specific questions, you can search them here. We'll find the best answer for you.

Search

Study Full Subject

If you are looking for good study material, you can checkout our subjects. Hundreds of important topics are covered in them.

Know More