File manager

File manager - Edit - /home/autoph/public_html/portal/includes/admin/pod_admin_view_all.php

Back
<?php if(isset($_GET['searchBox'])){ $searchString=$_GET['searchBox']; $qq=mysql_query("SELECT DISTINCT(`training_id`) FROM `pod_training_enrollees` WHERE `title` LIKE '%$searchString%' \|\| `emp_name` LIKE '%$searchString%' ORDER by `title` ASC "); }else{ $qq=mysql_query("SELECT DISTINCT(`training_id`) FROM `pod_training_enrollees` WHERE `status`='1' \|\| `status`='2' ORDER by `title` ASC "); } echo "<div STYLE='height: 100%; width: 99.9%; font-size: 12px; overflow: auto;'> <table style='width:100%; height:100% border:1px solid gray; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' align='left' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:10px;font-family:Calibri Light;font-weight:normal'>No.</th> <th class='Gradient' align='left' style='width:8%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:10px;font-family:Calibri Light;font-weight:normal'>TYPE</th> <th class='Gradient' align='left' style='width:50%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:10px;font-family:Calibri Light;font-weight:normal'>TITLE/DESCRIPTION</th> <th class='Gradient' align='left' style='width:7%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:10px;font-family:Calibri Light;font-weight:normal'>DATE CREATED</th> <th class='Gradient' align='left' style='width:7%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:10px;font-family:Calibri Light;font-weight:normal'>ENROLLED EMPLOYEES</th> <th class='Gradient' align='left' style='width:8%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:10px;font-family:Calibri Light;font-weight:normal'>EXAM FOR VERIFICATION</th> <th class='Gradient' align='left' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:10px;font-family:Calibri Light;font-weight:normal'></th>"; echo "</tr>"; while($row = mysql_fetch_array($qq)){ $count = $count + 1; $trID = $row['training_id']; $title = mysql_result(mysql_query("SELECT `title` FROM `pod_training_list` WHERE `id`='$trID' "),0); $date = mysql_result(mysql_query("SELECT `date` FROM `pod_training_list` WHERE `id`='$trID' "),0); $grouping = mysql_result(mysql_query("SELECT `grouping` FROM `pod_training_list` WHERE `id`='$trID' "),0); echo "<tr>"; echo "<td class='tableList'>" . $count . "</td>"; echo "<td class='tableList'>" .STRTOUPPER($grouping) . " Training</td>"; echo "<td class='tableList'>" . STRTOUPPER($title) . "</td>"; echo "<td class='tableList'><center>" . STRTOUPPER($date) . "</center></td>"; echo "<td class='tableList'><center>"; $chkEnrollees = mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_training_enrollees` WHERE `training_id`='$trID' AND `status`='1'"),0); echo "<a href='main_new.php?view=104&sid=PEXA&sview=101&tab=3&recID=".$row['id']."&tID=".$row['training_id']."&open=en'>".number_format($chkEnrollees,0,'.',','); echo "</center></td>"; echo "<td class='tableList'><center>"; $chkOpenExamTaken = mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_exam_true_false_answer` WHERE `training_id`='$trID' AND `status`='1' AND `chk_required`='YES' AND `verified`='NO'"),0); if($chkOpenExamTaken > 0){ $openExam = $openExam + 1; } echo "<a href='main_new.php?view=104&sid=PEXA&sview=101&tab=3&recID=".$row['id']."&tID=".$row['training_id']."&open=ox'>".number_format($openExam,0,'.',',')."</a>"; echo "</center></td>"; echo "<td class='tableList'><center>"; echo "</center></td>"; echo "</tr>"; } echo "</table>"; ?>

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