Query Multiple Count Eloquent Laravel

omahkoding.com – Laravel merupakan framework php yang sangat populer, kali ini saya akan membagikan cara membuat query multiple count di eloquent laravel.

Query Multiple Count menggunakan eloquent di laravel

$date = new DateTime('tomorrow -1 week');

$days = Object::where('objecttime', '>', $date)
    ->group_by('date')
    ->order_by('date', 'DESC') // or ASC
    ->get(array(
        DB::raw('DATE(`objecttime`) AS `date`'),
        DB::raw('COUNT(*) as `count`')
    ));

foreach ($days as $day) {
    print($day->date . ' - '. $day->count);
}

$date = new DateTime('tomorrow -1 week');

$days = Object::where('objecttime', '>', $date)

->group_by('date')

->order_by('date', 'DESC') // or ASC

->get(array(

DB::raw('DATE(`objecttime`) AS `date`'),

DB::raw('COUNT(*) as `count`')

));

foreach ($days as $day) {

print($day->date . ' - '. $day->count);

}

Hasilnya :

Baca artikel lainya di omahkoding.com | tempat belajar koding pertama di Kota Semarang dan Sekitarnya, dan ikuti media social kamu @Omahkoding

Query Multiple Count Eloquent Laravel

Tags: kursus koding, kursus laravel jogja, laravel, omah koding

Artikel Terkait :

Cara Install Laravel 9 di Ubuntu

Apa Fungsi Laravel, saya jelasin disini

Cara Membuat Tombol Sebelumnya dengan Php

Cara Menghapus Package di Laravel Menggunakan Composer

Cara Membuat Query dengan substr di Eloquent Laravel