Have a quick look on these documents:
The PEAR::DB [1] documentation (sorted by version)
http://pear.php.net/package/DB/docs
A short primer to PEAR::DB (a very good starting point):
http://www.onlamp.com/pub/a/php/2001/11/29/peardb.html
Combining PEAR::DB with Smarty [2]:
http://www.onlamp.com/pub/a/php/2003/04/17/pear_smarty.html
[1]: PEAR is a collection of PHP classes. It can save a lot of time and
headache browsing through their collection. PEAR::DB is one of them which is
used to distanciate the programming from the underlying database. It works in
general, but as it seems, the DB->lastID function is not working for
PostgreSQL (yet). Support is planned afaik. For now I use PostgreSQL's
"SELECT last_id ..." for that matter. If you have root access to your
web-sever you might be able to install DB using the command "pear install
DB", or if necessacry do a "pear upgrade".
[2]: Smarty is a template engine for PHP. It is used to separate the business
logic (the programming bit in php) from the presentation layer (the
html/css/... part). VERY useful!
hth.
Michel Albert
On Saturday 06 November 2004 02:58, you wrote:
> I am a novice at both sql and php.
> I am looking for a tutorial to help me get started.
> Last year I worked on very simple mysql/php projects for my own interest.
> I would like to try using postgres.
> Any help would be appreciated.
>
> Thanks.
--
This email is digitally signed. My public key (PGP/GPG) is available from
http://www.albert.lu
Diese Email ist mit einer digitalen Unterschrift versehen. Mein oeffentlicher
(PGP/GPG) Schluessel ist auf http://www.albert.lu erhaeltlich.