php怎么获取json中某一列的值,如何从php脚本中获取JSON中mysql表的所有值？

这是从mysql(一行)获取表值的php脚本. &安培;将其作为JSON回应

$username = "user";

$password = "********";

$hostname = "localhost";

$dbh = mysql_connect($hostname, $username, $password) or die("Unable to

connect to MySQL");

$selected = mysql_select_db("spec",$dbh) or die("Could not select first_test");

$query = "SELECT * FROM user_spec";

$result=mysql_query($query);

$outArray = array();

if ($result) {

while ($row = mysql_fetch_assoc($result)) $outArray[] = $row;

}

echo json_encode($outArray);

?>

这是接收的HTML文件&打印json数据.

SRC = “http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js” &GT

// $(‘document’).ready(function(){

function Preload() {

$.getJSON("http://localhost/conn_mysql.php", function(jsonData){

$.each(jsonData, function(i,j)

{ alert(j.options);});

});}

// });