FUDforum: comp.lang.php » display data from mysql db in text box??

Home » Imported messages » comp.lang.php » display data from mysql db in text box??

Show: Today's Messages :: Polls :: Message Navigator

display data from mysql db in text box?? [message #169374]

Wed, 08 September 2010 19:12

PAkerly
Messages: 7
Registered: September 2010

Karma:

Junior Member

I want to create a simple page to edit a record, and when submit is
clicked I want to update the record.

First I want to display all the data for the record, based on ID, on
the page
Here is what I am doing:

<?php
$txtid= $_POST[txtid];

$sql = "SELECT date, user1, user2, user3, role, id
FROM myuserdata
WHERE id= $txtid
ORDER BY id";

And so then I have text boxes on the page and I want to fill those in
based on the current ID

I tried to do this:

<input type="text" name="txtdate" id="txtdate" value=<?php echo
[date];?> />

<input type="text" name="txtuser1" id="txtuser1" value=<?php echo
[user1];?> />

this did not work. How would I display the actual db fields in the
textboxes?

Report message to a moderator

[Message index]

		display data from mysql db in text box?? By: PAkerly on Wed, 08 September 2010 19:12
		Re: display data from mysql db in text box?? By: The Natural Philosoph on Wed, 08 September 2010 20:04
		Re: display data from mysql db in text box?? By: PAkerly on Wed, 08 September 2010 20:20
		Re: display data from mysql db in text box?? By: The Natural Philosoph on Wed, 08 September 2010 20:32
		Re: display data from mysql db in text box?? By: rf on Wed, 08 September 2010 23:01
		Re: display data from mysql db in text box?? By: Michael Fesser on Wed, 08 September 2010 23:06
		Re: display data from mysql db in text box?? By: alvaro.NOSPAMTHANX on Thu, 09 September 2010 07:20
		Re: display data from mysql db in text box?? By: Ajayendra on Thu, 09 September 2010 12:18

Previous Topic:	Re: Php code for ajax encoding
Next Topic:	Re: get_object_vars ($this) and member visibility

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 12:05:17 GMT 2024

Total time taken to generate the page: 0.04300 seconds