Re: Is this possible or am I on drugs :)

If I'm reading correctly your basically just asking "how do i do php ?"

I'd reccommend any one of the many tutorials on the net, but i'll include a gist..

create an HTML form with a text input form. name it "input"

in your php script connect to the database and do

$query = pg_exec($dbconnection,"SELECT * from mytable WHERE badabing='$input'");

that's the gist..

jeff

On Mon, 27 Nov 2000, shawn everett wrote:

> I have a web application that needs to generate a report.  Said report
> requires a lot of calcuations so that hard coding them is a pain.
>
> I would like to set up a view does does all the apropriate selects and
> calculations to make writing my report easier.  Is it possible to pass a
> user supplied parameter to a view?  Would a procedure make this easier?
>
> I could write the query in the code to accomplish want I want but I'm
> always looking for new and interesting ways to accomplish things. :)
>
> >From a general point of view I want to do something like:
>
> select stuff from table where something=UserSuppliedParameter.
>
> Is this possible to do from within Postgres?  How would I go about getting
> the User Supplied Parameter?  How would I pass it using PHP?
>
> Any comments would be apreciated
>
> Shawn
>

Jeff MacDonald,

-----------------------------------------------------
PostgreSQL Inc        | Hub.Org Networking Services
jeff@pgsql.com        | jeff@hub.org
www.pgsql.com        | www.hub.org
1-902-542-0713        | 1-902-542-3657
-----------------------------------------------------
Facsimile : 1 902 542 5386
IRC Nick  : bignose