当前位置：首页 > article >正文

laravel-数据库查询

article 2024/10/20 20:57:46

在这里插入图片描述

数据库配置

在这里插入图片描述

导入对应的DB类

在这里插入图片描述
路由

<?php

use Illuminate\Support\Facades\Route;

/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/

Route::get('/', function () {
    return view('welcome');
});
use App\Http\Controllers\Demo;
Route::get('d1',[Demo::class,'index'] );
Route::get('d2',[Demo::class,'db1'] );

控制器

<?php
namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
class Demo extends Controller{
    public function index(){
        return view("demo/list",
        ['name'=>'烟雨','addr'=>'<del>东莞</del>']
    
    
    
    );
    
    
    }
    public function db1(){
        $user = DB::select("select * from user");
        //   DB :: select  去 查询数据库  并返回查询结果  的数组
        //  也就是 $user   是一个数组  ，那我们 用 foreach  遍历   没问题
        dump($user);
        foreach ($user as $key) {
            echo"姓名：". $key->name ."<br>";
            echo"密码：". $key->password ."<br>";

            echo"年龄：". $key->age ."<br>";
            echo"地址：". $key->addr ."<br>";
            echo "<br><br><br><br>";

        }


    }


}