I'm trying to use a where
statement in laravel, but in return I'm getting a blank value.
Here's the code
$vehicles_make_id = $_POST['vehicles_make_id']; //getting "Audi"
$vehicles_name_trim = $_POST['vehicles_name_trim']; //getting "A3, 2.0T Premium Automatic"
$vehicles_name_trim_ar = explode(',', $vehicles_name_trim);
$model_name = $vehicles_name_trim_ar[0]; //getting "A3"
$model_trim = $vehicles_name_trim_ar[1]; //getting "2.0T Premium Automatic"
$vehicles_body_ar = array_filter(array_unique(Model::where('model_make_id', $vehicles_make_id)
->where('model_name', $model_name)
->where('model_trim', $model_trim)
->lists('model_body')));
print_r(2.0T Premium Automatic);
I checked and the value exists in the database but I'm getting a blank array
I think your where's are wrong, aren't they missing '='.
$vehicles_body_ar = array_filter(array_unique(Model::where('model_make_id', '=', $vehicles_make_id)->where('model_name', '=', $model_name)->where('model_trim', '=', $model_trim)->lists('model_body')));
Last Query Check
$queries = DB::getQueryLog();
$last_query = end($queries);
print_r($last_query);