File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/ilc.al/en/search.php

<?php 
error_reporting(0);
define('INCLUDE_CHECK',1);
include "../ilc_php_files/dbconnect.php";
$search=preg_replace("/[^a-z A-Z 0-9 ë Ç]/", "", $_GET['search']); 
	$lid= preg_replace("/[^0-9]/", "", $_GET['lid']); 
	$tipi= preg_replace("/[^a-z A-Z ë Ç]/", "", $_GET['type']); 
	$offerts= preg_replace("/[^0-9]/", "", $_GET['offerts']); 
	$rruga= preg_replace("/[^0-9]/", "", $_GET['rruga']);
	$category= preg_replace("/[^a-zA-Z0-9 ë ÇwW]/", "", $_GET['category']);
$kategoria__emri = mysql_fetch_array(mysql_query("SELECT name from kategorite where emri = '$category'"));
	if(!empty($_GET['cnga']) && empty($_GET['cderi']))
	{
		$cderi= 999999999999999999999999999999999999999999999999999;
	}
	else
	{
		$cderi= preg_replace("/[^0-9]/", "", $_GET['cderi']);
	}
	if(empty($_GET['cnga']) && !empty($_GET['cderi']))
	{
		$cnga= 0;
	}
	else
	{
		$cnga= preg_replace("/[^0-9]/", "", $_GET['cnga']);
	}
	if(!empty($_GET['sipnga']) && empty($_GET['sipderi']))
	{
		$sipderi= 999999999999999999999999999999999999999999999999999;
	}
	else
	{
		$sipderi= preg_replace("/[^0-9]/", "", $_GET['sipderi']);
	}
	if(empty($_GET['sipnga']) && !empty($_GET['sipderi']))
	{
		$sipnga= 0;
	}
	else
	{
		$sipnga= preg_replace("/[^0-9]/", "", $_GET['sipnga']);
	}
	$luks= preg_replace("/[^a-z]/", "", $_GET['luks']);
	$tbl_name="permbledhje";		
	$adjacents = 1;
	$query = "SELECT COUNT(*) as num FROM $tbl_name WHERE aktiv='1' ";
	if(!empty($category))
	{
	$query .=" AND  kategoria  ='$category'";
	}	if(!empty($tipi))
	{
	$query .=" AND  tipi  ='$tipi'";
	}
		if(!empty($offerts) && $offerts==1)
	{
	$query .=" AND  oferte ='1'";
	}	if(!empty($lid))
	{
	$query .=" AND  id ='$lid'";
	}	if(!empty($okazion))
	{
	$query .=" AND  reduced != '0'";
	}
			if(!empty($rruga))
	{
	$query .=" AND  rruga='$rruga'";
	}	
		if(!empty($cnga) || !empty($cderi))
	{
	$query .=" AND  cmimi BETWEEN '$cnga' AND '$cderi'";
	}
	if(!empty($sipnga) || !empty($sipderi))
	{
	$query .=" AND  siprfaqe BETWEEN '$sipnga' AND '$sipderi'";
	}
	if(!empty($search))
	{
	$query .="AND MATCH(kategoria, entitulli, enartikulli) AGAINST('+$search*' IN BOOLEAN MODE) OR cmimi like '%$search%' OR 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&tipi=$_GET[tipi]
						&qyteti=$_GET[qyteti]&rruga=$_GET[rruga]
						&cnga=$_GET[cnga]&cderi=$_GET[cderi]&sipnga=$_GET[sipnga]
						&sipderi=$_GET[sipderi]&items=$_GET[items]&order=$_GET[order]"; 	//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 * from $tbl_name where aktiv='1' ";	
 if(!empty($category))
	{
	$prod .=" AND  kategoria  ='$category'";
	}	
	if(!empty($tipi))
	{
	$prod .=" AND  tipi  ='$tipi'";
	}
	if(!empty($offerts) && $offerts==1)
	{
	$prod .=" AND  oferte ='1'";
	}
			if(!empty($rruga))
	{
	$prod .=" AND  rruga='$rruga'";
	}	
		if(!empty($cnga) || !empty($cderi))
	{
	$prod .=" AND  cmimi BETWEEN '$cnga' AND '$cderi'";
	}
	if(!empty($sipnga) || !empty($sipderi))
	{
	$prod .=" AND  siprfaqe BETWEEN '$sipnga' AND '$sipderi'";
	}
		if(!empty($lid))
	{
	$prod .=" AND  id ='$lid'";
	}	if(!empty($okazion))
	{
	$prod .=" AND  reduced != '0'";
	}
		if(!empty($search))
	{
	$prod .="AND MATCH(kategoria, entitulli, enartikulli) AGAINST('+$search*' IN BOOLEAN MODE) OR cmimi like '%$search%' OR 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 type like '%$tipi%' 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;'><</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='color: #D6D6D6;' class=\"disabled\">></span></li>";
		$pagination.= "</div>\n";		
	}$basename=basename(__FILE__);
?><!DOCTYPE html>
<html lang="en-US" class="scheme_original">

<head>
	<title>ILC Foreign Language Center | <?php echo $kategoria__emri["name"]; ?> | </title>
	<?php include_once("header.php"); ?>
			<div class="page_content_wrap page_paddings_no">
<style>.sc_item_title {    margin: 2rem 0 -1px !important; } .top_panel_wrap {    margin-top: 0px;
    -webkit-box-shadow: -4px 3px 0px 0px rgba(0, 0, 0, 0.2);
    -moz-box-shadow: -4px 3px 0px 0px rgba(0, 0, 0, 0.2);
    box-shadow: -4px 3px 0px 0px rgba(0, 0, 0, 0.2);
}</style>
				
<div class="content_wrap">
<div class="content">
<article class="itemscope post_item post_item_single post_featured_default post_format_standard post-436 page type-page status-publish hentry" itemscope itemtype="http://schema.org/Article">
<section class="post_content" itemprop="articleBody"><div class="vc_row wpb_row vc_row-fluid">
<div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner "><div class="wpb_wrapper">
<div id="sc_blogger_2100812131" class="sc_blogger layout_colored_3 template_portfolio margin_bottom_huge  sc_blogger_horizontal">
<h3 class="sc_blogger_title sc_item_title sc_item_title_without_descr"><?php if(!empty($category)){echo $kategoria__emri["name"];}else{echo $search;} ?></h3>
<h5 class="sc_blogger_subtitle sc_item_subtitle">Programs We Provide</h5><div class="isotope_wrap" data-columns="3">

<?php  while($rows = mysql_fetch_array($prodr)) { ?> 
<div class="isotope_item isotope_item_colored isotope_item_colored_3 isotope_column_3						">
				<div class="post_item post_item_colored post_item_colored_3	post_format_standard odd">
	
					<div class="post_content isotope_item_content">
												<div class="post_featured img ">
							<a href="details/<?php echo $rows["id"] ?>-<?php echo slug($rows["entitulli"]); ?>">
							<img class="wp-post-image" width="370" height="370" alt="<?php echo $rows["entitulli"]; ?>" src=" ../images/<?php echo $rows["foto"]; ?>"></a>								
							<h4 class="post_title"><a href="details/<?php echo $rows["id"] ?>-<?php echo slug($rows["entitulli"]); ?>"><?php echo $rows["entitulli"]; ?></a></h4>
								<div class="post_descr">
									<div class="post_category"><a href="details/<?php echo $rows["id"] ?>-<?php echo slug($rows["entitulli"]); ?>"><?php echo $kategoria__emri["name"]; ?></a></div>                                            
									<div class="post_price"><?php echo $rows["cmimi"] ?></div>
                                        								</div>
														</div>

<div class="post-hover">
                                <h4 class="post_title"><a href="details/<?php echo $rows["id"] ?>-<?php echo slug($rows["entitulli"]); ?>"><?php echo $rows["name"]; ?></a></h4>
                                <p><?php echo substr(strip_tags($rows['enartikulli']),0,350); ?>...</p><a href="details/<?php echo $rows["id"] ?>-<?php echo slug($rows["name"]); ?>" class="sc_button sc_button_square sc_button_style_filled sc_button_size_small">More</a>                            </div>
                        					</div>				
				</div>	
			</div>						
			
		<?php } ?>

<nav class="woocommerce-pagination">
	<ul class='page-numbers'>
  <?php echo $pagination;?>	
</ul>   
</nav>
						
			</div></div></div></div></div></div>
				</section> 
			</article> 	<section class="related_wrap related_wrap_empty"></section>
	
		</div> 
	</div> 			
			</div>		
	<?php include_once("footer.php"); ?>

Batal

⬅ Naik ke ilc.al 12 item

Nama	Tipe	Ukuran	Diubah	Aksi
📄.htaccess	htaccess	1.2 KB	2022-09-16 13:14	✏️ Edit 👁️ View
🐘about.php	php	5.5 KB	2020-01-08 13:05	✏️ Edit 👁️ View
🐘admin.php	php	102.7 KB	2017-10-06 02:10	✏️ Edit 👁️ View
🐘contact.php	php	6.2 KB	2024-06-17 21:02	✏️ Edit 👁️ View
🐘details.php	php	4.5 KB	2020-01-08 12:47	✏️ Edit 👁️ View
🐘footer.php	php	20.9 KB	2020-01-08 12:50	✏️ Edit 👁️ View
🐘galeria.php	php	3.6 KB	2022-09-18 00:37	✏️ Edit 👁️ View
🐘header.php	php	25.2 KB	2022-09-18 00:41	✏️ Edit 👁️ View
🐘index.php	php	26.4 KB	2020-09-09 14:23	✏️ Edit 👁️ View
🐘login.php	php	4.1 KB	2017-10-06 02:10	✏️ Edit 👁️ View
🐘logout.php	php	663 B	2017-10-06 02:10	✏️ Edit 👁️ View
🐘search.php	php	11.4 KB	2020-01-08 14:38	✏️ Edit 👁️ View