GHS Supplies List Database
if (!isset($_GET['action']))
{
?>
}
else if ($_GET['action'] == 'search')
{
$last = $_GET['last'];
if ($last == 'Any') { $last = '%'; }
$subject = $_GET['subject'];
if ($subject == 'Any' || !isset($_GET['subject'])) { $subject = '%%'; }
}
if (!isset($_GET['numpage']))
{
$numpage = 1;
}
else
{
$numpage = $_GET['numpage'];
}
$rowlimit = 30;
$offset = $rowlimit * ($numpage - 1);
$sql = "FROM hssupplylist WHERE last LIKE '$last%' $supplies AND subject LIKE '$subject'";
$sql_query = "SELECT * $sql ORDER BY last ASC LIMIT $offset, $rowlimit";
$query = mysql_query("$sql_query");
$sql_querycount = "SELECT COUNT(id) $sql";
$querycount = mysql_query("$sql_querycount");
$rowsforpages = mysql_fetch_array($querycount);
$rowsforpages = $rowsforpages['0'];
if ($rowsforpages > 0)
{
?>
| Teacher Name |
|
Course |
|
Supplies |
$class1 = "colorff";
$class2 = "colore6";
$row_count = 0;
while ($list = mysql_fetch_array($query))
{
$row_class = ($row_count % 2) ? $class1 : $class2;
?>
| print $list['last']; if ($list['first'] != '') { print ', '; } ?> |
|
print $list['subject']; ?> |
|
print $list['supplies']; ?> |
$row_count++;
}
?>
}
else
{
print ' ';
}
// calculate number of pages needing links
$numpages = intval($rowsforpages / $rowlimit);
// $numpages now contains int of pages needed unless there is a remainder from division
if ($rowsforpages % $rowlimit) {
// has remainder so add one page
$numpages++;
}
if ($numpages != 1 && $numpages != 0)
{
print ' ';
}
$uriget = $_SERVER['QUERY_STRING'];
$newuriget = str_replace('&numpage='.$_GET[numpage].'', '', $uriget);
if ($numpage > 1) { // bypass PREV link if offset is 0
$refpage = $numpage - 1;
print "PREV ";
}
if ($numpages != '1') {
for ($i = 1; $i <= $numpages; $i++) { // loop thru
if($numpage != $i)
{
print " ";
}
print $i;
if ($numpage != $i)
{
print " ";
}
}
// check to see if last page
if ($numpage < $numpages) {
// not last page so give NEXT link
$refpage = $numpage + 1;
print " NEXT";
}
if ($numpages != 1 && $numpages != 0)
{
print ' ';
}
?>
Search Again
}
?> |
|