$clause = array();
if ($nb_author != "") {
$clause[] = "nb_auth LIKE '%$nb_author%'";
}
if ($nb_subj != "") {
$clause[] = "nb_subject LIKE '%$nb_subj%'";
}
if ($nb_num != "") {
$clause[] = "nb_number LIKE '%$nb_num%'";
}
if ($nb_type != "") {
$clause[] = "nb_type LIKE '%$nb_type%'";
}
$clause = implode(' AND ', $clause);
// Pagination
$limit = 25;
$query_count = "SELECT count(*) FROM Notebooks WHERE $clause";
$result_count = mysql_query($query_count);
$totalrows = mysql_result($result_count,0,0);
$new_clause = preg_replace("/[%]/", "", $clause);
echo "Search Results for: $new_clause
";
if(!isset($page)){
$page = 1;
}
$limitvalue = $page * $limit - ($limit);
$query = "SELECT * FROM Notebooks WHERE $clause LIMIT $limitvalue, $limit";
echo 'Query: "'. $query .'"
';
$result = mysql_query($query) or die("Error: " . mysql_error());
if ($page != 1){
$pageprev = $page--;
echo("Prev ");
} else {
echo("Prev ");
}
$numofpages = $totalrows / $limit;
for($i = 1; $i <= $numofpages; $i++){
if($i == $page){
echo($i." of ");
}else{
echo("$i ");
}
}
if(($totalrows % $limit) != 0){
if($i == $page){
echo($i." of ");
}else{
echo("$i ");
}
}
if(($totalrows - ($limit * $page)) > 0){
$pagenext = $page++;
echo("Next");
} else {
echo("Next");
}
print ($query);
// Display the results
//echo "";
//echo "
";
//echo "Show Entries |
10 |
20 |
30 |
50 |
100 | ";
//echo "
";
echo "";
echo "| NB# | ";
echo "Author | ";
echo "Subject Matter | ";
echo "Date Created | ";
echo "
";
while ($row = mysql_fetch_array($result)){
echo "";
echo "| $row[nb_number]";
echo "";
echo "";
echo " | ";
echo "$row[nb_auth] | ";
echo "$row[nb_subject] | ";
echo "$row[issue_date] | ";
echo "
";
}
echo "
";