| 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/(Del)discoverylearning.com.hk/webadmin/ |
Upload File : |
<?php
require 'check_login.php';
if ($logged_in <> 1) {
header('Location: login.php');
return;
}
else
{
require("configure.php");
$CoursesCatId = $_GET['CoursesCatId'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Content Management System (CMS) - Powered by One Solution Limited</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<!-- Main Menu -->
<link rel="stylesheet" type="text/css" href="css/menu.css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript" src="js/ddaccordion.js"></script>
<script type="text/javascript" src="js/menuddaccordion.js"></script>
<!-- End Main Menu -->
<script type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<script type="text/javascript">
function DeleteRowCategory(CoursesCatId,CoursesDetailId,CoursesDetailSort)
{
if (confirm("Are you sure you want to delete?"))
{
window.location.href = 'coursesdetail_delete.php?CoursesCatId='+CoursesCatId+'&CoursesDetailId='+CoursesDetailId+'&CoursesDetailSort='+CoursesDetailSort;
}
}
</script>
</head>
<body>
<table width="1000" 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="800" align="left" valign="top"><table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="70" class="pagetitletxt"> </td>
<td width="50" align="center" class="icontxt"><a href="coursesdetail_addform.php?CoursesCatId=<?=$CoursesCatId;?>"><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" /> Courses Detail </b></td>
</tr>
<tr>
<td height="25" align="left" valign="middle" class="msg"><?php echo $_GET['msg']; ?></td>
</tr>
<tr>
<td height="35" align="right" valign="middle" class="content"> <strong>Courses Category</strong>
<select name="CoursesCatId" onChange="MM_jumpMenu('self',this,0)">
<option value="coursesdetail_index.php" <? if (($CoursesCatId=='0') || ($CoursesCatId=='')) echo 'selected'; ?>>View All</option>
<?php
$sql1 = "SELECT * FROM CoursesCat cc ORDER BY cc.CoursesCatSort ASC, cc.CoursesCatId DESC ";
$result1 = mysql_query($sql1) or die(mysql_error());
while ($row1 = mysql_fetch_array($result1,MYSQL_ASSOC))
{
?>
<option value="coursesdetail_index.php?CoursesCatId=<?=$row1{'CoursesCatId'}?>" <? if ($CoursesCatId==$row1{'CoursesCatId'}) echo 'selected'; ?> ><?=$row1{'CoursesCatTitleen'}?></option>
<? } ?>
</select>
</td>
</tr>
<tr>
<td align="left" valign="middle"><table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<td width="40" class="listtitletxt">Sort</td>
<td width="600" class="listtitletxt">Courses Name</td>
<td width="20" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
</tr>
<?php
if (($CoursesCatId <> "0") && ($CoursesCatId <> "")) {
$sql = "SELECT * FROM CoursesCat cc INNER JOIN CoursesDetail cd ON cc.CoursesCatId = cd.CoursesCatId WHERE cd.CoursesCatId = '".$CoursesCatId."' ORDER BY cc.CoursesCatSort ASC, cc.CoursesCatId DESC, cd.CoursesDetailSort ASC, cd.CoursesDetailId DESC ";
$result = mysql_query($sql);
} else {
$result = mysql_query("SELECT * FROM CoursesCat cc INNER JOIN CoursesDetail cd ON cc.CoursesCatId = cd.CoursesCatId ORDER BY cc.CoursesCatSort ASC, cc.CoursesCatId DESC, cd.CoursesDetailSort ASC, cd.CoursesDetailId DESC ");
}
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
print "<tr>";
print "<td class='listtxt' style='padding-left:5'>".$row{'CoursesDetailSort'}."</td>";
print "<td class='listtxt' valign='middle' align='left'>";
print "<a href='coursesdetail_sort.php?status=up&CoursesCatId=".$row{'CoursesCatId'}."&CoursesDetailId=".$row{'CoursesDetailId'}."&sort=".$row{'CoursesDetailSort'}."'>";
print "<img src='images/up.gif' alt='Up' border='0'></a> ";
print "<a href='coursesdetail_sort.php?status=down&CoursesCatId=".$row{'CoursesCatId'}."&CoursesDetailId=".$row{'CoursesDetailId'}."&sort=".$row{'CoursesDetailSort'}."'>";
print "<img src='images/down.gif' alt='Down' border='0'></a>";
print "</td>";
print "<td class='listtxt' style='padding-left:5'>".$row{'CoursesDetailNameen'}."</td>";
// Modify
print "<td class='listtxt' align='center'><a href='#' onClick=\"window.location='coursesdetail_modifyform.php?CoursesCatId=".$row{'CoursesCatId'}."&CoursesDetailId=".$row{'CoursesDetailId'}."'\"><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=\"DeleteRowCategory(".$row{'CoursesCatId'}.", ".$row{'CoursesDetailId'}.", ".$row{'CoursesDetailSort'}.")\"><img src='images/btnDelete.png' title='Delete' alt='Delete' hspace='2' border='0'></a></td>";
print "</tr>";
}
mysql_close($dbh);
?>
</table></td>
</tr>
</table>
</td></tr>
</table>
</body>
</html>
<?php
}?>