<?php
$conn = mysqli_connect ("localhost","root","","facility");
$query = "SELECT * FROM user WHERE IDNo = 11";

$result = mysqli_query($conn, $query);

while($row = mysqli_fetch_array($result)) {

echo '<tr><td>
<img src = "data:image/jpeg;base64,'.base64_encode($row ['Image']). '"/>
</td>  </tr> ';}

?>

$Image = file_get_contents($_FILES['image']['name']);
                        $ImageLoc = file_get_contents($_FILES['image']
              ['name']);
                        $imagesize = getimagesize($_FILES['image']
               ['tmp_name']);
                        $target = "upload/".basename($Image);

    if (move_uploaded_file($_FILES['image']['tmp_name'], $target)){

    }else {
        array_push($errors, "Failed to upload image");
    }


    if (count($errorMessage) <= 0) {

        // save to database
        $data = [
            'IDNo' => $IDNo,
            'FullName' => $FullName,
            'username' => $Username,
            'Type' => $Type,
            'Dept' => $Dept,
            'Password' => $Password,
            'Email' => $Email,
            'Role' => $Role,
            'Image' => $Image,
            'ImageLoc' => $ImageLoc,
        ];
        $id = $mysql->insert('user', $data);

        $_SESSION['message'] = "Successfully added $FullName";
        header('location: users.php');



        if(isset($_POST['Type'])){
        $Type = e($_POST['Type']);
        $query = "INSERT INTO user (IDNo , FullName , username , Type , Dept , Password , Email , Role , Image , ImageLoc)
        VALUES('$IDNo', '$FullName', '$username', '$Type', '$Dept', '$Password', '$Email','$Role' , '$Image' , '$ImageLoc')";

        mysqli_query($conn, $query);
        $_SESSION['success']  = "New user successfully created!!";
        header('location: users.php');
    } else{
        $query = "INSERT INTO user (IDNo , FullName , username , Type , Dept , Password , Email , Role , Image , ImageLoc)
        VALUES('$IDNo', '$FullName', '$Username', '$Type', '$Dept', '$Password', '$Email','$Role' , '$Image' , '$ImageLoc')";
        mysqli_query($conn, $query);


}
}