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