Question about the each method?

Question

JavaScript

My database query selects only one record. Next, I encode it in JSON. And I pass it to the script.

Here is just the question. Do I need to use each, because I don’t seem to have an array, but one record, but I can’t access the property directly.

$.each(json.client_date,function() {
               $('#changeClientDataForm')[0].reset();
               $('#changeClientDataForm .code').val(this['code_client']);
               $('#changeClientDataForm .name').val(this['name']);
               $('#changeClientDataForm .login').val(this['login']);
               $('#changeClientDataForm .password').val(this['password']);
           });

Here, I need to display this once, how can I do without each ?

Answer 1

So if you are sure that only one record is always selected from the database (search by key, for example), then you should rewrite the php code

$row = mysql_fetch_array($result, MYSQL_ASSOC))
echo json_encode(array("client_date" => $row));

Then in the js code it will be easier to deal with the properties of the object

$('#changeClientDataForm')[0].reset();
$('#changeClientDataForm .code').val(json.client_date.code_client);
$('#changeClientDataForm .name').val(json.client_date.name);
$('#changeClientDataForm .login').val(json.client_date.login);
$('#changeClientDataForm .password').val(json.client_date.password);

PS Do you store the password in clear text in the database?

Answer 2

Try like this:
console.log(json.client_date[0].name);