overzicht.php 2.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  1. <?php
  2. if($stmt = $mysqli -> prepare("SELECT FolloweID FROM Twitter WHERE uid = ?")){
  3. $stmt -> bind_param("i", $userid);
  4. $stmt -> execute();
  5. $stmt -> bind_result($FollowerID);
  6. $stmt -> fetch();
  7. $stmt -> close();
  8. }
  9. ?>
  10. <div class="col-lg-12">
  11. <div class="ibox float-e-margins">
  12. <div class="ibox-title">
  13. <h5>Twitter Integratie</h5>
  14. <div class="ibox-tools">
  15. <a class="collapse-link">
  16. <i class="fa fa-chevron-up"></i>
  17. </a>
  18. <a class="dropdown-toggle" data-toggle="dropdown" href="#">
  19. <i class="fa fa-wrench"></i>
  20. </a>
  21. <ul class="dropdown-menu dropdown-user">
  22. <li><a href="twitter.php?i=configuration">New follower</a></li>
  23. </ul>
  24. <a class="close-link">
  25. <i class="fa fa-times"></i>
  26. </a>
  27. </div>
  28. </div>
  29. <div class="ibox-content">
  30. <table class="table table-striped">
  31. <thead>
  32. <tr>
  33. <th>Follower</th>
  34. </tr>
  35. </thead>
  36. <tbody>
  37. <?php
  38. if($stmt = $mysqli -> prepare("SELECT FollowerID FROM Twitter WHERE uid=?")){
  39. $stmt -> bind_param('i', $userid);
  40. $stmt -> execute();
  41. $stmt -> bind_result($FollowerID);
  42. while($result = $stmt -> fetch()){
  43. print '
  44. <tr>
  45. <td>'.$FollowerID.'</td>
  46. <td style="width: 100px !important" class="text-center valign-middle" >
  47. <a href="twitter.php?i=wijzigen&FollowerID='.$FollowerID.'"><button class="btn btn-xs btn-primary"><i class="fa fa-pencil"></i></button></a>
  48. &nbsp;
  49. <a href="twitter.php?i=verwijderen&FollowerID='.$FollowerID.'"><button class="btn btn-xs btn-danger"><i class="fa fa-times"></i></button></a>
  50. </td>
  51. </tr>
  52. ';
  53. };
  54. $stmt -> close();
  55. }
  56. ?>
  57. </tbody>
  58. </table>
  59. </div>
  60. </div>
  61. </div>