CakePhp multiple table data fetch on single page

Question

I am new in cakePHP try to create a blog site where user add blog after category select, I have one categories table : fields: category_id, name and posts table : fields : id, category_id , title, body. I want to fetch all categories to a dropdown list. When user add new post they have to select category first then he is able to post anything..

My PostsController:

<?php 


class PostsController extends AppController{



    public $helpers = array('Html', 'Form', 'Session');
    public $components = array('Session','Paginator');

    public function index(){

        $this->Paginator->setting = array(
            'limit' =>'10',
            'order' => array('Post.id' =>'Desc')
            /*'conditions' => array(
                'Post.user_id' => AuthComponent::user(id)
                )*/
            ); 

        $arrPosts = $this->Paginator->paginate('Post');

        $this->set('posts', $arrPosts);

    }

    public function view($id = null){

        if(!$id){

            throw new NotFoundException(__("Error Processing Request ID"));

        }
        $post =$this->Post->findById($id);
        if(!$post){

            throw new NotFoundException(__("Error Processing Request POST"));

        }
        $this->set('post',$post);   
    }

    public function add(){

         // HERE I want to fetch all categoryies from categories table and want to send to view

        if($this->request->is('post')){

            $this->Post->create();
            if($this->Post->save($this->request->data)){
                $this->Session->setFlash(__('Blog Posted Sucessfully'));
                return $this->redirect(array('action' => 'index'));
            }else{
                $this->Session->setFlash(__('Unable to Post Blog '));
            }
        }


    }
}
?>

I want to show my category in add form:

Please help me ...

drmonkeyninja · Accepted Answer · 2015-05-20 13:16:04Z

1

In your controller action you need to use $this->set() to set a View variable. As long as you've got your associations setup correctly in your Post model you should then be able to use:-

$this->set('categories', $this->Post->Category->find('list'));

Cake's FormHelper should automatically know that the Post.category_id form field wants to be a select input with $categories as the options.

One further point, it would be better to set the view variables after processing the form as you won't need them if it saves correctly and so can reduce the number of database queries by 1.

If you use find('all') to retrieve the categories you will need to convert it into the format used by find('list') which can easily be done using Hash::combine():-

$categories = $this->Post->Category->find('all');
$this->set(
    'categories', 
    Hash::combine($categories, '{n}.Category.id', '{n}.Category.name')
);

The only real value in doing this is if you need $categories for something else.

edited May 20, 2015 at 13:16

answered May 20, 2015 at 10:48

drmonkeyninja

8,5404 gold badges35 silver badges59 bronze badges

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

3 Comments

Rahul Saxena Over a year ago

But i want to print it using find('all'); ** $this->set('categories', $this->Post->Category->find('all'));**

drmonkeyninja Over a year ago

If you're using find('all') you won't get the data in the correct form for the form helper. I've updated my answer to show you how you can use find('all') and correct the format.

ndm Over a year ago

@RahulSaxena Wanting to do something one way, and doing something the right way, is often mutually exclusive, just like in this case, there's no reason to use an all find, from looking at your question it makes absolutely no sense.

Ashutosh Singh · Accepted Answer · 2015-05-20 12:40:08Z

0

public function add(){

  /*Here get the category list & set the view (ctp file)*/
 $this->set('categories', $this->Post->Category->find('list'));

    if($this->request->is('post')){

        $this->Post->create();
        if($this->Post->save($this->request->data)){
            $this->Session->setFlash(__('Blog Posted Sucessfully'));
            return $this->redirect(array('action' => 'index'));
        }else{
            $this->Session->setFlash(__('Unable to Post Blog '));
        }
    }

}

//Set The dropdown in ctp file
$this->Form->input('category_id', array('type'=>'select', 'options'=>'categories'));

edited May 20, 2015 at 12:40

answered May 20, 2015 at 12:37

Ashutosh Singh

561 silver badge7 bronze badges

1 Comment

Rahul Saxena Over a year ago

i am using find('all') hence it return array like array( (int) 0 => array( 'Category' => array( 'category_id' => '1', 'name' => 'Php' ) ), (int) 1 => array( 'Category' => array( 'category_id' => '3', 'name' => 'Ajax' ) ) } how to print it?

Collectives™ on Stack Overflow

CakePhp multiple table data fetch on single page

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related