xxxxxxxxxx
The find Method
If you are overriding the find method in your own models and calling parent::find() within your custom method, you should now change it to call the find method on the Eloquent query builder:
public static function find($id, $columns = ['*'])
{
$model = static::query()->find($id, $columns);
// ...
return $model;
}
xxxxxxxxxx
$searchTerm ='milad zamir Abc';
$reservedSymbols = ['-', '+', '<', '>', '@', '(', ')', '~'];
$searchTerm = str_replace($reservedSymbols, ' ', $searchTerm);
$searchValues = preg_split('/\s+/', $searchTerm, -1, PREG_SPLIT_NO_EMPTY);
$res = User::where(function ($q) use ($searchValues) {
foreach ($searchValues as $value) {
$q->orWhere('name', 'like', "%{$value}%");
$q->orWhere('family_name', 'like', "%{$value}%");
}
})->get();
xxxxxxxxxx
// SEARCH QUERY
if (request()->has('search')){
$search = trim(request('search'));
$resumess = $resumess->where(function($query) use ($search){
$query->where('doc_name', 'LIKE', "%{$search}%");
$searches = explode(" ",$search);
foreach($searches as $s){
$query->orWhere('first_name', 'LIKE', "%{$s}%");
$query->orWhere('last_name', 'LIKE', "%{$s}%");
$query->orWhere('position_type', 'LIKE', "%{$s}%");
$query->orWhere('position_type', 'LIKE', "%{$s}%");
}
});
}
xxxxxxxxxx
// Retrieve a model by its primary key...
$flight = App\Models\Flight::find(1);
// Retrieve the first model matching the query constraints...
$flight = App\Models\Flight::where('active', 1)->first();
// Shorthand for retrieving the first model matching the query constraints...
$flight = App\Models\Flight::firstWhere('active', 1);
xxxxxxxxxx
public function index()
{
$q = Dog::query();
if (Input::has('search'))
{
// simple where here or another scope, whatever you like
$q->where('name','like',Input::get('search'));
}
if (Input::has('search-breed'))
{
$q->searchBreed(Input::get('search-breed'));
}
if (Input::has('sex'))
{
$q->where('sex', Input::get('sex'));
}
if (Input::has('radius'))
{
$q->withinRadius(Input::get('radius'));
}
$dogs = $q->orderBy(..)->paginate(5);
// ...
xxxxxxxxxx
return Destination::orderByDesc(
Flight::select('arrived_at')
->whereColumn('destination_id', 'destinations.id')
->orderBy('arrived_at', 'desc')
->limit(1)
)->get();
xxxxxxxxxx
php artisan make:model Flight --migration
php artisan make:model Flight -m
xxxxxxxxxx
$model = App\Models\Flight::where('legs', '>', 100)->firstOr(function () {
// ...
});
xxxxxxxxxx
<?php
$flights = App\Models\Flight::all();
foreach ($flights as $flight) {
echo $flight->name;
}