该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
//接口:获取演出类别
//1连接数据库
//$conn = mysql_connect("localhost","root","root");
//if($conn){
//echo "connect success".$conn;
//}else{
//echo "connect failed";
//}
header('content-type:application/json;charset=utf8');
$conn = mysql_connect("localhost","root","root") or die("connect failed".mysql_error());
//mysql_query("SET NAMES UTF8");
//2选择数据库
$select = mysql_select_db("sho***",$conn) or die("connect error".mysql_error());
//3执行aql语句
$sql = "select * from title";
$result = mysql_query($sql,$conn);
//4获取执行结果
$array = array();
$i = 0;
while($row = mysql_fetch_array($result)){
$array[$i]["title_biaoti"]=$row["title_biaoti"];
$array[$i]["title_content"]=$row["title_content"];
$i++;
}
mysql_close($conn);
//var_dump($array);
//6返回json
$json = json_encode(array(
"resultCode"=>"200",
"requset"=>"success",
"data"=>$array
));
echo $json;
?>