jQuery - How to send an array from PHP to HTML textboxes

Question

I want to autofill the user form when a user is selected. How can I pass through an array from PHP to JavaScript/jQuery and then put the values into the correct textboxes?

$("#client").change(function() {
     $.get("../jquery/update_client.php?id=" + $("#client").val(),function(data){
          $("#first").val(data);
     });
});

PHP file:

if(isset($_GET['id'])){
include('../db_connect.php');
$id = mysqli_real_escape_string($mysqli, $_GET['id']);
$query = "SELECT * FROM users WHERE iduser=$id LIMIT 1";
$result = $mysqli->query($query);
$row = $result->fetch_array();
echo $row[];
}

How can I capture the array in JavaScript/jQuery, and then parse the information to go into the right boxes?

user1467267 · Accepted Answer · 2013-04-21 21:16:25Z

1

In PHP;

echo json_encode($row);

In JavaScript you will now get a map (array) back as data. This map you can then loop to fill your textbox(es).

answered Apr 21, 2013 at 21:16

user1467267

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

Comments

dfsq · Accepted Answer · 2013-04-21 21:27:19Z

0

Maybe if you output JSON it's better to use getJSON method with a simple for loop to set corresponding fields values:

$.getJSON("../jquery/update_client.php?id=" + $("#client").val(), function(data) {
    for (var el in data) {
        $('[name="' + el + '"]').val(data[el]);
    };
});

http://jsfiddle.net/2LuuC/

answered Apr 21, 2013 at 21:27

dfsq

193k26 gold badges244 silver badges261 bronze badges

Comments

Sir Lojik · Accepted Answer · 2013-04-21 21:57:06Z

0

well in php output the data as json. that is use

echo (json_encode($data));

then as dfsq said

answered Apr 21, 2013 at 21:57

Sir Lojik

1,4497 gold badges24 silver badges46 bronze badges

Collectives™ on Stack Overflow

jQuery - How to send an array from PHP to HTML textboxes

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related