File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/EspressoBarUsato/ru/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(),'it')";
$vr21 = mysql_query($v21);
if($vr21)
{
echo 'successo registrarti';
exit();
}else{echo 'La registrazione non e 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' products.russiantitle !='' ";
	if(!empty($cnga) || !empty($cderi))
	{
	$query .=" AND  prices.rprice BETWEEN '$cnga' AND '$cderi'";
	}
	if(!empty($_GET['marche']))
	{
	$query .=" AND  products.marche ='$marche'";
	}
	if(!empty($_GET['color']))
	{
	$query .=" AND  products.color3 ='$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.russiantitle, products.russianarticle,products.category,products.subcategory,products.color3) AGAINST('+$search*' IN BOOLEAN MODE) OR prices.rprice like '%$search%' OR prices.rreduced 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.php?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 = 12; 
	}
									//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.rprice,prices.rreduced,prices.val,prices.pid,products.russiantitle,products.russianarticle,products.id,products.marche,products.category,products.foto from products inner join prices WHERE products.id=prices.pid and products.aktiv='1' AND  products.russiantitle !=''";	
	if(!empty($cnga) || !empty($cderi))
	{
	$prod .="AND  prices.rprice BETWEEN '$cnga' AND '$cderi'";
	}
	if(!empty($_GET['marche']))
	{
	$prod .="AND  products.marche ='$marche'";
	}
	if(!empty($_GET['color']))
	{
	$prod .="AND  products.color3 ='$color'";
	}
	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.russiantitle, products.russianarticle,products.category,products.subcategory,products.color3) AGAINST('+$search*' IN BOOLEAN MODE) OR prices.rprice like '%$search%' OR prices.rreduced 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);
	/* 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</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="Default Description" />
<meta name="keywords" content="Magento, Varien, E-commerce" />
<?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">сетка</span>&nbsp;<?php }else{ ?><a href="posts.php?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">сетка </a><?php } ?>
					<?php if($_GET['display'] =='List'){?><span title="Griglia" class="button button-active button-list first">список</span>&nbsp;<?php }else{ ?><a href="posts.php?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">список </a><?php } ?>	
			
                                                   
        </div>
               </div> 
               <div id="sort-by">
            <label class="left">Сортировать по:</label>
         <ul>
                      <li>
 <?php if(!empty($_GET["order"])){ ?><a href="posts.php?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;">  Migliore  <span class="right-arrow"></span></a>';}  ?>     
          
          <ul>
                           
              <li>
                <a href="posts.php?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']; ?>">
                    лучший              </a>
              </li>
                           
              <li>
                <a href="posts.php?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']; ?>">
                   новинка         </a>
              </li>
                           
              <li>
                <a href="posts.php?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']; ?>">
                    цена                </a>
              </li>     <li>
                <a href="posts.php?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']; ?>">
                    популярность    </a>
              </li>
                      </ul> 
        </li>          
      </ul>
            </div>

<div class="pager"> 
      
    <div id="limiter">
     <ul>
      <label>выставка: </label>
       <li>

<?php if(!empty($_GET["items"])){ ?><a href="posts.php?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="posts.php?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="posts.php?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="posts.php?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> 
       
</div> 
        
    
           
<?php if($_GET['display'] !='List'){?>
  <ul class="products-list">       
                <?php  while($rows = mysql_fetch_array($prodr)) { ?> 
                    <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="details.php?post_id=<?php echo $rows["id"]; ?>"  title="<?php echo $rows["russiantitle"]; ?>" class="product-image">
                    <img id="product-collection-image-68" class="img-responsive"
                         src="http://nursoftalbania.com/exp2/images/<?php echo $rows["foto"]; ?>" style='height:175px !important;'
                         alt="<?php echo $rows["russiantitle"]; ?>" />
                </a>  
                      </div> 
                    </div>
                    <div class="item-info">
                      <div class="info-inner">
                        <div class="item-title">
                         <a class="" href="details.php?post_id=<?php echo $rows["id"]; ?>" title="<?php echo $rows["russiantitle"]; ?>">
                            <?php echo $rows["russiantitle"]; ?>                       </a>                  
                         </div>
                         <div class="item-content">                                                            
                           <div class="item-price"> 
    <div class="price-box">
                                
                  <?php if($rows["rreduced"] != 0){?>     <p class="old-price">
                <span itemprop="price" class="price" id="old-price-45-related">
                    <?php echo $rows["rreduced"] ?> <?php echo $rows["val"] ?>              </span>
            </p>
<?php } ?>
                        <p class="special-price">
                <span class="price" id="product-price-45-related">
                  <?php echo $rows["rprice"] ?> <?php echo $rows["val"] ?>           </span>
            </p>
                    
    
        </div>                       </div>
                         </div>                         
                       </div>
                    </div> 
              </div>
            </li>
<?php } }?><?php if($_GET['display'] =='List'){?> <ol class="products-list" id="products-list">
<?php  while($rows = mysql_fetch_array($prodr)) {
				$asd = "SELECT * FROM wcd_rate where id_post = '$rows[id]'";
                $query = mysql_query($asd);
                while($data = mysql_fetch_assoc($query)){
                    $rate_db[] = $data;
                    $sum_rates[] = $data['rate'];
                }
                if(@count($rate_db)){
                    $rate_times = count($rate_db);
                    $sum_rates = array_sum($sum_rates);
                    $rate_value = $sum_rates/$rate_times;
                    $rate_bg = (($rate_value)/5)*100;
                }else{
                    $rate_times = 0;
                    $rate_value = 0;
                    $rate_bg = 0;
                }
	?>
          
            <li class="item">
        
          <div class="product-image">

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

<div class="price-box">
                                
                  <?php if($rows["rreduced"] != 0){?>     <p class="old-price">
                <span itemprop="price" class="price" id="old-price-45-related">
                    <?php echo $rows["rreduced"] ?> <?php echo $rows["val"] ?>              </span>
            </p>
<?php } ?>
                        <p class="special-price">
                <span class="price" id="product-price-45-related">
                  <?php echo $rows["rprice"] ?> <?php echo $rows["val"] ?>           </span>
            </p>
                    
    
        </div>
<div class="ratings">
                    <div class="rating-box">
                <div class="rating" style="width:<?php echo $rate_bg; ?>%"></div>
            </div>
                <span class="amount"><a href="details.php?post_id=<?php echo $rows["id"]; ?>#review-form"><?php echo $rate_times; ?> Recensioni</a></span>
    </div>                                            
            <div class="desc std">
              <p><?php echo substr("$rows[russianarticle]",0,200); ?>...</p>
              <p><a href="details.php?post_id=<?php echo $rows["id"]; ?>" title="Contrast Women's Belt" class="link-learn">Learn More</a></p>
            </div>

</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">ТОВАРЫ ПО</div>
    <div class="block-content">
            <dl id="narrow-by-list">

<dt>Марши</dt>
                    <dd>
<ol>						  <?php $mak =  "SELECT DISTINCT  marche FROM products where aktiv ='1' AND marche !='' order by marche asc";
$maki = mysql_query($mak);
while($makina = mysql_fetch_assoc ($maki)){  
?>      
    <li>
                    <a href="posts.php?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>
                                                                    <dt>цвет</dt>
                    <dd>
<ol>
			  <?php $mak =  "SELECT DISTINCT color3 FROM products where aktiv ='1' AND color3 !='' order by color3 asc";
$maki = mysql_query($mak);
while($makina = mysql_fetch_assoc ($maki)){  
?>      
    <li>
                    <a href="posts.php?search=<?php echo $search; ?>&cnga=<?php echo $_GET['cnga']; ?>&cderi=<?php echo $_GET['cderi']; ?>
						&order=<?php echo $_GET['order']; ?>&items=<?php echo $_GET['items']; ?>&marche=<?php echo $_GET['marche']; ?>&color=<?php echo $makina['color3']; ?>">
                <?php echo $makina['color3']; ?>                              
                            </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/alicedibiz/?fref=ts" data-width="400" 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 EspressoBarUsato 14 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁App_Data	dir	—	2018-02-01 03:53	📂 Buka
📄.user.ini	ini	202 B	2018-02-01 03:53	✏️ Edit 👁️ View
🐘About.php	php	2.1 KB	2018-02-01 03:53	✏️ Edit 👁️ View
🐘Admin.php	php	19.3 KB	2018-02-01 03:53	✏️ Edit 👁️ View
🐘Contact.php	php	6.9 KB	2018-02-01 03:53	✏️ Edit 👁️ View
🐘details.php	php	34.2 KB	2018-02-01 03:53	✏️ Edit 👁️ View
🐘footer.php	php	5.6 KB	2018-02-01 03:53	✏️ Edit 👁️ View
🐘header.php	php	23.4 KB	2018-02-01 03:53	✏️ Edit 👁️ View
🐘index.php	php	24.4 KB	2018-02-01 03:53	✏️ Edit 👁️ View
🐘login.php	php	4.5 KB	2018-02-01 03:53	✏️ Edit 👁️ View
🐘logout.php	php	621 B	2018-02-01 03:53	✏️ Edit 👁️ View
🌐new 3.html	html	231.6 KB	2018-02-01 03:53	✏️ Edit 👁️ View
📝new 3.txt	txt	37.8 KB	2018-02-01 03:53	✏️ Edit 👁️ View
🐘posts.php	php	23.3 KB	2018-02-01 03:53	✏️ Edit 👁️ View