File manager - Edit - /home/autoph/public_html/connect/home/PRF_DeletePOApprover.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); 193 * 1067 * 215 $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['done'])){ $SelExecomID = mysql_escape_string($_POST['SelExecomID']); mysql_query("UPDATE prf_poapprover SET deleted = 1 WHERE id='$SelExecomID'"); mysql_query("UPDATE `prf_request_detl` SET `POVAL`=0 WHERE id='$SelExecomID'"); } echo "<table>"; $getExecomList = mysql_query("SELECT vts_users.u_id,vts_users.u_fname,vts_users.u_lname,prf_poapprover.id,prf_poapprover.po_officer_id,prf_poapprover.authority,prf_poapprover.comp_id FROM `vts_users` JOIN `prf_poapprover` ON `prf_poapprover`.po_officer_id = vts_users.u_id WHERE `vts_users`.u_id=`prf_poapprover`.po_officer_id AND `prf_poapprover`.deleted=0"); while($row=mysql_fetch_array($getExecomList)){ ?> <tr id='deleteEXECOM' onclick="javascript:getExecomID(this);"><!-- getCategoryIDonDblclick="javascript:showActionViewDelete(this);" >--> <?php echo "<td style='width:10%'>".$row['id']."</td> <td style='width:50%'>".$row['u_lname'].", ".$row['u_fname']."</td> <td style='width:30%'>".$row['authority']."</td> <td style='width:10%;text-align:center'>❌</td>"; echo "</tr>"; } echo "</table>"; exit(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings