Zend_Db_Table result formatting

stm · #1 (**permalink**) 06-07-2008, 09:05 AM

Is it possible to write a function in my Zend_Db_Table class which will do all the formatting on a column in the result?
E.g.

PHP Code:


			
$users = new Users();
$result = $users->fetchAll();
// $result->created = 000000229233 (unix timestamp)
// $result->createdFormatted = Thurs 12 Feb 2008 (function from above)

Any advice would be greatly appreciated.

t-mow · #2 (**permalink**) 06-07-2008, 11:16 AM

Maybe you should use a view-helper (create one by yourself)...

stm · #3 (**permalink**) 06-10-2008, 11:46 PM

Thanks for the advice.

I could easily make a view helper but I was wondering if I could do it within the db_table function.

Can anyone confirm whether this is possible and give advice on a solution.

Davidoff · #4 (**permalink**) 07-04-2008, 11:26 PM

Use a custom Row class: Zend Framework: Documentation

You can override the __get method to call functions in your custom row class for properties that don't exist.

For example:

PHP Code:


			
//model

class User extends Zend_Db_Table_Abstract

{

    protected $_name = 'user';

//use custom row class

    protected $_rowClass = 'UserRow';

}



//custom row class

class UserRow extends Zend_Db_Table_Row_Abstract {



    function __get($key){

    

        if(method_exists($this, $key)){

            return $this->$key();

        }

        

        return parent::__get($key);

    }

    

    function fullname(){

        

        return $this->forename . ' ' . $this->lastname;

        

    }



}

In the above example, you'd be able to access a fullname property of rows, even though there is no fullname column.

PHP Code:


			
$fullname = $row->fullname;

jweber · #5 (**permalink**) 07-09-2008, 03:55 PM

What about doing it with SQL?

Code:

SELECT CONVERT(VARCHAR, created, 101) AS createdFormatted, ...

bennell · #6 (**permalink**) 07-15-2008, 05:58 PM

Another way would be to provide an init() method in your custom row class, to populate a member variable after the row is created.
Building on Davidoff's example:

PHP Code:


			
//custom row class

class UserRow extends Zend_Db_Table_Row_Abstract 

{

    public $fullname;



    public function init()

    {

        $this->fullname = $this->forename . ' ' . $this->lastname; 

    }

}

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