In php 7.2+ you can’t use count on the relation object, so there’s no one-fits-all method for all relations. Use query method instead as @tremby provided below: $model->relation()->exists() generic solution working on all the relation types (pre php 7.2): if (count($model->relation)) { // exists } This will work for every relation since dynamic properties return … Read more
When using ->get() you cannot simply use any of the below: if (empty($result)) { } if (!$result) { } if ($result) { } Because if you dd($result); you’ll notice an instance of Illuminate\Support\Collection is always returned, even when there are no results. Essentially what you’re checking is $a = new stdClass; if ($a) { … … Read more
It is really easy to do a bulk insert in Laravel using Eloquent or the query builder. You can use the following approach. $data = [ [‘user_id’=>’Coder 1’, ‘subject_id’=> 4096], [‘user_id’=>’Coder 2’, ‘subject_id’=> 2048], //… ]; Model::insert($data); // Eloquent approach DB::table(‘table’)->insert($data); // Query Builder approach In your case you already have the data within the … Read more
In addition to @delmadord’s answer and your comments: Currently there is no method to create subquery in FROM clause, so you need to manually use raw statement, then, if necessary, you will merge all the bindings: $sub = Abc::where(..)->groupBy(..); // Eloquent Builder instance $count = DB::table( DB::raw(“({$sub->toSql()}) as sub”) ) ->mergeBindings($sub->getQuery()) // you need to … Read more
This is working for me: $user_info = DB::table(‘usermetas’) ->select(‘browser’, DB::raw(‘count(*) as total’)) ->groupBy(‘browser’) ->get();
Add it in two steps, and it’s good to make it unsigned too: public function up() { Schema::create(‘priorities’, function($table) { $table->increments(‘id’, true); $table->integer(‘user_id’)->unsigned(); $table->string(‘priority_name’); $table->smallInteger(‘rank’); $table->text(‘class’); $table->timestamps(‘timecreated’); }); Schema::table(‘priorities’, function($table) { $table->foreign(‘user_id’)->references(‘id’)->on(‘users’); }); }
Make use of Logical Grouping (Laravel 7.x/4.2). For your example, it’d be something like this: Model::where(function ($query) { $query->where(‘a’, ‘=’, 1) ->orWhere(‘b’, ‘=’, 1); })->where(function ($query) { $query->where(‘c’, ‘=’, 1) ->orWhere(‘d’, ‘=’, 1); });
Consider this code: Products::whereIn(‘id’, function($query){ $query->select(‘paper_type_id’) ->from(with(new ProductCategory)->getTable()) ->whereIn(‘category_id’, [‘223′, ’15’]) ->where(‘active’, 1); })->get();
You can just use Eloquent::insert(). For example: $data = [ [‘name’=>’Coder 1’, ‘rep’=>’4096’], [‘name’=>’Coder 2’, ‘rep’=>’2048’], //… ]; Coder::insert($data);
With with() is for eager loading. That basically means, along the main model, Laravel will preload the relationship(s) you specify. This is especially helpful if you have a collection of models and you want to load a relation for all of them. Because with eager loading you run only one additional DB query instead of … Read more