Laravel 8 Tutorial - Database Query Builder and CRUD Operation

In this video I will talk about what database query builder and crud operation.

TOPIC DISCUSSED:

DB Query Builder
Fetch Records From Database
Fetch Record by id
Update record
Delete record
Create Record
Controller
Routes

Your Queries -

9.How to use DB query builder in laravel 8?
10.How to create crud operation in laravel 8?

FOLLOW SURFSIDE MEDIA:

#laravel #laravel8 #laravel8x

[mdsaifulalam]

I enjoy watching your tutorials from Germany. Personally I find all your video tutorials very USEFUL for the beginners in Laravel, including clear instruction as well as helpful hints. Thank you for great contributions in it.

[ytubewiki]

Thank you from the bottom of my heart.
Thanks a lot.

[kiznyctslyer]

Great video. Now I learned how to use DB on controllers. Godbless for your YouTube career💖

[canaldoues]

Awesome! Thanks for this amazing Laravel 8 series, I am watching all the videos and coding along! Pretty helpful, cheers!

[Abhishekkumar-ffhu]

Awesome! Thanks for this amazing Laravel 8 series, I am watching all the videos and coding along! Pretty helpful,

[pauliversoncortez]

I hope you create a video of a user is logged in then you apply the CRUD. anyways thanks for this great video tutorial.

[rashiduddin]

these are so awesome lectures, can we the code written by you?

[GauravKumar-woks]

Hi Sir,

My get post by Id route is not working, and I'm not able to find the error, please help me out.

posts.blade.php
<a

web.php
Route::get('/posts/{$id}', [PostController::class, 'getPostById'])->name('post.getbyid');

PostController.php
public function getPostById($id)
{
echo "test ".$id; die;
/*$post = DB::table('posts')->where('id', $id)->first();
return view('single-post', compact('post'));*/
}

If i'm comment everything in the function getPostById, and just try to print the id. It always shows 404
NOT FOUND

Please guide me sir.

[ahadjalbani]

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'title' cannot be null (SQL: insert into `posts` (`title`, `body`) values (?, ?)) this error appear when i perform crud operation

[aniekanakpan]

hello pls am having this error (SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.) pls help.

[tonutanmoy]

can you give any solutation about this problem this videos minute after 13.24 sec
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'title' cannot be null (SQL: insert into `laravel_check` (`title`, `body`) values (?, ?))

[taranewstime]

Please kindly reply
I am facing issue after click of update button it's not redirect to "posts" table page, and try in controller, and route page
any kind of function is not working

[kehbumasama]

i followed the video strictly but still get this error"The GET method is not supported for this route. Supported methods: POST."
ill appreciate anyones help please

[Gauravkumar-jdro]

Hi Sir,

My get post by Id route is not working, and I'm not able to find the error, please help me out.

posts.blade.php
<a

web.php
Route::get('/posts/{$id}', [PostController::class, 'getPostById'])->name('post.getbyid');

PostController.php
public function getPostById($id)
{
echo "test ".$id; die;
/*$post = DB::table('posts')->where('id', $id)->first();
return view('single-post', compact('post'));*/
}

If i'm comment everything in the function getPostById, and just try to print the id. It always shows 404 NOT FOUND.

Same thing happen with delete-post also. I have 2 routes with same name and it always call the wrong one.

Route 1 Route::get('/delete-post/{id}', [ClientController::class, 'deletePost'])->name('deletepost');
Route 2 Route::get('/delete-post/{$id}', [PostController::class,

It should call the Route 2, but it calls Route 1

Please guide me sir.