Re: Refresh web page?

Ah, I see. So it's basically "Show page A unless Submit has been hit, else show page B instead" I could do it that way, I suppose, but it's quite a long page - it'd be easier to have a refresh() function. I knows it's OT, but is there a javascript function I could use instead? I tried <script>location.reload();</script> but that didn't seem to work either :-( Thanks for your help. Andy ----- Original Message ----- From: "Cody Caughlan" <codyc@cisco.com> To: "Andy Wallace" <andyw@datent.com> Sent: Thursday, September 07, 2000 8:23 PM Subject: Re: [PHP-DB] Refresh web page? > I would have your structure be something like this: > > <? > #DB Insert Code.. > if($action == "Submit") > { > do your SQL insert here... > } > ?> > <? > # at this point do a select to get all your data from the DB > $row = mysql_fetch_array($yourSelect_Pointer); > while(list($key,$val) = each($row)) > { > ${$key} = $val; > } > ?> > <HTML > <FORM ACTION="$PHP_SELF" METHOD=POST> > > <INPUT TYPE=TEXT NAME=firstName VALUE=\"$firstName\"> > > <INPUT TYPE=SUBMIT NAME=action VALUE="Submit"> > > </HTML> > > > --- > What I am doing is this, in order: > 1) If this is the 1st time the page is being access the if($action) part > fails > because its not true, so nothing is inserted... > 2) after that it does a DB select and gets all the data > since you probably only getting one row you can iterate through all the > values > in that row using mysql_fetch_array, > by doing the list() function with each() you can set each column field > with its value > so if you have a Database field called firstName then that is made into > a variable with the same > name and its value is whatever it is in the database > Look at the construct ${someVar} its really handy! > 3) Then when you do your HTML put the VALUE part in in your tags and set > it to your variable > the first time this page is accessed, if no data exists because lets > say you use a key which wont exist > until after the person hits submit then all these variables are empty > and the user doesnt see any > pre-filled out fields.. > > Do you understand what I am saying? Its easy if you get the hang of it > but I can see how what I said above > makes no sense... > > good luck > /cody caughlan > > Andy Wallace wrote: > > > > Hi, > > > > Can someone help me out here? > > > > I've got a web page with embedded php scripts which read and update a MySQL > > database. Default values in a form are taken from the db, and altered values > > are written back. > > > > How do I refresh the page so that the form entries reflect the changes made? > > Currently when I submit the changed values the database is correctly updated > > but the page is redisplayed with the old defaults back in place, making > > users think the update has failed. > > > > I'm sure I'm missing something obvious, but I've spent hours browsing > > through the docs without finding anything useful. > > > > TIA, Andy > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > > > > Cody Caughlan -codyc@cisco.com- Cisco Systems > Web/Database Engineer phone: (408) 525-6029 > Enterprise Line of Business pager: (408) 951-9949