list_new.php 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  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. global $PDO;
  8. PDO_Connect("sqlite:"._FILE_DB_COURSE_);
  9. $query = "select * from course where 1 order by create_time DESC limit 0,4";
  10. $Fetch = PDO_FetchAll($query);
  11. $coverList = array();
  12. foreach($Fetch as $row){
  13. $coverList[] = $row["cover"];
  14. }
  15. $covers = media_get($coverList);
  16. foreach ($covers as $value) {
  17. $cover["{$value["id"]}"] = $value["link"];
  18. }
  19. foreach($Fetch as $row){
  20. echo '<div class="content_block">';
  21. echo '<div class="card">';
  22. echo '<div class="pd-10">';
  23. echo '<div class="title" style="padding-bottom:5px;font-size:110%;font-weight:600;"><a href="../course/course.php?id='.$row["id"].'">'.$row["title"].'</a></div>';
  24. echo '<div class="summary" style="padding-bottom:5px;">'.$row["subtitle"].'</div>';
  25. echo '<div class="author" style="padding-bottom:5px;margin-bottom:0.4em;">主讲:'.$row["teacher"].'</div>';
  26. echo '<div class="summary" style="padding-bottom:5px;">'.$row["summary"].'</div>';
  27. echo '</div>';
  28. echo '<div class="pd-10" style="display:flex;justify-content: space-between;">';
  29. echo '<button>赞<span>3</span></button><button>订阅<span>23</span></button>';
  30. echo '</div>';
  31. echo '</div>';
  32. echo '</div>';
  33. }
  34. ?>