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 76BE4D1F07B for ; Sun, 9 May 2004 20:18:44 -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 43669-02 for ; Sun, 9 May 2004 20:18:25 -0300 (ADT) Received: from hotmail.com (bay14-f29.bay14.hotmail.com [64.4.49.29]) by svr1.postgresql.org (Postfix) with ESMTP id 33F36D1CA45 for ; Sun, 9 May 2004 20:18:22 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sun, 9 May 2004 16:18:24 -0700 Received: from 82.47.145.179 by by14fd.bay14.hotmail.msn.com with HTTP; Sun, 09 May 2004 23:18:24 GMT X-Originating-IP: [82.47.145.179] X-Originating-Email: [yazkedoo@hotmail.com] X-Sender: yazkedoo@hotmail.com From: "Yasmine Kedoo" To: pgsql-php@postgresql.org Subject: Re: Parsing Data, Table to Form Date: Sun, 09 May 2004 23:18:24 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 09 May 2004 23:18:24.0562 (UTC) FILETIME=[ED3FE120:01C4361B] X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/8 X-Sequence-Number: 2727 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