configuring zend application for postgres

Question

I always used Application_Model_DbTable to work with database, but I used MySql. I configured my application.ini like this:

resources.db.adapter = PDO_MYSQL 
resources.db.params.host = localhost
resources.db.params.username = admin    
resources.db.params.password = 12345
resources.db.params.dbname = daedu
resources.db.params.charset = utf8

and used standart functions of dbtable such as fetchAll or insert. How to have same result, but with PostgreSQL?

I've installed PostgreSQL and through pgAdmin III I already made database and tables. The problem is how to connect it to Zend using db-table?

I configured it like this:

resources.db.adapter = PDO_PGSQL 
resources.db.params.host = localhost
resources.db.params.port = 5432
resources.db.params.username = postgres 
resources.db.params.password = 12345
resources.db.params.dbname = postgres
resources.db.params.charset = utf8

I work with it through dbtable like this:

class Application_Model_DbTable_Postrgres extends Zend_Db_Table_Abstract
{
    protected $_name = 'postgres';

    public function insert(){
        $data = array(
            'name' => "dan"
        );

        $this->insert($data);
    }
}

in Controller:

$f = new Application_Model_DbTable_Postrgres();
$f->insert();

but page doesnot open (error is: net::ERR_EMPTY_RESPONSE) and there is no new insert in table, when I try to fetchAll in db table, I get application error.

personman · Accepted Answer · 2013-01-04 21:19:03Z

1

resources.db.adapter = PDO_PGSQL

You'll need to have PDO_PGSQL installed.

answered Jan 4, 2013 at 21:19

personman

659 bronze badges

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

Comments

Mark Okhman · Accepted Answer · 2013-01-05 17:12:29Z

1

Solved the problem! How? I turned on the development mode in public/index.php file:

// Define application environment
defined('APPLICATION_ENV')
    || define('APPLICATION_ENV', (getenv('APPLICATION_ENV') ? getenv('APPLICATION_ENV') : 'development'));

The error was shown that there is not Prymary Key in my table. I added it with SQl and threr it is! Everything works! So this way of connecting Zend to PostgreSQL is fully right!

answered Jan 5, 2013 at 17:12

Mark Okhman

1052 silver badges11 bronze badges

Collectives™ on Stack Overflow

configuring zend application for postgres

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related