图书管理系统(后端)--查询读者信息

1.查询函数文件dbop.php

<?php
    function qry_admin_niki_read_info($conn)
    {
        $query = "select name,bnum,vnum from NIKI_READ_INFO";

        $result = $conn->query($query);

        $i = 0;

        if($result->num_rows > 0)
        {
            while($row = $result->fetch_assoc())
            {
                $col[$i] = $row;
                $i++;
            }
        }

        return $col;
    }
?>

2.api封装2.php文件

<?php
    require "dbop.php";

    //$recv = json_decode(file_get_contents('php://input'));

    $conn = new mysqli("localhost", "niki", "niki", "niki") or dir("不能连接到mysql");

    $conn->query("set names utf8");

    $res = qry_admin_niki_read_info($conn);

    echo json_encode($res);

    $conn->close();
?>

3.测试脚本read_info_qry.sh

#!/bin/bash

curl -H "Content-Type:application/json" -X POST --data '{
    "label": 1,
    "orderid": "1"
}' http://10.192.89.12/local/2/2.php

4.运行脚本

$ ./read_info_qry.sh