Code: Select all
$sql->execute(array(':c' => $_GET['c']));Moderator: General Moderators
Code: Select all
$sql->execute(array(':c' => $_GET['c']));simonmlewis wrote:but it's there.... where am I missing it?
Code: Select all
<a href='/infinite-scroll?p=<?php echo $next?>'>Next</a>Code: Select all
<a href='/infinite-scroll?p=<?php echo $next?>'>Next</a>Code: Select all
<a href='/infinite-scroll?c=<?= $c; ?>&p=<?php echo $next?>'>Next</a>Code: Select all
<?php
echo "<div class='nav'>
<a href='/infinite-scroll?c=$c?p=";?><?php echo $next?>'>Next</a>
</div>
<?php endif?>Code: Select all
<?php
echo "<div class='nav'>
<a href='/infinite-scroll?c=$c?p=";?><?php echo $next?>'>Next</a>
</div>
<?php endif?>Code: Select all
<a href='/infinite-scroll?c=$c&p=";?><?php echo $next?>'>Next</a>Code: Select all
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script type="text/javascript" src="/js/infinite-scroll/jquery-ias.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
// Infinite Ajax Scroll configuration
jQuery.ias({
container : '.wrap', // main container where data goes to append
item: '.home_popular', // single items
pagination: '.nav', // page navigation
next: '.nav a', // next page selector
loader: '<img src="/js/infinite-scroll/ajax-loader.gif"/>', // loading gif
triggerPageThreshold: 3 // show load more if scroll more than this
});
});
</script>
<link rel="stylesheet" media="all" href="/js/infinite-scroll/style.css">
<?php
require_once 'Mobile_Detect.php';
$detect = new Mobile_Detect;
include('dbconn.php');
$c = isset($_GET['c']) ? $_GET['c'] : null;
$cname = isset($_GET['cname']) ? $_GET['cname'] : null;
$query = ("SELECT * FROM categorybanners WHERE catid =:c");
$result = $pdo->prepare($query);
$result->execute(array(':c' => $_GET['c']));
$num_rows = $result->rowCount();
$query = ("SELECT categories FROM categories WHERE id =:c");
$result = $pdo->prepare($query);
$result->execute(array(':c' => $_GET['c']));
while ($row = $result->fetch(PDO::FETCH_OBJ))
{
echo "</div><div class='cat_head'><h1>$row->categories</h1></div>";
}
$query = ("SELECT * FROM categories WHERE id = :c AND introtext <> ''");
$result = $pdo->prepare($query);
$result->execute(array(':c' => $_GET['c']));
if (isset($_SESSION["loggedin"]))
{
$usertype = $_SESSION["usertype"];
if ($usertype == "admin")
{
$num_rows = $result->rowCount();
if ($num_rows == 0)
{
echo "<div class='cat_adminlink' style='float: left'><a href='/index.php?page=a_catbanners&ctype=cat&id=$c&p=y'><i class='fa fa-pencil-square-o'></i> Edit/Add Text</a></div>";
}
}
}
while ($row = $result->fetch(PDO::FETCH_OBJ))
{
echo "<div class='category_intro'>";
if (isset($_SESSION["loggedin"]))
{
$usertype = $_SESSION["usertype"];
if ($usertype == "admin")
{
echo "<div class='cat_adminlink'><a href='/index.php?page=a_catbanners&ctype=cat&id=$c&p=y'><i class='fa fa-pencil-square-o'></i> Edit/Add Text</a></div>";
}
}
echo "$row->introtext</div>";
}
echo "<div style='clear: both' /></div><div class='mainbodybox'>";
echo "<div class='categ_topbox'><div class='categ_subbox'>";
$query = "SELECT subname, subid, catname FROM products WHERE catid = :c AND pause = 'off' GROUP BY subname";
$result = $pdo->prepare($query);
$result->execute(array(':c' => $_GET['c']));
while ($row = $result->fetch(PDO::FETCH_OBJ))
{
$subcateg = "$row->subname";
$findsubcateg ="/ /";
$replacesubcateg ="-";
$subcategreplace = preg_replace ($findsubcateg, $replacesubcateg, $subcateg);
$categ = "$row->catname";
$findcateg ="/ /";
$replacecateg ="-";
$categreplace = preg_replace ($findcateg, $replacecateg, $categ);
echo "<div class='categ_subcateg'><a href='/subcateg/$c/$categreplace/$row->subid/$subcategreplace/'>$row->subname</a></div>";
}
echo "</div>";
if (isset($_REQUEST['order'])) {
$order = $_REQUEST['order'];
$_SESSION['order'] = $_REQUEST['order'];
} else if (isset($_SESSION['order'])) {
$order = $_SESSION['order'];
}
if(empty($_REQUEST['order']))
{ $order = "subname ASC";}
echo "<div class='categ_sortbox'><div class='";
if(isset($order))
{
if ($order == "title ASC") { echo "categ_orderon";}
else
{
echo "categ_order";
}
}
echo "'><a href='/categ/$c/$categreplace&order=title ASC' style='text-decoration: none'>A-Z</a></div>";
echo "<div class='";
if(isset($order))
{
if ($order == "title DESC") { echo "categ_orderon";}
else
{
echo "categ_order";
}
}
echo "'><a href='/categ/$c/$categreplace&order=title DESC' style='text-decoration: none'>Z-A</a></div>
<div class='";
if(isset($order))
{
if ($order == "price ASC") { echo "categ_orderon";}
else
{
echo "categ_order";
}
}
echo "'><a href='/categ/$c/$categreplace&order=price ASC' style='text-decoration: none'>Price (Low-High)</a></div>
<div class='";
if(isset($order))
{
if ($order == "price DESC") { echo "categ_orderon";}
else
{
echo "categ_order";
}
}
echo "'><a href='/categ/$c/$categreplace&order=price DESC' style='text-decoration: none'> (High-Low)</a></div>
</div><div style='clear: both; width: 500px'/></div></div><br/>";
if ( $detect->isMobile() && !$detect->isTablet() ) {
$limit = 30; #item per page
}
else
{
$limit = 44; #item per page
}
$page = (int) (!isset($_GET['p'])) ? 1 : $_GET['p'];
# sql query
$result = "SELECT * FROM products WHERE catid = :c AND pause = 'off' ORDER BY rcstock ASC, $order";
$sql = $pdo->prepare($result);
$sql->execute(array(':c' => $_GET['c']));
$num_rows = $sql->rowCount();
# find out query stat point
$start = ($page * $limit) - $limit;
# query for page navigation
if(($num_rows) > ($page * $limit) ){
$next = ++$page;
}
$num_rows = 0;
$count = 0;
$query = $result . " LIMIT $start, $limit";
$sql = $pdo->prepare($query);
$sql->execute(array(':c' => $_GET['c']));
$num_rows = $sql->rowCount();
if ($num_rows < 1) {
header("HTTP/1.1 404 Not Found", true, 404);
include ("custom_404.php");
exit();
}
?>
<div class="wrap">
<!-- loop row data -->
<?php while ($row = $sql->fetch(PDO::FETCH_OBJ)):
$count ++;
$todaydate = date('Y-m-d');
$backinstock = NULL;
$newdate = strtotime("$todaydate");
$datebackinstock = strtotime($row->datebackinstock);
$i=30;
$checkBackinstock = strtotime(date("Y-m-d", strtotime($row->datebackinstock)) . " +".$i."days");
if ($checkBackinstock >= $newdate) { $backinstock = "enable"; }
$title = $row->title;
$findtitle ="/ /";
$replacetitle ="-";
$titlereplace = preg_replace ($findtitle, $replacetitle, $title);
$categ = $row->catname;
$findcateg ="/ /";
$replacecateg ="-";
$categreplace = preg_replace ($findcateg, $replacecateg, $categ);
$subcateg = $row->subname;
$findsubcateg ="/ /";
$replacesubcateg ="-";
$subcategreplace = preg_replace ($findsubcateg, $replacesubcateg, $subcateg);
echo "<div class='home_popular'";
if (($count % 4) == 0)
{
echo " style=' margin-right: 0px' ";
}
echo "><b>here</b>";
if(isset($backinstock) && $row->pricedropenable != "yes" && $row->rcstock == "in stock")
{
if ($backinstock == "enable")
{
echo "<div id='home_popular_backinstock'><a href='/product/$row->catid/$categreplace/$row->subid/$subcategreplace/$row->id/$titlereplace'>✔ BACK IN STOCK</a></div>";
}
}
if(isset($row->pricedropenable))
{
if ($row->pricedropenable == "yes")
{
echo "<div id='home_popular_pricedrop'><a href='/product/$row->catid/$categreplace/$row->subid/$subcategreplace/$row->id/$titlereplace'>▼ PRICE DROP</a></div>";
}
}
echo "<a href='/product/$row->catid/$categreplace/$row->subid/$subcategreplace/$row->id/$titlereplace'><img src='/images/productphotos/small/$row->photoprimary' alt='$row->title' />
<div class='home_popular_title'>$row->title ($count - $c)</div></a>
<div id='home_popular_base'>
<div class='home_popular_stock'>";
if ($row->preorder == "yes") { echo "pre-order only";}
else if ($row->comingsoon == "yes") { echo "coming soon";}
else
{
echo "$row->rcstock";
}
echo "</div>
<div class='home_popular_price'>";
if ($row->pricedropenable == "yes") { echo "<font color='#ff0000'>▼</font> Only $";
printf ("%.2f", $row->price);
echo "</font> Was <s>$";
printf ("%.2f", $row->pricedrop);
echo "</s>";
}
else
{
echo "Only ";
printf ("$%.2f", $row->price);
}
echo "</div>
</div></div>";
endwhile?>
<!--page navigation-->
<?php if (isset($next)): ?>
<?php
echo "<div class='nav'>
<a href='/infinite-scroll?c=$c&p=";?><?php echo $next?>'>Next</a>
</div>
<?php endif?>
</div><!--.wrap-->Code: Select all
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script type="text/javascript" src="/js/infinite-scroll/jquery-ias.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
// Infinite Ajax Scroll configuration
jQuery.ias({
container : '.wrap', // main container where data goes to append
item: '.home_popular', // single items
pagination: '.nav', // page navigation
next: '.nav a', // next page selector
loader: '<img src="/js/infinite-scroll/ajax-loader.gif"/>', // loading gif
triggerPageThreshold: 3 // show load more if scroll more than this
});
});
</script>
<link rel="stylesheet" media="all" href="/js/infinite-scroll/style.css">
<?php
require_once 'Mobile_Detect.php';
$detect = new Mobile_Detect;
include('dbconn.php');
$c = isset($_GET['c']) ? $_GET['c'] : null;
$query = ("SELECT categories FROM categories WHERE id =:c");
$result = $pdo->prepare($query);
$result->execute(array(':c' => $_GET['c']));
while ($row = $result->fetch(PDO::FETCH_OBJ))
{
echo "</div><div class='cat_head'><h1>$row->categories</h1></div>";
}
$query = ("SELECT * FROM categories WHERE id = :c AND introtext <> ''");
$result = $pdo->prepare($query);
$result->execute(array(':c' => $_GET['c']));
if (isset($_SESSION["loggedin"]))
{
$usertype = $_SESSION["usertype"];
if ($usertype == "admin")
{
$num_rows = $result->rowCount();
if ($num_rows == 0)
{
echo "<div class='cat_adminlink' style='float: left'><a href='/index.php?page=a_catbanners&ctype=cat&id=$c&p=y'><i class='fa fa-pencil-square-o'></i> Edit/Add Text</a></div>";
}
}
}
while ($row = $result->fetch(PDO::FETCH_OBJ))
{
echo "<div class='category_intro'>";
if (isset($_SESSION["loggedin"]))
{
$usertype = $_SESSION["usertype"];
if ($usertype == "admin")
{
echo "<div class='cat_adminlink'><a href='/index.php?page=a_catbanners&ctype=cat&id=$c&p=y'><i class='fa fa-pencil-square-o'></i> Edit/Add Text</a></div>";
}
}
echo "$row->introtext</div>";
}
echo "<div style='clear: both' /></div>";
$query = ("SELECT * FROM categorybanners WHERE catid =:c");
$result = $pdo->prepare($query);
$result->execute(array(':c' => $_GET['c']));
$num_rows = $result->rowCount();
if ($num_rows != 0)
{
while ($row = $result->fetch(PDO::FETCH_OBJ))
{
echo "<div class='categ_topbanner'><a href='$row->url' style='text-decoration: none'><img src='/images/pages/$row->image' border='0'/></a>
</div>
<div class='categ_topbanner_text'>$row->cattext</div>";
}
}
echo "<div class='categ_topbox'><div class='categ_subbox'>";
$count = 0;
$query = "SELECT subname, subid, catname FROM products WHERE catid = :c AND pause = 'off' GROUP BY subname";
$result = $pdo->prepare($query);
$result->execute(array(':c' => $_GET['c']));
while ($row = $result->fetch(PDO::FETCH_OBJ))
{
$subcateg = "$row->subname";
$findsubcateg ="/ /";
$replacesubcateg ="-";
$subcategreplace = preg_replace ($findsubcateg, $replacesubcateg, $subcateg);
$categ = "$row->catname";
$findcateg ="/ /";
$replacecateg ="-";
$categreplace = preg_replace ($findcateg, $replacecateg, $categ);
echo "<div class='categ_subcateg'><a href='/subcateg/$c/$categreplace/$row->subid/$subcategreplace/'>$row->subname</a></div>";
}
echo "</div>";
if (isset($_REQUEST['order'])) {
$order = $_REQUEST['order'];
$_SESSION['order'] = $_REQUEST['order'];
} else if (isset($_SESSION['order'])) {
$order = $_SESSION['order'];
}
if(empty($_REQUEST['order']))
{ $order = "subname ASC";}
echo "<div class='categ_sortbox'><div class='";
if(isset($order))
{
if ($order == "title ASC") { echo "categ_subcategon";}
else
{
echo "categ_subcateg";
}
}
echo "'><a href='/categ/$c/$categreplace&order=title ASC' style='text-decoration: none'>A-Z</a></div>";
echo "<div class='";
if(isset($order))
{
if ($order == "title DESC") { echo "categ_subcategon";}
else
{
echo "categ_subcateg";
}
}
echo "'><a href='/categ/$c/$categreplace&order=title DESC' style='text-decoration: none'>Z-A</a></div>
<div class='";
if(isset($order))
{
if ($order == "price ASC") { echo "categ_subcategon";}
else
{
echo "categ_subcateg";
}
}
echo "'><a href='/categ/$c/$categreplace&order=price ASC' style='text-decoration: none'>Price (Low-High)</a></div>
<div class='";
if(isset($order))
{
if ($order == "price DESC") { echo "categ_subcategon";}
else
{
echo "categ_subcateg";
}
}
echo "'><a href='/categ/$c/$categreplace&order=price DESC' style='text-decoration: none'> (High-Low)</a></div>
</div><div style='clear: both; width: 500px'/></div></div><br/><div class='mainbodybox'>";
if ( $detect->isMobile() && !$detect->isTablet() ) {
$limit = 30; #item per page
}
else
{
$limit = 44; #item per page
}
$page = (int) (!isset($_GET['p'])) ? 1 : $_GET['p'];
# sql query
$result = "SELECT * FROM products WHERE catid = :c AND pause = 'off' ORDER BY rcstock = 'in stock' DESC, rcstock = '' DESC, comingsoon = 'yes', rcstock = 'out of stock', $order";
$sql = $pdo->prepare($result);
$sql->execute(array(':c' => $_GET['c']));
$num_rows = $sql->rowCount();
# find out query stat point
$start = ($page * $limit) - $limit;
# query for page navigation
if(($num_rows) > ($page * $limit) ){
$next = ++$page;
}
$num_rows = 0;
$count = 0;
$query = $result . " LIMIT $start, $limit";
$sql = $pdo->prepare($query);
$sql->execute(array(':c' => $_GET['c']));
$num_rows = $sql->rowCount();
if ($num_rows < 1) {
header("HTTP/1.1 404 Not Found", true, 404);
include ("custom_404.php");
exit();
}
?>
<div class="wrap">
<!-- loop row data -->
<?php while ($row = $sql->fetch(PDO::FETCH_OBJ)):
$count ++;
$pricedrop = NULL;
$backinstock = NULL;
$checkBackinstock = NULL;
$todaydate = date('Y-m-d');
$newdate = strtotime("$todaydate");
$dateenduse = strtotime("$row->datepricedrop");
$datebackinstock = strtotime("$row->datebackinstock");
$i=30;
$checkBackinstock = strtotime(date("Y-m-d", strtotime($row->datebackinstock)) . " +".$i."days");
$title = "$row->title";
$findtitle ="/ /";
$replacetitle ="-";
$titlereplace = preg_replace ($findtitle, $replacetitle, $title);
$categ = "$row->catname";
$findcateg ="/ /";
$replacecateg ="-";
$categreplace = preg_replace ($findcateg, $replacecateg, $categ);
$subcateg = "$row->subname";
$findsubcateg ="/ /";
$replacesubcateg ="-";
$subcategreplace = preg_replace ($findsubcateg, $replacesubcateg, $subcateg);
if ($checkBackinstock >= $newdate) { $backinstock = "enable";
}
if ($row->comingsoon != "yes")
{
if ($row->pricedrop != '' && $newdate < $dateenduse) { $pricedrop = "enable";}
}
echo "<div class='home_popular'";
if (($count % 4) == 0)
{
echo "style=' margin-right: 0px'";
}
echo ">";
echo "<a href='/product/$row->catid/$categreplace/$row->subid/$subcategreplace/$row->id/$titlereplace' title='Look at the $row->title'>";
if (isset($row->bundleroman1) && $row->bundleroman1 != '')
{
if (isset($row->photoprimary) && $row->photoprimary != '')
{
echo "<img src='http://www.site.co.uk/images/productphotos/small/$row->photoprimary' alt='$row->title' />";
}
else
{
echo "<img src='http://www.site.co.uk/images/blank_bundle.jpg' alt='$row->title' />";
}
}
else
{
if ($row->photoprimary == "" || $row->photoprimary == NULL)
{
echo "<img src='/images/blank.jpg'>";
}
else
{
echo "<img src='/images/productphotos/small/$row->photoprimary'></a>";
}
}
echo "
<div class='home_popular_title'>$row->title</div></a>
<div id='home_popular_base'>
<div class='home_popular_stock'>";
echo "</div>
</div></div>";
endwhile?>
<!--page navigation-->
<?php if (isset($next)): ?>
<?php
echo "<div class='nav'>
<a href='/categ?c=$c&order=$order&p=";?><?php echo $next?>'>Next</a>
</div>
<?php endif?>
</div><!--.wrap-->