Zend_Model is not there.?

murugesanme · #1 (**permalink**) 02-19-2008, 02:50 PM

Hai all,

I understood the Controller and the View Creation. But i could not identify the Model files in this ZFwork. can any one tell me how we can add this Model? and how we can call the function from there?

Thanks
Mugesh.

zamanphp · #2 (**permalink**) 02-25-2008, 02:18 PM

hi
you can create a model link following then save in path of your project/application/models :

PHP Code:


			
<?php

class Blog 

{

    private $db;

    

    public function __construct()

    {

        $this->db = Zend_Registry::get('db');

    }

    

    /**

     * Enter description here...

     *

     * @return object

     */

    public function fetchAllPosts()

    {

        $sql = 'SELECT 

                         p.post_id,

                         t.name, 

                         p.title,

                         p.body,

                         p.date,

                         p.date_modify,

                         p.hits,

                         p.allow_comment

                FROM post AS p,

                     tag AS t

                WHERE

                      p.tag_id=t.tag_id 

                ORDER BY post_id DESC';

        

        $this->db->setFetchMode(Zend_Db::FETCH_OBJ);

        $result = $this->db->fetchAll($sql);

        return $result;

    }



    //others methods

}

?>

now you can use this model vai following :

PHP Code:


			
<?php

class IndexController extends Zend_Controller_Action 

{

    public function init()

    {

        Zend_Loader::loadClass('Blog');

        $this->view->baseUrl = $this->_request->getBaseUrl();

    }

    

    public function indexAction()

    {

        $blog = new Blog();

        $this->view->title = "My Album";

        $this->view->posts = $blog->fetchAllPosts();

    }

}

Jhorra · #3 (**permalink**) 02-25-2008, 04:00 PM

You can just extend the db_table_abstract, but I find that zamanphp's method is much better. The one change I would make is that I create the db class from the registery at the top of my controller, then pass it as a reference to all my models. I would change the controller to this:

PHP Code:


			
<?php
class IndexController extends Zend_Controller_Action 
{
    public function init()
    {
        Zend_Loader::loadClass('Blog');
        $this->db = Zend_Registry::get('db'); 
        $this->view->baseUrl = $this->_request->getBaseUrl();
    }
    
    public function indexAction()
    {
        $blog = new Blog(&$this->db);
        $this->view->title = "My Album";
        $this->view->posts = $blog->fetchAllPosts();
    }
}

Which would change the model to this:

PHP Code:


			
<?php
class Blog 
{
    private $db;
    
    public function __construct($db)
    {
        $this->db = $db;
    }

    //Other methods
}

intregus · #4 (**permalink**) 03-13-2008, 10:19 PM

This is very helpful, thank you.

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