mysql的数据返回html_从mysql返回数据到html

我有数据库，我是我从它只检索一个单元格，下面是一个例子：

+------+

|Failed|

+------+

|325 |

+------+我试图将这个值添加到我的html文件中的多个区域，但是我无法这样做，下面是html文件：

JSON：

$(document).ready(function() {

$.getJSON('PHP/Faild.php', function(GetFailedRenew) {

// set the html content of the id myThing to the value contained in data

$("#myThing").html(data.value);

});

});html正文样本：

150

Failed.php

$DB_NAME = 'test';

$DB_HOST = 'localhost';

$db_port = '3306';

$DB_USER = 'root';

$DB_PASS = 'mysql';

$mysqli = new mysqli($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);

if (mysqli_connect_errno()) {

printf("Connect failed: %s\n", mysqli_connect_error());

exit();

}

$result = $mysqli->query('SELECT RenewFailed FROM Statistics where id=(select max(id) from Statistics);');

$rows = array();

$table = array();

$table['cols'] = array(

array('label' => 'RenewFailed', 'type' => 'number')

);

foreach($result as $r) {

$temp = array();

$temp[] = array('v' => (string) $r['RenewFailed']);

$rows[] = array('c' => $temp);

}

$table['rows'] = $rows;

// convert data into JSON format

$SubsStats = json_encode($table);

echo $SubsStats;

?>这是failed.php的outpout：

{"cols":[{"label":"RenewFailed","type":"number"}],"rows":[{"c":[{"v":"325"}]}]}我是PHP和JSON的新手，所以请让我知道如果有任何其他/更好的方式来实现上述..

谢谢

阿里