How do i get the value from array and assign to view in zend frame work

Question

iam executing a stored procedure in php and iam returning an array ["record"]=> array(1175) { [0]=> array(20) { ["Col1"]=> string(1) "Mode" ["col2"]=> string(16) "type" } }

how do i get the col1 and col2 values from the array and assign it to the view .what should i say $view-.results = $result_val['record']; $view->col1 = ???? $view->col2 = ????

Answer 1

From the controller you assign data to the view using:

$this->view->myData = "something";

Then in the view phtml file:

echo $this->myData;

So in the controller its $this->view and in the view its $this.

In your case assuming your array is called $records:

$this->view->records = $records;

then in your view:

foreach($records as $record){
   echo 'Col1 = ' . $record['Col1']. "<BR />";
   echo 'Col2 = ' . $record['Col2']. "<BR />";
}

Hope this helps.

Answer 2

In the Controller:

$this->view->record=$record[0]

In the View:

echo $this->record["col1"]
echo $this->record["col2"]