File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_SEARCH_CL_HEADER.php

Back
<?php include 'core/init.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); $compID= $user_data['company']; $myDate = date_create() ->format("Y-m-d"); if(isset($_POST['done'])){ $SearchText = mysql_escape_string($_POST['SearchText']); $addByUID = mysql_escape_string($_POST['addByUID']); echo "<table>"; echo "<thead>"; echo "<th style='width:50px;border:0px solid white'>NO.</th>"; echo "<th style='width:80px;border:0px solid white'>TRANS ID.</th>"; echo "<th style='width:140px;border:0px solid white'>DATE CREATED.</th>"; echo "<th style='width:100px;border:0px solid white'>EMP. ID.</th>"; echo "<th style='width:250px;border:0px solid white'>EMPLOYEE NAME</th>"; echo "<th style='width:200px;border:0px solid white'>POSITION</th>"; echo "<th style='width:100px;border:0px solid white'>TYPE</th>"; echo "<th style='width:200px;border:0px solid white'>STATUS</th>"; echo "</thead>"; $getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`!='Approved' AND `cl_status`='1' AND `cl_h_comp_id` = '$compID' AND `search_ref_lname` LIKE '%$SearchText%' \|\| `cl_h_hr_approval`!='Approved' AND `cl_status`='1' AND `cl_h_comp_id` = '$compID' AND `search_ref_fname` LIKE '%$SearchText%' \|\| `search_ref_emp_id` LIKE '%$SearchText%' ORDER BY `cl_h_date_created` DESC"); while($row=mysql_fetch_array($getActiveClearance)){ $uID = $row['cl_h_emp_id']; $pID = $row['cl_emp_position']; $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$pID'"),0); $count = $count + 1; ?><tr onclick="javascript:showAdminAccess(this);"><?php echo "<td style=';border:0px solid white;cursor:pointer'>".$count."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($row['h_id'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($row['cl_h_date_created'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($uEMPID)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($uLName).",".strtoupper($uFName)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($uPosition)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($row['cl_rank'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($row['cl_h_hr_approval'])."</td>"; echo "</tr>"; } echo "</table>"; //echo '<script>alert("Record '.$selectedApprovingID.' has been deleted...")</script>'; exit(); } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings