Background A raw SQL query with many joins and selects and whatnots, when loaded with $results = DB::SELECT($query) creates a ~500mb, 450,000 items $results collection, which is not good. Solution So the $query now instead creates a temporary table, which…
I am working with Filament and Laravel and currently I've got these two field inputs for choosing City BASED ON Province Field, inside form() method: Select::make("meta.employment_state") ->label("Province") ->getSearchResultsUsing(fn (string $search): array => State::query()->where('name', 'like', "%{$search}%")->limit(10)->pluck('name', 'id')->toArray()) ->getOptionLabelUsing(fn ($value): ?string =>…
I have validation in Laravel 10 that contains validation for company_description. I want it to be required when two other fields have specified values. I got this code: 'company_description' => [ 'string', 'nullable', function ($attribute, $value, $fail) { if (request()->input('offer_type_id')…
I have one file dbConfig.php which contains simple array data. <?php return [ 'host' => 'localhost', 'database_name' => 'mitesh_practice', 'database_user_name' => 'root', 'database_password' => 'Kadiya@123' ] ?> I have another file which is Model.php So in Model.php I have created…
I am trying to make login functionality using JWT in Laravel 10. The issue I have is that I have base User class and Artist and Client as inherited classes. The query done by JWTAuth queries the artists table looking…
I want to hash password and fill it in my request validator to be able to save a new employee registration. Can you help how to hash password in request validator? Here details of my project: Model: <?php namespace AppModels;…
I'm trying to send a set of form inputs from a controller into an API endpoint but when I check the variables in the API, it all shows null value.. what is wrong with my code? CulinaryController.php public function update(Request…
I’m facing a small issue with time zones in my Laravel application and would appreciate your help. I have a scheduled job in Laravel that updates event statuses. The job logs show the following timestamps in the laravel.log file: [2024-08-19…
I need to insert the email data that goes in the .env, directly in the code and not in the .env. However, I can't figure out which file is getting these settings. I am using the following line of code…
I have a huge amount of data imported in my Typesense using Laravel command scout:import. And I need to stop after some time and continue where it left. I found this: https://laracasts.com/discuss/channels/laravel/skip-some-records-with-scoutimport but it always gives me All [AppModelsUser] records…