HOW TO: Laravel 5 - mySQL query

Question

the situation:

I have one mySQL database and I want to get a dinstinct count of the column C_ID where the set timestamp is like the current day (e.g. 2015-08-14)

in phpMyAdmin it works fine:

SELECT COUNT(DISTINCT C_ID) FROM table WHERE touched_at LIKE '2015-08-14%'

the result is 32; but in Laravel 5 I get 320 because the distinct function does not work for me

$date = date('Y-m-d');

$one = DB::table('talbe')
        ->select()
        ->where('touched_at', 'like', "$date%")
        ->distinct('C_ID')
        ->count();

Can you please assist me with this problem?

Thanks in advance Timo

Cor Bosman · Accepted Answer · 2015-08-14 09:00:31Z

1

This may work. Tried it in one of my projects and that produces the right answer for me.

$one = DB::table('talbe')
         ->where('touched_at', 'like', "$date%")
         ->count(DB::raw('distinct C_ID'));

answered Aug 14, 2015 at 9:00

Cor Bosman

3362 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aldrin27 · Accepted Answer · 2015-08-14 07:16:18Z

0

Try this if it works:

 $date = date('Y-m-d');

  $one = DB::table('talbe')
    ->select('touched_at')
    ->where('touched_at', 'like', "$date%")
    ->distinct('C_ID')
    ->count();

edited Aug 14, 2015 at 7:16

answered Aug 14, 2015 at 7:12

aldrin27

3,4184 gold badges31 silver badges44 bronze badges

1 Comment

Timo Over a year ago

P_ID, C_ID, SN, R_MAC, M_MAC, U_MAC, E_MAC, C_MAC, touched_at

Vipul · Accepted Answer · 2015-08-14 07:26:13Z

0

You may also try this code

 $date = date('Y-m-d');
 $one = DB::table('table')
     ->select(DB::raw('count(Distinct C_ID) as C_ID'))
     ->where('touched_at', 'like', "$date%")
     ->get();

answered Aug 14, 2015 at 7:26

Vipul

9317 silver badges16 bronze badges

3 Comments

Vipul Over a year ago

can you show me table's dummy record because i used this query on my end and its give correct result

Vipul Over a year ago

try this query --- DB::table('table')->where('touched_at', 'like', "$date%")->groupBy('C_ID')->count();

Timo Over a year ago

I need the distinct command otherwise i get all C_ID grouped seperated but i need them combined

Collectives™ on Stack Overflow

HOW TO: Laravel 5 - mySQL query

3 Answers 3

Comments

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related