Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbServername = "localhost"; //servername
- $dbUsername = "root"; //database username
- $dbPassword = ""; //database password
- $dbName = "iams"; //database name
- //Create connection
- $conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
- if(isset($_POST["sched_id"]))
- {
- $sched_id = $_POST["sched_id"];
- ?>
- <!-- Col-12 -->
- <div class="col-md-12">
- <?php
- $sql = "SELECT user.Schedule_ID, user.FullName FROM user
- WHERE $sched_id IN (Schedule_ID) AND user.UserType = 0";
- $results = mysqli_query($conn, $sql);
- $row = mysqli_fetch_assoc($results);
- ?>
- <div class="row">
- <?php
- foreach ($results as $i => $result) :
- $rows = ceil(count($result) / 3);
- ?>
- <?php if($i % $rows === 0 && $i !== 0): ?>
- </div><div class="row">
- <?php endif;?>
- <div class="col-sm-4">
- <?php echo $result['FullName']; ?>
- </div>
- <?php endforeach;?>
- </div>
- </div>
- <?php } ?>
Add Comment
Please, Sign In to add comment