Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include_once ('includes/variables.php');
- $connect->set_charset('utf8');
- if(isset($_GET['cat_id']))
- {
- $query = "SELECT * FROM tbl_category c,tbl_recipes n WHERE c.cid = n.cat_id and c.cid = '".$_GET['cat_id']."' ORDER BY n.nid DESC";
- $resouter = mysqli_query($connect, $query);
- }
- else if(isset($_GET['nid']))
- {
- $id = $_GET['nid'];
- $query = "SELECT * FROM tbl_category c,tbl_recipes n WHERE c.cid = n.cat_id && n.nid = '$id'";
- $resouter = mysqli_query($connect, $query);
- }
- else if(isset($_GET['latest_news']))
- {
- $limit = $_GET['latest_news'];
- $query = "SELECT * FROM tbl_category c,tbl_recipes n WHERE c.cid=n.cat_id ORDER BY n.nid DESC LIMIT $limit";
- $resouter = mysqli_query($connect, $query);
- }
- else
- {
- $query = "SELECT * FROM tbl_category ORDER BY cid DESC";
- $resouter = mysqli_query($connect, $query);
- }
- $set = array();
- $total_records = mysqli_num_rows($resouter);
- if($total_records >= 1){
- while ($link = mysqli_fetch_array($resouter, MYSQLI_ASSOC)){
- $set ['Json'][] = $link;
- }
- }
- header( 'Content-Type: application/json; charset=utf-8' );
- echo $val= str_replace('\\/', '/', json_encode($set));
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement