Geek asks and answers

How to pass the result of a recursive function to view

I use only the controller and view.
using the following code, I display a message and a response message.
I used the following controller and View to display the message and response.

Using query 1, I select the post for the topic id (eg.topic id = 34) from the mail table and using this get post id 30 and 31.

Using query 2, I select the response for each message identifier from the response table.
let's say message id 30 with response id 1 and
  message id 31 with response ID 2.

using the 2nd loop, I choose if any answer has anothr response using the parent_id column from the answer table. (use the showreply () function recursive call)

I am stuck in the way I pass the result from the showreply () recursive function.

Using my code, I say:

Post 30
 --- first reply for message 30
message 31
 --- response for message 31

but I want to show how.

Post 30
 --- first response for message 30
 --- response to first response
message 31
 --- first response for message 31
 --- response to first response

I used a recursive function call to get the response for the response using the parent id, but I don’t understand how to pass this for viewing.

Controller:

   <?php
public function viewpost()
    {  
        //Query 1

        $topicid = trim($this->input->get('topicid'));
        $q =$this->db->select(array(
            'fp.id as id',
            'fp.postdata',
            'fp.topicid'))
            ->from('forum_post AS fp')
            ->where('fp.topicid',$topicid)
            ->order_by('fp.id DESC')->limit(0,10)->get();

        $resultq1 = $q->result_array();
        $data['resultq1'] = $resultq1;

        //$data['resultq1'] = $res;
        $resultq2 = array();
        foreach ($resultq1 as $rec)
        {
            //Query 2

            $postid = $rec['id'];
             $q1 =$this->db->select(array(
                'fr.id as id',
                'fr.reply_data'))
                ->from('forum_reply AS fr')
                ->where('fr.postid',$postid)
                ->order_by('fr.id ')->get();

            $resultq2[$postid] = $q1->result_array();
            $data["resultq2"][$postid] = $resultq2[$postid];

            foreach($q1->result_array() as $row1)
            {

                //second for loop

                  $reply_id = $row1['id'];
                  $resultq3[$reply_id] = $this->showreply($reply_id); // call to function
                  $data["resultq3"] = $resultq3[$reply_id];


            }//inner for loop
        } //outer for loop

        $this->load->view('viewpost',$data);
    }

    public function showreply($reply_id)
    {

                    $reply_id1 = $reply_id;
                     $q1 =$this->db->select(array(
                        'fr.id as id',
                        'fr.reply_data',
                        'fr.parent_id'))
                        ->from('forum_reply AS fr')
                        ->where('fr.parent_id',$reply_id1)
                        ->order_by('fr.id ')->get();

                        //print $this->db->last_query();
                         $resultq4[$reply_id1] = $q1->result_array();
                         $data["resultq4"]= $resultq4[$reply_id1];

                        $i=0;
                        foreach($q1->result_array() as $row4)
                         { 
                                print_r($q1->result_array());
                                echo "id".$id = $row4['id'];
                                $parent_id = $row4['parent_id'];
                                if($parent_id!=0)
                                {  
                                    //$data['nested'][$i] = $q1->result_array();
                                    $this->showreply($id);  //recursive call to function                        
                                    $i++;
                                }
                         }

            return  $resultq4;
    }
?>

Table structure for response table:

Rep_id    rep_text                       post_id     Parent_ID
-------------------------------------------------------------------------
  1         Reply for post 30              30           null
  2         Reply for post 31              31           null
  3         reply to Rep_id 1              null           1
  4         Rep_id 3 have Rep_id 4         null           3
  5         Reply for post 31              null           2
  6         Reply for Rep_id 5             null           5

----------------------------------------------------------------------------

Message table

post_id  topic id   post_title   post_desc 
-----------------------------------------
  30       34         xyz         sssss
  31       34         pqr         tyyyu

----------------------------------------

* View: *

