From mmcgillick@attbi.com Sun Jun 9 15:08:28 2002 Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id D429647591A for ; Sun, 9 Jun 2002 11:08:28 -0400 (EDT) Received: from sccrmhc01.attbi.com (sccrmhc01.attbi.com [204.127.202.61]) by postgresql.org (Postfix) with ESMTP id 2368D4758F3 for ; Sun, 9 Jun 2002 11:08:27 -0400 (EDT) Received: from venus ([24.147.42.88]) by sccrmhc01.attbi.com (InterMail vM.4.01.03.27 201-229-121-127-20010626) with ESMTP id <20020609150831.IQU1024.sccrmhc01.attbi.com@venus> for ; Sun, 9 Jun 2002 15:08:31 +0000 From: "mmcgillick" To: Subject: Designing a Web Interface Date: Sun, 9 Jun 2002 11:08:08 -0400 Message-ID: <000001c20fc7$79e69ba0$0200a8c0@venus> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C20FA5.F2D4FBA0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200206/8 X-Sequence-Number: 1261 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C20FA5.F2D4FBA0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Good Morning: I've set up a PostgreSQL database on my Red Hat Linux 7.3 box. I'm trying to figure out how to put together a web page to administer records in the database. I'd like my web site to behave in the manner of a software application where the page itself is updated when I submit changes, and I don't have to go to a new page to see the change, and then click to get back to the main page. >From my experience with HTML, I understand I can use frames and a target= to make an html page appear in a particular frame. >From reading through PHP, in order to get it to work, you usually make the .php page the target, and this leaves me in the strange position that I can't direct where the output of the page should go. I'm curious if someone has implemented this type of layout, or if any has some pointers on where I might be able to do some further reading. Any pointers to examples would also be really appreciated. Thanks for your time. - Michael ------=_NextPart_000_0001_01C20FA5.F2D4FBA0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Good Morning:

 

I’ve set up a PostgreSQL database on my Red Hat Li= nux 7.3 box. I’m trying to figure out how to put together a web page to administer records in the database. I’d like my web site to behave in= the manner of a software application where the page itself is updated when I su= bmit changes, and I don’t have to go to a new page to see the change, and = then click to get back to the main page.

 

From my experience with HTML, I understand I can use fra= mes and a target=3D<frame name> to make an html page appear in a particul= ar frame. From reading through PHP, in order to get it to work, you usually ma= ke the .php page the target, and this leaves me in the strange position that I can= ’t direct where the output of the page should go.

 

I’m curious if someone has implemented this type of layout, or if any has some pointers on where I might be able to do some fur= ther reading. Any pointers to examples would also be really appreciated.<= /font>

 

Thanks for your time.

 

- Michael

