course_list.php 494 B

1234567891011121314151617181920212223
  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. if(isset($_GET["teacher"])){
  8. $teacher = " teacher = '".$_GET["teacher"]."'";
  9. }
  10. else{
  11. $teacher = " 1= 1";
  12. }
  13. global $PDO;
  14. PDO_Connect("sqlite:"._FILE_DB_COURSE_);
  15. $query = "select * from course where $teacher order by create_time DESC limit 0,100";
  16. $Fetch = PDO_FetchAll($query);
  17. echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
  18. ?>