Restructuring PHP array

Question

I have tried many different variation, but cannot get the right structure. Maybe, you expert might what to give it a try.

What I need to do is return the therapist who may have multiple children assigned to him. It will return the children's schedules that are assigned to him.

I have tried the following Code. This is the closest I can get to the format I need.

    // Grab the therapist    
    $therapist = $this->Therapist->find('first', array('conditions' => array('Therapist.' . $this->Therapist->primaryKey => $id)));
    // Grab the child(ren) assigned to the therapist
   // Returns id as key and name as value.
    $children =  $this->Child->get_children($id);
    $schedule = array();
   // Loop through the assigned children and get the id (key).
   foreach($children as $key => $value):
        // Loop through and grab all the scheduled days and times for child(ren).
        foreach($this->Schedule->get_full_schedule($key) as $child):
            // Have the child name at the top of the array. 
            if($name != $child['Child']['child_name']):
                 $schedule[] = array_push($schedule,  array('child_name' => $child['Child']['child_name']));
                $name = $child['Child']['child_name'];
            endif;
                // Get all the scheduled days for the child and add to array.
                if($child['Schedule']['child_id'] == $child['Child']['id']):
                    $schedule[]['Schedule'] =  $child['Schedule'];
                endif;
        endforeach;
    endforeach;

Which outputs the following Array:

What I would like is:

Any help is appreciated.

Thank, Greg

Does it have to be EXACTLY like that, or is there a way you can generalize it like.... "I want an array where each child has an array of dates" ? — Dave
– Dave, Commented Jul 23, 2014 at 21:40
No, it doesn't. I just need it in a format, so I can pass it to a view and build out a table of the schedule for each child. — Greg Fox
– Greg Fox, Commented Jul 24, 2014 at 10:43

Dave · Accepted Answer · 2014-07-24 15:59:52Z

1

Have you thought about just using Containable Behavior? Seems MUCH easier than the way you're trying to do it:

$this->Therapist->find('first', array(
    'conditions' => array(
        'Therapist.' . $this->Therapist->primaryKey => $id
    ),
    'contain' => array(
        'Child' => array(
            'Schedule'
        )
    )
));

Not only is it a lot easier, but your data should come back in an acceptable and nested format.

answered Jul 24, 2014 at 15:59

Dave

29.2k26 gold badges117 silver badges184 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Greg Fox Over a year ago

Yes, I tried to put something together using Containable. I was trying it in the Schedule Model, however I will give this a try. Thanks for the insight.

Greg Fox Over a year ago

I tried it. Everything worked, but didn't return the schedule for each child. Sorry.

Dave Over a year ago

@GregFox - then there's something else wrong with your code. Bottom line, this answer is "use containable behavior". Beyond that, you might need to ask a question about why your associations are wrong, or why containable isn't working as it should for you. My guess is you didn't set recursive to -1 per the instructions, but I can't be sure without seeing all your code.

Greg Fox Over a year ago

Once I fixed my relationships, it worked like a charm. Thanks.

Collectives™ on Stack Overflow

Restructuring PHP array

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related