| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/hkosl.com/alliancealliance/webadmin/ |
Upload File : |
<?php
require_once('check_login.php');
?>
<!DOCTYPE html>
<html>
<head>
<?php require_once('html_head.php'); ?>
<script type="text/javascript">
function DeleteRow(id, typeid) {
if (confirm("Are you sure to delete this record?")) {
window.location.href = 'course_delete.php?id=' + id;
}
}
</script>
</head>
<body>
<table width="1200" height="600" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200" align="left" valign="top">
<table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="70" align="left" valign="middle"> </td>
</tr>
<tr>
<td width="200" align="left" valign="top"><!-- Main Menu -->
<?php require("menu.php"); ?><!-- End Main Menu --></td>
</tr>
</table>
</td>
<td width="1000" align="left" valign="top">
<table width="1000" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<table width="1000" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="70" class="pagetitletxt"> </td>
<td width="50" align="center" class="icontxt">
<a href="course_addform.php"><img src="images/iconNew.png" alt="Add" width="32" height="32" border="0"/><br/> Add
</a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="pagetitletxt">
<b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle"/> Course
</b></td>
</tr>
<tr>
<td height="25" align="left" valign="middle" class="msg"><?php if (!empty($_GET["msg"])) echo $msg; ?></td>
</tr>
<tr>
<td align="left" valign="middle">
<table width="1000" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<td width="400" class="listtitletxt">Course Category</td>
<td width="120" class="listtitletxt">Code</td>
<td width="120" class="listtitletxt">Date</td>
<td width="100" class="listtitletxt">Fee</td>
<td width="200" class="listtitletxt">Available for application</td>
<td width="150" class="listtitletxt">Stop applying text</td>
<td width="100" class="listtitletxt">Last Update</td>
<td width="20" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
</tr>
<?php
$sql = "SELECT * FROM course where deleted = ? ORDER BY code ASC";
$parameters = array(0);
$row_array = bind_pdo($sql, $parameters, "selectall");
foreach ($row_array as $row) {
print "<tr>";
print "<td class='listtxt' style='padding-left:5'> </td>";
$sql = "select * from course_category where id = ? and deleted = ?";
$parameters = array($row["course_category_id"], 0);
$course_cate_info = bind_pdo($sql, $parameters, "selectone");
print "<td class='listtxt' style='padding-left:5'>" . $course_cate_info{'name_en'} . "</td>";
print "<td class='listtxt' style='padding-left:5'>" . $row{'code'} . "</td>";
$start_date = new DateTime($row["start_date"]);
$end_date = new DateTime($row["end_date"]);
print "<td class='listtxt' style='padding-left:5; text-align: center'>" . $start_date->format("d M Y") ." <br>to<br> ".$end_date->format("d M Y"). "</td>";
print "<td class='listtxt' style='padding-left:5'>$" . number_format($row{'fee'}) . "</td>";
if($row["valid_apply"] == 1){
$valid_apply = "Yes";
}else{
$valid_apply = "No";
}
print "<td class='listtxt' style='padding-left:5'>" . $valid_apply . "</td>";
print "<td class='listtxt' style='padding-left:5'>" . $row{'stop_applying_text_en'} . "</td>";
print "<td class='listtxt' style='padding-left:5'>" . $row{'lastupdate'} . "</td>";
// Modify
print "<td class='listtxt' align='center'><a href='#' onClick=\"window.location='course_modifyform.php?id=" . $row{'id'} . "'\"><img src='images/btnModify.png' title='Modify' alt='Modify' hspace='2' border='0'></a></td>";
// Delete
print "<td class='listtxt' align='center'><a href='#' onClick=\"DeleteRow(" . $row{'id'} . ")\"><img src='images/btnDelete.png' title='Delete' alt='Delete' hspace='2' border='0'></a></td>";
print "</tr>";
}
$dbh = null;
?>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>