var request = new XMLHttpRequest();
request.open("GET","get.php",true);
request.send();
request.onreadystatechange = function(){
if(request.readyState = = =4&& request.state = = =200){
//做一些事情 request.responseText
}
}
JQajax:
$.ajax({
// async:false,//同步 默认是true 异步
url:"ajax.php",//请求的服务器地址
data:{uid:"lisi",pwd:"123"},//发送的数据
type:"post",//提交方式 默认 get
dataType:"text",//接收服务器返回的数据格式
success:function(data){//ajax执行成功的回调
chuli(data);
}
});
php页面链接数据库:
//$db 是数据库的连接资源
$db = new MySQLi("localhost","root","","z_0705");
!mysqli_connect_error() or die("数据库连接错误");
$db->query("set names utf8");
//写sql语句
$sql = "select * from student";
//执行sql 语句 返回 <b>结果集</b>
$res = $db->query($sql);
//把结果集转成数组 from form
$arr = $res->fetch_all();
//var_dump($arr);
echo arrToStr($arr);
返回的二维数组转为字符串:
//二维数组转字符串
function arrToStr($arry){//$arry是结果集返回的二维数组
$brr = array();//用来存数组转字符串
foreach($arry as $v){
$brr[] = implode(",",$v);//数组转字符串
}
$brr = implode("^",$brr);//数组转字符串
return $brr;
}
传到html页面,ajax接收:
引用jquery:<script src="/JS/jquery-3.1.1.min.js"></script>
$.ajax({
// async:false,//同步 默认是true 异步
url:"ajax.php",//请求的服务器地址
data:{uid:"lisi",pwd:"123"},//发送的数据
type:"post",//提交方式 默认 get
dataType:"text",//接收服务器返回的数据格式
success:function(data){//ajax执行成功的回调
chuli(data);
}
});
字符串转成二维数组:
/*把字符串转二维数组
101,李军,女,1976-02-20 00:00:00,95033^
103,陆君,男,1974-06-03 00:00:00,95031^
105,匡明,男,1975-10-02 00:00:00,95031
*/
function chuli(data){
var arr = data.split("^");//一维数组
var brr = [];//二维数组
for(var i = 0; i <arr.length;i++){
var trmp = arr[i].split(",");
brr.push(trmp);
}
addHtml(brr);
}
页面展示:
/*往页面追加元素*/
function addHtml(brr){
var str = "<table width='100%' border='1'>";
for(var i =0;i<brr.length;i++){
str += `
<tr>
<td>`+brr[i][0]+`</td>
<td>`+brr[i][1]+`</td>
<td>`+brr[i][2]+`</td>
<td>`+brr[i][3]+`</td>
<td>`+brr[i][4]+`</td>
</tr>`;
}
str += "</table>";
document.write(str);
}