mint/app/collect/list.php

<?php
//文集列表

require_once "../config.php";
require_once "../public/_pdo.php";
require_once '../public/function.php';
require_once '../ucenter/function.php';


    $onepage = 100;
    if(isset($_GET["page"])){
        $onepage = $_GET["page"];
    }
    if(isset($_GET["begin"])){
        if($_GET["begin"]>=0){
            $begin=$_GET["begin"];
        }
        else{
            echo json_encode(array("data"=>array(),"next"=>-1), JSON_UNESCAPED_UNICODE);
            exit;
        }
    }
    else{
        $begin = 0;
    }
    PDO_Connect(_FILE_DB_USER_ARTICLE_);
    $query = "SELECT * FROM collect  where  status>=30 ";
    if(isset($_GET["orderby"])){
        switch ($_GET["orderby"]) {
            case 'like':
                # code...
                $query .="ORDER BY  DESC";
                break;
            
            default:
                # code...
                break;
        }
    }
    else{
        $query .="ORDER BY modify_time DESC";
    }
    $query .=" LIMIT ? , ? ";
    $Fetch = PDO_FetchAll($query,array($begin,$onepage));
    foreach ($Fetch as $key => $value) {
        # code...
        $userinfo = new UserInfo();
        $user = $userinfo->getName($value["owner"]);
        $Fetch[$key]["username"] = $user;
    }

    $output = array();
    $output["data"] =  $Fetch;
    if(count($Fetch)==$onepage){
        $output["next"] =  $begin+$onepage;
    }
    else{
        $output["next"] = -1;
    }

    echo json_encode($output, JSON_UNESCAPED_UNICODE);