接口的使用

最新推荐文章于 2022-07-22 08:14:49 发布

Er_Ni

最新推荐文章于 2022-07-22 08:14:49 发布

阅读量385

点赞数

分类专栏： xml json jsonp接口

本文链接：https://blog.csdn.net/Er_Ni/article/details/51276903

版权

jsonp接口同时被 3 个专栏收录

2 篇文章 0 订阅

订阅专栏

xml

1 篇文章 0 订阅

订阅专栏

json

1 篇文章 0 订阅

订阅专栏

<?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格式实例

Er_Ni

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
接口的使用

<?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=ne
复制链接

扫一扫

专栏目录