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@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
>
>
Try phpDBlib.