File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/EspressoBarUsato/africa/johannesburg/posts.php

<?php
error_reporting(1);
define('INCLUDE_CHECK',1);
include "../../espressophp/dbconnect.php";
					if(isset($_POST['email']))
					{
					$regg=mysql_real_escape_string($_POST['email']);
$v21 = "INSERT INTO registed VALUES('','$regg',now(),'johannesburg')";
$vr21 = mysql_query($v21);
if($vr21)
{
echo 'È successo registrarti';
exit();
}else{echo 'La registrazione non è fatto!';
exit();}
					}
    $search=mysql_real_escape_string($_GET['search']); 
    $marche=mysql_real_escape_string($_GET['marche']); 
	$color=mysql_real_escape_string($_GET['color']); 
	$category=mysql_real_escape_string($_GET['category']); 
	$subcategory=mysql_real_escape_string($_GET['subcategory']); 
	$cnga= preg_replace("/[^0-9]/", "", $_GET['cnga']);
	$cderi= preg_replace("/[^0-9]/", "", $_GET['cderi']);

$tbl_name="products";		
	$adjacents = 1;
	$query = "SELECT COUNT(*) as num FROM $tbl_name inner join prices WHERE products.id=prices.pid and  products.aktiv='1' and products.johannesburgtitle !='' ";
	if(!empty($cnga) || !empty($cderi))
	{
	$query .=" AND  prices.johannesburgprice BETWEEN '$cnga' AND '$cderi'";
	}
	if(!empty($_GET['marche']))
	{
	$query .=" AND  products.marche ='$marche'";
	}if($_GET['category'] !=='Ricambi'){$query .="AND  products.category !='Ricambi'";}
	if(!empty($_GET['color']))
	{
	$query .=" AND  products.color2 ='$color'";
	}if(!empty($_GET['category']))
	{
	$query .="AND  products.category ='$category'";
	}	if(!empty($_GET['subcategory']))
	{
	$query .="AND  products.subcategory ='$subcategory'";
	}
	if(!empty($search))
	{
	$query .="AND MATCH(products.marche, products.johannesburgtitle, products.johannesburgarticle,products.category,products.subcategory,products.color2) AGAINST('+$search*' IN BOOLEAN MODE) OR prices.johannesburgprice like '%$search%' OR prices.johannesburgreduced like '%$search%' OR products.id like '%$search%'";
	}
	$total_pages = mysql_fetch_array(mysql_query($query));
	$total_pages = $total_pages[num];
	/* Setup vars for query. */
	$targetpage = "?search=$search&cnga=$_GET[cnga]&cderi=$_GET[cderi]&marche=$_GET[marche]
						&items=$_GET[items]&color=$_GET[color]&order=$_GET[order]&category=$_GET[category]&subcategory=$_GET[subcategory]"; 	//your file name  (the name of this file)
	if(!empty($_GET['items']))
	{
	$limit = preg_replace("/[^0-9]/", "", $_GET['items']); 
	}
	else
	{
	$limit = 15; 
	}
									//how many items to show per page
	$page = $_GET['page'];
	if($page) 
		$start = ($page - 1) * $limit; 			//first item to display on this page
	else
		$start = 0;								//if no page var is given, set start to 0
    $prod = "select prices.johannesburgprice,prices.johannesburgreduced,prices.johannesburgvaluta,prices.pid,products.johannesburgtitle,products.johannesburgarticle,products.id,products.marche,products.category,products.foto from products inner join prices WHERE products.id=prices.pid and products.aktiv='1' and products.johannesburgtitle !=''";	
	if(!empty($cnga) || !empty($cderi))
	{
	$prod .="AND  prices.johannesburgprice BETWEEN '$cnga' AND '$cderi'";
	}
	if(!empty($_GET['marche']))
	{
	$prod .="AND  products.marche ='$marche'";
	}
	if(!empty($_GET['color']))
	{
	$prod .="AND  products.color2 ='$color'";
		}if($_GET['category'] !=='Ricambi'){$prod .="AND  products.category !='Ricambi'";}
	if(!empty($_GET['category']))
	{
	$prod .="AND  products.category ='$category'";
	}	if(!empty($_GET['subcategory']))
	{
	$prod .="AND  products.subcategory ='$subcategory'";
	}
	if(!empty($search))
	{
	$prod .="AND MATCH(products.marche, products.johannesburgtitle, products.johannesburgarticle,products.category,products.subcategory,products.color2) AGAINST('+$search*' IN BOOLEAN MODE) OR prices.johannesburgprice like '%$search%' OR prices.johannesburgreduced like '%$search%' OR products.id like '%$search%'";
	}elseif($_GET["order"]=='price')
	{$prod .=" ORDER BY cmimi asc  LIMIT $start, $limit";}
	elseif($_GET["order"]=='popularity'){$prod .=" ORDER BY shikime desc  LIMIT $start, $limit";}
	elseif($_GET["order"]=='Best'){
		$prod .="OR cmimi like '%$cmimi%' OR siprfaqe like '%$sipnga%' OR rruga like '%$rruga%' OR qyteti like '%$qyteti%' OR kategoria like '%$kat%' OR siprfaqe like '%$sipderi%' OR id like '%$lid%'";
	}else{	$prod .=" ORDER BY id desc  LIMIT $start, $limit"; }
