PHP स्क्रिप्ट का उपयोग करके मौजूदा MySQL तालिका में डेटा कैसे सम्मिलित करें?

हम जानते हैं कि PHP हमें मौजूदा MySQL तालिका में डेटा सम्मिलित करने के लिए mysql_query फ़ंक्शन प्रदान करता है।

उदाहरण

इसे समझाने के लिए हम PHP स्क्रिप्ट की सहायता से 'Tutorials_tbl' नामक तालिका में डेटा सम्मिलित कर रहे हैं:

<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() ) {
                    $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')";
                mysql_select_db('TUTORIALS');
                $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 = "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>