<?php
    $con= new mysqli('localhost','root','','crudop');
    if(isset($_GET['deleteid'])){
      $id=$_GET['deleteid'];
      

      //insert query
      $sql = "delete from company where id=$id";
      

      //execute query
      $result=mysqli_query($con,$sql);

      // we will check 
      if($result) {
        echo "deleted successfully";
        header('Location:display.php');
          }else{
            die(mysqli_error($con));
          }
        }<?php
    $con= new mysqli('localhost','root','','crudop');
    if(isset($_POST['submit'])){
        $visitors=$_POST['visitors'];
        $contact=$_POST['contact'];
        $purpose=$_POST['purpose'];
        
        

      //insert query
      $sql = "INSERT INTO company( visitors, contact, purpose)
      VALUES( '$visitors', '$contact','$purpose' )";

      //execute query
      $result=mysqli_query($con,$sql);

      // we will check 
      if($result) {
        echo "data inserted successfully";
        header('Location:display.php');
          }else{
            die(mysqli_error($con));
          }
        }
?>
<!doctype html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">

    <title>php crud</title>
  </head>
  <body>
    <div class="container">
        <form method="post">
  <div class="mb-3">
    <label> VISITORS_NAME </label>
    <input type="text" class="form-control" name="visitors" >
  </div>
  <div class="mb-3">
    <label> CONTACT</label>
    <input type="email" class="form-control" name="contact">
  </div>
  <div class="mb-3">
    <label> PURPOSE</label>
    <input type="text" class="form-control" name="purpose ">
  </div>
 
  
  <button type="submit" class="btn btn-primary" name="submit">Submit</button>
</form>
</div>

    <!-- Optional JavaScript; choose one of the two! -->

    <!-- Option 1: Bootstrap Bundle with Popper -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>

    <!-- Option 2: Separate Popper and Bootstrap JS -->
    <!--
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>
    -->
  </body>
  </html>
?>