Untitled

<html>
<head>
<title>
Activity 4
</title>
</head>
<body>
<?php
$servername = "localhost";
$username = "s2012181_darvinh";
$password = "jtd9267197";
$my_db = "s2012181_hrdp";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $my_db);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";

$title = $_POST['n'];
$concept = $_POST['rc'];
$role = $_POST['mu'];
$id = $_POST['fp'];

$sql = "INSERT INTO hrdept (title, concept, role, id)
VALUES ('$title', '$concept', '$role', '$id')";

if (mysqli_query($conn, $sql)) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

$sql_select = "SELECT * FROM hrdept ORDER BY title, title ASC";
$result_select = mysqli_query($conn,$sql_select);

echo "<center><table border='1'>

<tr>

<th> Title </th>
<th> Concept </th>
<th> Role </th>
<th> ID </th>

</tr></center>";

while($row = mysqli_fetch_array($result_select))

{
echo "<center><tr>";

echo "<td>" . $row['title'] . "</td>";
echo "<td>" . $row['concept'] . "</td>";
echo "<td>" . $row['role'] . "</td>";
echo "<td>" . $row['id'] . "</td>";

echo "</tr>";
}
echo "</table></center>";

mysqli_close($conn);

?>
</body>
</html>