eloquent Questions

Laravel SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: integer

March 20, 2023
Andreas Hunter
2 Answers

I have like this migration file: Schema::create('posts', function($table) { $table->engine = 'InnoDB'; $table->increments('id')->unsigned(); $table->string('title'); $table->text('description')->nullable(); $table->integer('sort_order')->default(0); $table->boolean('status')->default(0); }); And I have also seeder: class SeedPostsTable extends Seeder { public function run() { $posts = $this->getPosts(); foreach ($posts as $title =>…

VIEW QUESTION

Laravel conditional eager loading

March 20, 2023
RBFraphael
2 Answers

I'm developing an application where a User can be of type Admin, Client, Supplier or Manager. Each type (except Admin) has it's own model with respective data, and related with a user_id. For example: users - id - name -…

VIEW QUESTION

Get Only children from hasmany relation laravel 8

March 17, 2023
Moho
2 Answers

I have two mysql table with HasMany/belongsTo relation like this : public function Products() { return $this->hasMany(Prices::class, 'product_id'); } public function Prices() { return $this->belongsTo(Products::class); } If i do the following function, i can get the latest price for every…

VIEW QUESTION

Laravel model json column cast nested element

March 17, 2023
qwaz
3 Answers

I have a User model that stored credentials as json in db. class User extends Model { protected $casts = [ 'credentials' => 'array', ]; } $user = User::find(1); $user->credentials = ['username' => 'john', 'pass' => 'mypass']; $user->save(); How do…

VIEW QUESTION

Laravel datatabse cache : eloquent use a lot of RAM insted of DB facade

March 17, 2023
d3ridi
2 Answers

I want to cache the full table , when I use eloquent it use a lot of RAM to create or get the cached result. $users = Cache::remember('cache_with_eloquent', 60 * 5, function () { return User::all(); }); 128MB RAM used…

VIEW QUESTION

Laravel search using multiple condition (orWhere / orWhereHas)

March 16, 2023
Lea
2 Answers

I am creating a search field where user can search any data from any field from the list of displayed records. I have set the condition where the displayed records should only be the ones with the percentage of 50.…

VIEW QUESTION

Generate "WITH AS" via eloquent using an inner query builder – Laravel

March 12, 2023
Marcos DaSilva
2 Answers

How can I generate the equivalent of this (postgresql) query in eloquent WITH result as ( select *, order_id as alias_id from orders ) SELECT * FROM result; I should be able to pass the inner query as eloquent builder…

VIEW QUESTION

Why new saved item has 0 in id field? – Laravel

March 12, 2023
Petro Gromovo
2 Answers

Making job with new item created new saved item has 0 in id field when I try to pass this item in event. Model item is made without autoincrement field (this id is passed from other app and must be…

VIEW QUESTION

Laravel Eloquent sort by date but also by rank index to hold up entries

March 10, 2023
Jan
2 Answers

I am building a project with Laravel and I have a table which contains all my products. On that table, products get added daily, and I show all products on my page sorted by created_at. That's a pretty easy job…

VIEW QUESTION

Laravel Factory – generate fake json array data with random amount of iterations in a single column

March 10, 2023
Remicaster
3 Answers

In ListingFactory.php I have something like this return [ 'reviews' => json_encode([ 'user' => fake()->name(), 'body' => fake()->paragraph(), ]), ] Additionally, in the DatabaseSeeder.php I have this at the moment AppModelsListing::factory(10)->create(); The current problem is that it will always generate…

VIEW QUESTION