list.php 691 B

123456789101112131415161718192021
  1. <?php
  2. //文章列表
  3. require_once "../config.php";
  4. require_once "../public/_pdo.php";
  5. require_once '../public/function.php';
  6. require_once '../ucenter/function.php';
  7. PDO_Connect(_FILE_DB_USER_ARTICLE_,_DB_USERNAME_,_DB_PASSWORD_);
  8. if(isset($_GET["userid"])){
  9. $userid=$_GET["userid"];
  10. $query = "SELECT uid as id , title,subtitle ,summary,content,owner,setting,status,lang,create_time,modify_time from "._TABLE_ARTICLE_." where owner = ? and status <> 0 order by modify_time DESC";
  11. $Fetch = PDO_FetchAll($query,array($userid));
  12. if($Fetch){
  13. echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
  14. exit;
  15. }
  16. }
  17. echo json_encode(array(), JSON_UNESCAPED_UNICODE);
  18. ?>