course_list.php 868 B

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. <?php
  2. //
  3. require_once "../config.php";
  4. require_once "../public/_pdo.php";
  5. require_once '../public/load_lang.php';
  6. require_once '../media/function.php';
  7. require_once '../ucenter/function.php';
  8. /*
  9. 状态
  10. 0 删除
  11. 10 私有
  12. 20 不公开列出
  13. 30 公开连载
  14. 40 已完结
  15. */
  16. global $PDO;
  17. PDO_Connect(""._FILE_DB_COURSE_);
  18. if(isset($_GET["teacher"])){
  19. $query = "SELECT * from course where teacher = ? order by create_time DESC limit 0,100";
  20. $Fetch = PDO_FetchAll($query,array($_GET["teacher"]));
  21. }
  22. else{
  23. $query = "SELECT * from course where 1 order by create_time DESC limit 0,100";
  24. $Fetch = PDO_FetchAll($query);
  25. }
  26. $userinfo = new UserInfo();
  27. foreach ($Fetch as $key => $value) {
  28. # code...
  29. $user = $userinfo->getName($value["teacher"]);
  30. $Fetch[$key]["teacher_info"] = $user;
  31. }
  32. echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
  33. ?>