![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
laravel
江江江I
雨一直下
展开
-
Laravel with 多表查询条件筛选(按从表查询)
例如以下表:菜品表: foods字段说明id主键title菜品名称.....菜品规格表: foods_specs字段说明id主键title规格名称foods_id菜品表IDprice价格.....省略菜品模型: FoodsModelclass FoodsModel extends Model{ // 省略 /** *...原创 2021-01-15 08:44:48 · 2403 阅读 · 0 评论 -
with
imageUsersInfos=images::with(′imageable′=>function(imageUsersInfos = images::with('imageable' => function(imageUsersInfos=images::with(′imageable′=>function(q){$q->select(‘id’,‘phone’);})->where(‘imageable_type’, ‘App\User’)->get();查询一原创 2021-01-05 10:16:44 · 70 阅读 · 0 评论 -
groupBy
$list=DB::connection('sqlsrv')->table('user')->groupBy("Site_CN")->select('Site_CN')->get();原创 2021-01-04 14:50:18 · 58 阅读 · 0 评论 -
laravel查询排序
orderBy(‘created_at’,‘desc’)原创 2021-01-04 10:05:59 · 1193 阅读 · 0 评论 -
Laravel 条件数组 in 的用法
$where = [ ['status', '=', 1], ['name' , '>', 1] ];$ids = [1,2,3];$where[] = [function($query) use ($ids){ $query->whereIn('id', $ids);}];$list = User::where($where) ->get();原创 2020-12-31 11:32:15 · 1082 阅读 · 0 评论 -
Maatwebsite / Laravel-Excel 3.1(只适用3.1以上)
1.安装composer require maatwebsite/excel2.该Maatwebsite\Excel\ExcelServiceProvider是自动发现,并在默认情况下注册,但如果你想自己注册它:添加 ServiceProvider config/app.php‘providers’ => [/** Package Service Providers…*/Maatwebsite\Excel\ExcelServiceProvider::class,]3.添加 Fa原创 2020-12-30 14:40:30 · 390 阅读 · 0 评论 -
laravel excel 导出导入
laravel-excel教程手册链接laravel-excel Github链接原创 2020-12-30 09:25:50 · 79 阅读 · 0 评论 -
Composer提示:Installation failed, reverting ./composer.json to its original content.错误的解决办法
composer dump-autoloadcomposer update原创 2020-12-29 21:16:19 · 1546 阅读 · 0 评论 -
Class ‘Illuminate\Foundation\Application‘ not found Laravel
omposer update --no-scripts原创 2020-12-29 20:53:02 · 870 阅读 · 1 评论 -
Laravel 大数据量分块处理
DB::connection('sqlsrv')->table('表名')->select(array('字段1','字段2')) ->chunkById(100, function ($reslut) { var_dum($reslut); },'查询排序id');原创 2020-12-28 14:25:13 · 396 阅读 · 0 评论 -
laravel配置sqlsrv
1。在 config 下 database.php 里添加以下代码 'sqlsrv' => [ 'driver' => 'sqlsrv', 'url' => env('DATABASE_URL'), 'host' => env('DB_HOST_SRV', 'localhost'), 'port' => env('DB_PORT_SRV', '1433'), 'database' =>原创 2020-12-28 14:19:51 · 654 阅读 · 0 评论 -
Laravel自定义error log
1.config\logging.php2. ‘errorlog_test’ => [‘driver’ => ‘daily’,‘path’ => storage_path(‘logs/errorlog_test.log’),‘level’ => ‘debug’,‘days’ => 14,],3.调用方式Log::channel(‘errorlog_test’)->info(‘test’);...原创 2020-12-28 10:33:34 · 398 阅读 · 0 评论 -
laravel 时区设置差8个小时解决办法
根目录下的config目录下的app.php文件中时区修改成中国时区‘timezone’ => ‘UTC’,改成‘timezone’ => ‘PRC’,原创 2020-12-23 13:15:26 · 1947 阅读 · 2 评论 -
laravel 写log
leravel 写log1.use Log;2. log::info(‘内容’);写入的文件地址:项目\storage\logs原创 2020-12-23 08:42:35 · 239 阅读 · 2 评论