用ajax搜索，在数组中“喜欢”

Question

Please help with search script

$("#search").on("keyup",function(){
    var search=$("#search").val();
    search=search.replace(/  +/g, ' ');
    if(search.length>=1){
        var result=search.split("");
        $.ajax({  
            type: 'POST',  
            url: "{{URL('/searchajax')}}", 
            data: 
                { 
                    search:result
                },
            success: function(data) {
                $("#searchresult").css("display","block");
                if(data.length>0){
                    for(var i=0;i<data.length;i++){
                        $.each(data[i], function( index, value ) {
                            $("#itemssearch").append("<a href='{{URL('/product')}}/"+value.id+"'>\
                                                            <li>"+value.originalname+value.name+"</li>
\
                                                        </a>
\
                                                        ");

                            });
                    }
                }else{
                      ...
                }
            }
        });
    }
});

public function searchajax(Request $request){
    $search=$request->search;
        $return=DB::table("products")
                ->where('originalname', 'like', '%'.$search.'%')
                ->orWhere('name', 'like', '%'.$search.'%')
                ->orderby("products.table_id")
                ->take(5)
                ->get();

    return response()->json($return);
}

1. if have search word "iphone 7s" how to search first "iphone" then "7s" and get all result in one variable
2. if have search word "iphone 7s" how to search first "iphone" then "7s" and get all result in one variable

Answer 1

If I understood you correctly, you want to apply orWhere() pair for each word with foreach:

$words = explode(' ', $search);

$result = Product::query();

foreach ($words as $word) {
    $result = $result->orWhere('originalname', 'like', '%'.$word.'%')
                     ->orWhere('name', 'like', '%'.$word.'%');
}

$result = $result->orderby("products.table_id")->take(5)->get();