update-search-admin.php

<?php
include_once 'includes/db_connect.php';
session_start();
if (!isset($_SESSION['aai'])){
    header("Location: login-index.php");
}
$id=$_POST["uname"];
$_SESSION['showupdate']=0;
$result = $conn->query("SHOW TABLES from erp LIKE 'admin'");
$tables="";
$i=0;

$tables = "admin";
$search_sql = "SELECT * FROM admin where userid='$id'";
$search_result = $conn->query($search_sql);
if ($search_result->num_rows > 0) {
    $table_found = $tables;
}

$table_found_sql = "SELECT * FROM admin where userid='$id'";
$table_found_result = $conn->query($table_found_sql);
if ($table_found_result->num_rows > 0) {
    session_start();
    $row = mysqli_fetch_array($table_found_result);
    $_SESSION['utable_found']=$table_found;
    $_SESSION['uuserid']=$row['userid'];
    $_SESSION['ufname']=$row['fname'];
    $_SESSION['umname']=$row['mname'];
    $_SESSION['ulname']=$row['lname'];
    $_SESSION['uemail']=$row['email'];
    $_SESSION['uaddress']=$row['address'];

    $_SESSION['udept']=$row['dept'];
    $_SESSION['uimage']=$row['image'];
    $_SESSION['searched']="1";
    $_SESSION['update']='1';
    $_SESSION['showupdate']='1';
    header("Location: tab-admin.php");
}
else{
    session_start();
    $_SESSION['search-error'] = '*User ID not fount';
    $_SESSION['update']='1';
    $_SESSION['showupdate']='0';
    header("Location: tab-admin.php");
}
?>