Untitled

<?php
$host = "localhost";
$user = "root";
$password = "";
$database = "emplyees";
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

$employeeID = "";
$name = "";
$passport = "";
$iqama = "";
$department = "";
$position = "";
$passport_expiry= "";
$iqama_expiry = "";
$contract_start = "";
$contract_expiry = "";
$nationality = "";
$basic = "";
$house_allowance = "";
$transportation_allowance = "";
$other_allowance = "";
$raining_allowance = "";
$airman_allowance = "";
$total_packag = "";

TRY {
    $HOST ="";
    $connect = MYSQLI_CONNECT($HOST, $user, $password, $database);
} CATCH (exception $ex){
      echo 'ERROR';
    }
    function getPosts()
    {
        $posts = array();
        $posts[0]= $_POST['employeeID'];
        $posts[1]= $_POST['name'];
        $posts[2]= $_POST['passport'];
        $posts[3]= $_POST['iqama'];
        $posts[4]= $_POST['department'];
        $posts[5]= $_POST['position'];
        $posts[6]= $_POST['passport expiry'];
        $posts[7]= $_POST['iqama expiry'];
        $posts[8]= $_POST['contract start'];
        $posts[9]= $_POST['contract expiry'];
        $posts[10]= $_POST['nationality'];
        $posts[11]= $_POST['basic'];
        $posts[12]= $_POST['house allowance '];
        $posts[13]= $_POST['transportation allowance '];
        $posts[14]= $_POST['other allowance '];
        $posts[15]= $_POST['training allowance'];
        $posts[16]= $_POST['airman allowance'];
        $posts[17]= $_POST['total package'];
        return $posts;
    }

    // search
    if (isset($_POST['search']))
    {
        $data = getPosts();

        $search_Query = ('SELECT * FROM details where employeeID = $data[0]');


        $search_Result = mysqli_query($connect, $search_Query);

        if($search_Result)
        {
            if(mysqli_num_rows($search_Result))
            {
                while($rows = mysqli_fetch_array($search_Result))
                {
                    $employeeID = $rows['employeeID'];
                    $name = $rows['name'];
                    $passport = $rows['passport'];
                    $iqama = $rows['iqama'];
                    $department = $rows['department'];
                    $position = $rows['position'];
                    $passport_expiry = $rows['passport expiry'];
                    $iqama_expiryexpiry = $rows['qama expiry'];
                    $contract_start = $rows['contract start'];
                    $contract_expiry = $rows['contract expiry'];
                    $nationality = $rows['nationality'];
                    $basic = $rows['basic'];
                    $house_allowance = $rows['house allowance'];
                    $transportation_allowance = $rows['transportation allowance'];
                    $other_allowance = $rows['other allowance'];
                    $training_allowance = $rows['training allowance'];
                    $airman_allowance = $rows['airman allowance'];
                    $total_package = $rows['total package'];
                }


            }else
            {
                echo 'no data for your search';
            }

        }else
        {
            echo 'Result error';
        }
    }

?>
<! DOCTYPE Html>
<html>
<head>
    <title>php insert update delete search</title>

</head>
<form action="php_insert_update_delete_search.php" method="psot">
    <input type="number" name="employeeID" placeholder="employeeID " value="<?php echo $employeeID;?>"><br><br>
    <input type="text" name="name" placeholder="name " value="<?php echo $name;?>"><br><br>
    <input type="text" name="passport" placeholder="passport " value="<?php echo $passport;?>"><br><br>
    <input type="text" name="iqama" placeholder="iqama" value="<?php echo $iqama;?>"><br><br>
    <input type="text" name="department" placeholder="department " value="<?php echo $department;?>"><br><br>
    <input type="text" name="position" placeholder="position " value="<?php echo $position;?>"><br><br>
    <input type="date" name="passport expiry" placeholder="passport expiry " value="<?php echo $passport_expiry;?>"><br><br>
    <input type="date" name="iqama expiry" placeholder="iqama expiry " value="<?php echo $iqama_expiry;?>"><br><br>
    <input type="date" name="contract start" placeholder="icontract start " value="<?php echo $contract_start;?>"><br><br>
    <input type="date" name="conptract expiry" placeholder="conptract expiry " value="<?php echo $contract_expiry;?>"><br><br>
    <input type="text" name="nationality" placeholder="nationality " value="<?php echo $nationality;?>"><br><br>
    <input type="number" name="basic" placeholder="basic " value="<?php echo $basic;?>"><br><br>
    <input type="number" name="huose allowance" placeholder="huose allowance " value="<?php echo $house_allowance;?>"><br><br>
    <input type="number" name="transportation allowance " placeholder="transportation allowanc " value="<?php echo $transportation_allowance;?>"><br><br>
    <input type="number" name="other allowance" placeholder="other allowance " value="<?php echo $other_allowance;?>"><br><br>
    <input type="number" name="training allowance" placeholder="training allowanc " value="<?php echo $raining_allowance;?>"><br><br>
    <input type="number" name="airman allowance" placeholder="airman allowanc " value="<?php echo $airman_allowance;?>"><br><br>
    <input type="number" name="total package" placeholder="total package " value="<?php echo $total_packag;?>"><br><br>
        <div>
                <input type="submit" name="insert" value="add">
                <input type="submit" name="update" value="update">
                <input type="submit" name="delete" value="delete">
                <input type="submit" name="search" value="search">
        </div>
</form>

<body>

</body>

</html>