phppdo

Yii Framework Extensions

Popular Tags

phppdo PDO emulation library

Documentation
Change Log

This extension allow use PHPPDO library for emulate PDO functionality.

Sometimes hosting providers disable PDO wholly or PDO_ particularly. This extension allow you to use PHP-emulated PDO class on that hostings.

Resources ¶

Documentation ¶

Requirements ¶

Yii 1.0 or above

Installation ¶

Extract the release file under protected/extensions

Usage ¶

For use it add in config/main.php:

...
   'db'=>array(
      'class'=>'application.extensions.PHPPDO.CPdoDbConnection',
      'pdoClass' => 'PHPPDO',
      ...
      ),
   ...

Change Log ¶

Mar 7, 2010 ¶

PHPPDO version bump, thanks to rohit.

Sep 15, 2009 ¶

Fixed bug (PDO.php not found), thanks to Swarog.

June 15, 2009 ¶

Fixed bug, thanks to Ryuuzaki.

June 9, 2009 ¶

Fix for forced use of PHPPDO library: just add 'phpClass'=>'PHPPDO' db component parameter.

April 7, 2009 ¶

Initial release.

24 1

18 followers

5 206 downloads

Yii Version: 1.1

License: LGPL-3.0

Category: Database

Tags:

Developed by: Blake-R

Created on: Apr 7, 2009

Last updated: 14 years ago

Downloads

show all

User Contributed Notes 20

#231

1 0

helpful

some web hosting disabled PDO extension, and this extension emulates PDO very well. really helps me a lot. Thanks.

xhumanx at Aug 2, 2010, 1:38:47 AM

#694

0 0

Thank You

Need it.
my host's pdo is not available!

dongbeta at Mar 17, 2010, 11:36:05 AM

#750

0 0

Helped me a lot

On few hostings, pdo extension is not available! So, in that case this extension is very helpful.
The original classes have been upgraded from 1.2(which is used in this extension) to 1.4 by now. If the author of this extension does an upgrade it will be great. I just found, that only one class is for extension other files will just need update from original PHPPDO extension.
Good work. And very good example of extension!

rohit at Mar 6, 2010, 7:54:20 AM

#1228

0 0

太牛叉了。很实际的东西

very good!

zhouyang at Oct 20, 2009, 4:16:02 AM

#1436

1 0

Works great.

This extension is very good.

Unfortunately PDO_MYSQL is disabled here and this extesion emulates very good the the real PDO.

Ismael at Aug 3, 2009, 4:23:26 PM

#1456

0 1

Why?

I do not understand the sense of this extension - yii is based on pdo, so what does your extension? Please write more about it.

yingyang at Jul 30, 2009, 12:24:20 PM

#4386

2 0

but how to set in the config/main.php

i failed
'db'=>array(

		'class'=>'application.extensions.PHPPDO.phppdo',
		'pdoClass' => 'PHPPDO',			
		
		'connectionString' => 'mysql:host=localhost;dbname=yii',
		'emulatePrepare' => true,			
		'username' => 'root',
		'password' => '123456',
		'charset' => 'utf8',
		'tablePrefix'=> 'tbl_',			
	),

qijunz at Jul 4, 2011, 9:01:10 AM

#4457

1 0

Great

Solved a big problem for me. Thanks.

iamnotcoward at Jul 11, 2011, 2:33:21 AM

#5901

0 0

Thx :D

I had problems with the pdo_oci driver and this extension solved the problem :)

Iza at Nov 23, 2011, 7:53:23 PM

#10188

0 0

Los Amo

Los adoro, Gracias Dios por esta gran comunidad, me han solucionado un gran problema laboral, Gracias. Esta libreria funciona perfecto, emula muy bien los driver PDO que no estan habilitados en Hosting Mediocres pero que toca usarlos por motivos laborales.

Gracias

playdog at Oct 9, 2012, 10:45:34 PM

#10261

0 0

Awesome Extension

Thanks For This Awesome Extension.

Rajib Rakhmit at Oct 15, 2012, 5:15:40 PM

#11400

1 0

Bug in PHPPDO

It doesn't parse properly opertors like !=
I tried this statement:

UPDATE `item` SET `delivery_order_id`=NULL WHERE (id!=92) AND (delivery_order_id=32)

PHPPDO transforms it to

UPDATE `item` SET `delivery_order_id` = NULL  WHERE (id! = 92 ) AND (delivery_order_id = 31)

I found the line where the code is incorrect, but i can't change the source !
Need someone to move the project to GitHub

The bug is in PHPPDO/divers/base_statement.php line 851
You have to change

return implode(' ', $prepared);

return implode('', $prepared);

and it works

cnlevy at Jan 11, 2013, 10:59:48 AM

#11401

0 0

RE: Bug in PHPPDO

cnlevy, thank you.

Bugs in project PHPPDO firstly must be sent to it author. Contact can be found at http://sourceforge.net/projects/phppdo.

If author of PHPPDO doesn't answer or I'm loose new version, I'm try to find time for export project to github - just wait for some 'Thumb up' on this post.

I'm just more often use <> instead of != (hm... in fact, I'm never utilize !=).

Blake-R at Jan 11, 2013, 11:37:58 AM

#11418

0 0

RE: RE: Bug in PHPPDO

I also never did... until I started using

http://www.yiiframework.com/extension/activerecord-relation-behavior

which autogenerated this query

cnlevy at Jan 13, 2013, 7:48:25 AM

#14180

0 0

Possible to use PHPPDO in multi-db setup??

I have a project where I need to connect to both MySQL and MSSQL databases, but unfortunately the client's host cannot install PDO_DBLIB and hence to PDO for the MSSQL database... Is it possible to use phppdo in this context?? My thought was no, since the docs for multiple databases want you to put
'class'=>'CDbConnection' and your docs say to put 'class'=>'application.extensions.PHPPDO.CPdoDbConnection' so I figured that would be a problem.

Any suggestions?

Michael Sullivan at Jul 24, 2013, 7:38:14 PM

#14238

1 0

Works Great

awesome extension, thanks ... finally i solved my problem

Charly Rosero at Jul 29, 2013, 3:30:51 PM

#15965

0 0

thanks, for good extension !!

thank you, this is very good extension.

my app work fine in all php version without PDO :)

Hermans at Jan 5, 2014, 6:52:58 AM

#17425

0 0

Saved my skin!

It looks like you saved my skin with this, for a large project being migrated to Oracle. Is this extension still being updated/fixed, BTW?

MetaYii at Jun 10, 2014, 7:09:13 PM

#17426

0 0

RE: Is this extension still being updated/fixed?

MetaYii, I alive. But upstream project doesn't have any updates since 1.4.

Blake-R at Jun 11, 2014, 4:30:21 AM

#18629

0 0

Thanks

thankyou so much!

Juan David Rodriguez at Dec 3, 2014, 11:16:14 PM

Categories