图像 1

Laravel 基礎(二)

Response

//Route

Route::get('/blade','UserController@blade');

//Controller

public function blade()
{
$arr = ['name'=>'brian','age'=>'tel'=>'62111122'];
return view('admin.user.index',['title'=>'用戶列表',
'brian'=>$arr,
'page'=>'<a href="/1.html">1</a> <a href="/2.html">2</a> <a href="/3.html">3</a>']);
}

//view

TIME: {{date('Y-m-d')}}
字串: {{mb_substr($title,0,2)}}
<table>
<tbody>
<tr>
<td>名稱</td>
<td>{{$brian['name']}}</td>
</tr>
<tr>
<td>年齡</td>
<td>{{$brian['age']}}</td>
</tr>
<tr>
<td>電話</td>
<td>{{$brian['tel']}}</td>
</tr>
</tbody>
</table>
{!!$page!!}
Project Link

VIEW

//Route

Route::get('/layout','UserController@layout');
      Route::get('/extend','UserController@extend');
      Route::get('/proess','UserController@proess');

//Controller

    public function layout()
    {
       return view('layout.index');
    }

    public function extend()
    {
       return view('layout.extend');
    }

    public function proess()
    {
       return view('control.proess',['total'=>200,'sex'=>1, 'users' => [
           ['name'=>'Brian1', 'age'=>30], 
           ['name'=>'Brian2', 'age'=>34], 
           ['name'=>'Brian3', 'age'=>44]]]);
    }



//VIEW
//index.blade

<div>header01</div>
@section('content')
<div>content01</div>
@show
<div>footer01</div>

//extend.blade

@extends('layout.index')
@section('title','test')

@section('content')
<div>content002</div>
@endsection



//VIEW
//proess.blade

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>proess</title>
</head>


<body>
OUTOUT
@if($total >= 90 && $total <=100)
COMECOME
@elseif($total >= 80 && $total <=90)
SHOPSHOP
@else
GOGO
@endif

<hr>

<input type="radio" name="sex" value="1" @if($sex == 1) checked="checked" @endif>男
<input type="radio" name="sex" value="0" @if($sex == 0) checked="checked" @endif>女

<ul>
@foreach($users as $k=>$v)
<li>
name: {{$v['name']}}<br>
age: {{$v['age']}}<br>
</li>
<hr>
@endforeach
</ul>
</body>
</html>
DOWNLOAD
Index
Extend
Proess

DB

//正確在 env FILE 修改
// config/database.php

        'test01' => [
            'driver' => 'mysql',
            'host' => '127.0.0.1',
            'database' => 'goods',
            'username' => '',
            'password' => '',
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
        ],


//view

Route::get('/db','UserController@db');
Route::get('/builder','UserController@builder');



//Controller

    public function db()
    {
        // 查詢
    //    $res = DB::select("select * from event01 where id = ?", [2]);
    //    echo '<pre>';
    //    var_dump($res);

       //插入
      // $res = DB::insert("insert into event01 (name, age, tel, message) values('brianCC',31,232323, 'OK YOU WIN')");
    //    $res = DB::insert("insert into event01 (name, age, tel, message) values(?,?,?,?)", ['brianCC',31,232323, 'OK YOU WIN']);
    //    echo '<pre>';
    //    var_dump($res);

       //修改
    
    //   $res = DB::update("update event01 set age = '32'");
    //   echo '<pre>';
    //   var_dump($res);

        //刪除
    
        // $res = DB::delete("delete from event01 where id = 4");
        // echo '<pre>';
        // var_dump($res);

        //建立
        // $res = DB::statement("create table test (id int primary key auto_increment,name char(40))");
        // echo '<pre>';
        // var_dump($res);

//事務操作

// DB::beginTransaction();
// //扣錢
// $res = DB::update("update event01 set price = price + 2000 where id = 1");

//     $res2 = DB::update("update event01 set price = price - 2000 where id = 2");

//     if($res && $res2){
// //提交
//         DB::commit();
//     echo '提交成功';
//     }else{
//         DB::rollback();
//         echo '提交失敗';
//     }

//     echo '<pre>';
//     var_dump($res);


//另一個資料庫
$res = DB::connection('test01')->select("select * from event01 where id = ?", [2]);

    echo '<pre>';
    var_dump($res);

}

//快速使用

public function builder()
{
    $res=DB::table('event01')->insert(

        [
            'name'=>'hoki',
            'age'=>'23'
        ]);


       //多条插入
        // $res = DB::table('event01')->insert([
        //     ['username'=>'xdl-北京','password'=>'xdl','account'=>100],
        //     ['username'=>'xdl-天津','password'=>'xdl','account'=>200],
        //     ['username'=>'xdl-上海','password'=>'xdl','account'=>300]
        //     ]);

        //插入并获取id
        // $res = DB::table('event01')->insertGetId([
        //     'username'=>'xdl-深圳','password'=>'xdl','account'=>400
        //     ]);

        //更新操作
        // $res = DB::table('event01')->where('id','=',2)->update(['username'=>"兄弟连"]);

        //删除
        // $res = DB::table('event01')->where('id','<',100)->delete();

        //查询
        // 查询多条
        // $res = DB::table('event01')->get();

        //获取单条数据
        // $res = DB::table('event01')->first();

        //获取单个结果中的某个字段值
        // $res = DB::table('event01')->value('account');

        //获取结果集中的某i个字段的所有制
        // $res = DB::table('event01')->lists('username');

        //设置字段查询
        // $res = DB::table('event01')->select('username','password')->get();

        //设置where条件
        // $res = DB::table('event01')->where('username','=','xdl')->first();

        //orWhere
        // $res = DB::table('event01')->where('id','=',2)->orWhere('username','=','lampbrother')->get();

        //whereBetween
        // $res = DB::table('event01')->whereBetween('id',[5,10])->get();

        //whereIn
        // $res = DB::table('event01')->whereIn('id',[9, 11, 12])->get();


        //排序
        $res = DB::table('user')->orderBy('id','desc')->get();

        //分页操作
        $res = DB::table('user')->skip(5)->take(4)->get();

        //连接表的操作
        $res = DB::table('good_test')
            ->leftJoin('cate','cate.id','=','good_test.cid')
            ->where('good_test.gid','<',20)
            ->get();


        //运算
        // /统计
        // $res = DB::table('goods')->where('id','<',300)->count();
        //最大值
        // $res = DB::table('good_test')->max('price');
        //平均值
        // $res = DB::table('good_test')->avg('price');

        // dd（$ res）;

}
4