Zend Framework won't connect to MySQL database

Question

I am starting a new project in work and using my preferred setup of PHP Zend Framework and a MySQL database.

For some reason I can't setup the Zend_Db_Adapter correctly so it will connect to the database successfully. I've setup my database in MySQL and can connect to it using mysql_connect(), but not with the code I've used from past projects? It's really strange!

Here is the code I'm using...

require_once 'Zend/Registry.php';
require_once 'Zend/Db/Adapter/Pdo/Mysql.php';

// Set the database connection information
$params = array('host' =>'localhost',
                'username'  =>'root',
                'password'  =>'12345',
                'dbname'    =>'testdb');

// Assign the database connection to the registry
$db = new Zend_Db_Adapter_Pdo_Mysql($params);
$db->setFetchMode(Zend_Db::FETCH_OBJ);
Zend_Registry::set('db',$db);

Please remember the above parameters work perfectly when I use mysql_connect(), but I get a controller exception error whenever I try using the above?

it's version 1.12.0 - pretty sure i've tried Zend_Db_Factory but will try again. thanks — smclintock
– smclintock, Commented Sep 17, 2012 at 22:45
If not solved, what is the controller exception error? Can you trap and display? — Robbie
– Robbie, Commented Sep 18, 2012 at 0:27
Could you put a die; at the end of each line to find out which line is throwing the exception? — Richard Parnaby-King
– Richard Parnaby-King, Commented Sep 18, 2012 at 9:52
You should specify your connection parameters in application.ini. — vascowhite
– vascowhite, Commented Sep 19, 2012 at 7:58

Michael · Accepted Answer · 2012-09-27 19:30:15Z

1

Try to use application.ini approach:

resources.db.adapter = "pdo_mysql"
resources.db.params.host = "localhost"
resources.db.params.username = "root"
resources.db.params.password = "12345"
resources.db.params.dbname = "testdb"

Then, if you want to connect in bootstrap, you can do it manually (bootstrap will call it eventually itself):

$this->bootstrap('db');

And then access $db adapter:

$db = Zend_Db_Table::getDefaultAdapter();

Anyway if you prefer your approach, send us more data about exception.

answered Sep 27, 2012 at 19:30

Michael

1,38711 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Zend Framework won't connect to MySQL database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related