How do I get JSON from URL and set its value to texfield?

Question

I have some URL mysite.com/json.php, which returns something like this : [{"invoice_number":"INV#20101"}]

on another page I have a <input type="hidden" id="myinvoice" />

I just wanted to set that invoice_number value to this hidden field withJQuery. How can I do this?

on JSON page I have converted JSON with this code :

 <?php

$return_arr = array();

$fetch = mysql_query("SELECT invoice_number FROM db_stocks ORDER BY stock_id DESC LIMIT 1 "); 

while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {

    $row_array['invoice_number'] = $row['invoice_number'];

    array_push($return_arr,$row_array);
}

echo json_encode($return_arr);

?>

Dave · Answer 1 · 2014-09-17T19:10:35.030

2

You can use jQuery.ajax() to get the returned array then set the value.

$.ajax({
  url: "json.php",
  success: function(data) {
    $("#myinvoice").val(data[0].invoice_number);
  }
});

edited Sep 17 '14 at 19:10

answered Sep 17 '14 at 19:01

Dave

10,748
3
43
54

score 0 · Accepted Answer · edited May 23 '17 at 12:12

0

You can use the following jquery:

$.get('mysite.com/json.php', function(data){
    $('#myinvoice').val(data[0].invoice_number);
} 'json');

Also please don't use mysql but use pdo or mysqli instead, see why-shouldnt-i-use-mysql-functions-in-php for more information about this.

edited May 23 '17 at 12:12

Community

1
1

answered Sep 17 '14 at 19:01

Perry

11,172
2
27
37

His data is an array you have to get the first element – Dave Sep 17 '14 at 19:04
this Works But i have to chage $.get to $.getJSON – hxnAbbas Sep 17 '14 at 20:01

How do I get JSON from URL and set its value to texfield?

2 Answers2