Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host ="localhost";
- $user ="leo205";
- $pass ="01684669965leo205";
- $database = "gtvappunivac";
- $connect = new mysqli($host, $user, $pass,$database) or die("Error : ".mysql_error());
- ?>
- <?php
- mysqli_query($connect,"SET NAMES 'utf8'");
- //mysql_query('SET CHARACTER SET utf8');
- if(isset($_GET['cat_id']))
- {
- //$query="SELECT * FROM tbl_category WHERE cid='".$_GET['cat_id']."' ORDER BY tbl_category.cid DESC";
- //$resouter = mysql_query($query);
- $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";
- $resouter = mysqli_query($connect,$query);
- }
- else if(isset($_GET['latest']))
- {
- $limit=$_GET['latest'];
- $query="SELECT * FROM tbl_category c,tbl_gallery n WHERE c.cid=n.cat_id ORDER BY n.id DESC LIMIT $limit";
- $resouter = mysqli_query($connect,$query);
- }
- else if(isset($_GET['apps_details']))
- {
- $query="SELECT * FROM tbl_settings WHERE id='1'";
- $resouter = mysqli_query($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_assoc($resouter)){
- $set['YourVideosChannel'][] = $link;
- }
- }
- echo $val= str_replace('\\/', '/', json_encode($set));
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement