php--模拟接口的代码

返回xml的方式

<?php

/**
 *
 *
 */
//显示
function show($id)
{
    
    //连接数据库
    $pdo = new PDO('mysql:dbname=test;host=localhost','root','mysql123');
    $sql = "select * from user where user_id=:id";
    $pdo->query("set names utf8");
    $result = $pdo->prepare($sql);
    $result->execute(array('id'=>$id));
    return $result->fetch(PDO::FETCH_ASSOC);

}

$id = $_GET['id']?? 0;
//有返回值
if($id)
{
    $user = show($id);
    if(empty($user))
    {
        $user = array("errorno"=>"SN001","errormsg"=>'没有查找到数据！');
    }
}
else
{
    $user = array("errorno"=>"SN002","errormsg"=>"参数ID错误！");
}

//print_r($user);


/**
 *
 */
//转换成xml
function arrayToXml(array $arr)
{
    $xml = "<?xml version='1.0' encoding='utf-8' ?>";
    $xml .= "<root>";
    foreach ($arr as $key=>$value)
    {
        if(is_array($value))
        {
            $xml .= "<".$key.">".arrayToXml($value)."</".$key.">";
        }
        else
        {
            $xml .= "<".$key.">".$value."</".$key.">";
        }
    }
    $xml .= "</root>";
    return $xml;
}

header("Content-type:text/xml");

echo arrayToXml($user);

返回json格式

<?php

/**
 *
 *
 */

function show($id)
{
    $pdo = new PDO('mysql:dbname=test;host=localhost','root','mysql123');
    $sql = "select * from user where user_id=:id";
    $pdo->query("set names utf8");
    $result = $pdo->prepare($sql);
    $result->execute(array('id'=>$id));
    return $result->fetch(PDO::FETCH_ASSOC);

}

$id = $_GET['id']?? 0;

if($id)
{
    $user = show($id);
    if(empty($user))
    {
        $user = array("errorno"=>"SN001","errormsg"=>'没有查找到数据！');
    }
}
else
{
    $user = array("errorno"=>"SN002","errormsg"=>"参数ID错误！");
}

//print_r($user);
//返回json
echo json_encode($user);