1、php artisan 查看命令列表
2、php artisan make:controller ArticleController 命令 创建控制器
3、创建数据库迁移表
创建文章表
php artisan make:migration create_articles_table
Schema::create('articles', function (Blueprint $table) {
$table->increments('id');
$table->string('title',100)->default('');
$table->text('content');
$table->integer('user_id')->default(0);
$table->timestamps();
});
开始迁移 如果migration表里面有 就执行迁移没有的
php artisan migrate
如果报错 去config/database utf8mb4改为utf8
4、php artisan make:model Article
Article 模块
// 默认对应articles表
class Article extends Model
{
//
protected $table = "article";
}
5、tinker php artisan tinker
设置时区
config app.php
'timezone' => 'UTC'
添加
$art = new \App\Article()
$art->title = "this is title"
$art->content = "this is content"
$art->save()
查看 通过id where
\App\Article::find(2)
\App\Article::where('title','gg')->first()
/*先查找 在修改*/
$art->title = 'gg2'
$art->save()
$art = \App\Article::find(2)
$art->delete()
\App\Article::where('title','gg')->get()
public function list() {
//模型查找
$art = \App\Article::orderBy('created_at', 'desc')->get();
return response()->json(['status'=>1,'msg'=>'success','data'=>$art]);
}