'.$pathVars->fetchByIndex(0);
echo '
'.$pathVars->fetchByIndex(1);
echo '
'.$pathVars->fetchByIndex(2);
echo '
';
print_r($pathVars->fetchAll ());
exit;
*/
// **************************************************************************
/*
CREATE TABLE jr_books (
bk_id mediumint(9) NOT NULL auto_increment,
bk_title varchar(200) NOT NULL default '',
bk_author varchar(200) NOT NULL default '',
bk_numpages varchar(200) NOT NULL default '',
bk_pub_year varchar(4) NOT NULL default '',
bk_publisher varchar(200) NOT NULL default '',
bk_isbn varchar(50) NOT NULL default '',
PRIMARY KEY (bk_id)
) TYPE=MyISAM;
*/
// **************************************************************************
$p = clean($_GET['p'],2);
//$u = clean($_GET['u'],100);
$a = clean($pathVars->fetchByIndex(0), 20);
switch ($a) {
case 'isbn':
// Examine the second path variable
$isbn = clean($pathVars->fetchByIndex(1),20);
// ***********************************************
if ($isbn) {
$sql='SELECT * FROM jr_books WHERE bk_isbn="'.$isbn.'"';
if (!($result = @ mysql_query($sql, $connection))) {showerror(); }
$row = @ mysql_fetch_array($result, MYSQL_ASSOC);
tmpl1($row['bk_title']);
tmpl2();
echo 'Books
';
echo '';
if (!empty($row))
{
show_book($connection, $row, 2);
}
$sql='SELECT * FROM jr_reviews WHERE bk_isbn="'.$row['bk_isbn'].'"';
if (!($result = @ mysql_query($sql, $connection))) {showerror(); }
$numrows = mysql_num_rows($result);
$midway = ceil($numrows/2);
if($numrows) {
echo '
Reviews
';
$i = -1;
echo '
';
while ($row = @ mysql_fetch_array($result, MYSQL_ASSOC)) {
$i++;
//echo '
$midway: '.$midway.'
$i: '.$i.'
$numrows: '.$numrows.'
';
if ($numrows > 1) {
if ($i==$midway) {echo '
';}
}
show_review($row, 2);
}
echo '
';
}
echo '';
echo '
Reviews
';
echo '';
$sql='SELECT * FROM jr_reviews';
$nav = new pagnum;
// set the text/image to be used for prev/next links
$nav->str_prev = '
';
$nav->str_next = '
';
$nav->str_prev_spc = '
';
$nav->str_next_spc = '
';
$nav->numrowsperpage = 10;
$nav->str_results_prefix = 'Review';
//get the SQL LIMIT statement
$result = $nav->execute($sql, $connection);
// get the pagenumber array
$p_data = $nav->getlinks();
// print out the page numbers
echo '
';
//echo '
'.$p_data['results'].'
';
echo $p_data['pagenumbers'].' '.$p_data['prev'].$p_data['next'].'
';
if (!$p_data['total_results'])
{
echo '
The Reviews List is unavailable at present.
';
}
else
{
$midway = floor(($p_data['this_pg_last']-$p_data['this_pg_frst']+1)/2);
$i = -1;
echo '
';
while ($row = @ mysql_fetch_array($result, MYSQL_ASSOC))
{
$i++;
if ($p_data['total_results'] > 1) {
if ($i==$midway) {echo '
';}
}
show_review($row, 0);
}
echo '
';
echo '
'.$p_data['prev'].$p_data['next'].'
';
}
echo '
Books
';
echo '';
$sql='SELECT * FROM jr_books ORDER BY bk_pub_year DESC';
//$sql='SELECT * FROM jr_books ORDER BY bk_title';
// **************************************************************************
// generate the page numbers
$nav = new pagnum;
// set the text/image to be used for prev/next links
$nav->str_prev = '
';
$nav->str_next = '
';
$nav->str_prev_spc = '
';
$nav->str_next_spc = '
';
$nav->numrowsperpage = 10;
$nav->str_results_prefix = 'Book';
//get the SQL LIMIT statement
$result = $nav->execute($sql, $connection);
// get the pagenumber array
$p_data = $nav->getlinks();
// print out the page numbers
echo '
';
//echo '
'.$p_data['results'].'
';
echo $p_data['pagenumbers'].' '.$p_data['prev'].$p_data['next'].'
';
if (!$p_data['total_results'])
{
echo '
The Books List is unavailable at present.
';
}
else
{
while ($row = @ mysql_fetch_array($result, MYSQL_ASSOC))
{
show_book($connection, $row, 0);
}
echo '
'.$p_data['prev'].$p_data['next'].'
';
}
echo '