Advertisement
Guest User

update code

a guest
Jul 8th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. <?php
  2.  
  3. $host ="localhost";
  4. $user ="leo205";
  5. $pass ="01684669965leo205";
  6. $database = "gtvappunivac";
  7. $connect = new mysqli($host, $user, $pass,$database) or die("Error : ".mysql_error());
  8.  
  9. ?>
  10. <?php
  11.  
  12. mysqli_query($connect,"SET NAMES 'utf8'");
  13. //mysql_query('SET CHARACTER SET utf8');
  14.  
  15. if(isset($_GET['cat_id']))
  16. {
  17. //$query="SELECT * FROM tbl_category WHERE cid='".$_GET['cat_id']."' ORDER BY tbl_category.cid DESC";
  18. //$resouter = mysql_query($query);
  19.  
  20. $query="SELECT * FROM tbl_category c,tbl_gallery n WHERE c.cid=n.cat_id and c.cid='".$_GET['cat_id']."' ORDER BY n.id DESC";
  21. $resouter = mysqli_query($connect,$query);
  22.  
  23. }
  24. else if(isset($_GET['latest']))
  25. {
  26. $limit=$_GET['latest'];
  27.  
  28. $query="SELECT * FROM tbl_category c,tbl_gallery n WHERE c.cid=n.cat_id ORDER BY n.id DESC LIMIT $limit";
  29. $resouter = mysqli_query($connect,$query);
  30. }
  31. else if(isset($_GET['apps_details']))
  32. {
  33. $query="SELECT * FROM tbl_settings WHERE id='1'";
  34. $resouter = mysqli_query($query);
  35. }
  36. else
  37. {
  38. $query="SELECT * FROM tbl_category ORDER BY cid DESC";
  39. $resouter = mysqli_query($connect,$query);
  40. }
  41.  
  42. $set = array();
  43.  
  44. $total_records = mysqli_num_rows($resouter);
  45. if($total_records >= 1){
  46.  
  47. while ($link = mysqli_fetch_assoc($resouter)){
  48.  
  49. $set['YourVideosChannel'][] = $link;
  50. }
  51. }
  52.  
  53. echo $val= str_replace('\\/', '/', json_encode($set));
  54.  
  55.  
  56. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement