PHP Book::where方法代码示例

 public function updateNewBook()
 {
     $book = Book::where('ID', '=', Input::get("id"))->get();
     $book->Inhalt = Input::get("inhalt");
     $book->save();
     return View::make('updateNew');
 }

 function update()
 {
     $params = $this->input->post();
     $obj = new Book();
     $obj->where('id', $params['id'])->update($params);
     echo $obj->check_last_query();
 }

 /**
  * Searches and returns any books added in the last 24 hours
  *
  * @return Collection
  */
 public static function getBooksAddedInTheLast24Hours()
 {
     # Timestamp of 24 hours ago
     $past_24_hours = strtotime('-1 day');
     # Convert to MySQL timestamp
     $past_24_hours = date('Y-m-d H:i:s', $past_24_hours);
     $books = Book::where('created_at', '>', $past_24_hours)->get();
     return $books;
 }

 public function delete($id)
 {
     $exist = Book::where('id', $id)->count();
     if ($exist == 0) {
         Session::put('msgfail', 'Failed to delete book.');
         return Redirect::back()->withInput();
     }
     $book = Book::find($id);
     unlink(public_path() . "/uploads/book/" . $book->file);
     Book::where('id', $id)->delete();
     Session::put('msgsuccess', 'Successfully deleted book.');
     return Redirect::back();
 }

 public function getSearchBooks($key)
 {
     if (isset($key)) {
         $books = Book::where('name', 'like', '%' . $key . '%')->get();
         if (isset($books)) {
             return json_encode(array('message' => 'found', 'books' => $books->toArray()));
         } else {
             return json_encode(array('message' => 'empty'));
         }
     } else {
         return json_encode(array('message' => 'invalid'));
     }
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function show($id)
 {
     $product = Product::find($id)->toArray();
     $additional = null;
     if ($product['category'] == 'laptop') {
         $additional = Laptop::where('id_product', $id)->first()->toArray();
     } elseif ($product['category'] == 'book') {
         $additional = Book::where('id_product', $id)->first()->toArray();
     }
     $product = array_merge($product, $additional);
     $head = array('title' => $product['name']);
     $data = array('head' => $head, 'product' => $product);
     return view('product.show', $data);
 }

 public function postAdd()
 {
     $rules = array('isbn' => 'required|size:13', 'title' => 'required|min:3', 'author' => 'required|alpha', 'category' => 'required', 'publishing_house' => 'required', 'page_no' => 'required|numeric', 'publishing_year' => 'required|max:4');
     $validator = Validator::make(Input::all(), $rules);
     if ($validator->passes()) {
         //all fields are set
         $isbn = Input::get('isbn');
         //check if isbn exists in the books table
         $_test = Book::where('isbn', '=', $isbn)->first();
         if ($_test != null) {
             //the book is in the books table, just add him for this user
             $mybook = new LibraryBooks();
             $mybook->user_id = Auth::user()->id;
             $mybook->book_isbn = $isbn;
             $mybook->copies_no = 1;
             //TODO: change this
             $mybook->save();
             return "This book was saved on library_books";
         } else {
             //the book doesn't exist in the books table
             //add it there then add it to the user
             $mybook = new Book();
             $mybook->author = Input::get('author');
             $mybook->category = Input::get('category');
             $mybook->isbn = $isbn;
             $mybook->page_no = Input::get('page_no');
             $mybook->publishing_house = Input::get('publishing_house');
             $mybook->publishing_year = Input::get('publishing_year');
             $mybook->title = Input::get('title');
             $mybook->save();
             //now that the book was added to books
             //add him to the user
             $new_book = new LibraryBooks();
             $new_book->user_id = Auth::user()->id;
             $new_book->book_isbn = $isbn;
             $new_book->copies_no = 1;
             //TODO: change this
             $new_book->save();
             return "This was stored to books with id " . $mybook->id;
         }
     } else {
         return Redirect::to('/api/v1/add')->withErrors($validator);
     }
 }

 public function testDoubleSaveOneToMany()
 {
     $author = User::create(array('name' => 'George R. R. Martin'));
     $book = Book::create(array('title' => 'A Game of Thrones'));
     $author->books()->save($book);
     $author->books()->save($book);
     $author->save();
     $this->assertEquals(1, $author->books()->count());
     $this->assertEquals($author->_id, $book->author_id);
     $author = User::where('name', 'George R. R. Martin')->first();
     $book = Book::where('title', 'A Game of Thrones')->first();
     $this->assertEquals(1, $author->books()->count());
     $this->assertEquals($author->_id, $book->author_id);
     $author->books()->save($book);
     $author->books()->save($book);
     $author->save();
     $this->assertEquals(1, $author->books()->count());
     $this->assertEquals($author->_id, $book->author_id);
 }

 public function showPrivate($sl)
 {
     $chapter = Chapter::where('secret_link', '=', $sl)->first();
     if ($chapter->public_state == true && Book::where('id', '=', $chapter->book_id)->first()->public_state == true) {
         return Redirect::to('/chapter/' . $chapter->slug);
     }
     $markdownParser = new MarkdownParser();
     $markdownText = $markdownParser->transformMarkdown($chapter->text);
     return View::make('chapter.single', array('chapter' => $chapter, 'chapter_text' => $markdownText, 'pageTitle' => 'Chapter: ' . $chapter->title));
 }

 public function myprofile()
 {
     $_action = 'myprofile';
     $_viewtype = 'traveler/self';
     $_viewdata = array('env' => $this->_env, 'action' => $_action);
     if (!Auth::check()) {
         return Redirect::to('home/');
     } else {
         $_viewdata['books'] = Book::where('traveler_id', '=', Auth::user()->id)->get();
     }
     return View::make($_viewtype, $_viewdata);
 }

 public function getDeleteBook($id)
 {
     $book = Book::where('id', '=', $id)->first();
     if ($book) {
         $book->delete();
         return Redirect::to('/browse-books')->with('flash_message', 'Delete successfuly!');
     } else {
         return Redirect::to('/browse-books')->with('flash_message', 'Delete failed! Try again...!');
     }
 }

 public function queryWithOrder()
 {
     $books = Book::where('published', '>', 1950)->orderBy('title', 'desc')->get();
     Book::pretty_debug($books);
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function show($id)
 {
     $book = Book::where('id', '=', $id)->orWhere('slug', '=', $id)->first();
     $chapters = Chapter::where('book_id', '=', $book->id)->where('public_state', '=', true)->paginate(15);
     if ($book) {
         if ($book->public_state == true) {
             return View::make('book.single', array('book' => $book, 'chapters' => $chapters, 'pageTitle' => 'Book: ' . $book->title));
         } elseif (Sentry::Check() && $book->author_id == Sentry::getUser()->id) {
             return View::make('book.single', array('book' => $book, 'chapters' => $chapters, 'pageTitle' => 'Book: ' . $book->title));
         } else {
             return Redirect::to('/')->with('global_error', 'You can\'t access private resources without a secret link, which can be received from creation\'s author.');
         }
     }
     return Redirect::to('/')->with('global_error', 'Sorry, book you are trying to reach doesn\'t exist.');
 }

<?php

Route::get('/books', function () {
    $books = DB::table('books')->paginate(10);
    return View::make('management')->with('books', $books);
});
Route::get('/books/edit/{id}', function ($id) {
    $exist = Book::where('id', $id)->count();
    if ($exist == 0) {
        Session::put('msgfail', 'Failed to edit book.');
        return Redirect::back()->withInput();
    }
    $book = Book::find($id);
    return View::make('edit_books')->with('book', $book);
});
Route::post('/books/edit/{id}', array('uses' => 'BookController@edit'));
Route::post('/books', array('uses' => 'BookController@add', 'as' => 'books'));
Route::get('/books/delete/{id}', array('uses' => 'BookController@delete'));

 public function getBooks($id)
 {
     if (isset($id)) {
         $books = Book::where('course_id', $id)->get();
         if (isset($books)) {
             return json_encode(array('message' => 'found', 'books' => $books->toArray()));
         } else {
             return json_encode(array('message' => 'empty'));
         }
     } else {
         return json_encode(array('message' => 'invalid'));
     }
 }