Home > Article > Backend Development > PHP example - PHP writes app interface and returns JSON data example (share)
The following editor will bring you an example (share) of writing an app interface in PHP and returning json data. The editor thinks it is quite good, so I will share it with you now and give it as a reference for everyone. Let’s follow the editor and take a look.
The first step: conn.PHP file, used to connect to the databaseAnd define the interface format, the code is as follows:
<?php
header("charset=utf-8");
$servername="localhost";
$username="root";
$password="root";
$dbname="test";
$conn = mysql_connect($servername,$username,$password);
if(!$conn){
echo "数据库连接失败！";
}
mysql_select_db($dbname);
class Response{
public static function json($code,$message="",$data=array()){
$result=array(
'code'=>$code,
'message'=>$message,
'data'=>$data
);
//输出json
echo json_encode($result);
exit;
}
}
?>The second step: text.php, used to convert the data in the database into a json string, and output:
<?php
require_once('conn.php');
/*
*选择数据表
* */
$sqla = "SELECT * from user";
$result = mysql_query($sqla,$conn);
$dataarr = array();
while($row = mysql_fetch_array($result)){
$dataarr[]=$row;
}
$id=$_GET['id'];
if($id==1){
Response::json(1,'数据返回成功',$dataarr);
}else if($id==2){
Message::json(0,'失败');
}
?>The third step : text.html, ajax loads json data and displays:
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
<script src="jquery/2.0.0/jquery.min.js"></script>
</head>
<body>
<input id="text" type="text"/>
<input type="button" id="tijiao" value="提交" />
<p id="tex"></p>
<script type="text/javascript">
$("#tijiao").click(function(){
var data={"id":$("#text").val()}
$.get("text.php?flag=showmessage",data,function(res){
res=JSON.parse(res);//<span style="color:#cc0000;">将json字符串转化为json对象</span>
if(res.code==1){
$("#tex").empty();
$.each(res.data, function(x,y) {
$("#tex").append("id:"+y.id+"/姓名:"+y.username+"<br>");
});
}
})
})
</script>
</body>
</html>In this way, you can use php to write the json interface.
The above is the detailed content of PHP example - PHP writes app interface and returns JSON data example (share). For more information, please follow other related articles on the PHP Chinese website!