html:
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<?php header("content-type :text/html;charset=utf-8");?>
<script src="jquery-3.2.1.min.js"></script>
</head>
<body>
<form action="PDO_insert.php" method="post">
??: <input type="text" name="name" id="name"/>
<input type="submit" value='查詢' id="btn"/>
</form>
<script type="text/javascript">
? ? ? ? var ?? =document.getElementById('name').value;
$("#btn").on("click", function () {
$.ajax({
??: "POST",
url: "PDO_insert.php",//url放的是當(dāng)前頁面請求的后臺地址。
data:{name:name},
async:false,
dataType: "json",?
??: ??(???) {
var result=data;
//var result = eval('[' + data + ']');
Alert(result);
},
??: ?? () {
Alert("請求失敗!");
}
});
});
</script>
</body>
</html>
<?php?
$host = 'localhost' ;
$ ?????? = '???';
$username = '??';
$password = '??';
$selectName = $_POST['name'];
$pdo = ? PDO("mysql: ???=$host;dbname=$database", $username, $password);//創(chuàng)建一個pdo對象
$pdo->exec("?? ?? 'utf8'");//設(shè)置數(shù)據(jù)庫編碼
$ sql = "?? = ?? ????? * ??";
//$sql = "????? * ??";
$stmt = $pdo->prepare($sql);
$rs = $stmt ->execute(array($selectName));
if ($rs){
// PDO::FETCH_ASSOC 關(guān)聯(lián)數(shù)組TYPE式
// PDO::FETCH_NUM 數(shù)字索引數(shù)組shape式
?? ( $row = $stmt->fetch(PDO::FETCH_ASSOC)) {
?? $name,$age;
$name = $row['name'];
$age = $row['age' ];
}
}
$data='{name:"'.$name.'",age:"'.$age.'"}';
echo json_encode($data);? ?//打印?:"{??:"1",??:"1"}"
?>
為什么每次獲取的文是前一次查詢的數(shù)據(jù)?
? ?? ??? ?????. ? ??? ?? ???? ? ??? ajax ?????. ??? <input type="submit" value='query' id="btn"/> ???