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

Re: display data from mysql db in text box?? [message #169380 is a reply to message #169378]

Wed, 08 September 2010 20:32

The Natural Philosoph
Messages: 993
Registered: September 2010

Karma:

Senior Member

PAkerly wrote:
> On Sep 8, 4:04 pm, The Natural Philosopher <t...@invalid.invalid>
> wrote:
>> PAkerly wrote:
>>> 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?
>> $sql = "SELECT date, user1, user2, user3, role, id
>> FROM myuserdata
>> WHERE id= $txtid
>> ORDER BY id";
>> /* add these bits */
>>
>> $result=mysql_query($sql);
>>
>> $date=mysql_result($result,'date',0);
>> $user1=mysql_result($result,'user1',0);
>> ...etc.
>>
>> Then
>> <input type="text" name="txtdate" id="txtdate" value=<?php echo
>>> $date;?> />
>>
>> etc..
>
> Added this:
>
> <input type="text" name="txtdate" id="txtdate" value=<?php echo> >
> $date; ?> />
>
> and the other things...
>
> $result=mysql_query($sql);
>
> $date=mysql_result($result,'date',0);
> $user1=mysql_result($result,'user1',0);
> $user2=mysql_result($result,'user2',0);
>
> and I get an error:
> Parse error: syntax error, unexpected '>'

well that could be anywhere.

I am not convinced the select statement is properly formed either.

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: Tue Nov 26 01:01:12 GMT 2024

Total time taken to generate the page: 0.05183 seconds