ssrun

Hi,

I'm just wondering from those who have used PHP and MySQL in production environments, which DB access method they used and why. Is one preferred over the other?

The book (Web Database Applications with PHP and MySQL, O'Reilly) I'm following seems to be using MySQL over the PEAR DB extension for the most part but they occassionally switch in their examples.

tAK

Books from O'Reilly aim to teach, so it makes sense they would show you more than just one way.

Personally i think that the "average" web host (ie: the one everyone gets when they first start a website before they realise they shouldn't have cheaped out) is going to have the MySQL extensions enabled over the PEAR DB ones.

In the long run, just use whatever is most natural to you, that way you wont struggle to get it right, and the finished product will run a lot better.

Infinite Recursion

MySQL, just a personal preference.

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

DaWei

Pear DB isn't part of a MySQL/Pear DB choice. Pear DB is an abstraction layer that works with several DBs, MySQL included. I'm not totally convinced of the stability of Pear at this point, and I think you will find that Pear DB has been superseded by MDB2.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

pegasus001

I have recently been together with some friends learning together php from someone who is deep in the bussiness. In my opinion if you want to make money then most web pages use MySql so it is a kind of preriquisite of using the mysql, mysqli. If i am wrong on this one please correct me. When it comes to earning money i say, and my father taught me this : "if you can`t do what you like than like what you do". Hope this helps. Good Luck.

__________________
You never test the depth of a river with both feet.
The believer is happy. The doubter is wise.
Free speech carries with it some freedom to listen.
The next generation will always surpass the previous one. It`s one of the never ending cycles of life.

DaWei

I don't know what you said, but I respect your right to say it....

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

pegasus001

You are much much older than me so it is my duty to respect you although our opinions may vary. English is not my native english so i am sorry if what i wrote didnn`t make sense. Just forget it.

__________________
You never test the depth of a river with both feet.
The believer is happy. The doubter is wise.
Free speech carries with it some freedom to listen.
The next generation will always surpass the previous one. It`s one of the never ending cycles of life.