PHP dbStudent::getAllStudentData Exemples

Exemple #1

Fichier : roomallocation.php Projet : unnatRevo/schoolNew

									<?php 
//$allStudentNames =
$iterator = 1;
while ($iterator <= $_GET['total']) {
    ?>
		
											<select name="<?php 
    echo $nRoomId . $iterator;
    ?>
" >
											<option value="#"> --ALLOCATE-- </option>

												<?php 
    if ($bHostelFor == 1) {
        $genderId = 1;
        $allStudentData = $stdObj->getAllStudentData($genderId);
        while ($row = mysqli_fetch_assoc($allStudentData)) {
            extract($row);
            if ($row['nGRNO'] == $_GET[$nRoomId . $iterator]) {
                ?>
 			<option selected="true" value="<?php 
                echo $nGRNO;
                ?>
"> <?php 
                echo $tFname . " " . $tLname;
                ?>
 </option>
												<?php 
            } else {
                ?>
														<option value="<?php 

Exemple #2

Fichier : hostelStudentEntry.php Projet : unnatRevo/Billboard

								  <th style="width:90px;">Room No</th>
								  <th style="width:90px;">Capacity</th>
								  <th style="width:90px;">GRNO</th>
								  <th style="width:350px;">Name</th>
								  <th style="text-align:center">Operations</th>
							  </tr>
						  </thead>
							
						  <tbody>

								
						<?php 
$obj = new dbStudent();
$allRoom = $hObj->getRoomDetails($hostelName);
//$studentNames = $Obj->displayHostelStudentEntry($hostelName);
$studentNames = $obj->getAllStudentData();
while ($roomDetails = mysqli_fetch_assoc($allRoom)) {
    extract($roomDetails);
    ?>
							<tr>
								<!-- ROOM NUMBERS-->
								<td width=85 style="text-align:center">
									<!-- Hostel <?php 
    echo $hostelName;
    ?>
 -->
									Room <?php 
    echo $tRoomNo;
    ?>
									
								</td>

Exemple #3

Fichier : studentList.php Projet : unnatRevo/Billboard

							<i class="halflings-icon list"></i>
							<span class="break"></span>
							<b>Students</b>
						</h2>
						<div class="box-icon">
						<a href="studentEntry.php"><i class="halflings-icon plus"></i></a>
							<a href="#" class="btn-minimize">
								<i class="halflings-icon chevron-up"></i>
							</a>
						</div>
					</div>
					
					
					<?php 
$obj = new dbStudent();
$result = $obj->getAllStudentData();
?>
					
					
					<div class="box-content">
						<table class="table table-striped table-bordered bootstrap-datatable datatable">
						  <thead>
							  <tr>
								  <th style="text-align:center">Serial</th>
								  <th style="text-align:right">GRNO</th>
								  <th style="text-align:left">F Name</th>
								  <th style="text-align:left">M Name</th>
								  <th style="text-align:left">L Name</th>
								  <th style="text-align:center">Gender</th>
								  <th style="text-align:center">Birth Date</th>
								  <th style="text-align:center">Hostel Stay</th>

Exemple #4

Fichier : dbReport.php Projet : unnatRevo/schoolNew

 function master()
 {
     $stuObj = new dbStudent();
     print_r($stuObj->getAllStudentData());
 }