1#@!#!123s

22527 1#@!#!123s
: / home / parchhayin / www / include /
Filename : function.php
back
<?php 

function nav() { 
global $con;
 global $base_url;
$get_cats =mysqli_query($con,"SELECT * FROM `category` WHERE `category` NOT In ('स्लाइडर','ब्रेकिंग न्यूज़','खास खबरे','अन्य ख़बरें','ताजा खबरें' )");
while($cc=mysqli_fetch_array($get_cats)){
	
?>
<li><a href="<?php echo $base_url; ?>news.php?cat=<?php echo str_replace(' ','-',$cc['category']); ?>" ><?php echo $cc['category']; ?> </a></li>
					
<?php }} ?>

<?php 
function nav1() { 
global $con;
 global $base_url;
$get_cats =mysqli_query($con,"select * from category limit 12");
while($cc=mysqli_fetch_array($get_cats)){
?>
<li><a href="<?php echo $base_url; ?>news/<?php echo str_replace(' ','-',$cc['category']); ?>" class="sidenav__menu-link"><?php echo $cc['category']; ?> </a></li>
					
<?php }} ?>


 <?php 
 
function breacking_news() { 
	global $con;
	global $base_url;
	global $path;
	
$latest_news = mysqli_query($con, "select * from news where news_cat like '%ब्रेकिंग न्यूज़%' order by id desc limit 5");
	
	while($ls = mysqli_fetch_array($latest_news)) {
	   	echo '<li>
				<article class="entry-item clearfix">
					<div class="entry-thumb">
						<a href="'.$base_url.'details.php?title='.$ls['id'].'"><img src="'."$path".$ls['news_image'].'" alt="" /></a>
					</div>
					<div class="entry-content">
					<h4 class="entry-title"><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h4>
						<span class="entry-date"><span class="kopa-minus"></span>&mdash;'.date("m/d/Y", strtotime($ls['date'])).'</span>
					</div>
				</article>
			</li>';
	 } 
}

function world() { 
	global $con;
	global $base_url;
	global $path;
	
	$latest_news = mysqli_query($con, "select * from news where news_cat like '%विदेश%' order by id desc limit 1,5");
	

	while($ls = mysqli_fetch_array($latest_news)) {
		echo '<div class="post clearfix">
				<div class="item_thumb">
					<div class="thumb_icon">
						<a href="'.$base_url.'details.php?title='.$ls['id'].'" jQuery><i class="fa fa-copy"></i></a>
					</div>
					<div class="thumb_hover">
						<a href="'.$base_url.'details.php?title='.$ls['id'].'"><img src="'."$path".$ls['news_image'].'" alt="Post"></a>
					</div>
				</div>
				<div class="item_content">
					
					<h4><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h4>
					<div class="item_meta clearfix">
						<span class="meta_date">'.date("M d Y", strtotime($ls['date'])).'</span>
					</div>
				</div>
			</div><!-- End Post -->';
	 } 
}


function news_headlines1() { 
	global $con;
	global $base_url;
	global $path;
	
	$latest_news = mysqli_query($con, "select * from news where news_cat like '%ताजा खबरें%' order by id desc limit 10");
	

	while($ls = mysqli_fetch_array($latest_news)) {
		echo '&nbsp;<a href="'.$base_url.'details.php?title='.$ls['id'].'"> &nbsp;'.$ls['news_title'].'</a> &nbsp;|&nbsp;';
	 } 
}

?>





  <?php 
  function slider() { 
  global $con;
  global $base_url;
  global $path;
 $latest_news = mysqli_query($con, "select * from news where news_cat like '%स्लाइडर%' order by id desc limit 5");
 $s=1;
		 while($ls = mysqli_fetch_array($latest_news)) {
			  $cate = explode(',',$ls['news_cat']); 
			 if(trim($cate[0])=== 'स्लाइडर' or trim($cate[0])=== 'खास खबरे' or trim($cate[0])=== 'ताजा खबरें' or trim($cate[0])=== 'अन्य ख़बरें'){
			  $category =''; 
		 }else{
			 $category = '<span class="category" jQuery><a href="#">'.$cate[0].'</a></span>';
		 }
			
				echo '<li>
						<article>
							<img src="'."$path".$ls['news_image'].'" alt="" style="height:390px;"/>
							<div class="flex-caption">
								<h3><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h3>
							</div>
						</article>
					</li>';
					
				$s++;
		 }}?>


<?php 
function country() { 
  global $con;
  global $base_url;
  global $path;
 $country = mysqli_query($con, "select * from news where news_cat like '%देश%'  order by id desc limit 1,5");
	while($ls = mysqli_fetch_array($country)) {
		
		echo '<div class="post clearfix">
				<div class="item_thumb">
					<div class="thumb_icon">
						<a href="#" jQuery><i class="fa fa-copy"></i></a>
					</div>
					<div class="thumb_hover">
						<a href="'.$base_url.'details.php?title='.$ls['id'].'"><img src="'."$path".$ls['news_image'].'" alt="Post"></a>
					</div>
				</div>
				<div class="item_content">
					
					<h4><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h4>
					<div class="item_meta clearfix">
						<span class="meta_date">'.date("M d Y", strtotime($ls['date'])).'</span>
					</div>
				</div>
			</div><!-- End Post -->';
	} 
}

