How do I repopulate a form with data...

Dev Articles Community Forums Sponsor:

May 12th, 2003, 04:07 PM

Mojoman

Contributing User

Join Date: Apr 2003

Location: Washington, DC

Posts: 39

Time spent in forums: 4 h 34 m 34 sec
Reputation Power: 6

How do I repopulate a form with data...

How do I repopulate a form with data from a mysql db?

I am building a member site with extensive user profile information. When a user needs to edit their profile, I want to send the user to a form with all their information already filled out (checkboxes, radio buttons and text fields) with data from the db.

Any suggestions?

__________________
$mybrain = "mush";
-------------------------------------------
http://www.loftsboston.com
http://www.gregdawsondesign.com

May 12th, 2003, 04:36 PM

jpenn

Contributing User

Join Date: Oct 2002

Location: Washington, DC

Posts: 317

Time spent in forums: 2 m 3 sec
Reputation Power: 7

Draw the info from the DB - set the starting values of the fields with what info is available for the user. Use conditionals for your radio buttons:

PHP Code:


		
			
if ( 'something' == 'something' )

{

      echo( '<input type="radio" name="somename" value="selectedValue" selected />' );

}

else

{

      echo( '<input type="radio" name="somename" value="selectedValue" />' );

}

__________________
~ Joe Penn

We work for free to help make this a valuable resource on the internet. Do you appreciate the help - did we provide help that will help you prosper and help that has contributed to sharpening your current skill set?

Show your appreciation and purchase something from our Amazon Wishlist's - it's simple and a great way to say thank you.

May 12th, 2003, 08:41 PM

Ben Rowe

Guest

Posts: n/a
Time spent in forums:
Reputation Power:

heres a very quick and untested example.

(Im asuming you have already have a database connection)

PHP Code:


		
			
<?php



$query = @mysql_query("SELECT * FROM members WHERE id = $id");



$row = @mysql_fetch_array($query);



?>



<form>

//normal input field

<input name='' type='text' value='<?php echo $row['fieldname']; ?>'>



</form>

Viewing: Dev Articles Community Forums > Programming > General Programming Help > How do I repopulate a form with data...

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump