teacher_list.php 1.0 KB

1234567891011121314151617181920212223242526272829
  1. <?php
  2. //
  3. require_once "../path.php";
  4. require_once "../public/_pdo.php";
  5. require_once '../public/load_lang.php';
  6. require_once '../ucenter/function.php';
  7. global $PDO;
  8. PDO_Connect("sqlite:"._FILE_DB_COURSE_);
  9. $query = "select teacher,count(*) as co from course where 1 group by teacher order by co DESC limit 0,4";
  10. $Fetch = PDO_FetchAll($query);
  11. foreach($Fetch as $value){
  12. echo '<div class="content_block">';
  13. echo '<div class="card pd-10">';
  14. echo '<div class="title" style="padding-bottom:5px;font-size:110%;font-weight:600;"><a href="../uhome/course.php?userid='.$value['teacher'].'">'.ucenter_getA($value['teacher']).'</a></div>';
  15. $query = "select id, title from course where teacher = '{$value['teacher']}' order by create_time DESC limit 0,5";
  16. $FetchTeacher = PDO_FetchAll($query);
  17. foreach($FetchTeacher as $row){
  18. echo '<div class="title" style="padding-bottom:5px;"><a href="../course/course.php?id='.$row["id"].'">'.$row["title"].'</a></div>';
  19. }
  20. echo '</div>';
  21. echo '</div>';
  22. }
  23. ?>