Get Daily Data using Laravel Query Builder

Query Builder

$result = DB::table('orders')
    ->select(DB::raw("sum(total) as total, DATE_FORMAT(created_at,'%Y-%m-%d') as date_label"))
    ->where('status', 1)
    ->get();

$result = DB::table('orders')

->select(DB::raw("sum(total) as total, DATE_FORMAT(created_at,'%Y-%m-%d') as date_label"))

->where('status', 1)

->get();

M	T	W	T	F	S	S
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30

Rex's Personal Site

This site is built on WordPress and contains personal notes, photos and videos

Get Daily Data using Laravel Query Builder