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"); ?>