I have a page controller which is used to control what template/view is displayed based on the URI requested. If the URI matches the ‘slug’ field in the Database then the controller serves up the related template/view that is associated with that page. There are separate Pages Model and Templates Model that are related via ..
Category : relationship
I’m implementing a database fetching where an orders table saves different product ids in a column. I wonder if this approach of storing all the products in a single column as an array is good enough or if I should implement an intermediate table storing order ids and products ids. Or if there is an ..
This is comments table This is my laravel relation – public function children() { return $this->hasMany(Comment::class, ‘parent_id’, ‘id’); } public function allChildren() { return $this->children()->with(‘allChildren’); } How can i run recursive foreach loop for this so i can print comments of comments. Sourc..
Assuming there is application where Users can be informed of their status of pending or complete actions, what would be the best way to solve this. For example, prompting the users to upload a profile picture if they have not done so and/or notifiying them the action is complete. One way would be to use ..
So i have a table users where every user has a role_id, then I have a roles table where there is role_id and the name of the role. The problem i am facing is on the User model. On migrations I made the foreign key correctly, but on the model when I try to, for ..
I am working on online reservation system where customer will search for room available with time and number of people. My database table looks like this: Table: Property id property_name property_number 1 abc property AB-123 2 def property DF-343 property_number is unique field Table: Rooms id Room Name Capacity property_number 1 Room one 150 AB-123 ..
.Hi, i’m encountering a problem with a script. i’m working with Laravel 6.x (but there is no big difference). So, i have a model Order, whic has relationship with another model Group like this : Model Order : public function groups() { return $this->hasMany(‘AppModelsOrderGroup’, ‘order_id’)->orderBy(‘order_group’); } Model Group : public function order() { return $this->belongsTo(‘AppModelsOrderOrder’, ..
I’m trying to get a model an his relations "filtered" by id and I didn’t succeed to achieve that. My db looks like : operations id | name | desc ———————————— 1 | operation system | operate sys items id | name | desc ———————————– 4 | maintenance | serv maint processes id | cat ..
I have a product database. I created tables with similar products. A relationship should have a multi-product to multi-product ratio. I created the product__similar table: product_id (FK) similar_id (FK). How can I create a relationship so that links are formed in both directions? I created the relationship: public function productSimilar() { return $this->belongsToMany(Product::class, ‘product__product_similar’, ‘product_id’, ..
i have manytomany relation ship between categroy and product category model class Attribute extends Model implements Auditable { use HasFactory, AuditableTrait; protected $fillable = [‘category’,’sub_categ’]; public function products(): BelongsToMany { return $this->belongsToMany(Product::class); } } product model class Product extends Model implements Auditable { use HasFactory, AuditableTrait; protected $table = ‘products’; protected $fillable = [‘name’,’price’,’description’, ‘details’]; ..
Given: "users" table: [{ id: 1, school_ids: [1, 2, 3] // text type cast as array }] Then: "schools" table: [{ id: 1, name: ‘school 1", }, { id: 2, name: ‘school 2", }, { id: 3, name: ‘school 3", }] I currently have a relationship in my User model as: public function schools() { ..
Need help, how do I display the name of the driver instead of the id? I have more tables but if only someone can help me with one i’ll be more that glad, the table show me the number of the ID 1, 2, 3… i have tried to change the model, Im learning php ..
I have pivot table vacancy_tag. I tried different options (value,select, lists and etc), but didn’t go further than that. My request: Vacancy::where(‘id’,1)->with([‘tags’ => function ($q){ $q->select(‘tags.id’)->pluck(‘id’); }])->get()->toArray(); return this: … "tags" => array:2 [▼ 0 => array:1 [▼ "id" => 1 ] 1 => array:1 [▼ "id" => 2 ] … but need this: "tags" ..
i need run ->unique(‘model_column’) from a eager loader collection. How can i run that without use a foreach? I need generate the final collection to use it in a json_encode axios call. If i call ->unique(‘model_column’) from the model relationship method it crash, if i run them from the controller, no crash but nothing happens, ..
I have these 2 tables that are related to Many to Mutos, and a pivor table between them, I’m recording normally this way, but I don’t know how to make the relationship between the values. Each bank records 7 records, which are 7 days a week, and each day has its opening and closing hours. ..
In the search I use below, I want to filter it according to the latest requests of customers. When I filter as follows, it brings me linked records of that user’s other requests. For example, let the customer have 2 requests. Let these be two different floor records. I’d like to search between multiples of ..
So I’m trying to have plans associated to the current user. I have modal and migration called Plan. I have a method called user that I use the belongsTo() to get all the users that’s associated to that plan. I’m not sure why its not working Modal namespace AppModels; use AppModelsUser; use IlluminateDatabaseEloquentModel; use IlluminateDatabaseEloquentFactoriesHasFactory; ..
We are trying to build an application in Laravel 8 where we need to fetch some data through complex queries. Let me explain you with my model structure. I have a Brand model, which is related to multiple Group and SubGroup model with many-to-many relation. Each brand is associated with multiple Project with respect to ..
I my laravel (7.x) application. I have to models User and UserReferral with hasMany relationships. User.php class User extends Authenticate implements MustVerifyEmail { public function referrals() { return $this ->hasMany(UserReferral::class) ->orderBy(‘created_at’, ‘DESC’) ->skip(0) ->take(10); } } UserReferral.php class UserReferral extends Model { public function user() { return $this->belongsTo(User::class); } } The list of Referrals has ..
I use Laravel 8. I want to get the user proccess course, but I get all users proccess. In User.php public function courses() { return $this->belongsToMany(Course::class); } Course.php public function progresses() { return $this->hasMany(Progress::class); } Progress.php is empty. Course table Schema::create(‘courses’, function (Blueprint $table) { $table->id(); $table->string(‘title’); … $table->timestamps(); }); Progress table Schema::create(‘progress’, function (Blueprint ..
I am creating tables in PHPMyAdmin using Laravel Migrations. One of the things that I want to do is have a Question Table and Answers Table where 1 question can have 4 answers (Multiple choice). I want to link the answers and the question with a relationship. Is it possible to set a primary/foreign key ..
Good afternoon I ran into a problem database structure langs id title 1 ru 2 en articles id alias 1 test_article_1 2 test_article_2 article_lang article_id lang_id 1 1 2 1 1 2 2 2 article_title_lang article_id lang_id title 1 1 novost_1 2 1 novost_2 1 2 article_1 2 2 article_2 models: Langs public function articles() ..
I have the following two tables in Laravel: Question Option How do I set a relationship that will create 4 new options for each question added to the table? So every time a new Question row is created/added I need to create 4 new Options rows in the option table… Hope someone can help. Thank ..
I’m relatively new to Laravel 8 and I have problem figuring what should I do when I need a relationship Has One Of Many In the doc of Laravel 8 It’s not very well documented. My User can have only one Job. I have a tables Jobs where I list all available Job { id, ..
I would like to merge 2 relationships into one query from 2 different models class User extends Authenticatable { public function relazioneFollower() { return $this->belongsToMany(User::class, ‘user_follower’,’follower_id’,’following_id’) ->withTimestamps(); } } class bacheca extends Model { protected $primaryKey = ‘id_post’; public function commento() { return $this->hasMany(Comment::class,’id_post_commento’); } } this piece of code works fine, but I would ..
Web Development Company
Free Hosting Company
