Guest User

Untitled

a guest
Aug 8th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. <?php
  2.  
  3. $dbServername = "localhost"; //servername
  4. $dbUsername = "root"; //database username
  5. $dbPassword = ""; //database password
  6. $dbName = "iams"; //database name
  7.  
  8. //Create connection
  9. $conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
  10.  
  11. if(isset($_POST["sched_id"]))
  12. {
  13.  
  14. $sched_id = $_POST["sched_id"];
  15.  
  16. ?>
  17. <!-- Col-12 -->
  18. <div class="col-md-12">
  19.  
  20. <?php
  21.  
  22. $sql = "SELECT user.Schedule_ID, user.FullName FROM user
  23.  
  24. WHERE $sched_id IN (Schedule_ID) AND user.UserType = 0";
  25. $results = mysqli_query($conn, $sql);
  26. $row = mysqli_fetch_assoc($results);
  27.  
  28. ?>
  29. <div class="row">
  30. <?php
  31. foreach ($results as $i => $result) :
  32. $rows = ceil(count($result) / 3);
  33. ?>
  34. <?php if($i % $rows === 0 && $i !== 0): ?>
  35. </div><div class="row">
  36. <?php endif;?>
  37.  
  38. <div class="col-sm-4">
  39. <?php echo $result['FullName']; ?>
  40. </div>
  41. <?php endforeach;?>
  42.  
  43. </div>
  44.  
  45. </div>
  46.  
  47. <?php } ?>
Add Comment
Please, Sign In to add comment