Re: Output HTML, or just a handle?

From: Alexander Borkowski <alexander(dot)borkowski(at)abri(dot)une(dot)edu(dot)au>
To: "Rodolfo J(dot) Paiz" <rpaiz(at)simpaticus(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Output HTML, or just a handle?
Date: 2005-01-25 02:36:47
Message-ID: 41F5B0BF.1050102@abri.une.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Rodolfo,

> Looking for "best practices" here. I've just seen that psql can output a
> query to an HTML file. [...] Or is it recommended to just run the bare query, then use PHP on my
> webpage to loop through the resulting output table handle and create the
> table there? [...]

Depends on your application really and without more information there is
nothing else I can say. For the vast majority of scenarios you
probably are better off using PHP (or some other language like Python,
Perl, Java, C, ...) and just loop through the result set. For PHP have a
look at

http://www.php.net/manual/en/ref.pgsql.php

Cheers,

Alex

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Alexander Borkowski 2005-01-25 02:43:43 Re: Output HTML, or just a handle?
Previous Message Hari Bhanujan 2005-01-25 02:28:20 Re: recommended programming language for postgresql