1
0

load_fines.php 1.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. <?php
  2. require_once($_SERVER['DOCUMENT_ROOT'] . "/modules/core/header.php");
  3. if(!isset($link))
  4. {
  5. $link = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);
  6. if($link === false)
  7. {
  8. die("ERROR: Could not connect. " . mysqli_connect_error());
  9. }
  10. }
  11. $user_check_query = "SELECT * FROM `fines`";
  12. $res = mysqli_query($link, $user_check_query);
  13. $rowcount = $res->num_rows;
  14. if($rowcount > 0)
  15. {
  16. $i = 0;
  17. while($result2 = mysqli_fetch_array($res, MYSQLI_ASSOC))
  18. {
  19. $fine_data[$i] = $result2;
  20. $i++;
  21. }
  22. }
  23. if($rowcount > 0)
  24. {
  25. for($i = 0; $i < $rowcount; $i++)
  26. {
  27. $ID = $fine_data[$i]['id'];
  28. $Name = $fine_data[$i]['addressee'];
  29. $Amount = $fine_data[$i]['price'];
  30. $Reason = $fine_data[$i]['reason'];
  31. $Date = $fine_data[$i]['date'];
  32. $Finer = $fine_data[$i]['cop'];
  33. $Agency = $fine_data[$i]['agency'];
  34. ?>
  35. <tr class="kari">
  36. <td><?php echo $ID; ?></td>
  37. <td><?php echo $Name; ?></td>
  38. <td>$<?php echo $Amount; ?></td>
  39. <td><?php echo $Reason; ?></td>
  40. <td><?php echo $Date; ?></td>
  41. <td>N/A</td>
  42. <td><?php echo $Finer; ?></td>
  43. <td><?php echo $Agency; ?></td>
  44. </tr>
  45. <?php
  46. }
  47. }
  48. ?>