国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

Name:

<輸入類(lèi)型=“提交”值='查詢'id =“btn”/>

< script type="text/javascript">

? ? ? ? var name=document.getElementById('name').value;

$("#btn"). on("點(diǎn)擊", function () {

$.ajax({

type: "POST",

url: "PDO_insert.php",//url放當(dāng)前是頁(yè)面請(qǐng)求的后臺(tái)地址。

data:{name:name},

async:false,

dataType: "json",?

success: function (data) {

var result=data;

//var result = eval('[' + data + ']');

alert(result);

},

error: function () {

alert("請(qǐng)求失敗！");

}

});

});

</script>

</body>

</html>

## $host = 'localhost';

$database = 'test ';

$用戶名 = 'root';

$password = 'root';

$selectName = $_POST['name'];

$pdo = new PDO("mysql:host=$host;dbname=$database", $username, $password);//創(chuàng)建一個(gè)pdo對(duì)象

$pdo-> ;exec("set names 'utf8'");//設(shè)置數(shù)據(jù)庫(kù)編碼

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

//$sql = "select * 來(lái)自用戶";

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

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

if ($rs){

// PDO::FETCH_ASSOC 關(guān)聯(lián)備份形式

// PDO::FETCH_NUM 數(shù)字索引備份形式

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

全局 $name,$age;

$name = $row[ '姓名'];

$age = $row['age'];

}

}

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

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

?>

為什么每次獲取的都是前一次查詢的數(shù)據(jù)？