File "api.php"

Full Path: /home/refref/public_html/tag/referate/api.php
File size: 1.23 KB
MIME-type: text/x-php
Charset: utf-8

<?php

	include_once ('includes/variables.php');

	DEFINE ('DB_HOST', $host);
	DEFINE ('DB_USER', $user);	 
	DEFINE ('DB_PASSWORD', $pass);
	DEFINE ('DB_NAME', $database);
	 
	$mysqli = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL');
	@mysql_select_db (DB_NAME) OR die ('Could not select the database');
 
 ?>
<?php
 
 	mysql_query("SET NAMES 'utf8'"); 
	
	if(isset($_GET['cat_id']))
	{		
			$query="SELECT * FROM tbl_news_category c,tbl_news n WHERE c.cid=n.cat_id and c.cid='".$_GET['cat_id']."' ORDER BY RAND() LIMIT 20";			
			$resouter = mysql_query($query);

	}
	else if(isset($_GET['latest_news']))
	{
			$limit=$_GET['latest_news'];	 	
			
			$query="SELECT * FROM tbl_news_category c,tbl_news n WHERE c.cid=n.cat_id ORDER BY RAND() LIMIT $limit";			
			$resouter = mysql_query($query);
	}
	else
	{	
			$query="SELECT * FROM tbl_news_category ORDER BY cid DESC";			
			$resouter = mysql_query($query);
	}
     
    $set = array();
     
    $total_records = mysql_num_rows($resouter);
    if($total_records >= 1){
     
      while ($link = mysql_fetch_array($resouter, MYSQL_ASSOC)){
	   
        $set['NewsApp'][] = $link;
      }
    }
     
     echo $val= str_replace('\\/', '/', json_encode($set)); 	 
	 
?>