teacher_list.php 1003 B

1234567891011121314151617181920212223242526272829303132333435
  1. <?php
  2. //
  3. require_once "../config.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( _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="teacher_photo"></div>';
  14. echo '<div class="teacher_text">';
  15. echo '<div class="title"><a href="../uhome/course.php?userid=' . $value['teacher'] . '">' . ucenter_getA($value['teacher']) . '</a></div>';
  16. echo '<div class="teacher_intro">';
  17. /*
  18. PDO_Connect(_FILE_DB_USERINFO_);
  19. $query = "SELECT bio from profile where user_id = ? limit 0,10";
  20. $Fetch = PDO_FetchAll($query,array($value['teacher']));
  21. if($Fetch){
  22. echo $Fetch[0]["bio"];
  23. }
  24. else{
  25. echo "";
  26. }
  27. */
  28. echo '</div>';
  29. echo '</div>';
  30. echo '</div>';
  31. }