Tutorial : Using Zend Framework Without PDO

we have noticed a problem in the describetable and zend_db_table about primary keys. I’ll try to address the problem as soon as possible.

Thanks for understanding

-D

Any thoughts on expanding what you’ve got here to include the IBM DB2 extension.
PDO_ODBC will not work on the i5/os and I’m stumped as to how I would use the Zend Framework here to access DB2. I can’t be the only one.

Jeff

hello David Coallier, i’ve tested your work with the new zend frmk rc2 but it doesn’t work, because zend_loader and other mod…
Do you plan to make a new version for the new zend frmk ?

hello David Coallier, i’ve tested your work with the new zend frmk rc2 but it doesn’t work, because zend_loader and other mod…
Do you plan to make a new version for the new zend frmk ?

Everything has been fixed in SVN in order to work with RC2 and we are building tests. As soon as those are done, I’ll release

Thanks for your interest.

Hi, David,

Thanks for the tutorial first. It’s very useful. However, I didn’t get your code work with my ZF1.0.1 application. Does it support version 1.0.1? I went to your blog and tried to get the latest code from http://dev.agoraproduction.com/zend/. But the svn directory cannot be accessed. It says "Technical difficulties, runnnig on zend framework has its downside…".
Looking forward to your reply.

Dix Mars

this is a fix I have come up with that will allow fetchAll to correctly join dependant parent tables, so that fetchAll in fact bring back all related parent tables as it would in a normal LEFT JOIN query – the ZPDataJoiner can obviously be refined a lot more.

How to: create a class file from the below and include it in your table model class file, then instead of extending your table class with Zend_Db_Table_Abstract extend it with ZPDataJoiner, this will override the fetchAll() of Zend_Db_Table_Abstract.

require_once ‘Zend/Db/Table/Abstract.php’;

class ZPDataJoiner extends Zend_Db_Table_Abstract{

public function fetchAll($where = null, $order = null, $count = null, $offset = null) {

$select = $this->_db->select();

$select ->from(array(‘thistable’ => $this->_name))
->order($order)
->limit($offset, $count);

if (!is_null($where)) {
$select->where($where);
}

if (!empty($this->_referenceMap)) {

foreach($this->_referenceMap as $ruleName => $specs) {

if (isset($specs['columns']) && isset($specs['refColumns']) && isset($specs['refTableClass'])) {

if(isset($this->parentTables[$specs['refTableClass']])){
// echo $specs['columns'].’<hr>’;
$parTable = $this->parentTables[$specs['refTableClass']];
$parAlias = $ruleName;

$select->joinLeft(array($parAlias => $parTable),
‘thistable.’.$specs['columns'].’ = ‘.$parAlias.’.’.$specs['refColumns'],array(‘*’));

}

}

}

}

//$select->toString(); return false;
$stmt = $select->query();

$data = array(
‘table’ => $this,
‘data’ => $stmt->fetchAll(Zend_Db::FETCH_ASSOC),
‘rowClass’ => $this->_rowClass,
‘stored’ => true
);
//print_r($data['data']);
Zend_Loader::loadClass($this->_rowsetClass);
return new $this->_rowsetClass($data);

}
}

//example model class

class Cities extends ZPDataJoiner{
protected $_primary = array(‘city_id’);
protected $_name = ‘cities’;
protected $_dependentTables = array(‘departments’,'staff’);

/*the $parentTables is important array(tableclass=>actual_table_name)
it is used by ZPDataJoiner to resolve relationships
and I was to lazy to write a lookup that could use only the
$_referenceMap
*/
protected $parentTables = array(‘Countries’=>’countries’);

protected $_referenceMap = array(
‘CitiesToCountries’ => array(
‘columns’ => ‘country_id’,
‘refTableClass’ => ‘Countries’,
‘refColumns’ => ‘country_id’,
‘onDelete’ => ”,
‘onUpdate ‘ => ”
));

}

BTW guys I just put up a new release which should make it compatible with 1.0.z.

I also have put the webSVN back up (http://dev.agoraproduction.com/zend/svn)

Let me know if it’s ok, in theory it should be.

Thanks,

Link to release: http://dev.agoraproduction.com/zend/releases/Php-0.3.0.tar.gz

Seems your Db.php is not compatible with ZF 1.0.x. I did not find a new version within you Php-0.3.0.tar.gz file. Or am I missing something?

As I see you just forgot add function

public function getQuoteIdentifierSymbol()
{
return ‘`’;
}

to php/Mysql.php file.

By default I we got a ".

Anyway thank you, with this fix all works super!! cool!

Great stuff!!

But it seems the current release dosn’t work with the ZF 1.5. Can you please fix this, so new ZF users can use this great piece of code )

OK, that was fun – heh.

I’ve managed to (so far) get simple "fetchAll" working with Zend 1.6.1.

Here’s what I had to do:

All changes within db.php

Replace:
/**
* Zend
*/
require_once ‘Zend.php’;

/**
* Zend_Db_Exception
*/
require_once ‘Zend/Db/Exception.php’;

With:
/**
* @see Zend_Loader
*/
require_once ‘Zend/Loader.php’;

Add:
/**
* Use the INT_TYPE, BIGINT_TYPE, and FLOAT_TYPE with the quote() method.
*/
const INT_TYPE = 0;
const BIGINT_TYPE = 1;
const FLOAT_TYPE = 2;

… to the top of the Zend_Db declaration.

Replace:
Zend::loadClass($adapterName);

With:
@Zend_Loader::loadClass($adapterName);

Now I’ve only been working with this for about 30 minutes, I’m going against MySQL, so I have no idea if there are other gotchas waiting.

But at least I can now have Zend DB in an environment where MySQLi and PDO are not enabled. Thanks! (I hope you confirm/update the code soon.)

I have been in a situation where I have had to preserve several straight-sql non mysqli calls to maintain a codebase and used your classes to get by for a while.

I have had to patch many, many incompatibilities — one of the most orerous was the fact that Zend quotes its references, as in "Users"."first_name", which took a ton of regex to patch.

Further the Zend_Db_Adapter interface has many methods — fetchPair, FetchAssoc, etc., which are not supported here. (they require fetch() calls to objects that do not have them.

Its my opinion that while this is a well intended hack that serves you for a while, on a project with a significant lifespan you are more likely to save time by converting to mysqli or pdo_mysql (or any of the other zend-supported drivers) and mutate your code to work with the supported Zend libraries, than you are to use this library.

I appreciate the work you put in to meld these two codebases, but the work is incomplete, and you are really buying into a terminal path by using this library.

Dear David!

Your link http://dev.agoraproduction.com/zend/ isn’t opening, can You or someone who downloaded that PHP adapters put it to mirror?

Thank You!

SELECT * FROM emp WHERE ename=’smith’ AND id=520

please tell me how to implement this qury in zend frame work