I'm trying to migrate a Laravel 5 API with MySQL 5.7 to a Laravel 9 API with MySQL 8. Almost everything is working well, except on a few queries that tries to load data with their parent, recursively. On Laravel…
I'm trying to call 2 columns from 2 different tables. applicants.ic_no and agents.ic_no. It have different values. Using the following codes only displayed only ic_no from agents.ic_no $claimLists = ClaimDetail::join('applicants', 'applicants.ic_no', '=', 'claim_details.ic_no') ->join('agents', 'agents.id', '=', 'claim_details.agent_id') ->where('claim_date', $cutt_off) ->groupBy('agents.id',…
I have a laravel model that has a JSON column type named "properties". This column is a array of objects like below [ { "quantity":4210, "price":"21247.10", "childs":[ { "quantity":0.19814469, "price":"22329.70" } ] }, { "quantity":1234, "price":"21247.10", "childs":[ { "quantity":0.19814469, "price":"22329.70"…
I have a polymorphic relationship between an Article model and 3 models (Company, Group & User) that sometimes returns null. 90% of the time, the articleable relation is perfectly OK and looks like this: #relations: array:1 [▼ "articleable" => AppModelsUser…
I am trying to display rows that show the highest Version of each Name. However, I'm having problems on how to convert my raw php code to Eloquent ORM. Any help will be appreciated. $sql="SELECT * FROM images WHERE (Name,Version)…
Can you please assist, I have laravel project working fine in my localhost where am using wamp.The problem arise after uploading the project to cpanel it says 404 Not found to new routes i just added and others works fine.…
Laravel version 9.x PHP version 8.1 Current code. /** * Show the form for editing the specified resource. * * @param AppModelsSite $site * * @return IlluminateHttpResponse */ public function edit(Request $request, Site $site) { $site->load(['servers' => function($query) { $query->select('id')->orderBy('id',…
first time I ask via the web, but I don't know what I can do anymore. My question is about laravel using Eloquent. I have no problems with migrations and seeding and have a connection to MySQL. But when I…
does anyone know how to store the data in this format ["123"] in PHPMyAdmin? Now the data I store into the database is only the value which is 123. I want to store the data like this ["123"]. Does anyone…
I'm using Redis to cache different parts of my app. My goal is to not make a database query when the user is not logged in, as the app's content don't get updated regularly. I cache the archive queries in…