Untitled

db php 

<?php
$servername = "localhost";
$username = "root";
$password = "";   
$database = "lab10";


$conn = new mysqli($servername, $username, $password, $database);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
?>


insert.php


<?php
include 'db.php';


if ($_POST) {

    $sql = "INSERT INTO employees (ename, eno, department)
            VALUES ('$_POST[ename]', '$_POST[eno]', '$_POST[department]')";

    $conn->query($sql);

    echo "Employee Inserted Successfully";
}
?>
<link rel="stylesheet" href="style.css">


<div class="container">
<h2>Add Employee</h2>

<?php
if ($_POST) {
    $sql = "INSERT INTO employees (ename, eno, department)
            VALUES ('$_POST[ename]', '$_POST[eno]', '$_POST[department]')";
    $conn->query($sql);
    echo "<p class='success'>Employee Inserted Successfully</p>";
}
?>

<form method="post">
    Name:
    <input type="text" name="ename" required>

    Employee No:
    <input type="text" name="eno" required>

    Department:
    <input type="text" name="department" required>

    <input type="submit" value="Insert Employee">
</form>

<br>
<a href="display.php">View Employees</a>
</div>


display.php

<?php
include 'db.php';

$result = $conn->query("SELECT * FROM employees");

echo "<table border='1'>
<tr>
<th>ID</th>  
<th>Name</th>
<th>Employee No</th>
<th>Department</th>
<th>Action</th>
</tr>";

while ($r = $result->fetch_assoc()) {
    echo "<tr>
    <td>".$r['id']."</td>
    <td>".$r['ename']."</td>
    <td>".$r['eno']."</td>
    <td>".$r['department']."</td>
    <td>
        <a class='delete-btn' href='delete.php?id=".$r['id']."'>Delete</a>

    </td>
    </tr>";
}

echo "</table>";
?>
<link rel="stylesheet" href="style.css">

<br>

<a href="insert.php">Add Employee</a>


delete.php

<?php
include 'db.php';

$conn->query("DELETE FROM employees WHERE id=".$_GET['id']);

echo "Employee Deleted Successfully";
?>
<link rel="stylesheet" href="style.css">

<br><br>

<a href="display.php">Back to Employee List</a>