Categories
Zend Framework 1.12

Zend Executing a straight SQL query without a Model

How to Execute a straight SQL query without the hassle of a model. #application/controlers/MyController.php I assume the Database is setup in the config file, Application.ini. $dbAdapter = Zend_Db_Table::getDefaultAdapter(); $sql =’SELECT * FROM users WHERE id > 23′; $statement = $dbAdapter->query($sql); $row = $statement->fetch(); if ($arr[‘id’] == 45) $this->view->response = ‘yes’; else $this->view->response = ‘no’; If […]

Categories
PHP 5 Zend Framework 1.12

New Year, New Dates on your Copyright Footer of your Website

It’s a New Year That means Instead of Saying 2014 on the bottom of your website it says 2014. copyright (c) 2013 Mysite.co.za Well here’s how to make that line dynamic so you need not change it again Zend: <?php $date = new Zend_Date(); echo $date->get(Zend_Date::YEAR); ?> PHP: echo date(“Y”);

Categories
Zend Framework 1.12

Zend_form populate() not working?

Zend_form populate() not working Below are a few reasons and a method for correcting: Zend_form populate() not working 1. Get the record used to populate $myModel = new Model_My(); $id = $this->_request->getparam(‘id’); $record = $myModel->find($id)->current(); 2. Make Sure is the form of key value pairs array Zend_Debug::dump($record->toArray()); 3. Make Sure you are calling correctly $frmResource […]