Jquery ajax 完整執行個體子1

標籤：enc   pos   his   child   inpu   end   put   char   val   

 

$ajax請求---------------------------------

var $personWifePs=$("#wife-money tbody tr");
var $personWife=$("#wife-money").find("input.write");
var $val=null;
$.ajax({
type: "POST",
url: "data/hm_monery_serceh.php",
success: function(dtmonery){
var $list = JSON.parse(dtmonery);
for(info in $list) {
$personWifePs.append(`<td>
<input id="d${n+=1}" value="${$list[info].monery}" class="write" type="text"/>
</td>`)
$personWife.val($list[info].monery);
}
}
});

$personWifePs.on("change",".write",function(){
var $iput=$(this);
$val=$(this).val();
var $index=$personWifePs.children().find("input").index($(this)[0]);
$.ajax({
type: "POST",
url: "data/hm_monery_update.php",
data: "id="+($index+1)+"&monery="+$val,
success: function(dtmonery){
var $listone = JSON.parse(dtmonery);
$iput.val($listone.monery);
}
});
});

PHP公用---------------------------------

<?php
//1:將串連資料庫與設定編碼程式儲存
// init.php中
//2:哪個php需要資料庫連接
// require(‘init.php‘);
//require載入-->init.php
$conn = mysqli_connect(‘127.0.0.1‘,‘root‘,‘‘,‘home‘);
$sql = "SET NAMES UTF8";
mysqli_query($conn,$sql);
?>

更新PHP-------------------

<?php
//1:修改響應資料類型
header("Content-Type:text/plain;charset=utf-8");
//2:擷取所有參數
@$n = $_REQUEST[‘id‘] or die("-2");
@$m = $_REQUEST[‘monery‘] or die("-3");
//3:串連資料庫 設定編碼
require("init.php");
//4:建立sql 發送sql
$sql = "UPDATE hm_moneryone SET monery =$m WHERE id = $n ";
$result = mysqli_query($conn,$sql);

$sql = "SELECT * FROM hm_moneryone WHERE id=$n";
$result = mysqli_query($conn,$sql);
$back = mysqli_fetch_assoc($result);
$json = json_encode($back);
echo $json;
?>

查詢PHP--------------------

<?php
//0:修改回應標頭訊息 text/html
header("Content-Type:text/html;charset=utf-8");
//2:串連資料庫 設定編碼
require("init.php");
//3:建立sql 發送sql
$sql = "SELECT * FROM hm_moneryone";
//4:抓取多行記錄
$result = mysqli_query($conn,$sql);
$rows = mysqli_fetch_all($result,MYSQLI_ASSOC);
$json = json_encode($rows);
echo $json;
?>

Jquery ajax 完整執行個體子1