adodb database connection (mysqli driver)

A programmer I hired wants to connect mysql to php
http://adodb.sourceforge.net/

Are the chosen drivers mysqli and mysql (soon to be deprecated)?

I see that there is error reporting is included with adodb.

I have asked previous questions about error reporting with mysqli which requires a developer to create custom classes.

When I suggest adodb, experts on experts exchange suggest using mysqli or pdo,

but I can use adodb and mysqli
LVL 1
rgb192Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
According to that page, that particular 'ADOdb' library uses one of the existing drivers like 'mysqli' to connect to the database.  Note that that isn't the same as Microsoft ADODB which is what I thought you were asking about.

That particular 'ADOdb' library adds a layer of abstraction on top of the actual driver.  Looks similar to the PDO concept where they are trying to make all the databases look the same.
0
Ray PaseurCommented:
All things being equal, why not just use PDO?  I don't see the advantage in ADODB.
0
rgb192Author Commented:
>>That particular 'ADOdb' library adds a layer of abstraction on top of the actual driver.  Looks similar to the PDO concept where they are trying to make all the databases look the same.

So I ADOdb missing any important features?


>>All things being equal, why not just use PDO?  I don't see the advantage in ADODB.

Programmer suggests that using ADODB is easier for him and I have delayed that part of the project days.

Is there a disadvantage?
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

Ray PaseurCommented:
Well, this is going to sound like a cop-out response. It's always easier to ride the horse in the direction he is going.  If your programmer prefers ADODB, then maybe your programmer should direct the development toward ADODB.  It's not for me to say which path is going to create the best business result.  It might be useful to consider the idea of an abstraction layer over the database.  (Do NOT use a singleton, which is as "code smell" as a global).  The abstraction layer would give you a way to "swap out" one method of running queries and "swap in" another method.  If, a year or two from now, your programmer was right, so much the better!  If you programmer was off-target, the abstraction layer will let you get back on target at minimal cost.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dave BaldwinFixer of ProblemsCommented:
So I ADOdb missing any important features?
Since I have never used that library, I don't know.

A related question is that developer going to be around to support his code or is he going to be gone when the project is done?
0
rgb192Author Commented:
Note that that isn't the same as Microsoft ADODB which is what I thought you were asking about.

I thought it was mssql initially also.

A related question is that developer going to be around to support his code or is he going to be gone when the project is done?

thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.