01.<form name="form1" method="get" action="">
02. <input type="hidden" name="page" value="reportdata">
03. <div class="page-content">
04. <div class="page-header">
05. <h1>
06. สรุปประจำปี
07. <small>
08. <i class="ace-icon fa fa-angle-double-right"></i>
09.
10. <select name="selectyear" id="selectyear">
11. <option value ="">โปรดเลือก</option>
12. <?php
13. for ($y = 2021; $y <= 2030; $y++) { ?>
14. <option value ="<?=$y?>" <?=(isset($_GET['selectyear']) &&
15. $_GET['selectyear']=="$y")?" selected":""?> > <?=$y?> </option>
16. <?php } ?>
17.
18. </select>
19.
20. </small>
21. <small>
22. <button type="submit" class="btn btn-primary btn-sm" name="btn_search" id="btn_search">ค้นหา</button>
23.
24. <a href="index.php?page=reportdata" class="btn btn-danger btn-sm">ล้างค่า</a>
25. </small>
26.
27. </h1>
28.
29. </div><!-- /.page-header -->
30.
31. </form>
32.<?php
33. ini_set('display_errors', 1);
34. error_reporting(~0);
35.
36. $strKeyword = 2021;
37.
38. if(isset($_get["selectyear"]))
39. {
40. $strKeyword = $_get["selectyear"];
41. }
42. $sql = "SELECT * FROM tb_repiar ";
43. $sql.= " WHERE Year(date_repiar) = '" . $strKeyword . "' ";
44. $query = $conn->query($sql);
45. $count = $query->num_rows;
46.
47. ?>
48.
49. <div class="infobox-data">
50. <span class="infobox-data-number"><?php
51. echo "$count"; ?></span>
52. <div class="infobox-content">ปัญหาที่เกิดขึ้น</div>
53. </div>
54. </div>
