rendered paste body<?PHP include("header.php"); ?><?PHP include("classes.php");$perpage = 10;$page = 1;if (isset($_REQUEST['page']) && is_numeric($_REQUEST['page'])) { $page = $_REQUEST['page']; };$offset = (($page-1)*$perpage);if (empty($_GET['cat']) && empty($_GET['type'])) { $data = $link->query("SELECT `id`, `title`, `desc`, FORMAT(`cost` * `markup`, 2) AS `price` FROM `jewelery` ORDER BY `id` LIMIT $offset, $perpage;");} elseif(empty($_GET['type'])) { $cat = mysql_real_escape_string($_GET['cat']); $data = $link->query("SELECT `id`, `title`, `desc`, FORMAT(`cost` * `markup`, 2) AS `price` FROM `jewelery` WHERE `cat` LIKE '%$cat%' ORDER BY `id` LIMIT $offset, $perpage;");} elseif(!empty($_GET['type'])) { $type = mysql_real_escape_string($_GET['type']); $data = $link->query("SELECT `id`, `title`, `desc`, FORMAT(`cost` * `markup`, 2) AS `price` FROM `jewelery` WHERE `type` = '$type' ORDER BY `id` LIMIT $offset, $perpage;");}if (empty($_GET['cat']) && empty($_GET['type'])) { $data2 = $link->query("SELECT COUNT(`id`) AS `count` FROM `jewelery`;");} elseif(empty($_GET['type'])) {// $cat = mysql_real_escape_string($_GET['cat']); $data2 = $link->query("SELECT COUNT(`id`) AS `count` FROM `jewelery` WHERE `cat` LIKE '%$cat%';");} elseif(!empty($_GET['type'])) { $data2 = $link->query("SELECT COUNT(`id`) AS `count` FROM `jewelery` WHERE `type` = '$type';");};$numrows = $data2->fetch_array();$pages = ceil($numrows['count']/$perpage);if ( $page == 1 ) { $nav = '<<-';} else { $check_back = true; $nav = '';};$nav_add = 0;if ( ($page-5) < 1 ) { $cpage = 1; $nav_add = 5-$page;} else { $cpage = $page-5;};if ( ($page+5+$nav_add) > $pages ) { $max_page = $pages; if ( $nav_add == 0 ) { $nav_sub = $pages-(5+$page); if ( (($page-5)+$nav_sub) < 1 ) { $cpage = 1; } else { $cpage = ($page-5)+$nav_sub; } }} else { $max_page = $page+5+$nav_add;};if (empty($_GET['cat']) && empty($_GET['type'])) { if ($check_back == true) { $nav .= " <a href=\"shop.php?page=" . ($page-1) . "\"><<-</a> "; }; for($cpage = $cpage; $cpage <= $max_page; $cpage++){ if ($cpage == $page){ $nav .= " $cpage "; } else { $nav .= " <a href=\"shop.php?page=$cpage\">$cpage</a> "; }; }; if ($page < $pages) { $nav .= " <a href=\"shop.php?page=" . ($page+1) . "\">->></a> "; } else { $nav .= " ->>"; };} elseif(empty($_GET['type'])) { if ($check_back == true) { $nav .= " <a href=\"shop.php?cat=$cat&page=" . ($page-1) . "\"><<-</a> "; }; for($cpage = $cpage; $cpage <= $max_page; $cpage++){ if ($cpage == $page){ $nav .= " $cpage "; } else { $nav .= " <a href=\"shop.php?cat=$cat&page=$cpage\">$cpage</a> "; }; }; if ($page < $pages) { $nav .= " <a href=\"shop.php?cat=$cat&page=" . ($page+1) . "\">->></a> "; } else { $nav .= " ->>"; };} elseif(!empty($_GET['type'])) { if ($check_back == true) { $nav .= " <a href=\"shop.php?type=$type&page=" . ($page-1) . "\"><<-</a> "; }; for($cpage = $cpage; $cpage <= $max_page; $cpage++){ if ($cpage == $page){ $nav .= " $cpage "; } else { $nav .= " <a href=\"shop.php?type=$type&page=$cpage\">$cpage</a> "; }; }; if ($page < $pages) { $nav .= " <a href=\"shop.php?type=$type&page=" . ($page+1) . "\">->></a> "; } else { $nav .= " ->>"; };};echo $link->error;?> <tr> <td valign="top" width="767" height="859" class="content"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="320" height="859"> <div style="margin:41 20 0 9px; padding: 0px;"><?$html = " <div class=\"left-block\"> <img src=\"./images/jewelery/%s.jpg\" class=\"side-image\" onClick=\"window.open('bigpic.php?id=%s','','scrollbars=no,menubar=no,height=320,width=320,resizable=yes,toolbar=no,location=no,status=no');\"/> <br /> Click To Enlarge </div> ";while($row = $data->fetch_array()) { check_image($row['id'], $link); printf($html, stripslashes($row['id']), stripslashes($row['id']));};echo $link->error;$data->data_seek(0); ?> </div> </td> <td valign="top" width="447" height="859"> <div style="width:100%; text-align:center;"><?=$nav?></div> <div style="margin:41 20 0 9px; padding: 0px;"> <div class="right-block"><?PHP$html = " <div class=\"sub-right-block\"> <h1> %s </h2> <h2> %s </h2> <h3> %s </h3> <div class=\"item-price\"><p>Price : %s </p></div> <div class=\"item-add\"> <form style=\"float: left;\" target=\"paypal\" action=\"https://www.paypal.com/cgi-bin/webscr\" method=\"post\"> <input type=\"image\" src=\"images/1_k3.gif\" border=\"0\" name=\"submit\" alt=\"Add this item to your shopping cart\"> <img alt=\"\" border=\"0\" src=\"https://www.paypal.com/en_US/i/scr/pixel.gif\" width=\"1\" height=\"1\"> <input type=\"hidden\" name=\"add\" value=\"1\"> <input type=\"hidden\" name=\"cmd\" value=\"_cart\"> <input type=\"hidden\" name=\"business\" value=\"support@hillcrestjewelers.com\"> <input type=\"hidden\" name=\"item_name\" value=\" %s \"> <input type=\"hidden\" name=\"item_number\" value=\" %s \"> <input type=\"hidden\" name=\"amount\" value=\"%s\"> <input type=\"hidden\" name=\"no_shipping\" value=\"2\"> <input type=\"hidden\" name=\"return\" value=\"http://hillcrestjewelers.com/thankyou.php\"> <input type=\"hidden\" name=\"currency_code\" value=\"USD\"> <input type=\"hidden\" name=\"lc\" value=\"US\"> <input type=\"hidden\" name=\"bn\" value=\"PP-ShopCartBF\"> </form> <form target=\"paypal\" style=\"float:left\" action=\"https://www.paypal.com/cgi-bin/webscr\" method=\"post\"> <input type=\"hidden\" name=\"cmd\" value=\"_cart\"> <input type=\"hidden\" name=\"business\" value=\"support@hillcrestjewelers.com\"> <input type=\"image\" src=\"images/1_k1.gif\" border=\"0\" name=\"submit\" alt=\"View items in your shopping cart\"> <input type=\"hidden\" name=\"display\" value=\"1\"> </form> </div> </div> ";while($row = $data->fetch_array()) {// $price = $row['cost'] * $row['markup']; printf($html, stripslashes($row['title']), stripslashes($row['id']), stripslashes($row['desc']), stripslashes($row['price']), stripslashes($row['title']), stripslashes($row['id']), stripslashes($row['price']));};$link->close();?></div></div><div style="width:100%; text-align:center;"><?=$nav?></div><div style="height:150px;"></div> </td> </tr> </table> </td> </tr><?PHP include("footer.php"); ?>