安装
默认安装最新版本
composer create-project laravel/laravel laravel_shop
选择性版本安装
composer create-project laravel/laravel mpop 5.4.15
更新数据库
php artisan migrate
查看路由
php artisan route:list
生成 model 生成数据库迁移
php artisan make:model -m File
生成 controller
php artisan make:controller ProductController
Controller (控制器)
获取 post 的值
use Illuminate\Http\Request;
function (Request $request)
$input = $request->all();
$imsi = $request->input('imsi');
join(item 数目) leftjoin(campaign 数目)
Campaign::where('user_id',$user_id)->Join('item','campaign.id','=','item.campaign_id')->get()
输出sql语句
DB::connection()->enableQueryLog();
$data['sim-list'] = DB::table('travel_sim')->where('status',0)->paginate(15);
$log = DB::getQueryLog();
dd($log);
route(路由)
route 定义name 后,可以在controller 中调用
Route::get('/home', 'IndexController@index')->name('web.home');
return redirect()->route('web.home');
//Laravel如何判断是get还是post请求
$request->isMethod('post')
// 获取所有集合中给定键的值:
$plucked = $collection->pluck('name');
//sql 输出
DB::connection()->enableQueryLog();#开启执行日志
**************
print_r(DB::getQueryLog());
array_column — 返回数组中指定的一列
array_column($excel_data,'id');