course_list.php 575 B

1234567891011121314151617181920212223242526272829303132
  1. <?php
  2. //
  3. require_once "../path.php";
  4. require_once "../public/_pdo.php";
  5. require_once '../public/load_lang.php';
  6. require_once '../media/function.php';
  7. /*
  8. 状态
  9. 0 删除
  10. 10 私有
  11. 20 不公开列出
  12. 30 公开连载
  13. 40 已完结
  14. */
  15. if(isset($_GET["teacher"])){
  16. $teacher = " teacher = '".$_GET["teacher"]."'";
  17. }
  18. else{
  19. $teacher = " 1= 1";
  20. }
  21. global $PDO;
  22. PDO_Connect("sqlite:"._FILE_DB_COURSE_);
  23. $query = "select * from course where $teacher order by create_time DESC limit 0,100";
  24. $Fetch = PDO_FetchAll($query);
  25. echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
  26. ?>