创建model:php artisan make:model privilegeModel(名字随便写,可以不加Model)
控制器层加载model
<?php namespace App\Http\Controllers\Admin; //注意命名空间 use App\Http\Controllers\Controller; use app\privilegeModel; function index(){ $model=new \App\PrivilegeModel(); //实例化model $data = $model -> getlist(); //调用model层中方法 }
Model层
<?php namespace App; use Illuminate\Database\Eloquent\Model; use DB; class privilegeModel extends Model { /** * 查询友情链接 */ public function getlist() { return DB::table('tablename')->get(); } }