View difference between Paste ID: ajPawCWL and pYqCfcBW
SHOW: | | - or go back to the newest paste.
1
<?php
2
3
class Application_Model_Albums extends Zend_Db_Table_Abstract
4
{
5-
	protected $bootstrap;
5+
	protected $_name = 'albums';
6-
	protected $db;
6+
	protected $_primary = 'id';
7-
	//protected $_name = 'albulms';
7+
8-
	//protected $_primary = 'id';
8+
}
9
10-
	//public $db;
10+
class Application_Model_Album
11
{
12
13-
	function __construct(){
13+
14-
		
14+
15-
    	  /*$this->db = Zend_Db::factory('Pdo_Mysql', array(
15+
16-
												'host'
16+
		$albums = new Application_Model_Albums();
17-
												=> 'localhost',
17+
                $albumList = $albums->fetchAll(
18-
												'username' => 'root',
18+
			$albums->select()
19-
												'password' => 'monkey12',
19+
				     ->where('id > ?', 1)
20-
												'dbname'
20+
		);
21-
												=> 'zend_test'));
21+
		return $albumList;
22-
		$this->db = $resource->getDbAdapter();*/
22+
23-
		$this->bootstrap = Zend_Controller_Front::getInstance()->getParam('bootstrap');
23+
24-
		$this->db = $this->bootstrap->getResource('db');
24+
class AlbumsController extends Zend_Controller_Action
25
{
26
	public function testAction()
27
        {
28
		$albums = new Application_Model_Album();
29
                $this->view->results = $albums->getAlbums();
30-
		/*$sql = 'SELECT * FROM albulms';
30+
31-
        $results = $this->db->fetchAll($sql);
31+
}
32-
        return $results;*/
32+
33-
        
33+