Javascript PHP/MySQL - Insert row value from database into textfield

Question

Possibly very easy to do but I cannot work it out!

I'm trying to make a button which inserts row value pulled out from the database into a textfield.

<?php while ($row = mysql_fetch_array($query)) { ?> <tr> 
<td><?php echo $row['mobile_number']; ?></td>
<td><input type="button" value="select" onclick="clickMe()" /></td>
</tr>
<?php } ?>

<input type="text" id="textfield" />

so when the button "select" is clicked, the textfield would get populated with the mobile number.

Many thanks for your help in advance.

Unless I'm missing something: <input type="text" id="textfield" value="<?php echo $row['mobile_number']; ?>" /> ? — Amal
– Amal, Commented Nov 4, 2013 at 12:45

karmafunk · Accepted Answer · 2013-11-04 12:55:46Z

1

Try this:

<script>
function clickMe(number) {
    document.getElementById("textfield").value = number;
    // or jQuery
    $("#textfield").val(number);
}
</script>

<?php while ($row = mysql_fetch_array($query)) { ?> <tr> 
<td><?php echo $row['mobile_number']; ?></td>
<td><input type="button" value="select" onclick="clickMe(<?php echo $row['mobile_number']; ?>)" /></td>
</tr>
<?php } ?>

<input type="text" id="textfield" />

edited Nov 4, 2013 at 12:55

answered Nov 4, 2013 at 12:50

karmafunk

1,45312 silver badges20 bronze badges

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

7 Comments

SiZa Over a year ago

Thank you so much! document.getElementById("textfield").text = number; didn't work but the jQuery one did, any idea why?

karmafunk Over a year ago

Yeah I think it should be .value Happy to help.

SiZa Over a year ago

thanks, yes, .value worked! i've just tried this with another column which the values hold a string, e.g. "AB214" and it's not pulling the information now, does .val only pull integers?

karmafunk Over a year ago

YOu could try converting it to a string before you set it. number.toString()

SiZa Over a year ago

Like this?: function clickMe2(text) { text.toString().$("#txtfield").val(text); } -- it's not working :(

|

Collectives™ on Stack Overflow

Javascript PHP/MySQL - Insert row value from database into textfield

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related