本文整理汇总了PHP中app\Book::whereNull方法的典型用法代码示例。如果您正苦于以下问题:PHP Book::whereNull方法的具体用法?PHP Book::whereNull怎么用?PHP Book::whereNull使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类app\Book
的用法示例。
在下文中一共展示了Book::whereNull方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getList
/**
* @return \Illuminate\View\View
*/
public function getList()
{
$currentUser = \Auth::user();
$userBooks = $currentUser->books;
$freeBooks = Book::whereNull('user_id')->paginate(10);
return view('books', ['userBooks' => $userBooks, 'freeBooks' => $freeBooks]);
}
示例2: 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();
return $results;
});
/**
* AGGREGATES
*/
// Get the number of books in the database
Route::get('book_get_books_count', function () {
$booksCount = \App\Book::count();
return $booksCount;
});
// Get the number of books that have page count greater than 140
Route::get('book_get_bookPages_count', function () {
$booksCount = \App\Book::where('pages_count', '>', 140)->count();
return $booksCount;
});