course.php 4.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161
  1. <?PHP
  2. include "../pcdl/html_head.php";
  3. ?>
  4. <body>
  5. <?php
  6. require_once("../pcdl/head_bar.php");
  7. ?>
  8. <style>
  9. #main_video_win iframe{
  10. width:100%;
  11. height:100%;
  12. }
  13. </style>
  14. <?php
  15. //
  16. require_once "../path.php";
  17. require_once "../public/_pdo.php";
  18. require_once '../media/function.php';
  19. global $PDO;
  20. PDO_Connect("sqlite:"._FILE_DB_COURSE_);
  21. $query = "select * from course where id = '{$_GET["id"]}' limit 0,1";
  22. $Fetch = PDO_FetchAll($query);
  23. if(count($Fetch)==0)
  24. {
  25. echo "无法找到此课程。可能该课程已经被拥有者删除。";
  26. exit;
  27. }
  28. $course_info = $Fetch[0];
  29. $coverList[] = $course_info["cover"];
  30. $covers = media_get($coverList);
  31. foreach ($covers as $value) {
  32. $cover["{$value["id"]}"] = $value["link"];
  33. }
  34. if(isset($_GET["lesson"])){
  35. $query = "select * from lesson where id = '{$_GET["lesson"]}' limit 0,1";
  36. $fLesson = PDO_FetchAll($query);
  37. if(count($fLesson)>0){
  38. $lesson_info= $fLesson[0];
  39. }
  40. }
  41. echo "<div id='course_head_bar' style='background-color:gray;padding:3em 10px 10px 10px;'>";
  42. echo $course_info["teacher"]." > ";
  43. echo '<a href="../course/course.php?id='.$course_info["id"].'">'.$course_info["title"].'</a>';
  44. if(isset($lesson_info)){
  45. echo " > ".$lesson_info["title"];
  46. }
  47. echo '<div class="summary" style="padding-bottom:5px;">'.$course_info["subtitle"].'</div>';
  48. echo '</div>';
  49. echo '<div style="display:flex;">';
  50. echo '<div style="flex:7;">';
  51. $coverlink = $cover["{$course_info["cover"]}"];
  52. echo '<div id="main_video_win" class="v-cover">';
  53. if(isset($lesson_info)){
  54. echo $lesson_info["link"];
  55. }
  56. else{
  57. if(substr($coverlink,0,6)=="media:"){
  58. echo '<img src="'._DIR_USER_IMG_LINK_.'/' .substr($coverlink,6).'" width="100%" height="auto">';
  59. }
  60. else{
  61. echo '<img src="'.$coverlink.'" width="100%" height="auto">';
  62. }
  63. }
  64. echo '</div>';
  65. echo '</div>';
  66. //右侧lesson列表
  67. echo '<div style="flex:3;">';
  68. //课程视频
  69. $query = "select * from lesson where course_id = '{$_GET["id"]}' limit 0,100";
  70. $fAllLesson = PDO_FetchAll($query);
  71. $coverList = array();
  72. foreach($fAllLesson as $row){
  73. $coverList[] = $row["cover"];
  74. }
  75. $covers = media_get($coverList);
  76. foreach ($covers as $value) {
  77. $cover["{$value["id"]}"] = $value["link"];
  78. }
  79. $iLesson = 1;
  80. foreach($fAllLesson as $row){
  81. echo '<div class="pd-10">';
  82. echo 'Lesson:'.$iLesson;
  83. echo '<div class="title" style="padding-bottom:5px;"><a href="../course/course.php?id='.$_GET["id"].'&lesson='.$row["id"].'">'.$row["title"].'</a></div>';
  84. echo '<div class="author" style="padding-bottom:5px;">主讲:'.$row["teacher"].'</div>';
  85. echo '</div>';
  86. $iLesson++;
  87. }
  88. echo '</div>';
  89. echo '</div>';
  90. echo '<div class="couse_item">';
  91. echo '<div class="title">';
  92. echo '简介';
  93. echo '</div>';
  94. echo '<div class="detail">';
  95. if(isset($lesson_info)){
  96. echo $lesson_info["summary"];
  97. }
  98. else{
  99. echo $course_info["summary"];
  100. }
  101. echo '</div>';
  102. echo '</div>';
  103. echo '<div class="couse_item">';
  104. echo '<div class="title">';
  105. echo '课程列表';
  106. echo '</div>';
  107. echo '<div class="detail">';
  108. foreach($fAllLesson as $row){
  109. echo '<div style="display:flex;">';
  110. echo '<div style="flex:3;">';
  111. $coverlink = $cover["{$row["cover"]}"];
  112. echo '<div class="v-cover">';
  113. if(substr($coverlink,0,6)=="media:"){
  114. echo '<img src="'._DIR_USER_IMG_LINK_.'/'.substr($coverlink,6).'" width="100%" height="auto">';
  115. }
  116. else{
  117. echo '<img src="'.$coverlink.'" width="50" height="50">';
  118. }
  119. echo '</div>';
  120. echo '</div>';
  121. echo '<div style="flex:7;">';
  122. echo '<div class="pd-10">';
  123. echo '<div class="title" style="padding-bottom:5px;"><a href="../course/course.php?id='.$row["id"].'">'.$row["title"].'</a></div>';
  124. echo '<div class="summary" style="padding-bottom:5px;">'.$row["subtitle"].'</div>';
  125. echo '<div class="summary" style="padding-bottom:5px;">'.$row["summary"].'</div>';
  126. echo '<div class="author" style="padding-bottom:5px;">主讲:'.$row["teacher"].'</div>';
  127. echo '</div>';
  128. echo '</div>';
  129. echo '</div>';
  130. }
  131. echo '</div>';
  132. echo '</div>';
  133. ?>
  134. <script>
  135. $("#main_video_win").height($("#main_video_win").width()*9/16);
  136. </script>
  137. <?php
  138. include "../pcdl/html_foot.php";
  139. ?>