Re: Database Classes and prepared statements - Mailing list pgsql-novice

From G. J. Walsh
Subject Re: Database Classes and prepared statements
Date
Msg-id 1205954721.8630.13.camel@www.dscdirectionalservices.com
Whole thread Raw
In response to Re: Database Classes and prepared statements  (John DeSoi <desoi@pgedit.com>)
List pgsql-novice
My thanks for the reference, John.

Given the fact that there will be no direct access to our databases, I
have decided it would be more practical to complete the full beta
testing of the site first, and then introduce either pgsql classes or
PDO later if that need is indicated. Until norm gathering has been
completed, I won't have sufficient data available to properly consider
efficiency and maintenance factors anyway. None of us has extensive
experience with object coding and that is probably still another
'abstraction' layer we don't need to introduce at the moment. It has
been challenging enough converting everything from 'C' code and c-isam
to PHP and PostgreSQL while designing the site itself. Maybe we are
better off continuing on our present path. It may not be super
sophisticated, but it works. In these days of constant change, that
counts for something.

Thanks again for your referral.

George





On Wed, 2008-03-19 at 00:36 -0400, John DeSoi wrote:
> On Mar 18, 2008, at 6:25 PM, G. J. Walsh wrote:
>
> > This will allow me to move on, but I was wondering about the use of
> > prepared statements. Can this functionality be included in the class -
> > that is I need a bit of a boost to incorporate the requisite
> > pg_prepare
> > and pg_execute functions.
> >
> > Assuming this is possible, could someone kindly show me some sample
> > code
> > to make it happen?
>
>
> There is an example here on using a PHP class to call PostgreSQL
> functions using prepared statements:
>
> http://pgedit.com/resource/php/pgfuncall
>
>
>
>
> John DeSoi, Ph.D.
>
>
>

pgsql-novice by date:

Previous
From: James Long
Date:
Subject: Re: COPY doesn't like my dates on STDIN
Next
From: "☆Pumu :-D ☆ "
Date:
Subject: About db session time-out while uploading data to database