FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Is PDO an abstraction layer?
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Is PDO an abstraction layer? [message #178987] Sat, 01 September 2012 01:00 Go to next message
Burnsy is currently offline  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 Go to previous messageGo to next message
Jerry Stuckle is currently offline  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 Go to previous messageGo to next message
r.mariotti is currently offline  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 Go to previous messageGo to next message
P E Schoen is currently offline  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 Go to previous message
Jerry Stuckle is currently offline  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
==================
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Re: problem sending attachement with the mail() function
Next Topic: Exec Security
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 17:46:36 GMT 2024

Total time taken to generate the page: 0.02772 seconds