i trying to add the option if you click on # symbol, you only get the rows with start symbol or #, but i not able to get to work. i think the use of # but not sure.
Site:
Click Here
Page code:
<?
$rowsPerPage = 14;
$pageNum = 1;
if(isset($_GET['page'])){
$pageNum = $_GET['page'];
}
if (!isset($_GET['letter'])) {$letter = "All";} else {$letter = $_GET['letter'];}
$offset = ($pageNum - 1) * $rowsPerPage;
$self = $_SERVER['PHP_SELF'];
require_once "header.php";
?>
<div id="wrapper">
<div id="header"><? echo $letter; ?></div>
<div id="navigation"><? show_navibar(); ?></div>
<div id="leftcolumn"><? include "login.php"; ?></div>
<div id="rightcolumn">
<? show_azbar(studios)?>
<table id="gradient-style" summary="Meeting Results">
<thead>
<tr>
<th scope="col">Studio</th>
<th scope="col">Website</th>
<th scope="col">English Website</th>
</tr>
</thead>
<tfoot>
<tr>
<td colspan="4"></td>
</tr>
</tfoot>
<tbody>
<? foreach (getStudios($offset,$rowsPerPage,$letter) as $studio) {
echo "<tr>"
. "<td>" . htmlspecialchars($studio['Company']) . "</td>"
. "<td>" . htmlspecialchars($studio['Website']) . "</td>"
. "<td>" . htmlspecialchars($studio['EngWebsite']) . "</td>"
. "</tr>";
}
?>
</tbody>
</table>
<div class="page_bracks">
<? if ($pageNum > 1) {
$page = $pageNum - 1;
$prev = " <a href=\"$self?page=$page&letter=$letter\">[Prev]</a> ";
$first = " <a href=\"$self?page=1&letter=$letter\">[First Page]</a> ";
}else{
$prev = ' [Prev] '; // we're on page one, don't enable 'previous' link
$first = ' [First Page] '; // nor 'first page' link
}
if ($pageNum < studiosMaxPage($rowsPerPage,$letter)) {
$page = $pageNum + 1;
$next = " <a href=\"$self?page=$page&letter=$letter\">[Next]</a> ";
$last = " <a href=\"$self?page=$maxPage&letter=$letter\">[Last Page]</a> ";
}else{
$next = ' [Next] '; // we're on the last page, don't enable 'next' link
$last = ' [Last Page] '; // nor 'last page' link
}
echo $first . $prev . " Showing page <strong>$pageNum</strong> of <strong> ".studiosMaxPage($rowsPerPage,$letter)." </strong> pages " . $next . $last; ?>
</div>
</div>
<?php
require_once "footer.php";
?>
Functions called:
function show_azbar($pageTitle) {
$alphabet = array('All','#','A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');
echo "<div class='azbar'>";
foreach ($alphabet as $letter) {
echo "<a href='".$pageTitle.".php?page=1&letter=" . $letter . "'>" . $letter . "</a> ";
}
echo "</div>";
}
function getStudios($offset,$rowsPerPage,$letter) {
if($letter == "All"){
$query = "SELECT Company , Website , EngWebsite FROM studio LIMIT ".$offset.",".$rowsPerPage;
$result = mysql_query($query) or die(mysql_error());
$studios = array();
while ($row = mysql_fetch_assoc($result)) {
$studios[] = $row;
}
return $studios;
}elseif($letter == "#"){
$query = "SELECT Company FROM studio WHERE ASCII(UPPER(Company)) NOT BETWEEN ASCII(A) and ASCII(Z) ORDER BY Company ASC LIMIT ".$offset.",".$rowsPerPage;
$result = mysql_query($query) or die(mysql_error());
$studios = array();
while ($row = mysql_fetch_assoc($result)) {
$studios[] = $row;
}
return $studios;
}else{
$query = "SELECT Company , Website , EngWebsite FROM studio WHERE Company LIKE '".$letter."%' ORDER BY Company ASC LIMIT ".$offset.",".$rowsPerPage;
$result = mysql_query($query) or die(mysql_error());
$studios = array();
while ($row = mysql_fetch_assoc($result)) {
$studios[] = $row;
}
return $studios;
}
}
function studiosMaxPage($rowsPerPage,$letter) {
if($letter == "All"){
$query = "SELECT COUNT(Company) AS numrows FROM studio";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
return $maxPage;
}elseif($letter == "#"){
$query = "SELECT COUNT(Company) AS numrows WHERE ASCII(UPPER(Company)) NOT BETWEEN ASCII(A) AND ASCII(Z)";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
return $maxPage;
}else{
$query = "SELECT COUNT(Company) AS numrows FROM studio WHERE Company LIKE '".$letter."%'";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
return $maxPage;
}
}
