แก้ไขข้อมูล หรือ UPDATE ข้อมูลในตาราง Database โดยใช้ Ajax jQuery

$.ajax({ url: 'U.urllink', type:'post', data: { name: 'xxx', amt: 123}, dataType: 'json'
	error: ( jqXHR, exception'){
		var msg = '';
		if (jqXHR.status === 0) { msg = 'Not connect.\n Verify Network.';
		} else if (jqXHR.status === 404) { msg = 'Requested page not found. [404]';
		} else if (jqXHR.status === 500) { msg = 'Internal Server Error [500].';
		} else if (exception === 'parsererror') { msg = 'Requested JSON parse failed.';
		} else if (exception === 'timeout') { msg = 'Time out error.';
		} else if (exception === 'abort') { msg = 'Ajax request aborted.';
		} else { msg = 'Uncaught Error.\n' + jqXHR.responseText;
		}
	},
	success: rs=>{
		alert(rs.test);
	}
});

<?php
$name = filter_input(INPUT_POST, 'name');
$amt = filter_input(INPUT_POST, 'amt');
$db = new mysqli('host','user','pswd','dbname');
if( $db->errno){ die($db->error);}
$db->query('update ...................') or die($db->error)
echo json_encode(['test'=>'จำนวนที่ อัพเดท '.$db->affected_row]);