PHP代码返回json数据:
<?php
//链接数据库 查询相关内容
$con=mysqli_connect("localhost", "root", "123456", "school");
if(!$con){
die("can not connect");
}
//编写查询语句
$sql="SELECT * FROM `websites`";
$result=mysqli_query($con, $sql);
while ($row=mysqli_fetch_assoc($result)) {
$rows[]=$row;
}
echo json_encode($rows);//封装成json数据
?>
前端界面接收json数据并显示:
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<meta http-equiv="X-UA-Compatible" content="ie=edge" />
<title>Document</title>
<!--<script type="text/javascript">
//原生ajax
if(new XMLHttpRequest()){
var xmlhttp=new XMLHttpRequest();
}else{
var xmlhttp=n