Zend_Db_Table results problem

tru · #1 (**permalink**) 07-21-2008, 02:46 PM

As I'm new, hello to every user of this forum!

This is my code
(controller)

PHP Code:


			
public function indexAction()

{

    $table = new Users();

        

    $rows = $table->getAllUsers();

}

class Users extends Zend_Db_Table_Abstract

{

    protected $_name = 'users';

    protected $_primary = 'id';

    

    public function getAllUsers() {

        return $this->fetchAll()->toArray();

    }

}

(view)

PHP Code:


			
<table border="1">  

    <tr>  

      <th>ID</th>  

      <th>Login</th>        

      <th>Password</th>       

      <th>E-mail</th>        

      <th>Action</th>       

    </tr>  

  <?php $rows = $this->rows; 

  foreach ($rows as $key => $user) { ?>  

    <tr>  

      <td><?=$user['id']?></td>      

      <td><?=$user['login']?></td>  

      <td><?=$user['password']?></td>        

      <td><?=$user['email']?></td>     

      <td>  

        <a href="edit/id/<?=$user['id']?>">Edit</a>  

        |  

        <a href="del/id/<?=$user['id']?>">Delete</a>         

      </td>     

    </tr>   

  <? } ?>  

</table>

When I run the script the following error occures

Code:

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\zend\application\views\scripts\user\index.phtml on line 21

What's wrong with my script?

Tekerson · #2 (**permalink**) 07-22-2008, 01:00 AM

You're not assigning the $rows variable to the view. In the controller you need to do.

Code:

$this->view->rows = $table->getAllUsers();

at the moment you're only assigning it to a local variable.

tru · #3 (**permalink**) 07-22-2008, 11:23 AM

Jesus Christ, you're awesome!
THANKS!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode