I have multiple many-to-many relationships and i want to filter through them. The models are: State District I attached an screenshot: (https://i.stack.imgur.com/TJPwp.png) States are Alabama and Arizona, Districts are Autaga, Baldwin and Apache When i check Alabama and Arizona the…
I want to remove old images in my public folder when he want to change him profile photo. ProfileController: if($request->hasFile('image')){ $request->validate([ 'image' => 'image|mimes:jpeg,png,jpg,svg|max:2048' ]); $imageName = $request->user()->id.'-'.time().'.'.$request->image->extension(); $request->image->move(public_path('users'), $imageName); $path = "users/".$imageName; $request->user()->image = $path; $request->user()->save(); } i tried…
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 =>…
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 -…
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…
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…
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…
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.…
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…
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…