亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

$.ajax() gets background data
等一個人
等一個人 2019-03-06 14:41:57
0
3
1476

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">

Name: <input type="text" name="name" id="name"/>

<input type="submit" value='查詢' id="btn"/>

</form>

<script type="text/javascript">

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

$("#btn").on("click", function () {

$.ajax({

type: "POST",

url: "PDO_insert.php",//url放的是當前頁面請求的后臺地址。

data:{name:name},

async:false,

dataType: "json",?

success: function (data) {

var result=data;

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

alert(result);

},

error: function () {

alert("請求失??!");

}

});

});

</script>

</body>

</html>



<?php?


$host = 'localhost';

$database = 'test';

$username = 'root';

$password = 'root';

$selectName = $_POST['name'];

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

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

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

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

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

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


if ($rs){

// PDO::FETCH_ASSOC 關聯(lián)數(shù)組形式

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

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\"}"

?>

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

等一個人
等一個人

reply all(1)
三言

You are equivalent to two queries, the first is a form query, the second is an ajax query, you put <input type="submit" value='query' id="btn"/> this Try putting it outside the form

  • reply I tried it, but the PHP code will not execute.
    等一個人 author 2019-03-06 17:13:10
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template