javascript:insert data from database into html5 text field

Question

I am trying to get data from mysql database in a textfield of html page. I am using php to take data from database and using json to give data to javascript. Then using id i am throwing value to textfield. But it is not working. I am easily getting the phone number in div or li tag using id but the same value does not appear in the textfield.

my javascript is like this

$('#tenantcontactTP').live('pageshow', function(event) {
var id = '[email protected]';
$.getJSON('tenantcontact.php?id='+id, displayEmployee);
});

function displayEmployee(data) {
var employee = data.item;

if (employee.TenantPhoneNumber) {
    $('#tphone').append(employee.TenantPhoneNumber);
}
}

Then my html page containing textfield is

<!DOCTYPE HTML>
<html>
<head>
</head> 
<body>
<div id="tenantcontactTP" data-role="page" data-add-back-btn="true">
<div data-role="content">    
<ul data-role="listview" data-inset="true">
<form>
<table>
<tr><td>Phone Number</td><td><input type="text" name="tphone" id="tphone" value=""/></td></tr>
</table>
</ul>
<input type="submit" name="update" value="Update" />
</form>
</div>
</div>
</body>
</html>

I will update phone number. Phone number is showing if i use list, but not showing in text field. What can I do?

automaticAllDramatic · Accepted Answer · 2012-09-13 11:28:04Z

1

Use $('#tphone').val(employee.TenantPhoneNumber); to add a value to the text field

answered Sep 13, 2012 at 11:28

automaticAllDramatic

2,0831 gold badge21 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Humayun Kabir Over a year ago

not working bro!!before i can show in a list but now not in list nor in textfield.

automaticAllDramatic Over a year ago

Try replacing $('#tenantcontactTP').live('pageshow', function(event) with $('#tenantcontactTP').live('pagecreate', function(event)

RobertP · Accepted Answer · 2012-09-13 11:30:20Z

0

You want to set the input element's value, rather than appending. Use the following:

if (employee.TenantPhoneNumber) {
    $('#tphone').val(employee.TenantPhoneNumber);
}

answered Sep 13, 2012 at 11:30

RobertP

1

2 Comments

Humayun Kabir Over a year ago

not working bro!!before i can show in a list but now not in list nor in textfield

transilvlad Over a year ago

can u ppl use the proper wording: JavaScript and jQuery?

Collectives™ on Stack Overflow

javascript:insert data from database into html5 text field

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related