Laravel Advanced Wheres how to pass variable into function?

by

You can pass the necessary variables from the parent scope into the closure with the use keyword.

For example: 

DB::table('users')->where(function ($query) use ($activated) {
    $query->where('activated', '=', $activated);
})->get();

More on that here.

EDIT (2019 update):

PHP 7.4 (will be released at November 28, 2019) introduces a shorter variation of the anonymous functions called arrow functions which makes this a bit less verbose.

An example using PHP 7.4 which is functionally nearly equivalent (see the 3rd bullet point below):

DB::table('users')->where(fn($query) => $query->where('activated', '=', $activated))->get();

Differences compared to the regular syntax:

  • fn keyword instead of function.
  • No need to explicitly list all variables which should be captured from the parent scope – this is now done automatically by-value. See the lack of use keyword in the latter example.
  • Arrow functions always return a value. This also means that it’s impossible to use void return type when declaring them.
  • The return keyword must be omitted.
  • Arrow functions must have a single expression which is the return statement. Multi-line functions aren’t supported at the moment. You can still chain methods though.

More Related Contents:

  1. How do I get the query builder to output its raw SQL query as a string?
  2. How to insert multiple rows from a single query using eloquent/fluent
  3. SQLSTATE[42S22]: Column not found: 1054 Unknown column – Laravel
  4. Laravel Eloquent get results grouped by days
  5. Laravel 5.1, Return response to user, then excute some code [closed]
  6. Query database then email posts from where user is subbed to
  7. Getting raw SQL query string from PDO prepared statements
  8. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  9. Post request in Laravel – Error – 419 Sorry, your session/ 419 your page has expired
  10. MySQL Prepared statements with a variable size variable list
  11. How to pass data to all views in Laravel 5?
  12. Laravel Check If Related Model Exists
  13. Composer error: “PHP extension fileinfo is missing from your system”
  14. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  15. Laravel pagination pretty URL
  16. Laravel OrderBy relationship count
  17. How to add some textfield in form register (laravel generator infyom)?
  18. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  19. How to set a default attribute value for a Laravel / Eloquent model?
  20. How to avoid code repetition with PHP SQL prepared statements?
  21. Laravel mail: pass string instead of view
  22. Laravel – Database, Table and Column Naming Conventions?
  23. Prevent Browser’s Back Button Login After Logout in Laravel 5
  24. How to define a Laravel route with a parameter that contains a slash character
  25. How to install all required PHP extensions for Laravel?
  26. Log the actual SQL query using ActiveRecord with Yii2?
  27. How to send data using redirect with Laravel
  28. Laravel Carbon Data Missing
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment