Advice needed in making a CakePHP Helper

Question

I need to make a CakePHP helper which involves making some HTML dynamically. But the part of the code is to make 1-2 database queries. These queries are very essential for this helper as all the text it populates is inside the database.

According to MVC pattern, i should not be making the DB queries in the View (Helper). I am wondering what the best design would be for this case as i want it to align with PHPUnit testing also.

Any ideas would be welcome...

score 2 · Accepted Answer · answered Oct 10 '12 at 18:43

2

Since the View job is purely to display the (already available) information passed to it from the Controller, I think it would be something like this:

Your controller:

public function foo() {
    $bar = $this->MyModel->find('all');
    $this->set(array('bar' => $bar));
}

Your view:

$result = $this->MyHelper->foo($bar);

answered Oct 10 '12 at 18:43

Paulo Rodrigues

5,273
7
35
58

Sounds good Paulo...That looks like a viable solution. What i am thinking is that the Database queries will go in the Model in a function. This function will be called in the controller, and output will be passed to the helper. This way, while testing the Helper, i can mock the model function, and pass it the data i want in order to make the Unit test independent of the Model. – abhi.gupta200297 Oct 10 '12 at 21:05

score 1 · Answer 2 · answered Oct 10 '12 at 19:29

1

You can create a component:

/**
* Set data info
* @access public
* @return void
*/
public function setData()
{
   $data = $this->Model->find('first', $params);
   $this->Controller->set('data', $data);
}

And print the helper in the layout:

echo $this->MyNewHelper->someHtml($data);

answered Oct 10 '12 at 19:29

aarkerio

2,183
2
20
34

1

A Component is a bad place to handle data because they are tied to Controllers. Should be done in the Model and passed along to the View. Your example also doesn't show an actual component. – Kyle Robinson Young Oct 10 '12 at 20:11

score 0 · Answer 3 · answered Oct 10 '12 at 22:42

If it's something that could be an Element instead of a Helper, you can use CakePHP's RequestAction [details here] to pull the data needed for the Element.

You can then pass any parameters to the Element, and use those to pass to your controller, which does the model call.

This fits very well with MVC, as the Element only displays the view, but it specifies where it should get it's data (still using the model to retrieve it), which makes it very re-usable.

Advice needed in making a CakePHP Helper

3 Answers3