第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

模型名稱、類名必須一致；否則報錯；提示找不到

控制器中調(diào)用語法為：模型名稱：：方法名稱（）；

新建數(shù)據(jù)表

學生表

CREATE TABLE IF NOT EXISTS student(
????`id` INT AUTO_INCREMENT PRIMARY KEY,
????`name` VARCHAR(255) NOT NULL DEFAULT " COMMENT '姓名',
????`age` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '年齡',
????`sex` TINYINT UNSIGNED NOT NULL DEFAULT 10 COMMENT '性別',
????`created_at` INT NOT NULL DEFAULT 0 COMMENT '新增時間',
????`updated_at` INT NOT NULL DEFAULT 0 COMMENT '修改時間',

)ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1001 COMMENT='學生表';

一、路由簡介：
????????????????????·將用戶的請求轉發(fā)給相應的程序進行處理
????????????????????·作用就是建立url和程序之間的映射
????????????????????·請求類型get , post , put , patch , delete

二、基本路由：app -> Http -> routes
基礎範例1：

基礎範例2：
多請求範例：

路由參數(shù)範例：

MVC位置

Controller: app -> Http -> controller

View: resources -> view

MVC(Model View Controller)

Model: 應用程序中用於處理應用程序數(shù)據(jù)邏輯的部分，通常在數(shù)據(jù)庫中存取數(shù)據(jù)

View: 應用程序中處理數(shù)據(jù)顯示的部分

Controller: 應用程序中處理用戶交互的部分
????????????????1. 從Model中獲取數(shù)據(jù)，並輸入到View中
????????????????2. 接收View中的用戶操作，然後作出相應的響應

laravel使用chunk 分段查詢數(shù)據(jù) 前面要加上orderBy 排序

查詢構造器的使用

<?php

namespace?App\Http\Controllers;

use?Illuminate\Support\Facades\DB;
use?phpDocumentor\Reflection\DocBlock\Tags\Var_;

class?StudentController?extends?Controller
{
????public?function?test1()
????{
//????????$students?=?DB::select('select?*?from?student');
//????????var_dump($students);
????????//新增
//????????$bool?=?DB::insert('insert?into?student(name,age)?values(?,?)',?['hanmeimei',?17]);
//????????var_dump($bool);
????????//修改
//????????$num?=?DB::update('update?student?set?age=??where?name=?',[20,?'lee']);
//????????var_dump($num);
????????//查詢
????????$students?=?DB::select('select?*?from?student?where?id>?',?[1002]);
????????dd($students);
????}

????//查詢構造器增加數(shù)據(jù)
????public?function?query1()
????{
????????//查詢控制器
//????????$bool?=?DB::table('student')->insert(['name'?=>?'mac',?'age'?=>?23]);
//????????var_dump($bool);

//????????$num?=?DB::table('student')->insertGetId(['name'=>'cai',?'age'=>22]);
//????????var_dump($num);

????????$bool?=?DB::table('student')->insert([
????????????['name'?=>?'nam1',?'age'?=>?24],
????????????['name'?=>?'name2',?'age'?=>?25]
????????]);
????????var_dump($bool);
????}

????//查詢構造器更新數(shù)據(jù)
????public?function?query2()
????{
//????????$num?=?DB::table('student')->where(['id'?=>?1001])->update(['name'?=>?'coco',?'age'?=>?30]);
//????????var_dump($num);
????????//全表age+3?自增
//????????$num?=?DB::table('student')->increment('age',3);
//????????var_dump($num);
????????//全表age-3?自減
????????$num?=?DB::table('student')->decrement('age',?3);
????????var_dump($num);
????}

????//查詢構造器刪除數(shù)據(jù)
????public?function?query3()
????{
????????$num?=?DB::table('student')->where('id',?15)->delete();
????????var_dump($num);
//????????$num?=?DB::table('student')->where('id','>=',13)->delete();
//????????var_dump($num);
????????//一鍵清空數(shù)據(jù)
//????????DB::table('student')->truncate();

????}

????public?function?query4()
????{
????????//get()
//????????$students?=?DB::table('student')->get();
//????????var_dump($students);

????????//first()
//????????$student?=?DB::table('student')->orderBy('id','desc')->first();
//????????dd($student);

????????//where()
//????????$students?=?DB::table('student')->where('id','>=',1002)->get();
//????????dd($students);
????????//where()多條件
//????????$students?=?DB::table('student')->whereRaw('id?>=???and?age?>=??',?[1001,?'25'])->get();
//????????dd($students);
????????//pluck
//????????$names?=?DB::table('student')->pluck('name');
//????????dd($names);
????????//select
//????????$students?=?DB::table('student')->select('id','name','age')->get();
//????????dd($students);
????????//chunk(定義一次查幾條數(shù)據(jù))
????????echo?'<pre>';
????????DB::table('student')->orderBy('id')->chunk(1000,?function?($students)?{
????????????var_dump($students);
????????});

????}
????//聚合函數(shù)
????public?function?query5()
????{
????????//count()
//????????$num?=?DB::table('student')->count();
//????????var_dump($num);
????????//max()
//????????$max?=?DB::table('student')->max('age');
//????????var_dump($max);
????????//min()
//????????$min?=?DB::table('student')->min('age');
//????????var_dump($min);
????????//avg()
//????????$avg?=?DB::table('student')->avg('age');
//????????var_dump($avg);
????????//sum()
????????$num?=?DB::table('student')->sum('age');
????????var_dump($num);
????}
}

