01.<?php $page = 'joblist';include 'include/menu.php'; ?>
02.<?php
03. include "include/dbcon.php";
04.$link = mysqli_connect($host, $username, $password, $db);
05.$link -> set_charset("utf8");
06.
07.if (mysqli_connect_errno()) {
08. printf("Connect failed: %s\n", mysqli_connect_error());
09. exit();
10.}
11.
12.$query = "SELECT * FROM jobs";
13.
14.if ($result = mysqli_query($link, $query)) {
15. $count=0;
16. while ($row = mysqli_fetch_assoc($result)) {
17. $position = $row['position'];
18. $description = $row['description'];
19.echo "<div class='container'>
20. <div class='row justify-content-start'>
21. <div class='col-4'>
22.
23.
25. <h2>{$position}</h2><hr>
26.
27. <p>{$description} </p>
28. <a href='#'><button type='button' class='btn btn-info' style='width:100%'><<รายละเอียด>></button></a>
29. </div>
30. </div>
31. </div>
32.
33. ";
34. $count++;
35. switch ($count){
36.
37.
38. case ($count % 4 == 0) ;
39. echo "<div class='clearfix visible-lg-block visible-md-block'></div>";
40. break ;
41.
42. case ($count % 2 == 0 && $count % 4 !==0 ) ;
43. echo "<div class='clearfix visible-sm-block'></div>";
44. break ;
45.
46. }
47.
48.}
49.mysqli_free_result($result);
50.}
51.
52.
53.mysqli_close($link);
54.?>
55.</body>
56.</html>
ครับ รับทราบ
