html:

$host = 'localhost';

$database = 'test';

$username = 'root';

$password = 'root';

$selectName = $_POST['name'];

$pdo = new PDO("mysql:host=$host;dbname=$database", $username, $password);//创建一个pdo对象

$pdo->exec("set names 'utf8'");//设置数据库编码

$sql = "select * from user where name = ?";

//$sql = "select * from user";

$stmt = $pdo->prepare($sql);

$rs = $stmt->execute(array($selectName));

if ($rs){

// PDO::FETCH_ASSOC 关联数组形式

// PDO::FETCH_NUM 数字索引数组形式

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

global $name,$age;

$name = $row['name'];

$age = $row['age'];

}

}

$data='{name:"'.$name.'",age:"'.$age.'"}';

echo json_encode($data);   //打印出："{name:\"1\",age:\"1\"}"

?>

为什么每次获取的都是前一次查询的数据？