School-Management-System/seating_plan_B.php at main · waqaskanju/School-Management-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
<?php
/**
 * Exam seating Plan
 * php version 8.1
 *
 * @category Exam
 *
 * @package None
 *
 * @author Waqas Ahmad <waqaskanju@gmail.com>
 *
 * @license http://www.waqaskanju.com/license MIT
 *
 * @link http://www.waqaskanju.com
 **/

require_once 'sand_box.php';
$link=$LINK;
?>
  <?php Page_header('Seating Plan B'); ?>
</head>
<body>
<div class="row">
    <div class="col-md-4">


        <?php
        $q="SELECT Roll_No,Name from Students_Info WHERE
        Status=1 AND Class='10th B' AND School='$SCHOOL_NAME'";
        $exe=mysqli_query($link, $q);
        $i=1;
        echo "<p>Class=10th B</p>";
        echo '<p>S#  Roll# Name</p>';
        while ($exer=mysqli_fetch_assoc($exe)) {
            if ($i==35) {
                echo '</div>';
                echo '<div class="col-md-4">';
            }
            echo "<p>". $i ." ".$exer['Roll_No'] ." ".$exer['Name']." "."</p>";
            $i++;
        }
        ?>

    </div>


</div>