John Davidson

Message:

im going to use time which saved in database table

$created_at = DB::table('posts')->select('created_at')->get();

this return Collection with this format

Illuminate\Support\Collection {#1201 ▼

  #items: array:5 [▼

    0 => {#1209 ▼

      +"created_at": "2021-04-18 11:17:37"

    }

    1 => {#1208 ▼

      +"created_at": "2021-04-18 11:20:34"

now how can i filter just month ?

I need this for line graph

---

My Answer:
>pluck('created_at');

// Convert timestamp to Unix timestamp
$timestamps = [];
foreach ($created_at as $timestamp) {
$timestamps[] = strtotime($timestamp);
}

// Pass timestamps to view
return view('line-graph', ['timestamps' => $timestamps]);