I have a ModelA with columns: name, last_name, email I want ModelA with the name Test to add an extra where on email what I tried is the following $model_a_res = A::when( function($query){ return $query->where('name','Test'); }, function ($query) { $query->where('email',…
How to use WHERE NOT IN in DB:raw Laravel? Here's my sample code $query = DB::select(DB::raw("... WHERE ID NOT IN (:ids) ..", array( 'ids' => "1,2,3" ))); I also tried this $ids = "'1','2','3'"; $query = DB::select(DB::raw("... WHERE ID NOT…
I am using cache to store data structure from database: Cache::forever(static::DATA_STRUCTURE, json_encode($tree)); However before I generate there should cleaned old: Artisan::call('cache:clear'); But generating new cache takes some time and I want to store old cache until new will be generated.…
I'm encountering a PHP execution time error while inserting approximately 250k records into a MySQL database using Laravel Eloquent. I'm aiming to achieve this without increasing the overall execution time, considering the following constraints: Frontend: Angular Multi-tenancy: Implemented using https://tenancyforlaravel.com/…
Here's the error PHP Warning: PHP Startup: Unable to load dynamic library 'php_mongodb.dll' (tried: C:xamppphpextphp_mongodb.dll (The specified module could not be found), C:xamppphpextphp_php_mongodb.dll.dll (The specified module could not be found)) in Unknown on line 0 Warning: PHP Startup: Unable to…
I'm doing the forgot password and recover password feature using Laravel API and React. I've done the form and now I'm stuck at the backend part. In the forgotPassword function, it will send a link for recover password at the…
This is what i see in the frontend: The problem is the following. I have a form in livewire: <div class="striped"> <div x-data="{showDeleteButton: false}" class="account-list grid"> <div class="card-item-name"> {{ $account->name }} </div> <div class="account-amount flex"> <span class="pt-1 mr-1">€</span> <x-input wire:model.live="amount"…
I have this long query builder where I am basically searching a table and then filter the results based on the passed query strings: $projects = Listing::query() ->when(request('q'), function($builder) { $builder->searchQuery(request('q')); }) ->when(request('tags'), function($builder) { $tags = request('tags'); $builder->whereHas('tags', function($builder)…
I was using github actions fine for ftp purposes in updating my server it worked fine untill when i integrated cloudflare and for security reasons decided to block all traffic except that from my country. Since then github action to…
[vite:css] [postcss] original.line and original.column are not numbers -- you probably meant to omit the original mapping entirely and only map the generated position. If so, pass null for the original mapping instead of an object with empty or null…