I have three Models. University, Professor and Student. They have some relations. University Model : <?php namespace AppModels; use IlluminateDatabaseEloquentModel; use AppModelsUser; class University extends Model { protected $fillable = [‘name’, ‘user_id’]; /** * Get the user that owns the university. */ public function owner() { return $this->belongsTo(User::class); } } Professor Model : <?php namespace ..
Category : eloquent–relationship
I have the following situation: A table product_mappings and a table product_mapping_options. I now want to find all entries within all product_mappings to which an entry product_mapping_options with certain ids is assigned. For example, this could look like this: "data" => array:4 [ 0 => array:6 [ "id" => 4 "product_id" => 1 "article_number" => ..
I have a requirement. My DB has tables like the following. The tables have OneToMany (1-n) parent-child relation. Table School (id, school_name) Table Class (id, school_id, class_name) Table Section (id, class_id, section, no_of_seats) Table Student (id, section_id, student_name, ….) When Some Student is registered, data is uploaded to the Student table. Now, I want to ..
I have a requirement. My DB has tables like the following. The tables have OneToMany (1-n) parent-child relation. Table School (id, school_name) Table Class (id, school_id, class_name) Table Section (id, class_id, section, no_of_seats) Table Student (id, section_id, student_name, ….) When Some Student is registered, data is uploaded to the Student table. Now, I want to ..
I have models: Page: id slug Image id file Video id file I need the Page model to have a relation with several Image and Video models through one relationship, like foreach($page->attachments as $attachment) { // $attachment can be Image or Video } And inserts like $attachments = [$image, $video]; $page->attachments()->saveMany($attachments); I tried to make ..
I need some specific columns from two relations. In my questions model I have two relations public function ans_options() { return $this->hasMany(‘AppModelsAnswerChoices’, ‘ac_quest_id’, ‘q_id’); } public function question_category() { return $this->hasOne("AppModelsCategories", ‘cat_id’, ‘q_category’); } I tried Questions::with(array( ‘questionCategory’ => function($query) {$query->select(‘cat_id’,’cat_value’);}, ‘ans_options’ => function($query1) {$query1->select(‘ac_id’,’ac_choiceTxt’);} ))->get(); am getting only the columns of question_category not in ..
I am facing an issue please if someone can help I want to get sorted inventory by apply orderBy clause on eager loaded table column blow is my code and you can check laravel doc for the reference https://laravel.com/docs/8.x/eloquent-relationships#constraining-eager-loads my code $inventoryFilterQuery = Inventory::with([‘inventoryPrice’ => function ($query) use ($request) { return $query->orderBy(‘inventory_price’, ‘desc’); }])->get(); but ..
I’m using Property Model for filtering data. Passing the filter values from the frontend. If the filter can’t find matches results coming from the DB just skip the filter. The data is filtered from the Model and the relations as well. Problem: I want to skip the if statement if there is no result against ..
My form posting this data { "name": "Company Name1", "contacts": [ { "name":"John Doe", "phone":"123123" }, { "name":"John Doe 2", "phone":"123123" } ] } I want to create a company with the name and then for each contact in contacts new contact relation which is related to this company. Do you guys have any idea ..
Let’s say Here . I have an extra column on intermediate table ‘noOfUpdates’ then how can i access its previous value. I tried this but it didn’t work. $user = User::find(1); $user->roles()->updateExistingPivot($roleId, [ ‘noOfUpdates’ => noOfUpdates + 1, ]); In raw SQL i can to do that. n_enroll column sorry for my english 🙁 PLEASE ..
Phone Model(Child) class Phone extends Model protected $guarded = []; public function user(){ return $this->belongsTo(AppModelsUser::class); } } User Model(Parent) class User extends Model{ protected $guarded = []; public function phone(){ return $this->hasOne(AppModelsPhone::class); } } I know we can do something like this: USE AppModelsUser; USE AppModelsPhone; $user = new User(); $user->name = ‘John Doe’; $user->email ..
I have three tables in my database: inquiry post product Columns in inquiry table: id message post Columns in post table: id title content product Columns in product table: id name I have an Inquiry model and I want to show the post title and product name with my inquiry. I found that hasOneThrough can ..
I have this two models in my Laravel project: class Post extends Model { public function tags(): MorphToMany { return $this->morphToMany(Tag::class, ‘taggable’); } } class Tag extends Model { public function tagable(): MorphTo { return $this->morphTo(); } } I want to get the posts what has the tag X. I know the correct SQL query ..
I have the following Models: Account: class Account extends Model { protected $attributes = [ ‘id’ => false, … ‘model_id’ => null, ‘model_type’ => null ]; public function model() { return $this->morphTo(); } } Driver: class Driver extends Model { protected $attributes = [ ‘id’ => false, ‘name’ => false, … ]; public function accounts() ..
I’ve a problem in Laravel Eloquent. I have 2 tables: evento users "evento" is the custom name table for Event model. In the model I declare custom table protected $table = "evento"; I have a many-to-many relationship with event_user as table name. In User model I have events() function that use custom pivot table name ..
How to Convert the following query into Eloquent specially the sub query in query and COALESCE and Group By in Eloquent select sub.activity_id,sub.district, COALESCE(sum(general_reports.quantity),0) as quantity from (SELECT activities.id as activity_id, project___districts.district FROM project___districts INNER JOIN activities ON project___districts.project_id = activities.project_id ) as sub LEFT JOIN general_reports on general_reports.activity_id=sub.activity_id and sub.district=general_reports.district WHERE sub.activity_id=’$id’ GROUP BY ..
I wanted to select the columns id,courseName & userId from Course table along with id,FilePath from Files table and id, name & aboutUser from user table. But the below code is not returning anything from course table , except that, it displays data from the other 2 other relations . How can i fix this? ..
After searching and trying for quite a while I am not sure how to tackle this issue. I cant really change the DB structure nor the specific function that is giving me problems. Following is my problem: I have a table where certain contents are stored in an array. Said array contains the ids of ..
i wanted access the value of content_type_id .i tried like $courseChapters[‘chapter_content’][‘content_type_id’] , $courseChapters[‘content_type_id’] , $courseChapters[0][‘content_type_id’] & $courseChapters[‘chapterContent’][‘content_type_id’].All these shows the error ErrorException: Undefined index: content_type_id . I also tried everything in the foreach loop i’ve commented below. Nothing works. Can someone tell me how to fix this? $courseChapters = courseChapter::with([‘chapterContent’ => function ($q) use ($id) ..
I want make relationship with attribute but i dont understand how to do that with laravel ORM Eloquent, can somebody help me? Thanks in advance Sourc..
i wanted to display id,FileName & FilePath from Files table and id & name from User table along with the course table columns – id,courseDisplayName & aboutCourse. But it is returning null from both files & user relations.How can i fix this? $course=Course::with([‘files:id,FileName,FilePath’,’user:id,name’]) ->select(‘id’,’courseDisplayName’,’aboutCourse’) ->where(‘userId’,$request->tutorId) ->get(); Course Model public function files() { return $this->belongsTo(Files::class, ‘fileId’, ..
I wanted to fetch all id & name from User table which satisfies the condition , order_userId of Orders table == id of User table and order & uploadId columns of Orders table has the values false & null respectively. The below code returns all rows if data from User table without checking the where ..
I’m trying to create a relationship between my ‘users’, ‘profiles’ and ‘countries’ table. Users table has the columns: id – name – email – password Profiles table has the columns: id – user_id – country_id Countries table has the columns: id – name – code The problem is that currently my code is matching a ..
i’ve an array like below for $response. i wanted to fetch the user field alone & files field lying inside the user from it . i tried like $response[‘user’] & $response[‘user’][‘files’] , it shows the error undefined index. How can i achieve this? [ { "id": 14, "userId": 1, "courseDisplayName": "yuu", "aboutCourse": "kljkl", "user": { ..
I wanted to fetch id & courseName from Course table, id,name & mob from user table and id & FilePath from files table , for which the userId of course table has the value of id in user table & fileId of course table has the value of id in files table.The below code is ..
Web Development Company
Free Hosting Company
