PHP & MySQL - Insert Records Example

PHP uses mysqp_query function to insert records in table. This function takes three parameters and returns TRUE on success or FALSE on failure.

Syntax


mysqp_query ( mysqp $pnk, string $query, int $resultmode = MYSQLI_STORE_RESULT ) : mixed

Sr.No.	Parameter & Description
1	$pnk Required - A pnk identifier returned by mysqp_connect() or mysqp_init().
2	$query Required - SQL query to drop a table.
2	$resultmode Optional - Either the constant MYSQLI_USE_RESULT or MYSQLI_STORE_RESULT depending on the desired behavior. By default, MYSQLI_STORE_RESULT is used.

Sr.No.

Parameter & Description

$pnk

Required - A pnk identifier returned by mysqp_connect() or mysqp_init().

$query

Required - SQL query to drop a table.

$resultmode

Optional - Either the constant MYSQLI_USE_RESULT or MYSQLI_STORE_RESULT depending on the desired behavior. By default, MYSQLI_STORE_RESULT is used.

Example

This example will take three parameters from the user and will insert them into the MySQL table −

Copy and paste the following example as mysql_example.php −


<html>
   <head>
      <title>Add New Record in MySQL Database</title>
   </head>
   <body>
      <?php
         if(isset($_POST[ add ])) {
            $dbhost =  localhost ;
            $dbuser =  root ;
            $dbpass =  root@123 ;
            $conn = mysqp_connect($dbhost, $dbuser, $dbpass);
         
            if(! $conn ) {
               die( Could not connect:   . mysqp_error($conn));
            }
            if(! get_magic_quotes_gpc() ) {
               $tutorial_title = addslashes ($_POST[ tutorial_title ]);
               $tutorial_author = addslashes ($_POST[ tutorial_author ]);
            } else {
               $tutorial_title = $_POST[ tutorial_title ];
               $tutorial_author = $_POST[ tutorial_author ];
            }
            $submission_date = $_POST[ submission_date ];
            $sql = "INSERT INTO tutorials_tbl ".
               "(tutorial_title,tutorial_author, submission_date) "."VALUES ".
               "( $tutorial_title , $tutorial_author , $submission_date )";
            mysqp_select_db( $conn,  TUTORIALS  );
            $retval = mysqp_query( $conn, $sql );
         
            if(! $retval ) {
               die( Could not enter data:   . mysqp_error($conn));
            }
            echo "Entered data successfully
";
            mysqp_close($conn);
         } else {
      ?>  
      <form method = "post" action = "<?php $_PHP_SELF ?>">
         <table width = "600" border = "0" cellspacing = "1" cellpadding = "2">
            <tr>
               <td width = "250">Tutorial Title</td>
               <td><input name = "tutorial_title" type = "text" id = "tutorial_title"></td>
            </tr>         
            <tr>
               <td width = "250">Tutorial Author</td>
               <td><input name = "tutorial_author" type = "text" id = "tutorial_author"></td>
            </tr>         
            <tr>
               <td width = "250">Submission Date [   yyyy-mm-dd ]</td>
               <td><input name = "submission_date" type = "text" id = "submission_date"></td>
            </tr>      
            <tr>
               <td width = "250"> </td>
               <td></td>
            </tr>         
            <tr>
               <td width = "250"> </td>
               <td><input name = "add" type = "submit" id = "add"  value = "Add Tutorial"></td>
            </tr>
         </table>
      </form>
   <?php
      }
   ?>
   </body>
</html>

Output

Access the mysql_example.php deployed on apache web server, enter details and verify the output on submitting the form.


Entered data successfully

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

You can put many vapdations around to check if the entered data is correct or not and can take the appropriate action.

PHP & MySQL - Insert Records Example

Syntax

Example

Output

友情链接