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…
I have the next database: Therefore I have three php models Purchase, Supplier and PurchaseDetail. My model Supplier has a relation hasMany with Purchase: public function purchases() { return $this->hasMany(Purchase::class, 'supplier_id'); } And the model Purchase has a relation hasMany…
I am trying to make a crud function in laravel with custom primary ID. The Create, Read, and Delete are all working but whenever I tried Update I get an error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in…
i am working on a Laravel 8 project and i have a bunch of categories that i selected in my multi select bar of my Form, and i want to return the suppliers in my database for each category i…
I am using Laravel 8 and i uploaded my project to cPanel. In my local server it works fine but in live server it show me error: syntax error, unexpected ':', expecting ')' on return $this->belongsTo(JournalHead::class, foreignKey: 'journal_head_id'); Below is…