public function genelArama($search) {
$arananlar = [];
// Subject Search
$subjectSearch = DB::table('Subject as s')
->join('Category as c', 'c.CategoryID', '=', 's.CategoryID')
->join('SubCategory as sc', 'sc.SubCategoryID', '=', 's.SubCategoryID')
->where('s.Title', 'LIKE', '%' . $search . '%') // '%search%' kullanımı
->select('s.Title', 's.TitleSlug', 'c.CategorySlug', 'sc.SubCategorySlug')
->limit(5)
->get();
$arananlar['subjects'] = $subjectSearch;
// User Search
$userSearch = DB::table('Users')
->where('Nickname', 'LIKE', '%' . $search . '%') // '%search%' kullanımı
->select('Nickname', 'UserImage')
->limit(5)
->get();
$arananlar['users'] = $userSearch;
return response()->json($arananlar);
}
Hocam çalışmadı aynı şuanda