Thread: PHP - Tutorial

On Fri, Nov 05, 2004 at 09:58:15PM -0500, Steph & Matt 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.

The PostgreSQL documentation is quite good and it has a tutorial:

http://www.postgresql.org/docs/7.4/static/index.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

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.

The documentation at postgresql.org is excellent.  I'd use that.  As
for php.  Try phpbuilder.com.  They also have very active forums for
any problems you might have.

--Bryan


On Fri, 5 Nov 2004 21:58:15 -0500, Steph & Matt <steph.matt@rogers.com> 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.