I have these: posts table public function up() { Schema::create('posts', function (Blueprint $table) { $table->id(); $table->string('title', 64); $table->string('teaser', 128)->nullable(); $table->text('content', 50000); $table->timestamps(); }); } posts model use HasFactory; protected $fillable = ['title', 'teaser', 'content']; public function tags() { return $this->belongsToMany(Tag::class,…
In my Laravel app there are 3 Models: Movie, User, Review Review: <?php namespace AppModels; use IlluminateDatabaseEloquentFactoriesHasFactory; use IlluminateDatabaseEloquentModel; class Review extends Model { use HasFactory; protected $hidden = ['user_id','movie_id','created_at','updated_at']; public function movie(){ return $this->belongsTo(Movie::class); } public function user(){ return…
I am trying to store a simple form into my database. My model is that I have jobs which where each job can contain several task. Therefore my Models look like this: User public function jobs() { return $this->hasMany(Job::class); }…
The below function allows me to retrieve related entries of a given model type that have, for instance, overlapping tags associated with them. <?php public function getRelated($entity, $fields = [], $relations = []) { $related = new EloquentCollection(); // get…
I fill a SQL Table from a Request with Laravel Excel. After this I do an Eloquent Statement to fill the values markt and period manually. public function importall(Request $request) { $periode = $request->periode; $markt = $request->markt; Excel::import(new periodenImport(), $request->file);…
I want to pick questions randomly but category dependent. For example, if the test is given with 10 questions and the total category is 5, the test flow should take 2 questions randomly from each category. Is there a way…
I want to show data from 'personas' (parent table) that has at least one 'residente' (child table), its a one to many relationship, and i want to show data of that residente too. I was trying to do it using…
I have a pivot table with two foreign keys and I want to list items according to one foreign key. id | tool_id | user_id ______________________ 1 2 12 2 5 12 3 3 12 4 4 7 I have…
Hello I have these columns 'name', 'email', 'username' and 'ip' how would I check or highlight table row in blade if records has same ip? This is my controller $promo = Promo::with(['participants' => function ($q) { $q->orderBy('winner', 'desc')->orderBy('created_at', 'desc'); }])->find($id);…
I'm trying to get the right data from the database, I'm retriving a model with a media relation via eloquent, but I want to return a photo that contains the 'main' tag stored in JSON, if this tag is missing,…