小程序php接口开发：输出json数据，以dedecms织梦示例

微信小程序开发的朋友，对小程序接口开发不甚了解，网上能找到的有效教程少的可怜，最近一个朋友让帮忙写一个织梦的接口，在此记录一下。文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

直接上代码：文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

列表页接口：文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

<?php文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

header("Content-Type:application/json;charset=UTF-8");//此处声明返回的是json类型及字符集为utf-8文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$link=@mysql_connect("远程数据库地址","用户名","密码");文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

if(!$link){die("error");}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

@mysql_select_db("数据表名",$link);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$typeid=$_GET['typeid'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$sql="select * from dede_archives as a inner join dede_addonarticle as b on a.id=b.aid where a.typeid= '$typeid' ";//（inner语句多表查询可以把附表中的body字段加载出来）文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

mysql_query("SET NAMES 'utf8'");//这一点很重要，如果数据库为gbk，没有这句代码，输出中文的时候为空。文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$rs = mysql_query($sql,$link);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$json ="";文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$data =array(); //定义好一个数组.PHP中array相当于一个数据字典.文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

//定义一个类,用到存放从数据库中取出的数据文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

class Lists文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

public $title;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

while ($row= mysql_fetch_array($rs))文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists =new Lists();文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists->id = $row['id'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists->title = $row['title'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists->litpic = $row['litpic'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists->description = $row['description'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$data[]=$lists;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$res=array(文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

"success"=>"true",文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

"data"=>$data文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

echo json_encode($res);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

内容页接口：文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

<?php文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

header("Content-Type:application/json;charset=UTF-8");//此处声明返回的是json类型及字符集为utf-8文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$link=@mysql_connect("远程数据库地址","用户名","密码");文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

if(!$link){die("error");}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

@mysql_select_db("要选择的数据库",$link);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$id=$_GET['id'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$sql="select * from dede_archives as a inner join dede_addonarticle as b on a.id=b.aid where a.id= '$id' ";文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

mysql_query("SET NAMES 'utf8'");文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$rs = mysql_query($sql,$link);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$json ="";文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$data =array(); //定义好一个数组.PHP中array相当于一个数据字典.文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

//定义一个类,用到存放从数据库中取出的数据文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

class Lists文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

public $title;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

while ($row= mysql_fetch_array($rs))文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists =new Lists();文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists->id = $row['id'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists->title = $row['title'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists->litpic = $row['litpic'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists->description = $row['description'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists->writer = $row['writer'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists->click = $row['click'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists->pubdate =date("Y-m-d",  $row['pubdate']);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$lists->body = $row['body'];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$data[]=$lists;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

$res=array(文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

"success"=>"true",文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

"data"=>$data文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html

echo json_encode($res);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/xcx/8049.html