rbs@u2-jsapi

<?php
$js = json_decode(file_get_contents('php://input'));
switch($p3) {
  case 'discover-search';
     $dt=discover_search($js);
     echo json_encode($dt);
   break;
  default;
}

function discover_search($js){
  global $ar,$db;
  $dt=array();

//{"search":"car","user_id":67032,"page":1,"type":"all","per_page":10}
  $limit=$js->per_page;
  $page=$js->page;

//events
  $sql1="SELECT id,title as name,cover_photo as thumbnail from `events` where title like '%".$js->search."%' order by rand()";
  $res1=mysqli_query($db,$sql1);
  $start=($page-1)*$limit;
  $dt['events']['total_items']=mysqli_num_rows($res1);
  $dt['events']['total_pages']=ceil(mysqli_num_rows($res1)/$limit);
  $dt['events']['page']=$page;
  $dt['events']['limit']=$limit;
  if(mysqli_num_rows($res1)>0) {
    $b=0;
    $sql1b=$sql1." limit 10";
    $res1b=mysqli_query($db,$sql1b);
    while($r1b=mysqli_fetch_assoc($res1b)) {
      $dt['events']['data'][$b]=$r1b;
      $dt['events']['data'][$b]['type']='events';
      if($b<3) {
      $dt['top_results']['events'][$b]=$r1b;
      $dt['top_results']['events'][$b]['type']='events';
      }
      $b++;
    }
  } 
  
  //users 
  $sql2="SELECT b.id,a.name,a.username,b.make,b.model,b.colour,b.cover_photo as thumbnail from `users` a JOIN garage b ON a.id=b.user_id where a.name like '%".$js->search."%' order by rand()";
  $res2=mysqli_query($db,$sql2);
  $dt['users']['total_items']=mysqli_num_rows($res2);
  $dt['users']['total_pages']=ceil(mysqli_num_rows($res2)/$limit);
  $dt['users']['page']=$page;
  $dt['users']['limit']=$limit;
  if(mysqli_num_rows($res2)>0) {
    $b=0;
    $sql2b=$sql2." limit 10";
    $res2b=mysqli_query($db,$sql2b);
    while($r2b=mysqli_fetch_assoc($res2b)) {
      $dt['users']['data'][$b]['id']=$r2b['id'];
      $dt['users']['data'][$b]['name']=$r2b['name'];
      $dt['users']['data'][$b]['username']=$r2b['username'];
      $dt['users']['data'][$b]['thumbnail']=$r2b['thumbnail'];
      $dt['users']['data'][$b]['meta']['make']=$r2b['make'];
      $dt['users']['data'][$b]['meta']['colour']=$r2b['colour'];
      $dt['users']['data'][$b]['meta']['model']=$r2b['model'];
      $dt['users']['data'][$b]['meta']['variant']='vehicle';
      $dt['users']['data'][$b]['type']='vehicle';
      if($b<3) {
        $dt['top_results']['users'][$b]['id']=$r2b['id'];
        $dt['top_results']['users'][$b]['name']=$r2b['name'];
        $dt['top_results']['users'][$b]['username']=$r2b['username'];
        $dt['top_results']['users'][$b]['thumbnail']=$r2b['thumbnail'];
        $dt['top_results']['users'][$b]['meta']['make']=$r2b['make'];
        $dt['top_results']['users'][$b]['meta']['colour']=$r2b['colour'];
        $dt['top_results']['users'][$b]['meta']['model']=$r2b['model'];
        $dt['top_results']['users'][$b]['meta']['variant']='vehicle';
        $dt['top_results']['users'][$b]['type']='vehicle';
      }
      $b++;
    }
  }

//venues
  $sql3="SELECT id,title as name,cover_photo as thumbnail,logo,location as venue_location from `venues` where title like '%".$js->search."%' order by rand()";
  $res3=mysqli_query($db,$sql3);
  $dt['venues']['total_items']=mysqli_num_rows($res3);
  $dt['venues']['total_pages']=ceil(mysqli_num_rows($res3)/$limit);
  $dt['venues']['page']=$page;
  $dt['venues']['limit']=$limit;
  if(mysqli_num_rows($res3)>0) {
    $b=0;
    $sql3b=$sql3." limit 10";
    $res3b=mysqli_query($db,$sql3b);
    while($r3b=mysqli_fetch_assoc($res3b)) {
      $dt['venues']['data'][$b]=$r3b;
      if($b<3) {
      $dt['top_results']['venues'][$b]=$r3b;
      }
      $b++;
    }
  } 
  
  $dt['success']=true;
  return $dt;
}
?>

<?php
$js = json_decode(file_get_contents('php://input'));  
switch($p3) {
	case 'discover-search';
			$dt=discover_search($js);
			echo json_encode($dt);
		break;

default;
}

function discover_search($js){
  global $ar,$db;
  $dt=array();

//{"search":"car","user_id":67032,"page":1,"type":"all","per_page":10}
  $limit=$js->per_page;
  $page=$js->page;

discover -- discover-search