Laravel

Laravel Database Connection : Part 13

Now Ques How to connect database in Laravel.

 

First Goto .env
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=llaravel
DB_USERNAME=root
DB_PASSWORD=

 

I am using localhost and don't have a password.  

 

See an example. Create a controller 

 

php artisan make:controller MyFirseDbController

 

 

 

<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
class MyFirseDbController extends Controller
{
function dbexm()
{
return "My Dabpage";
}
}

 

And I am creating a new view  databaseexample.blade.php.  Make a route for this page

 

use App\Http\Controllers\MyFirseDbController;
Route::get("dbexm",[MyFirseDbController::class,"dbexm"]);

 

 

Next, Include db connect in your controller

 


use Illuminate\Support\Facades\DB;

 


This is our Database Table

 

 

<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class MyFirseDbController extends Controller
{
function dbexm()
{
return DB::select("select * from example");
}
}

 

See result.

 

 

Recent Post



Related Post

subscribe to our newsletter

Get the latest news and updates by signing up to our daily newsletter.We won't sell your email or spam you !

We are always with you Contact Us | Privacy Policy | Terms and Conditions |

© 2023 DNSPACE INDIA | Developed By DNSPACEINDIA