<?php

namespace App\Http\Controllers;

use Illuminate\Database\Query\JoinClause;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class UserController extends Controller
{
    public function showUser() {
        $users = DB::table('users')
              //->leftjoin('cities','users.City','=','cities.id')
              //->select(DB::raw('count(*) as users_count'),'cities.city')
              //->groupBy('city')
              //->havingBetween('users_count',[1,3])
             // ->having('users_count','>',1)
              //->orderBy('users_count','desc')
              //->count();
              ->leftjoin('cities',function(JoinClause $Join) {
                     $Join->on('users.city','=','cities.id')
                     ->where('users.name','like','p%');
              })
              ->select('users.*','cities.city')
              ->get();

              //return $users; 
             return view('welcome',compact('users'));
    }



}