Assign FK to a Object - Is It a good Practice?

Question

Assign FK to a Object - Is It a good Practice?

Luis Eduardo Feb '15

Created Feb '15	Last Reply Feb '15	Replies 2	Views 456	Votes 0

Luis Eduardo 7.2k

Feb '15

Hello I have a little question about relacional models 1:N and how can I assign the Foreign Key.

    public function CreateAction(){

        $id = 3;
        $part = Parts::findFirst($id); // Looking for my specific record (FK) to assign later

        $robot = new Robots();
        $robot->name = "Ironman";
        $robot->type = "5289756";
        $robot->id_parts = $part->id_parts; // Here is the Question - Is it a good practice?

        // $robots->id_parts = Local Column FK

        $robot->save(); //Save Data
    }

Really I don't know If I am following a good practice to assign FK to a Object (model) or no?

Do exist other ways?

Thanks!

RompePC · Answer 1 · 2015-02-14T15:37:12-07:00

I should assign the robot_id into the Part instance (then you'll not have to assign an array instead of a non-array).

Luis Eduardo · Answer 2 · 2015-02-14T19:11:14-07:00

I understand you a little, how can I make it?

I don't know if you refer a it:

$part = $robots->id_robots; ? ?

I should assign the robot_id into the Part instance (then you'll not have to assign an array instead of a non-array).

RompePC · Answer 3 · 2015-02-15T05:18:57-07:00

If we have 5 parts for a robot (1:5):

foreach($parts as $part) {
    $part->robot_id = $robot->id;
}