本文整理匯總了PHP中app\Book::whereBetween方法的典型用法代碼示例。如果您正苦於以下問題：PHP Book::whereBetween方法的具體用法？PHP Book::whereBetween怎麽用？PHP Book::whereBetween使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類app\Book的用法示例。
在下文中一共展示了Book::whereBetween方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: function
* Or
* Find all bookx with less than 200 pages AND an empty desc
*/
Route::get('complexWhere', function () {
$result = Book::where(function ($query) {
$query->where('pages_count', '>', 120)->where('title', 'LIKE', '%Book%');
})->orWhere(function ($query) {
$query->where('pages_count', '<', 200)->where('description', '=', '');
})->get();
dd($result);
});
/**
* Find books between 100 and 200 pages
*/
Route::get('whereBetween', function () {
dd(Book::whereBetween('pages_count', [100, 200])->get());
});
/**
* Find books with titles
*/
Route::get('whereIn', function () {
dd(Book::whereIn('title', ['My First Book', 'My Second Book'])->get());
});
/**
* Magic where
* Using PHP Magic methos a dynamically create where methods on table columns
* Only valid when checking equal values
*/
Route::get('magicWhere', function () {
dd(Book::wherePagesCount(230)->first());
});示例2: function
return $result;
});
Route::get('book_get_where_complex', function () {
$results = \App\Book::where('title', 'LIKE', '%ook%')->orWhere('pages_count', '>', 190)->get();
return $results;
});
Route::get('book_get_where_more_complex', function () {
$results = \App\Book::where(function ($query) {
$query->where('pages_count', '>', 120)->where('title', 'LIKE', '%Book%');
})->orWhere(function ($query) {
$query->where('pages_count', '<', 200)->orWhere('description', '=', '');
})->get();
return $results;
});
Route::get('book_get_whereBetween', function () {
$results = \App\Book::whereBetween('pages_count', [170, 200])->get();
return $results;
});
// Return all results that have title that exist in this array
Route::get('book_get_whereIn', function () {
$results = \App\Book::whereIn('title', ['My Third Book!', 'My Second Book!'])->get();
return $results;
});
// Fetching all records with the where clause in conjunction with a column Name a.k.a magic Where
Route::get('book_get_whereColumnName', function () {
$results = \App\Book::whereTitle('My Fourth Book!')->get();
return $results;
});
// Return all books that dont exist. .ie books that have the title column as NULL
Route::get('book_get_whereNull', function () {
$results = \App\Book::whereNull('title')->get();