2 AND vendor_id = '" . $_POST['brandVen'][$i1] . "'";
if($i1 < (sizeof($_POST['brandVen']) - 1)){
$sql1 .= " UNION ";
} else {
$sql1 .= " ORDER BY product_name ASC";
}
}
$result1 = $conn->query($sql1);
while($row = mysqli_fetch_array($result1)) {
if ($vendorID != $row['vendor_id']) {
$vendorID = $row['vendor_id'];
array_push($companyProds, $row);
} else {
array_push($companyProds, $row);
}
}
$brandVenList = $_POST['brandVen'];
$allProds = $companyProds;
$totalProdCount = sizeof($companyProds);
} else {
$allProds = $mainList + $altList;
}
$maxPages = ceil( $totalProdCount / $limit );
$results = getData($limit, $page, $maxPages, $allProds, $brandVenList);
displayData($results, $conn, $xlistNumber);
function getData($limit, $page, $maxPages, $allProds, $brandVenList) {
$results = array();
$amountofProds = sizeof($allProds);
$startIndex = number_format($limit * ($page - 1));
$endIndex = number_format($startIndex + $limit);
if($endIndex > $amountofProds){
$endIndex = $amountofProds;
}
$x = $startIndex;
for($y = $startIndex; $x < $endIndex; $y++){
if(!empty($brandVenList)){
foreach($brandVenList as $brandVen){
if($brandVen == $allProds[$y]["id"]){
array_push($results, $allProds[$y]);
$x++;
}
}
} else {
array_push($results, $allProds[$y]);
$x++;
}
}
return $results;
}
function createPageLinks($maxPages, $page, $limit, $totalProdCount) {
if ( $limit == 'all' ) {
return '';
} else {
$link = 'https://landscapearchitect.com/LandscapeProducts/la_details.php?ad=' . $_GET['ad'] . '&xlist=' . $_GET['xlist'];
$last = $maxPages;
$start = ( ( $page - $maxPages ) > 0 ) ? $page - $maxPages : 1;
$end = ( ( $page + $maxPages ) < $last ) ? $page + $maxPages : $last;
$class = ( $page == 1 ) ? "disable" : "active";
$html = 'Prev';
if ( $start > 1 ) {
$html .= '1';
$html .= '...';
}
for ( $i = $start ; $i <= $end; $i++ ) {
$class = ( $page == $i ) ? "disable" : "";
$html .= '' . $i . '';
}
if ( $end < $last ) {
$html .= '...';
$html .= '' . $last . '';
}
$class = ( $page == $last ) ? "disable" : "active";
$html .= 'Next';
return $html;
}
}
function displayData($results, $conn, $xlistNumber){
foreach ($results as $product){
$sql99 = "SELECT * FROM vendor_product WHERE xlist = '" . $xlistNumber ."' AND vendor_id = '" . $product['vendor_id'] ."' AND series_product = 0";
$result99 = $conn->query($sql99);
$rowcount99=mysqli_num_rows($result99);
$prodName = substr($product['product_name'],0,21);
$companyName = substr($product['company_name'],0,20);
echo '
'. $prodName . '
'. $companyName . ''. $rowcount99 . ' Matching Products
';
}
unset($product);
}
?>