Laravel 8 tutorial - Database configuration and Fetch Data

In this laravel 8 English video tutorial, we learn how to configure MySQL database and get data from database table English. This video is made by anil Sidhu in the English language
steps of video
What is Config database
Checkout Database
Import DB class
Fetch Data from MySQL
Interview Question
Laravel tutorial for fresher
Laravel 9

complete laravel 9 playlist

[codestepbystep]

Please support me by subscribe, like, and comment :) thank you

[kachicelestine]

Thank you sir for the nice and concise series in laravel 8.

To avoid manual importation of classes use NameSpace Resolver extention(vscode).

Other extensions (VSCode) include :-

Laravel blade snippet
Laravel snippet
Laravel spacer

[mysteriousguy]

First, thank you so much for your incredible laravel lessons.
I applied everything in this lesson but it gives me this error:
Class not found

update: I solved it. the mistake was in the lower case i in illuminate.

[ekm]

Great tutorial. Are you planning to create Yii2 course? That would be great. Thanks btw.

[upperlip]

Do you have to save your laravel project in htdocs in order to be able to use xampp (mysql)?

[tarunkumargupta]

Hello sir,
I unable to fatch the data from database using simple method [DB::select()] as well as using Modal.

[ghazalafazal]

here brother tell me 1 thing we are using normal mysql as we were using it for simple php without laravel so as we type localhost:80/dashboard opens here with laravel by typing localhost:8000 dashboard doesn't open so how to open mysql with this port localhost:8000. or just simply add a database in mysql and get access accrodingly. please make me sure on that

[ghazalafazal]

brother i try to fetch data from db but its giving error Class not found i completely follow your proceedure when i write echo "hello from controller "; it giving me the output well but when i use return DB::select("select * from signup"); it is giving above error and also this error but line no 14 is perfectly fine

[muhammadakmalbinmohdsabri]

for those who having trouble with DB make sure your php installed version in your pc is same as php version of your xampp

[smitshah]

could not find driver (SQL: select * from `student`)

can please Provide the sollution of above,

[nurulsyakira]

How to create data in database phpmyadmin like yours? What and how to create for blog project? The video already have it in database :(

[ghazalafazal]

as you answered yesterday please help me out today i got stuck in this error.

[hariprasadhari]

Use DB; instead of use Illuminate\Support\Facade\DB; in case any error occured

[kashi]

I GONT THIS ERROR PLEASE HELP ME SIR :(


SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-table' at line 1 (SQL: select * from student-table)

[ghazalafazal]

return DB::select("select * from signup");

this is line no 14

class getdbData extends Controller
{
//
function index()
{
return DB::select("select * from signup");
}
}

this is the whole function




<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use

class getdbData extends Controller
{
//
function index()
{
return DB::select("select * from signup");
}
}

there is nothing wrong in line no 14 but its giving error

[followmyjourney-kasiaadamc]

How can I set up phpMyAdmin before following this tutorial?

[dhruvishsorathiya]

data is not inserted in this video series

[simransharma]

I am not getting the data
In my output screen shows this bracket
[ ]

[singhkamalpreet]

How can we connect Oracle Database with Laravel?

[santhoshkumar-sfbc]

bro.. you didn't take model to get data. directly used Facades.