MySQL-Query-Functions/InsertQuery.php at master · monica18p/MySQL-Query-Functions · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
<html>
<head>
    <title>Add new Record in MySQL DB</title>
</head>

<body>
<?php
if (isset($_POST['add'])) {
    $servername = "localhost";
    $username = "root";
    $password = "root";

//Create Conn
    $conn = mysql_connect($servername, $username, $password);

//Check Conn
    if (!$conn) {
        die("Could not connect: " . mysql_error());
    }
    echo "Connected successfully\n";

    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>