function other_news() { 
  global $con;
  global $base_url;
  global $path;
 $other_news = mysqli_query($con, "select * from news where news_cat like '%अन्य ख़बरें%' order by id desc limit 10");
	while($ls = mysqli_fetch_array($other_news)) {
		
	
		echo '<div class="recent-post">
				<div class="recent-post-thumb">
					<a href="'.$base_url.'details.php?title='.$ls['id'].'"><img src="'."$path".$ls['news_image'].'" /></a>
				</div>
				<h4 class="title"><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h4>
				<span class="post-date"><i class="fa fa-clock-o"></i>'.date("M d Y",strtotime($ls['date'])).'</span>
			</div>';
	} 
}
function sidebar_other_news() { 
  global $con;
  global $base_url;
  global $path;
 $other_news = mysqli_query($con, "select * from news where news_cat like '%अन्य ख़बरें%' order by id desc limit 5");
	while($ls = mysqli_fetch_array($other_news)) {
		echo '<li>
				<article class="entry-item clearfix">
					<div class="entry-thumb">
						<a href="'.$base_url.'details.php?title='.$ls['id'].'"><img src="'."$path".$ls['news_image'].'" alt="" /></a>
					</div>
					<div class="entry-content">
					<h4 class="entry-title"><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h4>
						<span class="entry-date"><span class="kopa-minus"></span>&mdash;'.date("m/d/Y", strtotime($ls['date'])).'</span>
					</div>
				</article>
			</li>';
	} 
}


function special_news() { 
  global $con;
  global $base_url;
  global $path;
 $special = mysqli_query($con, "select * from news where news_cat like '%खास खबरे%' order by id desc limit 7");
	while($ls = mysqli_fetch_array($special)) {		
		echo' <div class="item clearfix">
				<div class="item_thumb">
					<div class="thumb_icon">
						<a href="#"><i class="fa fa-copy"></i></a>
					</div>
					<div class="thumb_hover">
						<a href="'.$base_url.'details.php?title='.$ls['id'].'"><img src="'."$path".$ls['news_image'].'" alt="Post"></a>
					</div>
				</div>
				<div class="item_content">
					<h4><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h4>
					<div class="item_meta clearfix">
						<span class="meta_date">'.date("M d Y",strtotime($ls['date'])).'</span>
					</div>
				</div>
			</div>';
	} 
}

?>
<?php 

function politics(){
	global $con;
	global $base_url;
    global $path;
	$politics_footer = mysqli_query($con, "SELECT * FROM news where news_cat like '%राजनीति%' order by id desc limit 3");
	 while($ls = mysqli_fetch_array($politics_footer)) {
		echo'<div class="col col_4_of_12">
				<!-- Top review -->
				<div class="top_review">
					<div class="item_content">
						<a class="hover_effect" href="'.$base_url.'details.php?title='.$ls['id'].'">
							<div class="result" jQuery>3.0</div>
							<img src="'."$path".$ls['news_image'].'" alt="Post" style="    height: 196px;">
						</a>
						<h4><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h4>
					</div>
					<div class="transition_line"></div>
				</div><!-- End Top review -->
			</div>';
	 }
}

function crime(){
	global $con;
	global $base_url;
    global $path;
	$crime_footer = mysqli_query($con, "SELECT * FROM news where news_cat like '%क्राइम%' order by id desc limit 1,3");
	 while($ls = mysqli_fetch_array($crime_footer)) {
		
		echo '<li>
				<article class="entry-item clearfix">
					<div class="entry-thumb">
						<a href="'.$base_url.'details.php?title='.$ls['id'].'"><img src="'."$path".$ls['news_image'].'" style="height: 70px" /></a>
					</div>
					<div class="entry-content">
						<h4 class="entry-title"><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h4>
						<span class="entry-date"><span class="kopa-minus"></span>&mdash; '.date("M d Y", strtotime($ls['date'])).'</span>
					</div>
				</article>
			</li>';
	 }
}

