Level 3
The DB::update query needs sorting so that I can update the values where id = $id;
Dec 7, 2019
11
Level 3
DB::update query
I am trying to use the query using the valided values, $book_name, $isbn_no & $book_price and ofcourse the $Id but the query doesn't work.
public function update(Request $request, $id) {
$validatedData = $request->validate([
'book_name' => 'required|max:255',
'isbn_no' => 'required|alpha_num',
'book_price' => 'required|numeric',
]);
$book_name = $validatedData['book_name']; $isbn_no = $validatedData['isbn_no']; $book_price = $validatedData['book_price'];
DB::update('update Books (book_name, isbn_no, book_price) value (?,?,?), [$book_name, $isbn_no, $book_price] where id = $id');
return redirect('/books')->with('success', 'Book is successfully updated'); }
Level 73
What about:
DB::table('Books')->where('id', $id)->update($validatedData);
Level 3
Thanks, but I dont want to do it that way, I want to get better at SQL querying so don't want to use eloquent.
Level 73
I use the query builder above, not Eloquent. Eloquent is if you use models.
Level 73
@c3422867 you can use this then:
DB::update('update Books (book_name, isbn_no, book_price) value (?,?,?) where id = ?', [$book_name, $isbn_no, $book_price, $id]);
This is not a good way to learn SQL btw :)
Level 3
Thank You :)
Level 75
@nakov see https://laracasts.com/discuss/channels/general-discussion/raw-sql-query-and-binding-data
@c3422867 got it. Makes me feel good when someone puts the effort in trying and a little studying docs examples.
Way to go @c3422867
Level 3
Whats the best way to learn?
Level 75
If you are new also to sql see: http://www.mysqltutorial.org/
See the free videos here on laracasts
Work examples in the docs.
Try first, if stuck post a question with code.
Level 73
Level 3
haha thanks, I saw something on stackoverflow, figured it out and then came back to post by which time @nakov provided his answer which is writtens slightly differently to my one but both work the same :)
Please or to participate in this conversation.