Hello I have simple question. I have some data fetched from database and json encoded and sent to html file over AJAX from PHP script. I want to JSON parse that data. Data looks like this:
And in PHP file like this:
$profesors = array
(
'id' => ($id),
'name' => ($profesor)
);
When I try to JSON parse it with JSON.parse() command I get "unexpected token {". Does anyone have some suggestion what to do? Also if it would be easier for achieving my goal I can use some other data type than array I am using, if someone knows better way...
EDIT
my PHP code that generates 2d array
<?php
$var=$_POST["oblast"];
$connection = mysql_connect('localhost','root','pass');
if (!$connection) {die("not successfull" . mysql_error());}
$result = mysql_query('set character set utf8', $connection);
$result = mysql_query('set names utf8', $connection);
$db_select = mysql_select_db("fakultet",$connection);
$brojac=0;
$profesor="";
//$data = array(array());
$queryData = mysql_query("SELECT * FROM predmet WHERE idpred = '$var'");
while($result1 = mysql_fetch_array($queryData))
{
$prof=$result1['idprof'];
$queryData1 = mysql_query("SELECT * FROM profesori WHERE idprof = '$prof'");
while($result2 = mysql_fetch_array($queryData1))
{
$id=$result2['idprof'];
$profesor=$result2['ime']." ".$result2['prezime'];
$profesors = array
(
'id' => ($id),
'name' => ($profesor)
);
echo json_encode($profesors);
}
//echo($result1['idprof']);
//$data[]=$result['idprof'];
}
//echo "$data";
?>