function city_news(){
	global $con;
	global $base_url;
    global $path;
	$city_news = mysqli_query($con, "select * from news where news_cat like '%अपना शहर%' order by id desc limit 1, 3");
	 while($ls = mysqli_fetch_array($city_news)) {
		
		echo '<li>
				<article class="entry-item clearfix">
					<div class="entry-thumb">
						<a href="'.$base_url.'details.php?title='.$ls['id'].'"><img src="'."$path".$ls['news_image'].'" style="height: 70px" /></a>
					</div>
					<div class="entry-content">
						<h4 class="entry-title"><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h4>
						<span class="entry-date"><span class="kopa-minus"></span>&mdash; '.date("M d Y", strtotime($ls['date'])).'</span>
					</div>
				</article>
			</li>';
	 }
}
function state(){
	global $con;
	global $base_url;
    global $path;
	$state = mysqli_query($con, "SELECT * FROM news where news_cat like '%राज्य%' order by id desc limit 3");
	 while($ls = mysqli_fetch_array($state)) {
		echo'<div class="col col_4_of_12">
				<!-- Top review -->
				<div class="top_review">
					<div class="item_content">
						<a class="hover_effect" href="'.$base_url.'details.php?title='.$ls['id'].'">
							<div class="result" jQuery>3.0</div>
							<img src="'."$path".$ls['news_image'].'" alt="Post" style="    height: 196px;">
						</a>
						<h4><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h4>
					</div>
					<div class="transition_line"></div>
				</div><!-- End Top review -->
			</div>';
	 }
}



function sport_aside(){
	global $con;
	global $base_url;
    global $path;
	$sport_aside = mysqli_query($con, "SELECT * FROM news where news_cat like '%खेल%' order by id desc limit 1,3");
	 while($ls = mysqli_fetch_array($sport_aside)) {
		
		echo '<li>
				<article class="entry-item clearfix">
					<div class="entry-thumb">
						<a href="'.$base_url.'details.php?title='.$ls['id'].'"><img src="'."$path".$ls['news_image'].'" style="height: 70px" /></a>
					</div>
					<div class="entry-content">
						<h4 class="entry-title"><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h4>
						<span class="entry-date"><span class="kopa-minus"></span>&mdash; '.date("M d Y", strtotime($ls['date'])).'</span>
					</div>
				</article>
			</li>';
	 }
}

?>         

 <?php 
 function entertainment_news() { 
  global $con;
  global $base_url;
  global $path;
$latest_news = mysqli_query($con, "select * from news where news_cat like '%मनोरंजन%' order by id desc limit 1 ,3");
$i = 1;
 while($ls = mysqli_fetch_array($latest_news)) {
		
		echo '<li>
				<article class="entry-item clearfix">
					<div class="entry-thumb">
						<a href="'.$base_url.'details.php?title='.$ls['id'].'"><img src="'."$path".$ls['news_image'].'" style="height: 70px" /></a>
					</div>
					<div class="entry-content">
						<h4 class="entry-title"><a href="'.$base_url.'details.php?title='.$ls['id'].'">'.$ls['news_title'].'</a></h4>
						<span class="entry-date"><span class="kopa-minus"></span>&mdash; '.date("M d Y", strtotime($ls['date'])).'</span>
					</div>
				</article>
			</li>';
			$i++;
		} 
}
?>
	         


 
 
<?php 
function Videos() { 
	global $con;
	global $base_url;
	global $path;
	$latest_news = mysqli_query($con, "select * from video order by id desc limit 1");
		 while($ls = mysqli_fetch_array($latest_news)) {
				$video_link = $ls['video'];
				echo $video_link;
			} 
	}
?>
	
    
 
<?php function Videos1() { 
global $con;
global $base_url;
global $path;
$latest_news = mysqli_query($con, "select * from video order by id desc limit 5");
while($ls = mysqli_fetch_object($latest_news)) {
	echo '<li style="width: 228px;">
			<article class="entry-item clearfix">
				<div class="entry-thumb">
					<iframe src="http://www.youtube.com/embed/'.$ls->video.'" width="100%" height="150" allowfullscreen="allowfullscreen"></iframe>
					<div class="mask"><a href="#" data-icon="&#xe125;"></a></div>
				</div>
				<!-- entry-thumb -->
				<div class="entry-content">
					<header>
						<h5 class="entry-title"><a href="#">'.$ls->txtTitle.'</a></h5>
						<span class="entry-date">&mdash;'.date("M d Y", strtotime($ls->dtDate)).'</span>
					</header>
				</div>
				<!-- entry-content -->
			</article>
		</li>';

}
}
?>
                           

<?php 
function social() {
 global $con;
 global $base_url;
 global $path;
// echo "select * from social where `name` not in ('google')";
 $get_ss=mysqli_query($con,"select * from social where `name` not in ('google','whatsapp')");
 
//print_r($get_ss);
while($pp=mysqli_fetch_array($get_ss)){	
		
		echo '<li><a href="'.$pp['link'].'"><i class="fa fa-'.$pp['name'].'"></i></a></li>';
	}
}

function social_side() {
 global $con;
 global $base_url;
 global $path;
// echo "select * from social where `name` not in ('google')";
 $get_ss=mysqli_query($con,"select * from social where `name` not in ('google')");
 
//print_r($get_ss);
while($pp=mysqli_fetch_array($get_ss)){
	
	echo 	'<a href="'.$pp['link'].'" target="_blank" class="icon '.$pp['name'].'">
				<div class="symbol"><i class="fa fa-'.$pp['name'].'"></i></div>
			</a>';
	
	}
}
?>