Laravel 5.3 : Array Push Error

Question

I want parse data with json in laravel 5.3 but i got message

Undefined property: Illuminate\Support\Collection::$bulan

   public function chart()
    {
      $bulan = [];
      $jumlah = [];
      $data[] = DB::table('data_peminjaman')
                    ->select(DB::raw("DATE_FORMAT(created_at,'%Y') as tahun ,DATE_FORMAT(created_at,'%M') as bulan,COUNT(*) as jumlahdata, DATE_FORMAT(created_at,'%m') as b"))
                    ->groupBy(DB::raw("DATE_FORMAT(created_at,'%M'),DATE_FORMAT(created_at,'%Y'),DATE_FORMAT(created_at,'%m')"))
                    ->orderBy('tahun')
                    ->orderBy('b')
                    ->get();
      foreach ($data as $key ) {
        array_push($bulan, $key->bulan);
        array_push($jumlah, $key->jumlahdata);
      }
      // return view('chart',$data);
      return view('chart', compact('bulan', 'jumlah'));
    }

What does it mean "I can't push" ? What is "Array Push error"? Please be more specific what the problem is. — Marcin Nabiałek
– Marcin Nabiałek, Commented Aug 19, 2018 at 18:45
@MarcinNabiałek i got message 'Undefined property: Illuminate\Support\Collection::$bulan' — Irsyad Nurilhaq
– Irsyad Nurilhaq, Commented Aug 19, 2018 at 18:47

Marcin Nabiałek · Accepted Answer · 2018-08-19 18:54:13Z

Instead of:

$data[] = DB::table('data_peminjaman')
                    ->select(DB::raw("DATE_FORMAT(created_at,'%Y') as tahun ,DATE_FORMAT(created_at,'%M') as bulan,COUNT(*) as jumlahdata, DATE_FORMAT(created_at,'%m') as b"))
                    ->groupBy(DB::raw("DATE_FORMAT(created_at,'%M'),DATE_FORMAT(created_at,'%Y'),DATE_FORMAT(created_at,'%m')"))
                    ->orderBy('tahun')
                    ->orderBy('b')
                    ->get();

you should use:

$data = DB::table('data_peminjaman')
                    ->select(DB::raw("DATE_FORMAT(created_at,'%Y') as tahun ,DATE_FORMAT(created_at,'%M') as bulan,COUNT(*) as jumlahdata, DATE_FORMAT(created_at,'%m') as b"))
                    ->groupBy(DB::raw("DATE_FORMAT(created_at,'%M'),DATE_FORMAT(created_at,'%Y'),DATE_FORMAT(created_at,'%m')"))
                    ->orderBy('tahun')
                    ->orderBy('b')
                    ->get();

The only difference here is $data[] vs $data.

Also instead of:

foreach ($data as $key ) {
    array_push($bulan, $key->bulan);
    array_push($jumlah, $key->jumlahdata);
}

you can use pluck method:

$bulan = $data->pluck('bulan');
$jumlah = $data->pluck('jumlahdata');

Collectives™ on Stack Overflow

Laravel 5.3 : Array Push Error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related