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…
I am using laravel lumen framework v8 and with jwt authentication on the following website https://jwt-auth.readthedocs.io/en/develop/lumen-installation/. Here is some of code snippet that I have used in my project <?php return [ 'defaults' => [ 'guard' => 'web', 'passwords' =>…
Kind of a backstory, I inherited a Laravel project that initially used migrations and Eloquent to handle schema changes on it's database, but through the course of development the original developer decided it would be better to just ditch to…
I have a Laravel job that is supposed to accept a newly created Eloquent model as a constructor attribute, then perform a save() operation on it in the handle() method. However, as soon as I try saving the model to…
I am a Laravel and Eloquent noob. I'm trying to do a simple foreign key in a "checklist items" table that takes the primary ID from the "users" table as a foreign key. Here are my two database migrations: users:…
I am trying to pull the data from two tables by joining the data, but the sql query executed is dead slow. The idea is to pull all users and then combine with the created_at date from points table. Pulling…