KidsLib/insert.php at main · cn666278/KidsLib · 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
<?php
    require('db.php');
    include("auth.php");

    $status = "";
    if(isset($_POST['new']) && $_POST['new']==1)
    {
    $trn_date = date("Y-m-d H:i:s");
    $name =$_REQUEST['name'];
    $age = $_REQUEST['age'];
    $submittedby = $_SESSION["username"];
    $ins_query="insert into new_record (`trn_date`,`name`,`age`,`submittedby`) values ('$trn_date','$name','$age','$submittedby')";
    mysqli_query($con,$ins_query) or die(mysqli_error($con));
    $status = "New Record Inserted Successfully.</br></br><a href='view.php'>View Inserted Record</a>";
}
?>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8">
        <title>Insert New Record</title>
        <link rel="stylesheet" href="css/style.css" />
        <style media="screen">
        a,p {
          font-family: "Times New Roman", Georgia, Serif;
        }
        body{
          background-image:linear-gradient(to right, #9980FA, #fbc2eb);
          list-style: none;
          background-color: white;
          color: white;
          font-family: "Times New Roman", Georgia, Serif;
        }
        </style>
    </head>
    <body>
        <div class="form">
             <p><a href="dashboard.php">Dashboard</a> | <a href="view.php">View Records</a> | <a href="logout.php">Logout</a></p>

            <div>
                <h1>Insert New Record</h1>
                <form name="form" method="post" action="">
                <input type="hidden" name="new" value="1" />
                <p><input type="text" name="name" placeholder="Enter Name" required /></p>
                <p><input type="text" name="age" placeholder="Enter Age" required /></p>
                <p><input name="submit" type="submit" value="Submit" /></p>
                </form>
                <p style="color:#FF0000;"><?php echo $status; ?></p>

                <br/><br/><br/><br/>
            </div>
        </div>
    </body>
</html>