File manager - Edit - /home/autoph/public_html/voc/home/CL_DELETE_SELECTED_TEMPLATE.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'])){ $selectedTemplate = mysql_escape_string($_POST['selectedTemplate']); mysql_query("UPDATE `cl_template_name` SET `cl_template_status` = 0 WHERE `id`='$selectedTemplate'"); $gtTempHeader = mysql_query("SELECT * FROM `cl_template_name` WHERE `cl_template_status` = 1 AND `cl_comp_id`='$compID'ORDER BY `id` ASC"); echo "<table>"; echo "<thead>"; echo "<th style='width:5%'>No.</th>"; echo "<th style='width:10%'>LEVEL</th>"; echo "<th style='width:20%'>DESCRIPTOIN</th>"; echo "<th style='width:10%'>COVERAGE</th>"; echo "<th style='width:15%'>RECOMMENDIG OFFICER #1</t>"; echo "<th style='width:15%'>RECOMMENDIG OFFICER #1</t>"; echo "<th style='width:15%'>APPROVING OFFIER</t>"; ECHO "</thead>"; while($row=mysql_fetch_array($gtTempHeader)){ $rcaF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_a']."'"),0); $rcaL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_a']."'"),0); $rcbF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_b']."'"),0); $rcbL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_b']."'"),0); $aprF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer']."'"),0); $aprL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer']."'"),0); ?><tr onclick="javascript:showSelectedBrand(this);"><?php echo "<td>".$row['id']."</td>"; echo "<td>"; if($row['cl_template_tag']==='CO'){ echo "COMPANY LEVEL"; }else{ echo "AUTOHUB LEVEL"; } echo"</td>"; echo "<td>".$row['cl_template_name']."</td>"; echo "<td>"; echo $row['cl_template_rank']; echo"</td>"; echo "<td>"; echo $rcaL .', '.$rcaF; echo"</td>"; echo "<td>"; echo $rcbL .', '.$rcbF; echo"</td>"; echo "<td>"; echo $aprL .', '.$aprF; echo"</td>"; echo "</tr>"; } echo "</table>"; echo '<script>alert("Record '.$selectedTemplate.' has been deleted...")</script>'; exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings