Form Filled values from mysql

[apking]

hi Friends,


how to filled values from mysql database using php in html form.actually when user wants to edit his account.when fields filled with old details from musql database

for example :

<input type="text" name="uname" id="uname">

uname value in mysql database.how to get that name using PHP.


thanks

[vikas1111]

I am not sure regarding what you exactly want.. But i suppose this may help you.. Take a look..http://bytes.com/forum/thread797231.html

[TheServant]

Not sure if I understand either, but incase I do:

You need to connect to the database, and extract the field from where you want it. Like this:
[PHP]$raw_form_data = mysql_query("
SELECT uname
FROM your_table_name
WHERE another_table_value = 'your_way_to_choose'
") or die(mysql_error());
$form_data = mysql_fetch_array($raw_form_data);
[/PHP]

And then:

[PHP]<input type="text" name="<?php echo ($form_data['uname']); ?>" id="uname">[/PHP]

If this is all new to you, you should do some tutorials on MySQL and PHP. We can suggest some if you like?

[apking]

yea please suggest tutorials to me.iam new to PHP Programming.Thanks for reply theservant


apking

[vikas1111]

http://www.w3schools.com/php/default.asp & php.net for php.. and mysql basics..

[TheServant]

yea please suggest tutorials to me.iam new to PHP Programming.Thanks for reply theservant


apking

No problem. Another good one for basics is Tizag