$prodr = mysql_query($prod);
echo mysql_error();
	/* Setup page vars for display. */
	if ($page == 0) $page = 1;					//if no page var is given, default to 1.
	$prev = $page - 1;							//previous page is page - 1
	$next = $page + 1;							//next page is page + 1
	$lastpage = ceil($total_pages/$limit);		//lastpage is = total pages / items per page, rounded up.
	$lpm1 = $lastpage - 1;						//last page minus 1
	$pagination = "";
	if($lastpage > 1)
	{	
		$pagination .= "<div class=\"pagination\">";
		if ($page > 1) 
			$pagination.= "<li><a href=\"$targetpage&page=$prev\"><</a></li>";
		else
			$pagination.= "<li><span class=\"disabled\" style='color: #D6D6D6;display:none;'><</span></li>";	
		if ($lastpage < 7 + ($adjacents * 2))	//not enough pages to bother breaking it up
		{	
			for ($counter = 1; $counter <= $lastpage; $counter++)
			{
				if ($counter == $page)
					$pagination.= "<li class=active ><a href='#' style='border-color: #8dc153;'><span class=\"current\">$counter</span></a></li>";
				else
					$pagination.= "<li><a href=\"$targetpage&page=$counter\">$counter</a></li>";					
			}
		}
		elseif($lastpage > 5 + ($adjacents * 2))	//enough pages to hide some
		{
			if($page < 1 + ($adjacents * 2))		
			{
				for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
				{
					if ($counter == $page)
						$pagination.= "<li class=active><a href='#' style='border-color: #8dc153;'><span class=\"current\">$counter</span></a></li>";
					else
						$pagination.= "<li ><a href=\"$targetpage&page=$counter\">$counter</a>";					
				}
				$pagination.= "<li><span class='space'>...</span></li>";
				$pagination.= "<li><a href=\"$targetpage&page=$lpm1\">$lpm1</a></li>";
				$pagination.= "<li><a href=\"$targetpage&page=$lastpage\">$lastpage</a></li>";		
			}
			//in middle; hide some front and some back
			elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
			{
				$pagination.= "<li><a href=\"$targetpage&page=1\">1</a></li>";
				$pagination.= "<li><a href=\"$targetpage&page=2\">2</a></li>";
				$pagination.= "<li><span class='space'>...</span></li>";
				for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
				{
					if ($counter == $page)
						$pagination.= "<li class=active><a href='#' style='border-color: #8dc153;'><span class=\"current\">$counter</span></a></li>";
					else
						$pagination.= "<li><a href=\"$targetpage&page=$counter\">$counter</a></li>";					
				}
				$pagination.= "<li><span class='space'>...</span></li>";
				$pagination.= "<li><a href=\"$targetpage&page=$lpm1\">$lpm1</a></li>";
				$pagination.= "<li><a href=\"$targetpage&page=$lastpage\">$lastpage</a></li>";		
			}
			//close to end; only hide early pages
			else
			{
				$pagination.= "<li><a href=\"$targetpage&page=1\">1</a></li>";
				$pagination.= "<li><a href=\"$targetpage&page=2\">2</a></li>";
				$pagination.= "<li><span class='space'>...</span></li>";
				for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
				{
					if ($counter == $page)
						$pagination.= "<li class=active><a href='#' style='border-color: #8dc153;'><span class=\"current\">$counter</span></a></li>";
					else
						$pagination.= "<li><a href=\"$targetpage&page=$counter\">$counter</a></li>";					
				}
			}
		}
		
		//next button
		if ($page < $counter - 1) 
			$pagination.= "<li><a style='border-left: 1px solid #dddddd;' href=\"$targetpage&page=$next\">></li></a>";
		else
			$pagination.= "<li><span style='display:none;color: #D6D6D6;' class=\"disabled\">></span></li>";
		$pagination.= "</div>\n";		
	}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Espresso Bar Usato | Machines |</title>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" /> 
