So, I've been trying to send an array from a php file to a script through JSON, using json_encode, but whatever I do, I keep getting the same error:
SyntaxError: JSON.parse: unexpected non-whitespace character after JSON data at line 2 column 43 of the JSON data
Now, I've used jsonlint to validate the JSON received through json_encode, but it shows as not valid.
Here's my PHP code/query:
<?php
require_once '../../DAO/model.php';
$cd = $_POST['cd'];
$query = "SELECT ID,name FROM user WHERE cost_center = '$cd' order by name";
$results = mysqli_query($conn, $query);
while ($row = mysqli_fetch_assoc($results)){
echo json_encode($row);
}
?>
$("#centro").change(function(){
var id = $("#centro").val();
$.ajax({
url: 'insertManager.php',
method: 'POST',
data:
{'cd': id}
}).done(function(manager){
$('#manager').empty();
console.log(manager);
manager = JSON.parse(manager);
manager.forEach(function(managers){
$('#manager').append('<option value = "' +
managers.id + '">' + managers.name + '</option>')
})
})
});
And, just to make sure, that is part of the JSON he is generating
{
"ID": "RXA47",
"name": "Abraao Silva Souza"
} {
"ID": "F7R53",
"name": "Adao David Bueno"
} {
"ID": "DP800",
"name": "Adilson Silva"
} {
"ID": "C355P",
"name": "Adolfo Filho"
}
I need to be able to iterate through this JSON so I can append the options, but it doesn't even get to that, since it gives me the JSON syntax error, what am I doing wrong?
Try this code in code object array pass in one single array and after then array pass in json encode.
<?php
require_once '../../DAO/model.php';$cd = $_POST['cd'];
$array[]=" ";
$query = "SELECT ID,name FROM user WHERE cost_center = '$cd' order by name";
$results = mysqli_query($conn, $query);
while ($row = mysqli_fetch_object($results))
{
$array[]=$row;
}
echo json_encode($array);
?>