<div>
    <?php foreach($resultq1 as $row)
    {  ?> 
       <ul>
            <li></li>      // used to display post
      </ul>
    <?php foreach($resultq2 as $rows)
    {
        foreach($rows as $row1)
        {
            if($row['id']==$row1['postid'])
            {   ?>
            <ul>
              <li></li>      // used to display reyly for post 
            </ul>
           <?php foreach($resultq3 as $rows)
            {
                foreach($rows as $row2)
                { 
                  if($row1['id']==$row2['parent_id'])
                {   ?>
                    <ul>
                       <li></li>   // used to display reply for reply
                    </ul>
                 <?php     
                 }//if 
                } //inner for  $row2
            } // outr for $resultq3 
          } //if
        } //inner for of $row1
      }//outer for $resultq2
    } ?>
    </div>
+5
source share
2 answers

, :( .

:

ID    type    title    content  parent_id    post_id
1    post      xyx      asd       Null        1
2    comment    asd     DEMO      1           1
2    comment    com     DEMO2     2           1

, ,

1

( [, ])

a parent_id, .

post_id, .

, ,

$post = $this->db->select('*')->where('post_id',$post_id)->get('posts');

now $post .

db, , , -

$post = $this->db->select('*')->where('post_id',$post_id)->get('posts');

if($post->num_rows==0)return false;//end if there is no post found

//step 1 find main post
$main_post=FALSE;
foreach($post as $fp){
if($fp->type=='post')$main_post=array ('id'=>$fp->id,'title'=>$fp->title,'content'=>$fp->content);
}

if($main_post==false)return false;///THERE WAS NO MAIN POST FOUND !!!

//step 2 get comments on post

$comments=array();

foreach($post as $fp){
if($fp->type=='comment' && $fp->parent_id==$main_post['id']){
$comment[$fp->id]=array('title'=>$fp->title,'content'=>$fp->content,'child'=>array());
}
}

//step 3 comments of a comment

//IF comment is not on parent so its on another comment right :) !
foreach($post as $fp){
if($fp->type=='comment' && $fp->parent_id != $main_post['id']){
$comment[$fp->parent_id]['child'][]=array('title'=>$fp->title,'content'=>$fp->content);
}
}

inisde $comment var, $main_post:)

<h2><?=$main_post['title']?></h2>
<div class='fp_post'>
<?=$main_post['post']?>
</div>
<ul class='comments'>

<?
foreach($comment as $c){
echo "<li> $c['title'] : $c['content']";

if(!empty($c['comment'])){
//there is a comments on this comment :)
echo "<ul>";
foreach($c['comment'] as $coc){echo "<li> $coc['title']: $coc['content']</li>";}
echo "</ul>";//end of comment of comments
}
echo "</li>"//end of a comment and its comments

}

?>
</ul>

, , , , , try_catch , false , .

, :)

cheerz

+2

:

MVC aproach, db .

, . , , .:

<?php
public function viewpost()
{  
     //Query 1

     $topicid = trim($this->input->get('topicid'));
     $q =$this->db->select(array(
          'fp.id as id',
          'fp.postdata',
          'fp.topicid'))
           ->from('forum_post AS fp')
           ->where('fp.topicid',$topicid)
           ->order_by('fp.id DESC')->limit(0,10)->get();
     //$data['resultq1'] = $res;
     $resultq2 = array();
     if($q->num_rows() > 0) 
     {
            $resultq1 = $q->result_array();
            foreach ($resultq1 as $rec)
            {
                //Query 2

                $postid = $rec['id'];
                $q1 =$this->db->select(array(
                    'fr.id as id',
                    'fr.reply_data'))
                    ->from('forum_reply AS fr')
                    ->where('fr.postid',$postid)
                    ->order_by('fr.id ')->get();

            // the rest of your code

     }

     // the rest of your code

, , ( ):

-

-

-

-

<div>
<?php
if($resultq1) 
{
   echo '<ul>';
   foreach($resultq1 as $row)
   { 
      echo '<li>';      
      echo $row;// used to display post
      if(resultq2)
      { 
         echo '<ul>';
         foreach($resultq2 as $rows)
         {
             echo '<li>';
             echo $rows; // display reply to post
             echo '</li>';
             if($resultq3)
             {
                foreach($resultq3 as $row1)
                {
                    echo '<li>';
                    echo $row1; // display reply to reply
                    echo '</li>';
                }
             }
          }
          echo '</ul>';
       }
       echo '</li>';
    }
    echo '</ul>';
  }
  </div>

, , .

+2

More articles:


All Articles