Level 3
Basically want to know how to add variable to the raw insert query instead of specifying values?
Dec 7, 2019
6
Level 3
Raw SQL query and binding data?
create.blade.php
First Name Last Name SAVEcontroller >
Route::POST('/form-filled', 'PagesController@store');
& then my store function is:
DB::insert('insert into projects (title, description) values (?, ?)', ['Dynamic' 'some stuff about stuff']);
I can get my form values as follows in my store function:
$title = request('title'); $description = request('description');
How do I use the $title and $description variables into the query?
Level 70
What if you try this?
public function store(Request $request){
$title = $request->title;
$description = $request->description;
\DB::insert('insert into projects (title, description) values (?, ?)', [$title, $description]);
}
2 likes
Level 3
That has worked. Thank You :)
Level 3
How do I update?
DB::update('update Books set (book_name, isbn_no, book_price) value (?,?,?)', [$book_name, $isbn_no, $book_price],' where id = ?' [$id]);
Level 3
Nevermind, I figured it out, just posting as may help someone else.
DB::update('update Books set book_name = ? , isbn_no = ?, book_price = ? where id = ?', [$book_name , $isbn_no , $book_price, $id]);
Level 8
Why exactly aren't you using Eloquent for that? There'S really no need to write the sql yourself with laravel. Hope you noticed that in the last month, since you started the discussion.
Please or to participate in this conversation.