I'm new using json, mysql and php. I want to retrieve data from my mysql database into json and send it to highcharts.
I have some data that is stored in different tables.
I want to acheive this result:
[[name1,value1],[name2,value2],...]
I'm using this code in my data.php file:
$result = mysql_query("SELECT name, value FROM table1, table2");
$rows = array();
while($r = mysql_fetch_array($result)) {
$row[0] = $r[0];
$row[1] = $r[1];
array_push($rows,$row);
}
print json_encode($rows, JSON_NUMERIC_CHECK);
The output of this code gives this results:
[[name1,value1],[name2,value2],[name1,value2],[name2,value1],... ]
so instead of having each name with its value I get each name with all the values.
How can I fix this?
EDIT:
sorry for the ambiguity here a summury:
table 1 table 2
name other data value other data
name 1 data 1 value 1 data 1
name 2 data 2 value 2 data 2
name 3 data 3 value 3 data 3
name 4 data 4 value 4 data 4
name 5 data 5 value 5 data 5
name 6 data 6 value 6 data 6
name 7 data 7 value 7 data 7
name 8 data 8 value 8 data 8
name 9 data 9 value 9 data 9
name 10 data 10 value 10 data 10
name 11 data 11 value 11 data 11
name 12 data 12 value 12 data 12
name 13 data 13 value 13 data 13
obtained json desired json
name 1 value 1 name 1 value 1
name 1 value 2 name 2 value 2
name 1 value 3 name 3 value 3
name 1 value 4 name 4 value 4
name 1 value 5 name 5 value 5
name 1 value 6 name 6 value 6
name 1 value 7 name 7 value 7
name 1 value 8 name 8 value 8
name 1 value 9 name 9 value 9
name 1 value 10 name 10 value 10
name 1 value 11 name 11 value 11
name 1 value 12 name 12 value 12
name 1 value 13 name 13 value 13
name 2 value 1
name 2 value 2
name 2 value 3
name 2 value 4
name 2 value 5
. .
. .
name 13 value 13
mysql_*functions, they are officially deprecated, no longer maintained and will be removed in the future. You should update your code with PDO or MySQLi to ensure the functionality of your project in the future.