<?php
//生成一个xml格式的数据接口
//从数据库中获取数据
//接收条件
header("content-type:text/xml;charset=utf-8");
$key=isset($_GET['title'])?$_GET['title']:"";
$where=1;
if($key){
$where.="and name like '%$key%'";
}
$pdo=new PDO('mysql:host=127.0.0.1;dbname=php7;','root','root');
$sql="select * from bb where $where ";
$data=$pdo->query($sql)->fetchALL(PDO::FETCH_ASSOC);
//var_dump($data);
echo "<?xml version='1.0' encoding='utf-8'?>";
echo "<news>";
foreach ($data as $key => $value) {
echo "<msg>";
echo "<name>".$value['name']."</name>";
echo "<pwd>".$value['pwd']."</pwd>";
echo "</msg>";
}
echo "</news>";
?> #单纯的xml实例
<?php
//生成一个xml格式的数据接口
//从数据库中获取数据
//接收条件
$format=isset($_GET['format'])?$_GET['format']:"";
if($format=='xml'){
header("content-type:text/xml;charset=utf-8");
$key=isset($_GET['title'])?$_GET['title']:"";
$where=1;
if($key){
$where.="and name like '%$key%'";
}
$pdo=new PDO('mysql:host=127.0.0.1;dbname=php7;','root','root');
$sql="select * from bb where $where ";
$data=$pdo->query($sql)->fetchALL(PDO::FETCH_ASSOC);
//var_dump($data);
echo "<?xml version='1.0' encoding='utf-8'?>";
echo "<news>";
foreach ($data as $key => $value) {
echo "<msg>";
echo "<name>".$value['name']."</name>";
echo "<pwd>".$value['pwd']."</pwd>";
echo "</msg>";
}
echo "</news>";
}else{
$key=isset($_GET['title'])?$_GET['title']:"";
$where=1;
if($key){
$where.="and name like '%$key%'";
}
$pdo=new PDO('mysql:host=127.0.0.1;dbname=php7;','root','root');
$sql="select * from bb where $where ";
$data=$pdo->query($sql)->fetchALL(PDO::FETCH_ASSOC);
echo json_encode($data);
}
?> #判断xml实例还是json实例
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>Document</title>
<script src="jquery-2.1.4.min.js"></script>
<!--
<script type="text/javascript">
function data (msg) {
alert(msg)
}
</script>
<script type="text/javascript" src="http://localhost/1.php?callback=data"></script>
-->
</head>
<body>
<div id="div1"></div>
<script type="text/javascript">
var url="http://localhost/1.php?callback=?";
$.get(url,function(msg){
alert(msg)
},'jsonp');
</script>
</body>
</html>
<?php
//jsonp格式的接口
//取数据
$key=isset($_GET['title'])?$_GET['title']:"";
$where=1;
if($key){
$where.="and name like '%$key%'";
}
$pdo=new PDO('mysql:host=127.0.0.1;dbname=php7;','root','root');
$sql="select * from bb where $where ";
$data=$pdo->query($sql)->fetchALL(PDO::FETCH_ASSOC);
$str=json_encode($data);
$callback=isset($_GET['callback'])?$_GET['callback']:"data";
echo $callback."(".$str.")";
?> #jsonp实例
http://www.fqq.com/seven/review/jsonp.php jsonp格式实例
http://www.fqq.com/seven/review/xml.php?keyword=zs&format=xml xml格式实例
http://www.fqq.com/seven/review/xml.php?keyword=zs json格式实例