X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4E97FD1EF92 for ; Sun, 9 May 2004 20:39:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18870-08 for ; Sun, 9 May 2004 20:39:36 -0300 (ADT) Received: from dnscache2.syd.nexon.com.au (dnscache2.syd.nexon.com.au [210.215.48.100]) by svr1.postgresql.org (Postfix) with ESMTP id 87B2BD1E2E1 for ; Sun, 9 May 2004 20:39:32 -0300 (ADT) Received: from chris ([210.215.130.98]) by dnscache2.syd.nexon.com.au (8.12.8p1/8.12.8) with ESMTP id i49NfNuk012313; Mon, 10 May 2004 09:41:24 +1000 (EST) (envelope-from chris@interspire.com) From: "Chris" To: "'Yasmine Kedoo'" , Subject: Re: Parsing Data, Table to Form Date: Mon, 10 May 2004 09:39:21 +1000 Message-ID: <002801c4361e$dada39b0$0d00a8c0@chris> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 In-Reply-To: Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200405/9 X-Sequence-Number: 2728 Hi Yasmine, If you click the link only, it will not submit the form and pass the information on. You need to have a 'submit' button in your form and hit that. Chris. -----Original Message----- From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org] On Behalf Of Yasmine Kedoo Sent: Monday, May 10, 2004 9:18 AM To: pgsql-php@postgresql.org Subject: Re: [PHP] Parsing Data, Table to Form Hi again. I have carried out a search, then displayed the results in a table on a php page called admininfo.php: $row = pg_fetch_object($result, 0); $test = ""; for ($rw = 0; $rw < $maxrows; $rw++) { echo " "; for ($fld = 0; $fld < $maxfields ; $fld++) { echo ""; echo pg_Result($result,$rw,$fld); $test .= pg_Result($result,$rw,$fld); echo ""; echo "
\n"; } echo " "; } Now, i would like to parse the information displayed in the table to textfields on the page updaad.php, i've used a link to do this: Update On the page updaad.php, i have displyed the textfields using the following code: echo "Admin ID Number:
\n"; echo "Name:
\n"; echo "Surname:
\n"; echo "Phone:
\n"; echo "Email:
\n"; echo "Username:
\n"; echo "Password:
\n"; echo "Building:
\n"; echo "Postcode:
\n
"; echo "
\n"; but i am unable to write the information displayed in the table in admininfo.php, to the textfields in updaad.php. Has anybody got any suggestions? :-) Thanx Yaz >From: brew@theMode.com >To: Yasmine Kedoo >Subject: Re: [PHP] Parsing Data, Table to Form >Date: Sun, 9 May 2004 11:36:14 -0400 (EDT) > > >Yaz...... > > > i want to be able to display the table information in editable form > > fields, so that the data may be altered and the database updated. > >If by table information, you mean the information contained in the >table, then what I do is get one row's data and load it into variables. >I use the variables as the default text in the form (check the html >standard). After the user makes any edits he updates the entire row. > >This only works with text boxes, with radio buttons and on/off buttons >you have to generate different html depending on the existing button >state. > >It's not complicated, just tedious to code if it has lots of buttons. >If it's only text it's easier. I think I started with an example >someone posted on php.net, maybe you can search for that and use it for >reference, too. I think it has a subroutine to generate the buttons >preselected by the existing state of the database. > >My script is long, involving switches to display the possible rows to >be edited for a user on the first pass, then displaying the info for >the row selected in an editable form, then updating (or inserting the >row if it doesn't exist) and going back to displaying all the possible >rows for that user. I have to study it for a while myself, remembering >how it works before I make any changes to it! Hopefully somebody else >has a more basic example. > >If by table information you mean the definition of a table in the >database, then that would be diferent, although still involving >somewhat the same type of script, just working on different database >information. All my table definitions are static in my database, so >I've never done it from a script, though. > >brew > > >======================================================================= === > Strange Brew (brew@theMode.com) > Check out my Musician's Online Database Exchange (The MODE Pages) > http://www.TheMode.com > >======================================================================= >=== > _________________________________________________________________ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org