www
/
wwwroot
/
magazinmiorita.be
➕ New
📤 Upload
✎ Editing:
products.php
← Back
<?php ob_start(); include('includes/inc.config.php'); $limit = $data->settings('records'); $page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]); $startpoint = ($page * $limit) - $limit; $products_results = array(); if(isset($_GET['sku']) && $_GET['sku'] == 'disponible'){ $stock_filter = 'and sku > 0 '; }else if(isset($_GET['sku']) && $_GET['sku'] == 'all'){ $stock_filter = ''; }else{ $stock_filter = ''; } if(isset($_GET['c']) && $_GET['c'] != ''){ if($page){ $products = $database->execute(" SELECT * FROM `products` WHERE cat_id = '".$database->sanitize($_GET['c'])."' and `status` = '1' $stock_filter ORDER BY id ASC LIMIT {$startpoint} , {$limit} "); }else{ $products = $database->execute(" SELECT * FROM `products` WHERE cat_id = '".$database->sanitize($_GET['c'])."' and `status` = '1' $stock_filter ORDER BY id ASC limit $limit "); } $statement = "`products` WHERE cat_id = '".$database->sanitize($_GET['c'])."' and `status` = '1' $stock_filter "; $url = '?'.($_GET['sku'] ? 'sku='.$_GET['sku'].'&' : '').'page='; }else if(isset($_POST['search']) && $_POST['search'] != '' || isset($_GET['search']) && $_GET['search'] != ''){ if($page){ $products = $database->execute(" SELECT * FROM `products` WHERE name LIKE '%".$database->sanitize(($_POST['search'] ? $_POST['search'] : $_GET['search']))."%' and `status` = '1' $stock_filter ORDER BY id ASC LIMIT {$startpoint} , {$limit} "); }else{ $products = $database->execute(" SELECT * FROM `products` WHERE name LIKE '%".$database->sanitize(($_POST['search'] ? $_POST['search'] : $_GET['search']))."%' and `status` = '1' $stock_filter ORDER BY id ASC "); } $statement = "`products` WHERE name LIKE '%".$database->sanitize(($_POST['search'] ? $_POST['search'] : $_GET['search']))."%' and `status` = '1' $stock_filter "; $url = '?search='.($_POST['search'] ? $_POST['search'] : $_GET['search']).'&'.($_GET['sku'] ? 'sku='.$_GET['sku'].'&' : '').'page='; }else{ $products = $database->execute(" SELECT * FROM `products` WHERE `status` = '1' $stock_filter ORDER BY id ASC LIMIT {$startpoint} , {$limit} "); $statement = "`products` WHERE `status` = '1' $stock_filter "; $url = '?'.($_GET['sku'] ? 'sku='.$_GET['sku'].'&' : '').'page='; } while($row = $database->fetch($products)){ $query = $database->execute("SELECT sum(rating_count) as total_count, sum(rating_points) as total_points FROM prod_rating WHERE prod_id = '".$row['id']."'"); $ratingRow = $database->assoc($query); $row['avg'] = ($ratingRow['total_count'] != 0 ? round($ratingRow['total_points'] / $ratingRow['total_count']) : 0); $row['count'] = $ratingRow['total_count']; $row['price_eu'] = number_format($row['price'],2); $products_results[] = $row; } $categories_results = array(); $categories = $database->execute(" SELECT * FROM `categories` "); while($row = $database->fetch($categories)){ $categories_results[] = $row; } $getBigPrice = $database->execute("SELECT * FROM `products` WHERE `status` = '1' order by price desc limit 1"); while($row = $database->fetch($getBigPrice)){ $BigPrice = $row['price']; } include('header.php'); $pageURL = (@$_SERVER["HTTPS"] == "on" ? "https://" : "http://"); if ($_SERVER["SERVER_PORT"] != "80") { $pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"]; } else { $pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]; } $smarty->assign("comm_url", $pageURL); $smarty->assign("BigPrice", $BigPrice); $smarty->assign("categories", $categories_results); $smarty->assign("products", $products_results); $smarty->assign("pagination", $data->pagination($statement,$limit,$page,$url)); $smarty->display('products.tpl'); ?>
💾 Save Changes
Cancel
📤 Upload File
×
Select File
Upload
Cancel
➕ Create New
×
Type
📄 File
📁 Folder
Name
Create
Cancel
✎ Rename Item
×
Current Name
New Name
Rename
Cancel
🔐 Change Permissions
×
Target File
Permission (e.g., 0755, 0644)
0755
0644
0777
Apply
Cancel