prepare("SELECT EmployeeName FROM tbluseraccount WHERE UserID = ?");
$user->execute([$_COOKIE['userid']]);
$username = $user->fetch(PDO::FETCH_ASSOC);
////////////// Registry Access Query /////////////////
$registry = $conn->prepare("SELECT a.*,b.AccessName,b.AccessType,b.Script,b.icon FROM tbluseraccesschild a LEFT JOIN tbluseraccess b ON a.AccessID = b.AccessID WHERE b.AccessType ='Registry' AND a.UserID = ?");
$registry->execute([$_COOKIE['userid']]);
$registryLink = $registry->fetchAll(PDO::FETCH_ASSOC);
///////////////// Document Access Query ///////////////////////
$registryDoc = $conn->prepare("SELECT a.*,b.AccessName,b.AccessType,b.Script,b.icon FROM tbluseraccesschild a LEFT JOIN tbluseraccess b ON a.AccessID = b.AccessID WHERE b.AccessType ='Documents' AND a.UserID = ?");
$registryDoc->execute([$_COOKIE['userid']]);
$docLink = $registryDoc->fetchAll(PDO::FETCH_ASSOC);
///////////////// Others Access Query ///////////////////////
$OthersDoc = $conn->prepare("SELECT a.*,b.AccessName,b.AccessType,b.Script,b.icon FROM tbluseraccesschild a LEFT JOIN tbluseraccess b ON a.AccessID = b.AccessID WHERE b.AccessType ='Others' AND a.UserID = ?");
$OthersDoc->execute([$_COOKIE['userid']]);
$othersdocLink = $OthersDoc->fetchAll(PDO::FETCH_ASSOC);
///////////////// Reports Access Query //////////////////////
$ReportDoc = $conn->prepare("SELECT a.*,b.AccessName,b.AccessType,b.Script,b.icon FROM tbluseraccesschild a LEFT JOIN tbluseraccess b ON a.AccessID = b.AccessID WHERE b.AccessType ='Reports' AND a.UserID = ? ORDER BY FIELD(AccessName,'Birth Certificate Report','Marriage Certificate Report','Death Certificate Report','Other Report')");
$ReportDoc->execute([$_COOKIE['userid']]);
$ReportLink = $ReportDoc->fetchAll(PDO::FETCH_ASSOC);
?>
DeedBox