Now That I've Caught the Car

kebbelj

What does the car-chasing dog do with a car when he catches one?

I've got a similar problem. I have several Classes in a PHP 5 project accessing a MySQL database to initialize objects for that Class (among other things). I'm working my way through PHP5 Objects, Patterns, and Practice, and Zandstra recommends moving all the database-talking to its own Class.

With help from http://www.kitebird.com/articles/peardb.html#TOC_1 , I got my DB_Administrator Class connecting, executing a statement sent as a parameter , disconnecting from the database, and returning the results to the object that requested it.

I wanted the requesting object to process the data since the requests are so varied, but when I did a getClass() on what I was getting back, it was a DB_RESULT object. I've looked on the web, some PHP books I have at home, and this forum for guidance on how to extract my data from a DB_RESULT object, but nothing really clear turned up. Can anyone point me to a readable reference?

ahundiak

kebbelj wrote:
What does the car-chasing dog do with a car when he catches one?

Usually die.

kebbelj wrote:
I've got a similar problem. I have several Classes in a PHP 5 project accessing a MySQL database to initialize objects for that Class (among other things). I'm working my way through PHP5 Objects, Patterns, and Practice, and Zandstra recommends moving all the database-talking to its own Class.

With help from http://www.kitebird.com/articles/peardb.html#TOC_1 , I got my DB_Administrator Class connecting, executing a statement sent as a parameter , disconnecting from the database, and returning the results to the object that requested it.

I wanted the requesting object to process the data since the requests are so varied, but when I did a getClass() on what I was getting back, it was a DB_RESULT object. I've looked on the web, some PHP books I have at home, and this forum for guidance on how to extract my data from a DB_RESULT object, but nothing really clear turned up. Can anyone point me to a readable reference?

Have you gone through the tutorial on pera.php.net? You should also be aware that pear db is being replaced with mdb2. Though quite frankly I think you would be better off using PDO which is now built into PHP 5. Check the php manual for information.

kebbelj

I looked up mdb2 and PDO. You were right, PDO looked more promising. I tried

sudo pecl install PDO_MYSQL

but got this error message durng the install

 phpize: command not found

So I started searching for a solution to this error message. After a few minutes of searching, I realized the advantage of having a single method doing all the DB connections for my application made it easy to switch to PDO when I had the time to resolve the phpize error. In the meantime, I can continue development while I leisurely resolve the phpize problem.

That means I'm still stuck with the initial problem of cracking open a DB_RESULT object. How do I do this? Also, will PDO return a DB_RESULT?

ahundiak

Off to soccer. Don't have much time. If you are running PHP 5 then PDO should already by installed. Do a echo phpinfo() and check what you have. The PEAR site that I gave you shows how to use DB_Result. But PEAR is badly outdated.

kebbelj

PDO.
I directed the output from phpinfo() into a text file and did a search for PDO and phpize. Neither phrase was found.

phpize
Since I didn't detect PDO, I was back to the problem of installing it, which I can't do because of the phpize errror. Went back out on the web looking for some clear directions on fixing the phpize problem but didn't come across anything that gave me enough info to fix the problem.

DB_RESULT
I did go to the pear.php.net site, but found nothing about DB_RESULT that explained how to "unpack" a DB_RESULT. I've temporarily switched to using a two-dimensional array to return the data till I get PDO installed.

Thanks for the help you've offered so far.

halojoy

hi!

php_pdo.dll is an extension module
It is not enabled by default in PHP 5

Also, in this case, you need to load module pdo_mysql.dll

php.ini

extension=php_pdo.dll <- uncomment
;extension=php_pdo_firebird.dll
;extension=php_pdo_mssql.dll
extension=php_pdo_mysql.dll <- uncomment
;extension=php_pdo_oci.dll
;extension=php_pdo_oci8.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll

In Linux you should compile php
--with pdo
and
--with pdo_mysql
( I dont know the exact syntax )

[man]pdo[/man]

this is to enable pdo_sqlite

#

./configure --with-zlib --enable-pdo=shared --with-pdo-sqlite=shared --with-sqlite=shared

After installing PDO as a shared module, you must edit your php.ini file so that the PDO extension will be loaded automatically when PHP runs.

kebbelj

I use Linux, but I am in no way a Linux guru. Can I run

./configure --with-zlib --enable-pdo=shared --with-pdo-sqlite=shared --with-sqlite=shared

on an existing installation (PHP 5.1.2 is already up and running on my Ubuntu Linux system) or do I need to download and compile a 5.1.2 tar file, before configuring it per your instructions?