I'm trying to implement an efficient search on street names. A street has multiple residences (houses). The search I'm trying to build is street names LIKE %example% within the given city_id. The result must include the LIKE list of matching…
we have warehouse LOCATIONS in a system like this. D2705B, D2805C, F3805C, F3805F So we used these all locations but want to know which locations are not used YET. Case 1: D2705B USED means missing D2705A (Need to go back…
Here is the message I got after the migration. IlluminateDatabaseQueryException SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. (SQL: select * from information_schema.tables where table_schema = econnect and table_name = migrations and table_type =…
I have the following query params in string format $query = '->whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request('startTime'), request('endTime')])'; How do i pass it to the eloquent? Am trying to achieve something like this InboundMessage::query()->{$query}; Am getting the error below Property [->whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request('startTime'),…
My code $datas = DB::table('patrol_gate_surveillance_transactions as a') ->leftJoin('client_locations as b','a.client_location_id', 'b.id') ->leftJoin('clients as c', 'b.client_id', 'c.id') ->select('a.client_location_id as location_id', 'b.name as location_name', 'c.name as client_name', DB::raw('SUM(CASE WHEN a.type = 1 THEN employee_qty ELSE 0 END) as e_qty_in'), DB::raw('SUM(CASE WHEN a.type…
I have this query and works fine: SELECT id_categoria, categorias.descricao_categoria, MAX(CASE WHEN month(data_compra) = 1 THEN valor ELSE NULL END) as Jan, MAX(CASE WHEN month(data_compra) = 2 THEN valor ELSE NULL END) as Fev, MAX(CASE WHEN month(data_compra) = 3 THEN…
I have problem with laravel , in my localhost everthing is fine but on my shared hosting i got problem even is the same php version For example : I want to get question title using $answer->question->title but i got…
My system has 2 xampp's one with PHP 5.6 and the other with PHP 7.3. I have correctly included both the PHP versions in environment variables. I am trying to connect my laravel v5.8 application with mongodb v4.2. I have…
I have the following route in my laravel project Route::get('/',[ 'uses' => 'MakeController@index' ]); Controller class MakeController extends Controller{ public function index(){ $makes = MakeType::all(); return View::make('Index', $makes); // tried this // return view('Index',compact('makes')); } } index.blade.php <select> <option>Select Make</option>…
I'm trying to validate a request from form and appear a problem, not showing error messages on the view. The validation succeeds, refreshing the view but not displaying errors. Apparently $errors is always empty I tested it on fresh installation.…