返回查询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数据:
<?php
//请求的参数
$id=intval($_POST['id']);
$con=mysqli_connect("localhost", "root", "123456", "school");
if(!$con){
die("can not connect");
}
//编写查询语句
//$sql="update `websites` set name='111' where id=$id";
$sql="update `websites` set name='111' where id=$id";
$result=mysqli_query($con, $sql);
$n=mysqli_affected_rows($con);
//组织一下返回的json文件
$response=[];
if($n>0){
$response=array(
'e