From: | thomas wong <twong(at)aamsin(dot)com> |
---|---|
To: | Jeff MacDonald <jeff(at)pgsql(dot)com> |
Cc: | shawn everett <everett(at)pgweb(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Is this possible or am I on drugs :) |
Date: | 2000-11-28 09:31:08 |
Message-ID: | 3A237B5C.3020007@aamsin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Partyka Robert | 2000-11-28 10:22:27 | Re: one ask |
Previous Message | He weiping | 2000-11-28 08:58:44 | is it a bug? |