Finding Duplicate Data

$users = DB::table('users')
                    ->select(array('users.ip', DB::raw('COUNT('*')'))
                    ->groupBy('users.ip')
                ->having(DB::raw('COUNT('*')'))
                    ->get();

May be something like this.

@shahinul87 not working bro................ And also note i have User Model

User::groupBy('ip')->get();

@toniperic not working bro

@rtechshow please be more explicit then. What's not working?

@toniperic bro it is showing just one result and i want all result having ip same like

7 users are there in database out of them 2 have the ip 255.255.30.12 , other 3 have ip 124.35.89.78 and the rest two have different ip respectively

So I want to grab all the users having ip address common so in this case we will get 5 users having ip 255.255.30.12 (in this case 2 users) and 124.35.89.78 (in this case 3 users) respectively and excluding the remaining two having different ip

What's with this bro thing? And after reading the initial post I have a headache.

You get a collection with get. So you just have to traverse it with a foreach loop. Here's an example:

User::where('ip', '=', $ip_address)->get();

Then in your view:

@foreach($users as $user)
    {{ $user->username }}: {{ $user->ip }}<br />
@endforeach

@xtremer360 @beznez @toniperic @shahinul87 Bro listen............

Forgot about everything just tell me how can i get the duplicate data from table without passing any variable just as we use in my sql this query for any particular column

SELECT ip, COUNT(ip) AS occurrences
FROM users
GROUP BY ip
HAVING occurrences > 1;

Please tell me how to convert it into laravel 5 using eloquent

@rtechshow

$records = \DB::select('ip')
              ->selectRaw('count(`ip`) as `occurences`')
              ->from('users')
              ->groupBy('ip')
              ->having('occurences', '>', 1)
              ->get()

@constb bro getting error and by the way i also have User model

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ip' at line 1 (SQL: ip)

Bro. You must bro the SQL query before broing others into the bro. Okay bro?

@bashy I didn't get you with lots of bro in your sentence

Now its just getting sad.

If I understood, you want the Users instances with duplicate IP's, I would do a sub-query:

// app/Http/routes.php


    Route::get('duplicates', function () {
        $results = \App\Users::whereIn('id', function ( $query ) {
            $query->select('id')->from('users')->groupBy('ip')->havingRaw('count(*) > 1');
        })->get();

        return $results;
    });

thanks @rodrigo.pedra

Wow he didn't get a "thanks bro"

$ip= AgentContact::select('id', DB::raw('COUNT() as count')) ->groupBy('ip') ->havingRaw('COUNT() > 1') ->get();