update

<?php
    $con= new mysqli('localhost','root','','crudop');
    $id = $_GET['updateid'];
        if(isset($_POST['submit'])){
            $visitors=$_POST['visitors'];
            $contact=$_POST['contact'];
            $purpose=$_POST['purpose'];


        $sql="update  company set visitors='$visitors', contact='$contact', purpose='$purpose' where id=$id";

        $result=mysqli_query($con,$sql);


        if($result) {
            echo "updated successfully ";
           header('Location:display.php');
              }else{
                die(mysqli_error($con));
              }
            }

            $sql="Select * from company";
            $result=mysqli_query($con,$sql);
            $row=mysqli_fetch_array($result);
            $visitors=$row['visitors'];
            $contact=$row['contact'];
            $purpose=$row['purpose'];


?>

<!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/[email protected]/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/[email protected]/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/[email protected]/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>
    -->
  </body>
  </html>