<?php header("content-type:text/html;charset=utf-8"); $address=$_GET['goods_category']; $dtype=isset($_GET['dtype']) ? $_GET['dtype'] : 'json'; $appKey=$_GET['key']; $key=md5("luyaran7"); //echo $key;die; if($appKey != $key){ die("非法请求"); } $pdo=new PDO("mysql:host=localhost;dbname=shopCity","root","root"); $pdo->exec("set names utf8"); $sql="select * from goods where goods_category='$address'"; $arr=$pdo->query($sql)->fetchAll(); if($dtype=='json'){ //生成json格式数据 echo json_encode($arr); }else{ //生成XML格式数据 echo '<?xml version="1.0" encoding="utf-8" ?>'; echo '<goods>'; foreach($arr as $key=>$val){ echo '<good>'; echo "<name>{$val['goods_name']}</name>"; echo "<sn>{$val['goods_sn']}</sn>"; echo "<content>{$val['goods_content']}</content>"; echo '</good>'; } echo '</goods>'; } //$url="http://localhost/Year.php?goods_category=7&key=149b55b72f578dedbf50f6b8330ea3a5&dtype=json"; ?>
PHP接口的编写
最新推荐文章于 2024-10-15 15:52:03 发布