lab.php

<style>
    #idtable{
        width:80px !important;
    }
    table{
        width:80%;
    }
    td{
        border-bottom: inset 1px;
        text-align:center;
        width:auto;
        margin:0px auto;
    }
</style>
<?php
$servername = "localhost";
$username = "root";
$password = "12345678";
$dbname = "cmtc";
$conn = new mysqli($servername, $username, $password, $dbname);

if ($_POST) {
    if($_POST['status'] == 'Insert'){
         $id = $_POST['ID'];
        $Name = $_POST['Name'];
        $Lname = $_POST['Lname'];
        $Email = $_POST['Email'];

        echo $Name.$Lname.$Email;



        $sql = "INSERT INTO `onepiece` (ID,Name,Lname,Email) VALUES('$id','$Name','$Lname','$Email')";

        if ($conn->query($sql) !== FALSE){
            echo "Record add successfully";
            header( "location: http://localhost/lab.php" );
            exit(0);
        }else{
            echo "Error: " . $sql . "<br>" . $conn->error;
        }

    }
    if($_POST['status'] == 'update'){
        if ($_POST['status2'] == 'update') {
            $id = $_POST['id'];
            $Fname = $_POST['Name'];
            $Lname = $_POST['Lname'];
            $email = $_POST['Email'];

            echo $Fname.$Lname.$Email;

            $sql = "UPDATE `onepiece` SET Name='$Name',Lname='$Lname',Email='$Email' WHERE ID='$id'";

            if ($conn->query($sql) !== FALSE){
                echo "Record add successfully";
                header( "location: http://localhost/lab.php" );
                exit(0);
            }else{
                echo "Error: " . $sql . "<br>" . $conn->error;
            }
        }else{
            ?>
                <form method="post">
            <?php
            $id = $_POST['id'];
            $sql = "SELECT * FROM onepiece WHERE id=$id";
            $result = $conn->query($sql);

            if  ($result->num_rows > 0) {
                while($row = $result->fetch_assoc()){
                    ?>
ID :<input type="text" name="id" value="<?php  echo $row["id"]; ?>">
NAME :<input type="text" name="Name" value="<?php  echo $row["Fname"]; ?>">
LASTNAME :<input type="text" name="Lname" value="<?php  echo $row["Lname"]; ?>">
E-MAIL :<input type="Email" name="Email" value="<?php  echo $row["Email"]; ?>">
<input type="text" name="status" value="update" hidden>
<input type="text" name="status2" value="update" hidden>

 <input type=submit value=Submit>
<input type=reset value=Clear>
<?php
                }
            }
            ?>
                </form>
            <?php
        }
    }
    if($_POST['status'] == 'delete'){
        $id = $_POST['id'];
        $sql = "DELETE FROM `onepiece` WHERE ID='$id'";

        if ($conn->query($sql) !== FALSE){
            echo "Record add successfully";
            header( "location: http://localhost/lab.php" );
            exit(0);
        }else{
            echo "Error: " . $sql . "<br>" . $conn->error;
        }
    }
}else{
    ?>
    <form method="post">
ID :<input type="text" name="ID">
    NAME :<input type="text" name="Name">
    LASTNAME :<input type="text" name="Lname">
    E-MAIL :<input type="Email" name="Email">
    <input type="text" name="status" value="Insert" hidden>
    <input type=submit value=Insert>
    <input type=reset value=Clear>
    </form>
    <?php
        $sql = "SELECT * FROM onepiece";
        $result = $conn->query($sql);

        if  ($result->num_rows > 0) {
            ?>
                <table>
                    <thead>
        <td id="idtable">ID</td>
        <td>Name</td>
                        <td>Lname</td>
                        <td>E-mail</td>
                        <td></td>
                        <td></td>
                    </thead>
                    <tbody>
            <?php
            while($row = $result->fetch_assoc()){

                ?>


                            <tr>
                                <td id="idtable"><?php  echo $row["ID"]; ?></td>
                                <td><?php  echo $row["Name"]; ?></td>
                                <td><?php  echo $row["Lname"]; ?></td>
                                <td><?php  echo $row["Email"]; ?></td>
                                <form method="post">
                                    <input type="text" name="id" value="<?php  echo $row["ID"]; ?>" hidden>
                                    <input type="text" name="status" value="update"
                                    <input type="text" name="status2" value="aa" hidden>
                                    <td><input type="submit" value="edit"></td>
                                </form>
                                <form method="post">
                                    <input type="text" name="id" value="<?php  echo $row["ID"]; ?>" hidden>
                                    <input type="text" name="status" value="delete" hidden>
                                    <td><input type="submit" value="delete"></td>
                                </form>
                            </tr>

                <?php
            }
        }
}

?>
                </tbody>
            </table>