Welcome Guest, Not a member yet? Register   Sign In
nesting mysql results, need help passing the array to my view
#1

[eluser]skattabrain[/eluser]
ok, still new to CI ... and object orientated design. i have no problems doing this procedurally.

creating a profile page for users ... on this page i load their details, then any comments made about them. i also want to include a list of replies for each on those comments.

i pass the data to my view like this ...

Code:
$this->load->view('profile.php', $data);

so i fetch my client, then all comments made on them, here's the code to fetch the comments ...

Code:
$comments = $this->Profile_data->getCoComments($clientID);
$data['comments'] = $comments;

now, i get the replies to each of these comments ...
Code:
if ($comments->num_rows() > 0)
{
foreach ($comments->result() as $comment)
$replies = $this->Profile_data->getReplies($comment->commentID);
}

the trouble i'm having is attaching this new reply array to the exisiting comment array ... so in my view i can simply loop through each comment, and while in a comment, i check for replies and loop through them before moving to my next comment. not really sure how to do this ... again, i've done this procedurally forever now ...
#2

[eluser]Taff[/eluser]
I had a similar issue a few days back. Unfortunately nobody could help me on the forums.
This is what I ended up doing:
//Get the list into the controller
Code:
$data['query'] = $this->model->get_list($this->user_id);
//copy it to avoid issues and get convert the result into an array
$test = $data['query']->result_array();
//find out how long it is
$len = sizeof($test);
//Loop through test
for($i=0;$i<$len;$i++){
//create a temp vaariable grabbing the items from my second table with a value equal to list_id
$tmp=$this->model->get_todo_items($test[$i]['list_id'],$this->user_id);
//assign a new element to the array called sublink
  $test[$i]['sublink']=$tmp->result_array();
}
//Reassign test back to data['query'] with our modified "query" array which now contains a new element called sublink.
$data['query']=$test;

which will output something like this:
Code:
array(8) {
    ["list_id"]=>
    string(1) "2"
    ["title"]=>
    string(23) "Second to do list title"
    ["sublink"]=>
    array(2) {
      [0]=>
      array(11) {
        ["item_id"]=>
        string(1) "3"
        ["list_id"]=>
        string(1) "2"
        ["responsible"]=>
        string(4) "Taff"
        ["title"]=>
        string(29) "Second title for to do list 1"
      }
      [1]=>
      array(11) {
       ["item_id"]=>
        string(1) "4"
        ["list_id"]=>
        string(1) "2"
        ["responsible"]=>
        string(4) "Taff"
        ["title"]=>
        string(29) "Second title for to do list 2"
      }
}

Hope I understood your question correctly, and that this helps.

Taff
#3

[eluser]Pascal Kriete[/eluser]
Taff has it spot on. Just to add my 2c though, returning the result_array from your model makes this a lot easier. Also, if you're using PHP5 you can do the loop very easily by using a reference in the foreach.
Code:
$comments = $this->Profile_data->getCoComments($clientID);

// No longer need the if, since we know it's an array.
foreach ($comments as &$comment)
{
    $comment['reply'] = $this->Profile_data->getReplies($comment->commentID);
}

$data['comments'] = $comments;

The same works in PHP4, but you have to do foreach($comments as $key => $comment) and then use $comments[$key]['reply'] similar to what Taff did.
#4

[eluser]skattabrain[/eluser]
thanks for your insights ... thank you very much.

this is what i did shortly after my post ...

Code:
$comments = $this->Profile_data->getCoComments($clientID);
$data['comments'] = $comments;
            
if ($comments->num_rows() > 0)
{
  foreach ($comments->result() as $comment)
   {
     $replies = $this->Profile_data->getReplies($comment->commentID);
     $data["replies"][$comment->commentID] = $replies;
   }
}

then in my view inside the comment loop, i do this ...

Code:
if($replies[$comment->commentID]->num_rows() > 0):
foreach($replies[$comment->commentID]->result() as $reply):
etc ...
#5

[eluser]Miguel Diaz[/eluser]
One question I am trying to do the same thing but I am still new at this. I was trying to use my database model with this but it do not work. Can some one help me please

This is my model
Code:
function getReply()
    {
        $data = array();
        $q = $this->db->query("select * from replies");
        if($q->num_rows() > 0) {
            foreach($q->result() as $row){
                $data[] = $row;
            }
            $q->free_result();      
        }
        return $data;
    }

and my controller
Code:
$comments = $this->data_model->getComments($commentID);

        // No longer need the if, since we know it's an array.
        foreach ($comments as &$comment)
        {
            $comment['reply'] = $this->data_model->getReply($comment->commentID);
        }
        
        $op['comments'] = $comments;          
        
        $this->layouts->view('articulos-template', $op);

View
Code:
&lt;?php foreach($comments as $row) :?&gt;
<p>&lt;?=$row->comment;?&gt;<p>
<h2>Reply</h2>
     &lt;?php foreach($reply as $rowReply) :?&gt;
     <p>&lt;?=$rowReply->reply;?&gt;<p>
     &lt;?php endforeach; ?&gt;
&lt;?php endforeach; ?&gt;

Can someone help me and let me know what i am doing wrong




Theme © iAndrew 2016 - Forum software by © MyBB