欧美野外疯狂做受xxxx高潮,brazzersvideosex欧美高清

首頁(yè) > 博客列表 > laravel框架的數(shù)據(jù)增查改刪mvc

博主信息

博文 52

粉絲 0

評(píng)論 3

訪問(wèn)量 53135

專題推薦

更多>

相關(guān)推薦

熱門教程

更多>

相關(guān)教程

首先設(shè)置數(shù)據(jù)庫(kù)

找到數(shù)據(jù)庫(kù)文件 .env

第9行到14行

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=php
DB_USERNAME=root
DB_PASSWORD=123456

修改成自己的數(shù)據(jù)庫(kù)賬戶

創(chuàng)建控制器 Home.php

在app/Http/Controllers 目錄下創(chuàng)建控制器
可以用命令行的方式創(chuàng)建也可以新建文件的方式創(chuàng)建

控制器代碼：

 <?php
namespace App\Http\Controllers;
use DB;
class Home extends Controller{
    // 數(shù)據(jù)庫(kù)查詢
    public function get(){
        echo '<pre>';
        $res = DB::select('select * from users');
        print_r($res);
    }
    //數(shù)據(jù)庫(kù)更新
    public function gxupdata(){
        $res = DB::update('update users set name="我知道，最好的語(yǔ)言：php25歲了" where id=4');
        var_dump($res);
    }
    //數(shù)據(jù)庫(kù)新增
    public function xzupdata(){
        $res = DB::insert('insert users(`name`,`email`,`password`)values("mignzi","ad@s.com","aginogsg")');
        var_dump($res);
    }
    //刪除數(shù)據(jù)
    public function delete(){
        $res = DB::delete("delete from users where id=2");
        var_dump($res);
    }
    public function index(){
        // 加載v視圖文件
        $res = DB::select('SELECT * FROM `jizhang`');
        $lists = [];
        foreach ($res as $val){
            $lists[] = (array)$val;
        }
        $data['result'] = $lists;
        // print_r($val);
        return view('v', $data);
    }
}

設(shè)置路由

路徑public/routes/web.php

路由代碼：

<?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('v');
    // echo date('Y-m-d h:i:s');
});
Route::get('/article/p/aaa', function () {
    // return view('v');
    echo date('Y-m-d h:i:s');
});
Route::get('home/index','Home@index');
Route::get('/db','Home@get');
Route::get('/dbgx','Home@gxupdata');
Route::get('/dbxz','Home@zxupdata');
Route::get('/dbsc','Home@delete');

添加視圖文件

路徑public/resources/views/v.blade.php

文件代碼：

<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>數(shù)據(jù)庫(kù)操作</title>
    <link rel="stylesheet" type="text/css" href="/layui/css/layui.css">
    <script src="layui/layui.js"></script>
</head>
<body>
<table class="layui-table">
    <thead>
        <tr>
            <td>ID</td>
            <td>金額</td>
            <td>賬戶</td>
            <td>成員</td>
            <td>備注</td>
            <td>成員id</td>
        </tr>
    </thead>
    <tbody>
    <?php foreach ($result as $val): ?>
        <tr>
            <td><?php echo $val['id']; ?></td>
            <td><?php echo $val['jine']; ?></td>
            <td><?php echo $val['zhanghu']; ?></td>
            <td><?php echo $val['chengyuan']; ?></td>
            <td><?php echo $val['beizhu']; ?></td>
            <td><?php echo $val['yonghuid']; ?></td>
        </tr>
    <?php endforeach; ?>
    </tbody>
</table>
</body>
</html>