路由
HTTP方法:支持http1.1中所有类型传参方式,get,post,put,delete,options,patch
Route::get($url,$callback);
路由参数:
Route::get('user/{id}',function($id){return 'userid:'.$id});
路由分组:
Route::group(['prefix'=>'admin'],function(){
Route::get('users',function(){
//"admin/users"
})
});
绑定模型:
//默认对应关系:user=>表users ,主键=>id
Route::get('api/users/{user}',function(App\user $user){ return $user->email; })
创建控制器
php artisan make:controller PostController
相关:
php artisan
php artisan help make:controller
创建路由(文章模块)
routes/web.php
//文章列表页
Route::get('/posts','\App\Http\Controllers\PostController@index');
//文章创建
Route::get('/posts/create','\App\Http\Controllers\PostController@create');
Route::post('/posts','\App\Http\Controllers\PostController@store');
//文章详情页
Route::get('/posts/{post}','\App\Http\Controllers\PostController@show');
//文章编辑
Route::get('/posts/{post}/edit','\App\Http\Controllers\PostController@edit');
Route::put('/posts/{post}','\App\Http\Controllers\PostController@update');
//文章删除
Route::get('/posts/delete','\App\Http\Controllers\PostController@delete');
创建控制器具体方法
位置:app/Http/Controllers/PostController.php
public function index(){
return view("post/index"); //模版渲染
}
public function show(){
return view("post/show");
}
public function delete(Post $post){
$post->delete();
return(redirect('posts/')); //页面跳转
}
创建模板
在 resources/views/下创建post文件夹,在其中创建对应的 *.blade.php ,eg: resources/views/post/create.blade.php
模版语法
{{}}
@if @endif
@foreach @endforeach
注:参数传递 compact
继承模型
extends 引入公共模板 @extends('layout.main')
section 进行填充 @section("content") @endsection
yield 定义填充 @yield("content")
引入视图 include(模型再细化) @include('layout.footer')
数据表
migrate ,对所有的表的操作都以日志来记录,便于协同开发
表名(名词+s)
外键(表名_键名)
时间(created_at,updated_at)
数据库迁移
创建posts表:
php artisan make:migration create_posts_table
自动创建 database/migrations/2018_09_29_072923_create_posts_table.php
Q: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))
A: app/Providers/AppServiceProvider.php boot()
use Illuminate\Support\Facades\Schema;
Schema::c(250);
自动检查sqllog并执行:
php artisan migrate
文章模块模型
ORM Laravel 的 Eloquent ORM 提供了漂亮、简洁的 ActiveRecord 实现来和数据库交互。
每个数据库表都有一个对应的「模型」用来与该表交互。你可以通过模型查询数据表中的数据,并将新记录添加到数据表中。
创建模型:
php artisan make:model Post
生成: app/Post.php //对应数据表posts,可通过 private $table = 'newtableName'; 来修改默认表名
about: php artisan help make:model
thinker 常驻进程
php artisan tinker
add:
$post = new \App\Post();
$post->title="this is post';
$post->content="this is content';
$post->save();
select:
$post->find(2); // \App\Post::find(2); 仅支持主键查找
\App:Post::where('title','zhangsan')->first();
\App:Post::where('title','zhangsan')->get();
modify
$post = \App\Post::find(2);
$post->title = 'hahazhangsan';
$post->save();
delete:
$post->delete();
修改时区(默认英国时区)
config/app.php
'timezone' => 'Asia/Shanghai', //UTC
数据填充thinker
参考:https://github.com/fzaninotto/Faker
创建工厂,目录:database/factories/ModelFactory.php
$factory->define(App\Post::class,function(Faker\Generator $faker) {
return [
'title'=>$faker->words($nb = 3, $asText = true),
'content'=>$faker->text($maxNbChars = 100)
];
});
在tinker中(新创建的工厂记得重启tinker后才可生效)
php artisan tinker
factory(App\Post::class,20)->make(); //仅显示,未真正添加至库中
factory(App\Post::class,20)->create(); //创建并写入库
分页
参考:
//$lists = Post::orderBy('created_at','desc')->get();
$lists = Post::orderBy('created_at','desc')->paginate(5);
// $lists = [['title'=>'nana'],['title'=>'nana2'],['title'=>'nana'],['title'=>'nana2'],['title'=>'nana'],['title'=>'nana2']];
{{$posts->links()}}
辅助函数
参考:https://laravel-china.org/docs/laravel/5.4/helpers/1252 ,eg:str_limit()
栗子:html原生输出:{!! str_limit($post->content,30,'...') !!}