Web Prac 7

index.php
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <style>
        form {
            font-size: 1.2rem;
        }
        form div{
            margin: 10px;
        }

        h1{
            text-align: center;
        }
    </style>
    <title>Form</title>
</head>
<body>
    <form action="insert.php" method="post">
        <h1>Employee ID</h1>
        <fieldset>
            <div>
                <label for="empid">Employee ID: </label>
                <input type="number" name="id" id="empid"/>
            </div>
            <div>
                <label for="empname">Employee Name:</label>
                <input type="text" name="name" id="empname"/>
            </div>
            <div>
                <label for="empdept">Employee Dept:</label>
                <input type="text" name="dept" id="empdept"/>
            </div>
            <div>
                <label for="emppos">Employee Position:</label>
                <input type="text" name="pos" id="emppos"/>
            </div>
            <div><input type="submit" value="Submit">&nbsp;<input type="reset" value="Reset"></div>
        </fieldset>
    </form>
</body>
</html>

insert.php
<?php
$hostname = "localhost";
$username = "root";
$password = "";
$database = "urmum";

$conn = mysqli_connect($hostname, $username, $password, $database);

if(!$conn){
    die("Connection failed: ".mysqli_connect_error());
}
else{
    echo "Connection successful!";
}

$id = $_POST["id"];
$name = $_POST["name"];
$dept = $_POST["dept"];
$pos = $_POST["pos"];

$query = "INSERT INTO daemployees(empid, empdept, empname, emppos) VALUES ('$id','$dept','$name','$pos')";
if( mysqli_query($conn, $query) ){
    echo "<br/>Data entered successfully";
    header("Location: display.php");
    exit;
}
else{
    echo "Even a donkey is more useful than you!!";
}

mysqli_close($conn);
?>

display.php
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>The Table</title>
</head>
<body>
    <?php
        $hostname = "localhost";
        $username = "root";
        $password = "";
        $database = "urmum";

        $conn = mysqli_connect($hostname, $username, $password, $database);

        if(!$conn){
            die("Connection failed: ".mysqli_connect_error());
        }
        else{
            $query = "SELECT * from daemployees";
            $res = mysqli_query($conn, $query);
            if(mysqli_num_rows($res) > 0){
                echo "<table border='2' cellpadding='5' cellspacing='0'><tr>
                    <th>ID</th>
                    <th>Name</th>
                    <th>Department</th>
                    <th>Position</th>
                </tr>";

                while( $row = mysqli_fetch_assoc($res) ){
                   echo "<tr>
                    <td>" .$row['empid']. "</td>
                    <td>" .$row['empname']. "</td>
                    <td>" .$row['empdept']. "</td>
                    <td>" .$row['emppos']. "</td>
                    </tr>";
                }

                echo "</table>";
            }
            else{
                echo "No Data. Get fucked.";
            }
        }
        mysqli_close($conn);
    ?>
</body>
</html>