Is PDO an abstraction layer? [message #178987] |
Sat, 01 September 2012 01:00 |
Burnsy
Messages: 2 Registered: March 2012
Karma: 0
|
Junior Member |
|
|
What's going on folks. I'm trying to wrap my brain around just what PDO
is. Is it a database abstraction layer like ADOdb? Or is it just a
method to simplify access to the sql databases out there? Or is it
something else all together?
I've been working on a project and decided to use ADOdb before PDO was
available. I'm at a point where I'm looking into other options for my
database access, and where PDO fits into this scheme of things eludes me.
Thanks ahead of time for any input you may have.
|
|
|
Re: Is PDO an abstraction layer? [message #178989 is a reply to message #178987] |
Sat, 01 September 2012 02:05 |
Jerry Stuckle
Messages: 2598 Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 8/31/2012 9:00 PM, Burnsy wrote:
> What's going on folks. I'm trying to wrap my brain around just what PDO
> is. Is it a database abstraction layer like ADOdb? Or is it just a
> method to simplify access to the sql databases out there? Or is it
> something else all together?
>
> I've been working on a project and decided to use ADOdb before PDO was
> available. I'm at a point where I'm looking into other options for my
> database access, and where PDO fits into this scheme of things eludes me.
>
> Thanks ahead of time for any input you may have.
Yes, it is an abstraction layer for data access. See
http://www.php.net/manual/en/intro.pdo.php.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
Re: Is PDO an abstraction layer? [message #178994 is a reply to message #178987] |
Sat, 01 September 2012 14:12 |
r.mariotti
Messages: 17 Registered: December 2011
Karma: 0
|
Junior Member |
|
|
On Fri, 31 Aug 2012 21:00:44 -0400, Burnsy <jburns131(at)gmail(dot)com>
wrote:
> What's going on folks. I'm trying to wrap my brain around just what PDO
> is. Is it a database abstraction layer like ADOdb? Or is it just a
> method to simplify access to the sql databases out there? Or is it
> something else all together?
>
> I've been working on a project and decided to use ADOdb before PDO was
> available. I'm at a point where I'm looking into other options for my
> database access, and where PDO fits into this scheme of things eludes me.
>
> Thanks ahead of time for any input you may have.
As Jerry stated - it is an abstract layer. For a look at using this
layer you might want to take a look at this article:
http://phpmaster.com/migrate-from-the-mysql-extension-to-pdo/
|
|
|
Re: Is PDO an abstraction layer? [message #179004 is a reply to message #178994] |
Mon, 03 September 2012 03:31 |
P E Schoen
Messages: 86 Registered: January 2011
Karma: 0
|
Member |
|
|
"BobMCT" wrote in message
news:ot5448t5elu4ja83d8h093n1lahq81p3ba(at)4ax(dot)com...
> As Jerry stated - it is an abstract layer. For a look at using this
> layer you might want to take a look at this article:
> http://phpmaster.com/migrate-from-the-mysql-extension-to-pdo/
Thanks for the article. It helps explain my problem with SQlite. Seems like
a good idea to consolidate the various database functions in this way.
Hopefully now that I've figured it out and got it working, I should have few
problems in the future due to server differences.
Paul
www.muttleydog.com
|
|
|
Re: Is PDO an abstraction layer? [message #179007 is a reply to message #179004] |
Mon, 03 September 2012 03:38 |
Jerry Stuckle
Messages: 2598 Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 9/2/2012 11:31 PM, P E Schoen wrote:
> "BobMCT" wrote in message
> news:ot5448t5elu4ja83d8h093n1lahq81p3ba(at)4ax(dot)com...
>
>> As Jerry stated - it is an abstract layer. For a look at using this
>> layer you might want to take a look at this article:
>> http://phpmaster.com/migrate-from-the-mysql-extension-to-pdo/
>
> Thanks for the article. It helps explain my problem with SQlite. Seems
> like a good idea to consolidate the various database functions in this
> way. Hopefully now that I've figured it out and got it working, I should
> have few problems in the future due to server differences.
>
> Paul
> www.muttleydog.com
Unfortunately, unless you stick with ANSI standard SQL (which can be
limiting), you'll always have inconsistencies when switching databases.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|