php 封装mysql查询的api

数据库设置

database.php(连接数据库)

<?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "manhua";
 
 

 
 
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
} 
 
//json格式
header("content-type:application/json");

?>

api.php

<?php
require_once "database.php";
$bookid=1;
$showlist="all";
$yeshu=20;
$page=1;


if(isset($_GET['bookid']))
{
	$bookid=$_GET["bookid"];
	$sql = "SELECT * FROM book where bookid=".$bookid."";
    $result = $conn->query($sql);
    $arr=[];
	if ($result->num_rows > 0) {
    // 输出数据
    while($row = $result->fetch_assoc()) {
       
	   $title=$row["bookname"];
	    // var_dump ($title);
	   array_push($arr,$title);
	   
    }
	echo json_encode($arr);
} else {
    echo "0 结果";
}

$conn->close();
}


if(isset($_GET['showlist']))
{

	if($_GET["showlist"]=="all"){    //监听GET传上来的值
	$page=$_GET["page"];
	$yeshu=$_GET["yeshu"];
	$start=($page-1)*$yeshu;
	$sql = "SELECT * FROM book limit ".$start.",".$yeshu."";
    $result = $conn->query($sql);
    $arr1=[];
	$arr2=[];
	$arr3=[];
	$arr4=[];
	$arr5=[];
	$arr6=[];
	// $arr7=[];
	// $arr8=[];
	if ($result->num_rows > 0) {
    // 输出数据
    while($row = $result->fetch_assoc()) {
       
	   $bookname=$row["bookname"];
	   $bookid=$row["bookid"];
	   $bookauthor=$row["bookauthor"];
	   $bookthemes=$row["bookthemes"];
	   $bookdes=$row["bookdes"];
	   $bookimg=$row["bookimg"];
	    // var_dump ($title);
	   array_push($arr1,$bookname);//把值放进数据
	   array_push($arr2,$bookid);
	   array_push($arr3,$bookauthor);
	   array_push($arr4,$bookthemes);
	   array_push($arr5,$bookdes);
	   array_push($arr6,$bookimg);
    }
	foreach ( $arr1 as $key => $bookname ) {//将数据转换成urlcode，在转换成json_encode,
最后又转换回urlcode，这样中文就不会乱码
	    $arr1[$key] = urlencode ( $bookname );
	}
	foreach ( $arr2 as $key => $bookid ) {
	    $arr2[$key] = urlencode ( $bookid );
	}
	foreach ( $arr3 as $key => $bookauthor ) {
	    $arr3[$key] = urlencode ( $bookauthor );
	}
	foreach ( $arr4 as $key => $bookthemes ) {
	    $arr4[$key] = urlencode ( $bookthemes );
	}
	foreach ( $arr5 as $key => $bookdes ) {
	    $arr5[$key] = urlencode ( $bookdes );
	}
	foreach ( $arr6 as $key => $bookimg ) {
	    $arr6[$key] = urlencode ( $bookimg );
	}
	echo urldecode ( json_encode ( $arr1 ) );   
	    echo urldecode ( json_encode ( $arr2 ) );   
	   echo urldecode ( json_encode ( $arr3 ) );   
	   echo urldecode ( json_encode ( $arr4 ) );   
	   echo urldecode ( json_encode ( $arr5 ) );   
	   echo urldecode ( json_encode ( $arr6 ) );   
	//    echo urldecode ( json_encode ( $arr1 ) );   
	// echo json_encode($arr1);
	// echo json_encode($arr2);
	// echo json_encode($arr3);
	// echo json_encode($arr4);
	// echo json_encode($arr5);
	// echo json_encode($arr6);
} else {
    echo "0 结果";
}
$conn->close();
}
}

?>

结果