webadmin.php

/var/www/(Del)explorer-island.com/old/webadmin/coursesubindex.php

<?
//require 'db_connect.php';
require 'check_login.php';
if ($logged_in <> 1) {
    header('Location: login.php');
    return;
}
else
{
?>
<?php 
require("configure.php");
$ccatid    = $_GET['ccatid'];
?>
<!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">
<!--
ddaccordion.init({
    headerclass: "expandable", //Shared CSS class name of headers group that are expandable
    contentclass: "categoryitems", //Shared CSS class name of contents group
    revealtype: "click", //Reveal content when user clicks or onmouseover the header? Valid value: "click", "clickgo", or "mouseover"
    mouseoverdelay: 200, //if revealtype="mouseover", set delay in milliseconds before header expands onMouseover
    collapseprev: true, //Collapse previous content (so only one open at any time)? true/false 
    defaultexpanded: [0], //index of content(s) open by default [index1, index2, etc]. [] denotes no content
    onemustopen: false, //Specify whether at least one header should be open always (so never all headers closed)
    animatedefault: false, //Should contents open by default be animated into view?
    persiststate: true, //persist state of opened contents within browser session?
    toggleclass: ["", "openheader"], //Two CSS classes to be applied to the header when it's collapsed and expanded, respectively ["class1", "class2"]
    togglehtml: ["prefix", "", ""], //Additional HTML added to the header when it's collapsed and expanded, respectively  ["position", "html1", "html2"] (see docs)
    animatespeed: "fast", //speed of animation: integer in milliseconds (ie: 200), or keywords "fast", "normal", or "slow"
    oninit:function(headers, expandedindices){ //custom code to run when headers have initalized
        //do nothing
    },
    onopenclose:function(header, index, state, isuseractivated){ //custom code to run whenever a header is opened or closed
        //do nothing
    }
})
//-->
</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>
</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">&nbsp;</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 height="70" align="right" valign="middle" class="icontxt"><table border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td width="50" align="center"><a href="coursesubaddform.php?ccatid=<?=$ccatid;?>"><img src="images/iconNew.png" alt="Add" width="32" height="32" border="0" /><br />
                &nbsp;Add&nbsp;&nbsp;</a></td>
              <td>&nbsp;</td>
            </tr>
        </table></td>
      </tr>
      <tr>
        <td class="pagetitletxt">&nbsp;&nbsp;<b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle" /> Course 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">&nbsp;<strong>Course Category</strong>
          <select name="ccatid" onChange="MM_jumpMenu('self',this,0)">
      <option value="coursesubindex.php?ccatid=0" <? if (($ccatid=='0') || ($ccatid=='')) echo 'selected'; ?>>View All</option>
              <?php
              $sql = "SELECT * FROM coursecat order by ccatnameen ASC, ccatid DESC  ";
            $result1 = mysql_query($sql) or die(mysql_error());
            while ($row1 = mysql_fetch_array($result1,MYSQL_ASSOC))
            {
            ?>
        <option value="coursesubindex.php?ccatid=<?=$row1{'ccatid'}?>" <? if ($ccatid==$row1{'ccatid'}) echo 'selected'; ?> ><?=$row1{'ccatnameen'}?></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="500" class="listtitletxt">Course Name</td>
              <td width="140" class="listtitletxt">Age</td>
              <td width="150" align="center" class="listtitletxt">Action</td>
            </tr>
            <?php
            if (($ccatid <> "0") && ($ccatid <> "")) {
                $sql = "SELECT * FROM coursesub cs INNER JOIN coursecat ca ON cs.ccatid = ca.ccatid WHERE cs.ccatid = $ccatid ORDER BY ca.ccatnameen ASC, ca.ccatid DESC, cs.csubnameen ASC, cs.csubid DESC ";
                $result = mysql_query($sql);
            } else {
                $result = mysql_query("SELECT * FROM coursesub cs INNER JOIN coursecat ca ON cs.ccatid = ca.ccatid ORDER BY ca.ccatnameen ASC, ca.ccatid DESC, cs.csubnameen ASC, cs.csubid DESC ");
            }
            while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
            {
                print "<tr>";
                print "<td class='listtxt' style='padding-left:5'>&nbsp;</td>";
                print "<td class='listtxt' style='padding-left:5'>".$row{'csubnameen'}."</td>";
                print "<td class='listtxt' style='padding-left:5'>".$row{'csubageen'}."</td>";
                print "<td class='listtxt' align='center' style='padding-left:5'>";
                print "<a href='coursesubmodifyform.php?ccatid=".$row{'ccatid'}."&csubid=".$row{'csubid'}."' border='0'>";
                print "<img src='images/btnmodify.jpg' border='0' alt='Modify'></a>";
                print "&nbsp;&nbsp;&nbsp;<a href='coursesubdeleteform.php?ccatid=".$row{'ccatid'}."&csubid=".$row{'csubid'}."' border='0'>";
                print "<img src='images/btnRemove.jpg' border='0' alt='Delete'></a>";
                print "</td>";
                print "</tr>";
            }
            mysql_close($dbh);
            ?>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td align="left" valign="top">&nbsp;</td>
    <td align="left" valign="top">&nbsp;</td>
  </tr>
</table>


</body>
</html>
<?
}?>