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
