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

Jeff MacDonald wrote:

> 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(at)pgsql(dot)com | jeff(at)hub(dot)org
> www.pgsql.com | www.hub.org
> 1-902-542-0713 | 1-902-542-3657
> -----------------------------------------------------
> Facsimile : 1 902 542 5386
> IRC Nick : bignose
>
>
Try phpDBlib.