Page 4 - Accessing Databases with Class

May be you must not compile it.
Look for php_oracle.dll in php/extension dir.
If you find it, only uncomment
;extension=php_oracle.dll
in php.ini and restart apache.

Let me know what happens ;)

This article was a decent short synopsis of PHP class syntax even for experienced OO architects unfamiliar with PHP

I have Redhat linux 6.2 box (i386), on its able run .php3 files.
I hope, this php environment has come default with Linux installation.

Now I would write PHP scripts to connect the MySQL database.
So, what are php-MySQL modules, which version do I need to install on this Linux box?

Where do I get the compatable php-mysql modules?

Becuase, I have tried with
php-mysql-4.0.5-3.i386.rpm

It's giving following error:

only packages with major numbers <= 3 are supported by this version of RPM
error: php-mysql-4.0.5-3.i386.rpm cannot be installed


Please help me in this regard.

I would be thankfull for help.

-SubbaReddy
msubbareddy@mailcity.com

I don't have a formal software engineering academic, however I've been programming professionally for several years- php for over 1.5. However, I've never really been able to realize the power for object oriented programming. Most of my applications were written solely by me, and as long as I organized my libraries I found my code to be pretty scalable and reusable. However, this article with the example of mounting directories finally hit home. This is a great article. Thank you!!

TO the Author,
Thanks for taking the time to wirte this tutorial. It has helped me get over a serious hump...

I used class DB_Sql on my localhost and it works fine.
When using it on a web server, I get

"
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /db_mysql.inc on line 66

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /db_mysql.inc on line 73
"

the call is

$query = "select ...";
$db->query($query);
if (!$db->next_record()) {
do {
..
} while ($db->next_record());

Any idea ?

Thanks

Accessing Databases with Class

June 14, 1999 - PHP offers a large number of native interfaces to database servers from different vendors. All of them are accessed in a similar, but subtly different way, which has its reason in the differences of the underlying C API and in the historic development of PHP's database support. In this article, you will learn how to create an easier interface to SQL databases by employing the class and object features of PHP.

Please discuss this article in this thread. You can read the article here .

If you would like to see an article covering a particular topic, please post your request here.