php API查询数据

<?php
session_start();

if (key_exists('page', $_GET)) {
    if(intval($_GET['page'])>0){
        // 判断是否存在次数
        if (isset($_SESSION['LIMIT'])) {
            // 判断是否已经访问了2000次
            if ($_SESSION['LIMIT'] > 2000) {
                // 判断如果超过2000次则12小时后才能再次访问
                if (intval(time()) - intval($_SESSION['XS_TIME']) >= 43200) {
                    $_SESSION['LIMIT'] = 0;
                }
                $data = array(0, 'error', "Rate Limit Exceeded");
                header('Content-Type: application/json');
                echo json_encode($data);
            } else {
                $_SESSION['XS_TIME'] = time();
                $_SESSION['LIMIT'] = $_SESSION['LIMIT'] + 1;
                $servername = "localhost";
                $username = "xx";
                $password = "xx";
                $dbname = 'xx';
                $link = mysqli_connect($servername, $username, $password);
                if (!$link) {
                    die('Could not connect to MySQL: ' . mysqli_error());
                } else {
                    $pdo = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
                    $pdo->exec('set names utf8');
                    // 总页数
                    $sum = "SELECT * FROM ay_content WHERE id != 1 AND id != 2 AND id != 3 AND id != 20 AND id != 21 AND id != 22 AND id != 23 AND id != 26 AND id != 27 AND id != 109 AND id != 110 AND id != 111 AND id != 112 AND id != 113 AND id != 119 AND id != 753 AND id != 754 AND id != 755";
                    //分页
                    $sql = "SELECT ay_content.id,ay_content.scode,ay_content.title,author,source,ay_content.date,ay_content.ico,ay_content.pics,ay_content.content,ay_content.tags,enclosure,ay_content.keywords,ay_content.description,ay_content.sorting,ay_content.status,ay_content.istop,ay_content.isrecommend,ay_content.isheadline,ay_content.visits,ay_content.likes,ay_content.oppose,ay_content.create_user,ay_content.update_user,ay_content.create_time,ay_content.update_time,ay_content_sort.name AS className FROM ay_content INNER JOIN ay_content_sort ON ay_content.scode=ay_content_sort.id LIMIT   ".((intval($_GET['page'])-1) * 100).",100";
                    $sum = $pdo->query($sum);
                    $sum = $sum->fetchAll(PDO::FETCH_ASSOC);
                    $num = count($sum);
                    $page = intval($num / 100);
                    if($num % 100 !=0){
                        $page +=1;
                    }
                    $smt = $pdo->query($sql);
//总数据数
                    $rows['num'] = count($sum);
//分页总数
                    $rows['page_count'] = $page;
//当前页数
                    $rows['page'] = $_GET['page'];
                    $smt = $smt->fetchAll(PDO::FETCH_ASSOC);
//当前页数据总数
                    $rows['page_num'] = count($smt);
//当前页数据
                    $rows['data'] = $smt;
                    $rows = json_encode($rows);
                    $data = json_decode($rows);
                    $data = array(1, 'success', $data);
                    header('Content-Type: application/json');
                    echo json_encode($data);
                };
                mysqli_close($link);
            }
        } else {
            $_SESSION['LIMIT'] = 0;
        }
    } else {
        $data = array(0, 'error', "Please pass in the correct parameters");
        header('Content-Type: application/json');
        echo json_encode($data);
    }
}else{
    $data = array(0, 'error', "Please pass in the correct parameters");
    header('Content-Type: application/json');
    echo json_encode($data);
}