創(chuàng)建學生表

CREATE?TABLE?IF?NOT?EXISTS?student(	`id`?INT?AUTO_INCREMENT?PRIMARY?KEY,	`name`?VARCHAR(255)?NOT?NULL?DEFAULT?''?COMMENT?'姓名',	`age`?TINYINT?UNSIGNED?NOT?NULL?DEFAULT?0?COMMENT?'年齡',	`sex`?TINYINT?UNSIGNED?NOT?NULL?DEFAULT?10?COMMENT?'性別',	`created_at`?INT?NOT?NULL?DEFAULT?0?COMMENT?'新增時間',	`updated_at`?INT?NOT?NULL?DEFAULT?0?COMMENT?'修改時間')ENGINE=InnoDB?DEFAULT?CHARSET=UTF8?AUTO_INCREMENT=1001?COMMENT?'學生表';

使用DB facade實現(xiàn)CURD

//StudentController.php
<?php

namespace?App\Http\Controllers;

use?Illuminate\Support\Facades\DB;

class?StudentController?extends?Controller
{
????public?function?test1()
????{
//????????$students?=?DB::select('select?*?from?student');
//????????var_dump($students);
????????//新增
//????????$bool?=?DB::insert('insert?into?student(name,age)?values(?,?)',?['hanmeimei',?17]);
//????????var_dump($bool);
????????//修改
//????????$num?=?DB::update('update?student?set?age=??where?name=?',[20,?'lee']);
//????????var_dump($num);
????????//查詢
????????$students?=?DB::select('select?*?from?student?where?id>?',?[1002]);
????????dd($students);
????}
}

模型

//member.php
name?space?App;
use?Illuminate\Database\Eloquent\Model;
class?Member?extends?Model{
????public?static?function?getMember(){
????????retrun?'member?name?is?june';
????}
}

//控制器調(diào)用模型
//MemberController.php
namespace?App\Htpp\Controllers;
class?MemberController?extends?Controller{
????public?function?info($id){
????????Member::getMember();
????}
}

視圖

一般創(chuàng)建一個控制器，就在view文件夾下創(chuàng)建一個控制器文件夾

//view-member-創(chuàng)建視圖文件?info.blade.php
//info.blade.php
member/info?blade
{{name}}


//MemberController.php
namespace?App\Http\Controllers;
class?MemberController?extends?Controller{
????public?function?info($id){
????????retrun?view('member/info',[
????????????'name'?=>?'Junexiang'????????????????????
????????]);
????}
}

控制器

創(chuàng)建MemberController.php

<?php
name?space?App\Http\Controllers;
Class?MemberController?extends?Controller{
????public?function?info(){
????????return?'member-info';
????}
}

路由和控制器關聯(lián)

Rount::get('member/info',?'MemberController@info');
//或者
Rount::get('member/info',?['uses'?=>?'MemberController@info']);

別名

Rount::any('member/info',?[
????'uses'?=>?'MemberController@info',
????'as'?=>?'memberinfo'
]);

參數(shù)綁定

Rount::get('member/{id}',?['uses'?=>?'MemberController@info'])->where('id','[0-9]+');

//MemberController.php
namespace?App\Http\Controllers;
Class?MemberController?extends?Controller{
????public?function?info($id){
????????return?'member-info-id-'?.?$id;
????}
}

路由篇

get請求

Rount::get('/',?function(){
????return?'Hello?World';
});

match 指定多種請求方式

Rount::match(['get','post'],'muly',function(){
????return?'multy';
});

路由參數(shù)

Rount::get('user/{id}',?function($id){
????return?'User-id-'?.?$id;
});

Rount::get('user/{name?}',?function($name?=?'sean'){
????return?'User-name'.?$name;
})->where('name',?'[A-Za-z]+');

路由別名

Rount::get('user/member-center',?['as'?=>?'center',?function(){
????return?'member-center';
}]);

路由群組

Rount::group(['prefix'?=>?'member'],?function(){
????Rount::get('user/member-center',?['as'?=>?'center',?function(){
????????return?'member-center';
????}]);
????Rount::get('user/{name?}',?function($name?=?'sean'){
????????return?'User-name'.?$name;
????})->where('name',?'[A-Za-z]+');
});

輸出視圖

Rount::get('/',?function(){
????return?view('index')
});

//路由別名

路由別名，

Route::get('user/');

路由群組

路由別名，

Route::get('user/');

路由群組

路由中輸出視圖