Fetch data from data base table in zend framework

Question

I am new to zend framework and in the process of learning. I want to know that how we can fetch whole data of a table in zend framework and display it on the screen. I saw lots of tutorials but can't understand the logic behind this.

If someone can give me small tutorial regarding this that would be very helpful.

I am using these classes

Model

Application_Model_DbTable_Form extends Zend_Db_Table_Abstract{

        protected $_name = 'register';
        protected $_primary = 'firstName';

}

class Application_Model_Sign {

    private $_dbTable;

    public function __construct() {
        $this->_dbTable = new Application_Model_DbTable_Form();
    }
}

Controller

public function outAction() {
 //action body
}

View

<html>
    <body>
        <table>
            <tr>                  
                <th>First Name</th>
                <th>Middle Name</th>
                <th>Last Name</th>
                <th>Gender</th>
                <th>Job Type</th>
            </tr>  
        </table>
    </body>
</html>

liyakat · Accepted Answer · 2013-09-10 07:09:07Z

1

here i can give you sample tutorial for that you can easily understand how can we manipulate data in zend framework

http://akrabat.com/zend-framework-tutorial/

just download and install in you local.

also see

http://mishrarakesh.blogspot.in/2010/12/zend-framework-111-simple-examples.html

for better understanding.

hope this will sure help you.

answered Sep 10, 2013 at 7:09

liyakat

11.9k2 gold badges42 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ram Pukar · Accepted Answer · 2018-06-10 04:02:02Z

:: Model

class Default_Model_Deployment extends Zend_Db_Table_Abstract { 
    protected $_name = 'tbl_deployment';
    protected $_primary = 'id';
    public function allData(){
        $db = Zend_Db_Table::getDefaultAdapter();
        $sql = "SELECT * FROM tbl_deployment";
        $result = $db->query($sql);
        $row = $result->fetchAll(); // TO RENDER ALL DATA IN TABLE.
        return $row;
    }
}

:: Controller

class Default_DeploymentController extends Zend_Controller_Action {
  public function indexAction(){
    $model = new Default_Model_Deployment();
    $renderData = $model->allData();
    $this->view->assign(array('recDeploy'=>$renderData));
  }
} // To close class

:: View

print '<pre>';print_r($this->recDeploy);print '</pre>';die;

Ajith S · Accepted Answer · 2013-09-10 07:11:28Z

0

Please check this links

Hope this will help you as a begginner

The first link tells you the proper folder structure of Zend MVC

edited Sep 10, 2013 at 7:11

answered Sep 10, 2013 at 7:06

Ajith S

2,9172 gold badges20 silver badges30 bronze badges

Collectives™ on Stack Overflow

Fetch data from data base table in zend framework

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related