Admin Control Panel v2.0

✎ Editing: index.php ← Back

<?php
include('includes/inc.config.php');
 $ip = $_SERVER["REMOTE_ADDR"];

include('header.php');

$limit = $data->settings('records');
        $page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]);
        $startpoint = ($page * $limit) - $limit;

$products_results = array();
if(isset($_GET['c']) && $_GET['c'] != ''){
	if($page){
$products = $database->execute("
SELECT * FROM `products` WHERE cat_id = '".$database->sanitize($_GET['c'])."' and `status` = '1' ORDER BY id ASC LIMIT {$startpoint} , {$limit}
");
	}else{
$products = $database->execute("
SELECT * FROM `products` WHERE cat_id = '".$database->sanitize($_GET['c'])."' and `status` = '1' ORDER BY id ASC
");		
	}
$statement = "`products` WHERE cat_id = '".$database->sanitize($_GET['c'])."' and `status` = '1'  ";
$url = '';
}else if(isset($_POST['search']) && $_POST['search'] != ''){
	if($page){
$products = $database->execute("
SELECT * FROM `products` WHERE name LIKE '%".$database->sanitize($_POST['search'])."%' and `status` = '1' ORDER BY id ASC LIMIT {$startpoint} , {$limit}
");
	}else{
$products = $database->execute("
SELECT * FROM `products` WHERE name LIKE '%".$database->sanitize($_POST['search'])."%' and `status` = '1' ORDER BY id ASC
");		
	}
$statement = "`products` WHERE name LIKE '%".$database->sanitize($_POST['search'])."%' and `status` = '1'  ";
$url = '';	
}else{
$products = $database->execute("
SELECT * FROM `products` WHERE `status` = '1' ORDER BY id ASC LIMIT {$startpoint} , {$limit}
");	
$statement = "`products` WHERE `status` = '1'  ";
$url = '?page=';
}
while($row = $database->fetch($products)){
    $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');
$smarty->assign("BigPrice", $BigPrice);
$smarty->assign("categories", $categories_results);
$smarty->assign("products", $products_results);
$smarty->assign("pagination", $data->pagination($statement,$limit,$page,$url));

$products_results = array();
$products = $database->execute("
SELECT * FROM `products` WHERE `status` = '1' ORDER BY RAND() limit 12
");
while($row = $database->fetch($products)){
    $row['price_eu'] = number_format($row['price'],2);
      $products_results[] = $row;
}
$smarty->assign("galery", $products_results);

$promo_results = array();
$promo = $database->execute("
SELECT * FROM `promotions` ORDER BY RAND() limit 3
");
while($row = $database->fetch($promo)){
    $row['price_eu'] = number_format($row['price'],2);
	$row['price_new'] = number_format($row['new_price'],2);
      $promo_results[] = $row;
}
$smarty->assign("promo_results", $promo_results);
$disc_results = array();$discounts = $database->execute("SELECT * FROM `discounts` ORDER BY id limit 1");while($row = $database->fetch($discounts)){    $row['price_eu'] = number_format($row['price'],2);	$row['price_new'] = number_format($row['new_price'],2);      $disc_results[] = $row;}$smarty->assign("disc_results", $disc_results);
$smarty->assign("rate_times", $rate_times);
$smarty->assign("rate_value", $rate_value);
$smarty->assign("rate_bg", $rate_bg);
$smarty->assign("packages", $list);
$smarty->display('index.tpl');
?>

Cancel