<meta name="viewport" content="width=device-width; initial-scale=1.0; maximum-scale=1.0; user-scalable=no">
<meta name="description" content="Espresso Bar Usato Machines" />
<meta name="keywords" content="espresso bar usato, esresso, bar, usato, espresso machines" />
<?php include_once "header.php"; ?>

<section class="main-container col2-left-layout">
           <div class="main container">   
             <div class="row">          
               <section class="col-main col-sm-9 col-sm-push-3 wow bounceInUp animated">                                          
<div class="category-products">
  <div class="toolbar">
        <div class="sorter">
                <div class="view-mode"> 
<?php if($_GET['display'] !='List'){?><span title="Griglia" class="button button-active button-grid first">Grid</span>&nbsp;<?php }else{ ?><a href="?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo $_GET['cderi']; ?>
						&order=<?php echo $_GET['order']; ?>&category=<?php echo $_GET['category']; ?>&marche=<?php echo $_GET['marche']; ?>
						&color=<?php echo $_GET['color']; ?>&subcategory=<?php echo $_GET['subcategory']; ?>&items=<?php echo $_GET['items']; ?>
						&display=Grid" title="Lista " class="button button-grid">Griglia </a><?php } ?>
					<?php if($_GET['display'] =='List'){?><span title="Griglia" class="button button-active button-list first">Lista</span>&nbsp;<?php }else{ ?><a href="?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo $_GET['cderi']; ?>
						&order=<?php echo $_GET['order']; ?>&category=<?php echo $_GET['category']; ?>&marche=<?php echo $_GET['marche']; ?>
						&color=<?php echo $_GET['color']; ?>&subcategory=<?php echo $_GET['subcategory']; ?>&items=<?php echo $_GET['items']; ?>
						&display=List" title="Lista " class="button button-list first">List </a><?php } ?>	
			
                                                   
        </div>
               </div> 
               <div id="sort-by">
            <label class="left">Sort By:</label>
         <ul>
                      <li>
 <?php if(!empty($_GET["order"])){ ?><a href="?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo $_GET['cderi']; ?>
						&order=<?php echo $_GET['order']; ?>&category=<?php echo $_GET['category']; ?>&marche=<?php echo $_GET['marche']; ?>&color=<?php echo $_GET['color']; ?>&subcategory=<?php echo $_GET['subcategory']; ?>&items=<?php echo $_GET['items']; ?>"style="font-size:9px;"><?php echo $_GET['order']; ?> <span class="right-arrow"></span></a> <?php }else{ echo'<a href="#" style="font-size:9px;">  Best Match      <span class="right-arrow"></span></a>';}  ?>     
          
          <ul>
                           
              <li>
                <a href="?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo$_GET['cderi']; ?>
						&order=Best&items=<?php echo $_GET['items']; ?>&category=<?php echo $_GET['category']; ?>&marche=<?php echo $_GET['marche']; ?>&color=<?php echo $_GET['color']; ?>&subcategory=<?php echo $_GET['subcategory']; ?>">
                    Best Match              </a>
              </li>
                           
              <li>
                <a href="?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo$_GET['cderi']; ?>
						&order=Newness&items=<?php echo $_GET['items']; ?>&category=<?php echo $_GET['category']; ?>&marche=<?php echo $_GET['marche']; ?>&color=<?php echo $_GET['color']; ?>&subcategory=<?php echo $_GET['subcategory']; ?>">
                    Newness             </a>
              </li>
                           
              <li>
                <a href="?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo$_GET['cderi']; ?>
						&order=Price&items=<?php echo $_GET['items']; ?>&category=<?php echo $_GET['category']; ?>&marche=<?php echo $_GET['marche']; ?>&color=<?php echo $_GET['color']; ?>&subcategory=<?php echo $_GET['subcategory']; ?>">
                    Price                </a>
              </li>     <li>
                <a href="?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo$_GET['cderi']; ?>
						&order=Popularity&items=<?php echo $_GET['items']; ?>&category=<?php echo $_GET['category']; ?>&marche=<?php echo $_GET['marche']; ?>&color=<?php echo $_GET['color']; ?>&subcategory=<?php echo $_GET['subcategory']; ?>">
                    Popularity            </a>
              </li>
                      </ul> 
        </li>          
      </ul>
            </div>

<?php if(!empty($_GET["items"])){ ?><a href="?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo $_GET['cderi']; ?>
						&order=<?php echo $_GET['order']; ?>&items=<?php echo $_GET['items']; ?>&category=<?php echo $_GET['category']; ?>&marche=<?php echo $_GET['marche']; ?>&color=<?php echo $_GET['color']; ?>&subcategory=<?php echo $_GET['subcategory']; ?>"><?php echo $_GET['items']; ?>  <span class="right-arrow"></span></a> <?php }else{ echo'<a href="#"> 12  <span class="right-arrow"></span></a>';}  ?>     
        <ul>           
                          
            <li>
              <a href="?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo$_GET['cderi']; ?>
						&order=<?php echo $_GET['order']; ?>&items=12&category=<?php echo $_GET['category']; ?>&marche=<?php echo $_GET['marche']; ?>&color=<?php echo $_GET['color']; ?>&subcategory=<?php echo $_GET['subcategory']; ?>">
                 12              </a>
            </li>
                          
            <li>
              <a href="?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo$_GET['cderi']; ?>
						&order=<?php echo $_GET['order']; ?>&items=24&category=<?php echo $_GET['category']; ?>&marche=<?php echo $_GET['marche']; ?>&color=<?php echo $_GET['color']; ?>&subcategory=<?php echo $_GET['subcategory']; ?>">
                 24              </a>
            </li>
                          
            <li>
              <a href="?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo$_GET['cderi']; ?>&category=<?php echo $_GET['category']; ?>&marche=<?php echo $_GET['marche']; ?>&color=<?php echo $_GET['color']; ?>&subcategory=<?php echo $_GET['subcategory']; ?>
						&order=<?php echo $_GET['order']; ?>&items=36">
                 36              </a>
            </li>
                     
        </ul>

</li>
      </ul>
    </div>

<div class="pages">
        
        <ul class="pagination">
		<?=$pagination?>
                </ul>
    </div>
  </div> 
       
</div> 
   <?php if($category =='CUSTOMISATION SERVICE'){?> <img src="http://espressobarusato.com/images/enbanner1.jpg" style="width:99.9%"> <?php } ?> 
<?php if($_GET['display'] !='List'){?>
  <ul class="products-list">       
                <?php  while($rows = mysql_fetch_array($prodr)) { 
				$asd = "SELECT SUM(rate) as rates,COUNT(id) as i FROM wcd_rate where id_post = '$rows[id]'";
                $query = mysql_query($asd);
                $data = mysql_fetch_assoc($query);
                if($data['rates'] > 0){
					$rate_times =  $data['i'];
                    $rate_value = $data['rates'] / $data['i'];
                    $rate_bg = (($rate_value) / 5) * 100;
                }else{
                    $rate_times = 0;
                    $rate_value = 0;
                    $rate_bg = 0;
                }
			 	$title = $rows["johannesburgtitle"];
$string = slug($title); 
				?> 
                    <li class="item col-md-4 col-sm-6 col-xs-6" style='margin: auto;'>
              <div class="col-item">
                  <div class="item-img">
                    <div class="item-img-info">
                      <a href="<?php echo $rows["id"]; ?>-<?php echo $string; ?>" title="<?php echo $rows["johannesburgtitle"]; ?>" class="product-image">
                    <img id="product-collection-image-68" class="img-responsive"
                         src="http://espressobarusato.com/images/<?php echo $rows["foto"]; ?>"
                         alt="<?php echo $rows["johannesburgtitle"]; ?>" style='height:175px !important;'/>
                </a>  
                      </div> 
                    </div>
                    <div class="item-info">
                      <div class="info-inner" style=' text-align:center;'>
                        <div class="item-title">
                         <a class="" href="<?php echo $rows["id"]; ?>-<?php echo $string; ?>" title="<?php echo $rows["johannesburgtitle"]; ?>">
                            <?php echo $rows["johannesburgtitle"]; ?>                       </a>                  
                         </div>
                         <div class="item-content">

<p class="special-price">
                <span class="price" id="product-price-45-related">
                       <?php echo $rows["johannesburgreduced"] ?> <?php echo $rows["johannesburgvaluta"] ?>    </span>
            </p>
              <?php }else{ ?>                  <p class="special-price">
                <span class="price" id="product-price-45-related">
                  <?php echo $rows["johannesburgprice"] ?> <?php echo $rows["johannesburgvaluta"] ?>           </span>
            </p>   <?php } ?>  
    
        </div>                          </div>
                         </div>                         
                       </div>
                    </div> 
              </div>
            </li>
<?php } ?>   <div class="pages">
        
        <ul class="pagination">
		<?=$pagination?>
                </ul>
    </div> <?php } ?>  <?php if($_GET['display'] =='List'){?> <ol class="products-list" id="products-list">
<?php  while($rows = mysql_fetch_array($prodr)) {
				$asd = "SELECT SUM(rate) as rates,COUNT(id) as i FROM wcd_rate where id_post = '$rows[id]'";
                $query = mysql_query($asd);
                $data = mysql_fetch_assoc($query);
                if($data['rates'] > 0){
					$rate_times =  $data['i'];
                    $rate_value = $data['rates'] / $data['i'];
                    $rate_bg = (($rate_value) / 5) * 100;
                }else{
                    $rate_times = 0;
                    $rate_value = 0;
                    $rate_bg = 0;
                }$title = $rows["johannesburgtitle"];
$string = slug($title); 
	?>
          
            <li class="item">
        
          <div class="product-image">

<a href="<?php echo $rows["id"]; ?>-<?php echo $string; ?>" title="<?php echo $rows["johannesburgtitle"]; ?>">
                                                <img id="product-collection-image-68" class="small-image" width="230"     height='194'
                     src="http://espressobarusato.com/images/<?php echo $rows["foto"]; ?>"
                     alt="<?php echo $rows["johannesburgtitle"]; ?>" />
            </a>
           
          </div> 
          
          <div class="product-shop">
            <h2 class="product-name">
 <a href="<?php echo $rows["id"]; ?>-<?php echo $string; ?>" title="<?php echo $rows["johannesburgtitle"]; ?>"><?php echo $rows["johannesburgtitle"]; ?></a>
            </h2>

</div> 
        </li>      
                         
<?php } ?></ol>  <?php } ?>
                 
          </ul>        
       
        <script type="text/javascript">decorateGeneric($$('ul.products-grid'), ['odd','even','first','last'])</script>
    </div>

</section> 
               <aside class="col-left sidebar col-sm-3 col-xs-12 col-sm-pull-9 wow bounceInUp animated">               
                       
<div class="block block-layered-nav">
    <div class="block-title">SHOP BY</div>
    <div class="block-content">
            <dl id="narrow-by-list">
                                                                    <dt>Manufacturer</dt>
                    <dd>
<ol>						  <?php $mak =  "SELECT DISTINCT  marche FROM products where aktiv ='1' AND marche !=''  and johannesburgtitle !='' order by marche asc";
$maki = mysql_query($mak);
while($makina = mysql_fetch_assoc ($maki)){  
?>      
    <li>
                    <a href="?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo $_GET['cderi']; ?>
						&order=<?php echo $_GET['order']; ?>&items=<?php echo $_GET['items']; ?>&color=<?php echo $_GET['color']; ?>&marche=<?php echo $makina['marche']; ?>&category=<?php echo $_GET['category']; ?>&subcategory=<?php echo $_GET['subcategory']; ?>">
                <?php echo $makina['marche']; ?>                              
                            </a>
            </li>
<?php } ?>

</ol>
</dd>
              
                                            </dl>
            <script type="text/javascript">decorateDataList('narrow-by-list')</script>
            </div>
</div>
 <div class="fb-like-box" data-href="https://www.facebook.com/EBUJohannesburg/" data-width="300"
 data-show-faces="true" data-header="true" data-stream="true" data-show-border="true"></div>
 </br> </br>
 <div class="fb-like-box" data-href="https://www.facebook.com/africanpridecoffee/" data-width="300"
 data-show-faces="true" data-header="true" data-stream="true" data-show-border="true"></div>
           
               </aside>   
             </div>        
          </div>
       </section>    
    <?php include_once "footer.php"; ?>
</body>
</html>

Batal

⬅ Naik ke africa 15 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁App_Data	dir	—	2018-02-01 03:51	📂 Buka
🐘About.php	php	5.6 KB	2018-02-01 03:51	✏️ Edit 👁️ View
🐘Admin.php	php	18.2 KB	2018-02-01 03:51	✏️ Edit 👁️ View
🖼️Africanprideaaaalogo.png	png	129.6 KB	2018-02-01 03:51	✏️ Edit 👁️ View
🐘Contact.php	php	6.9 KB	2018-02-01 03:51	✏️ Edit 👁️ View
🐘asd.php	php	8.9 KB	2018-02-01 03:51	✏️ Edit 👁️ View
🐘captcha.php	php	761 B	2018-02-01 03:51	✏️ Edit 👁️ View
🌐cookies.html	html	2.9 KB	2018-02-01 03:51	✏️ Edit 👁️ View
🐘details.php	php	32.8 KB	2018-02-01 14:52	✏️ Edit 👁️ View
🐘footer.php	php	5.3 KB	2018-02-01 03:51	✏️ Edit 👁️ View
🐘header.php	php	21.9 KB	2018-02-01 14:52	✏️ Edit 👁️ View
🐘index.php	php	28.3 KB	2018-02-01 03:51	✏️ Edit 👁️ View
🐘login.php	php	4.5 KB	2018-02-01 03:51	✏️ Edit 👁️ View
🐘logout.php	php	621 B	2018-02-01 03:51	✏️ Edit 👁️ View
🐘posts.php	php	24.8 KB	2018-02-01 03:51	✏️ Edit 👁️ View