------=_NextPart_000_0001_01C20FA5.F2D4FBA0-- From mike@partner2partner.com Sun Jun 9 15:31:45 2002 Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 31B63475B81 for ; Sun, 9 Jun 2002 11:31:45 -0400 (EDT) Received: from conan.partner2partner.org (unknown [65.160.7.101]) by postgresql.org (Postfix) with SMTP id 4003C4759A8 for ; Sun, 9 Jun 2002 11:20:44 -0400 (EDT) Received: (qmail 59906 invoked by uid 89); 9 Jun 2002 15:38:56 -0000 Message-ID: <20020609153856.59905.qmail@conan.partner2partner.org> References: <000001c20fc7$79e69ba0$0200a8c0@venus> In-Reply-To: <000001c20fc7$79e69ba0$0200a8c0@venus> From: "mike" To: "mmcgillick" Cc: pgsql-php@postgresql.org Subject: Re: Designing a Web Interface Date: Sun, 09 Jun 2002 15:38:56 GMT Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Archive-Number: 200206/9 X-Sequence-Number: 1262 You do nothing special in the PHP page. It loads where you instructed the browser to load it. The only thing you need to specify in the html you send to the browser is the 'target' for future pages. If you want to learn more about frames, search google and you will find tons of reference sites. Michael J. Upchurch Partner2Partner Communications mike@partner2partner.com 615.286.2199 mmcgillick writes: > Good Morning: > > > > I've set up a PostgreSQL database on my Red Hat Linux 7.3 box. I'm > trying to figure out how to put together a web page to administer > records in the database. I'd like my web site to behave in the manner of > a software application where the page itself is updated when I submit > changes, and I don't have to go to a new page to see the change, and > then click to get back to the main page. > > > > From my experience with HTML, I understand I can use frames and a > target= to make an html page appear in a particular frame. > From reading through PHP, in order to get it to work, you usually make > the .php page the target, and this leaves me in the strange position > that I can't direct where the output of the page should go. > > > > I'm curious if someone has implemented this type of layout, or if any > has some pointers on where I might be able to do some further reading. > Any pointers to examples would also be really appreciated. > > > > Thanks for your time. > > > > - Michael > From hierophant@pcisys.net Sun Jun 9 16:44:03 2002 Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 9C9FA475D44 for ; Sun, 9 Jun 2002 12:44:03 -0400 (EDT) Received: from leo.pcisys.net (leo.pcisys.net [207.76.102.240]) by postgresql.org (Postfix) with ESMTP id 6FC11475CE7 for ; Sun, 9 Jun 2002 12:44:02 -0400 (EDT) Received: from [208.202.106.209] (moe1.meg106-209.cos.pcisys.net [208.202.106.209]) by leo.pcisys.net (8.12.1/8.12.1) via ESMTP id g59Gi6Tu029967 for ; Sun, 9 Jun 2002 10:44:07 -0600 (MDT) env-from (hierophant@pcisys.net) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.4 Date: Sun, 09 Jun 2002 10:44:05 -0600 Subject: Re: Designing a Web Interface From: Keary Suska To: Postgres-PHP Message-ID: In-Reply-To: <000001c20fc7$79e69ba0$0200a8c0@venus> Mime-version: 1.0 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable X-Archive-Number: 200206/10 X-Sequence-Number: 1263 on 6/9/02 9:08 AM, mmcgillick@attbi.com purportedly said: > I=B9ve set up a PostgreSQL database on my Red Hat Linux 7.3 box. I=B9m tr= ying to > figure out how to put together a web page to administer records in the > database. I=B9d like my web site to behave in the manner of a software > application where the page itself is updated when I submit changes, and I > don=B9t have to go to a new page to see the change, and then click to get= back > to the main page. If I understand you correctly, which I am not certain since your description is ambiguous, you want a page that displays database row fields in an editable form, and you want to submit the form which returns to the form with the new updated values, yes? If so, frames are unnecessary. You would only want some kind of frame implementation if you want some part of the display to *not* change when a form is submitted or a link clicked in some context. I often use the logic: if( $_SERVER['REQUEST_METHOD'] =3D=3D 'GET' ) { // get database info, store in associative array: I will use $data // you may need to distinguish between editing and adding } elseif( $_SERVER['REQUEST_METHOD'] =3D=3D 'POST' ) { // untaint data, store in $data; update/insert as the case may be } // here, display the form with default values according to $data __END__ If you want to account for multi-user access, where a different user may have also changed the data after you have but before the page is displayed, you can redirect to the same page: header( "Location: /page/URL" ); This will force the script to re-read from the database, instead of just using the submitted data. If performance is an issue, this step may be avoided since the situation would not occur too frequently. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet" From hodges@xprt.net Sun Jun 9 18:04:09 2002 Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 5CCE6475DBF for ; Sun, 9 Jun 2002 14:04:09 -0400 (EDT) Received: from smtp.gssf.org (smtp.gssf.org [209.102.124.32]) by postgresql.org (Postfix) with ESMTP id 6887C475957 for ; Sun, 9 Jun 2002 14:04:04 -0400 (EDT) Received: from r7m3j6 (pdx-ppp300.pop1.net [209.102.127.137]) by smtp.gssf.org (8.9.3/8.9.3/Debian 8.9.3-21) with ESMTP id LAA27003 for ; Sun, 9 Jun 2002 11:05:06 -0700 From: hodges@xprt.net X-Authentication-Warning: smtp.gssf.org: Host pdx-ppp300.pop1.net [209.102.127.137] claimed to be r7m3j6 To: pgsql-php@postgresql.org Date: Sun, 9 Jun 2002 11:06:40 -0700 MIME-Version: 1.0 Subject: Re: Designing a Web Interface Message-ID: <3D0336C0.51.54F962@localhost> In-reply-to: <20020609153856.59905.qmail@conan.partner2partner.org> References: <000001c20fc7$79e69ba0$0200a8c0@venus> X-mailer: Pegasus Mail for Windows (v4.01) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Archive-Number: 200206/11 X-Sequence-Number: 1264 A good example of setting up a web site in php is "_PHP fast&easy web development_" by Julie C Meloni http://www.thickbook.com/index.html It uses MySQL but can easily be adapted for postgresql (I did it as my first php project). Tom Hodges On 9 Jun 2002 at 15:38, mike wrote: > You do nothing special in the PHP page. It loads where you instructed the > browser to load it. The only thing you need to specify in the html you send to > the browser is the 'target' for future pages. If you want to learn more about > frames, search google and you will find tons of reference sites. > > Michael J. Upchurch > Partner2Partner Communications mike@partner2partner.com 615.286.2199 > > mmcgillick writes: > > > Good Morning: > > > > > > > > I've set up a PostgreSQL database on my Red Hat Linux 7.3 box. I'm > > trying to figure out how to put together a web page to administer > > records in the database. I'd like my web site to behave in the manner of > > a software application where the page itself is updated when I submit > > changes, and I don't have to go to a new page to see the change, and > > then click to get back to the main page. > > > > > > > > From my experience with HTML, I understand I can use frames and a > > target= to make an html page appear in a particular frame. > > From reading through PHP, in order to get it to work, you usually make > > the .php page the target, and this leaves me in the strange position > > that I can't direct where the output of the page should go. > > > > > > > > I'm curious if someone has implemented this type of layout, or if any > > has some pointers on where I might be able to do some further reading. > > Any pointers to examples would also be really appreciated. > > > > > > > > Thanks for your time. > > > > > > > > - Michael > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >