
Argument 1 passed to Illuminate\Database\Query\Builder::cleanBindings() must be of the type array, null given
Argument 1 passed to IlluminateDatabaseQueryBuilder::cleanBindings() must be of the type array, null given
In this session, we are going to try to solve the "Argument 1 passed to IlluminateDatabaseQueryBuilder::cleanBindings() must be of the type array, null given" puzzle by using the computer language.
Sometimes we get error Argument 1 passed to Illuminate\Database\Query\Builder::cleanBindings() must be of the type array, null given because we passed value to the query which is not in array format.-
WhereNotIn() query example in laravel
--PATH routes\web.phpRoute::get('/whereNotIn-with-array', function(){ $usersIdArray = array('1', '2', '3'); $users = App\Models\User::whereNotIn('id', $usersIdArray)->get(); return $users; });
You can check the variable before passing to the whereNotIn(). If the type of $array variable is not an array then you can convert it to an array and also pass an empty array if you don’t want to pass any data to it.
It will return all the records (user) from users table except the user which has id 1, 2, 3.
-
Pass null argument to WhereNotIn() query
--PATH routes\web.php//Code with error - to see the error message Route::get('/whereNotIn-with-null', function(){ $usersId = null; $users = App\Models\User::whereNotIn('id', $usersId)->get(); });
It will return Argument 1 passed to Illuminate\Database\Query\Builder::cleanBindings() must be of the type array, null given.
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Laravel
- How to create projects method with belongstomany relationship in user model
- How to get tomorrow and yesterday date in laravel
- Create project table with model and migration
- 419 page expired error in Laravel
- Check if Relationship Method Exists in Laravel
- Method Illuminate\Http\Request::validated does not exist
- How to get IP address in laravel
- How to get single column value in laravel
- How to check query string exists or not in laravel blade
- How to automatically update the timestamp of parent model in Laravel
- Generate random string lowercase in Laravel
- Drop foreign key column in Laravel using migration
- Class 'Facade\Ignition\IgnitionServiceProvider' not found
- Display message with session flash using bootstrap alert class in laravel
- Create a record if not exist in laravel
- Laravel create table migration with model
- How to use or operator in laravel
- PhpMyAdmin - Error The mysqli extension is missing
- How to authenticate admin users in Laravel ?
- Laravel API response format
- How to return error message from controller to view in laravel
- Redirect to previous page or url in laravel
- How to run a specific seeder class in laravel
- External link not working in laravel blade
- Get 30 days older records from table in laravel