</ul> <div class="row-fluid sortable"> <div class="box span12"> <div class="box-header" data-original-title> <h2><i class="halflings-icon list"></i><span class="break"></span><b>Students</b></h2> <div class="box-icon"> <a href="#" class="btn-minimize"><i class="halflings-icon chevron-up"></i></a> </div> </div> <?php $obj = new dbStudent(); $result = $obj->getAllStudentView(); ?> <div class="box-content"> <table class="table table-striped table-bordered bootstrap-datatable datatable"> <thead> <tr> <th style="text-align:center">GRNO</th> <th style="text-align:center">F Name</th> <th style="text-align:center">M Name</th> <th style="text-align:center">L Name</th> <th style="text-align:center">Gender</th> <th style="text-align:center">Birth Date</th> <th style="text-align:center">Admission Date</th>
'Gender' => $Gender,
'DOB' => $DOB,
'HostelStay' => $HostelStay,
'IsActive' => $IsActive,
'Standard' => $Standard
);*/
$mykey = array();
$myvalue = array();
foreach ($_POST as $key => $value) {
if ($key != 'submit') {
$mykey[] = $key;
$myvalue[] = $value;
}
}
//echo print_r($myvalue);
$Standard = $_POST['btStreamGroup'];
$obj = new dbStudent();
$conn = $obj->dbconnectModel();
$obj->insertData('tblstudent', $mykey, $myvalue);
$qry = "SELECT nGRNO FROM tblstudent ORDER BY nGRNO DESC LIMIT 1";
$results = mysqli_query($conn, $qry);
$res = mysqli_fetch_assoc($results);
extract($res);
$bb = print_r($myvalue[8]);
echo "bb:" . $bb . "<br>";
//print_r($myvalue);
echo $Standard;
$qry1 = "INSERT INTO tblstudentstandard VALUES ('', {$nGRNO} , {$Standard} ) ";
mysqli_query($conn, $qry1);
//$obj->insertIntoStudentStandard('tblstudentstandard',$nGRNO,$Standard);
header('location: /schoolNew/View/students/studentList.php');
<?php
include '../../Model/dbStudent.php';
$objStudentCls = new dbStudent();
$standardName = $_POST['standard'];
$atdDate = $_POST['date'];
$forStatus = $_POST['status'];
$isAll = '';
$status = 1;
$grChecked = '';
if (isset($_POST['SubjectName']) != null) {
$tStandardName[] = $_POST['SubjectName'];
$tsubject = array_values($_POST['SubjectName']);
//$tStandardName[] = join(',',$tStandardName);
foreach ($_POST['SubjectName'] as $tSubjectName) {
# code...
print_r($tSubjectName);
}
} else {
echo "Subject not available";
}
echo json_encode($tStandardName);
/*
NOTE - 1
Here it will check that, on previos page Select is Checked or not
If it is then the value of it as 1 otherwise 0.
*/
if (isset($_POST['selectAll']) != null && isset($_POST['SubjectName'])) {
$isAll = $_POST['selectAll'];
echo "BOTH SET";
}
<h2> <i class="halflings-icon list"></i> <span class="break"></span> <b>Attendance</b> </h2> <div class="box-icon"> <a href="hostelEntry.php"><i class="halflings-icon plus"></i></a> <a href="#" class="btn-minimize"> <i class="halflings-icon chevron-up"></i> </a> </div> </div> <?php $hObj = new dbHostel(); $sObj = new dbStudent(); $result = $hObj->getHostelNames(); ?> <form action ="<?php echo $_SERVER['PHP_SELF']; ?> " method="POST" > <div class="box-content"> <!-- <input type="button" onClick="fetch_r( 'H1', 11 )" value="TEST"></input> --> <table> <tr>
<?php include '../../Model/dbStudent.php'; $id = $_GET['id']; $obj = new dbStudent(); $result = $obj->studentViewSingle($id); $row = mysqli_fetch_assoc($result); ?> <!DOCTYPE html> <html lang="en"> <head> <!-- start: Meta --> <meta charset="utf-8"> <title>Student Edit</title> <!-- end: Meta --> <!-- start: Mobile Specific --> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- end: Mobile Specific --> <!-- start: CSS --> <link id="bootstrap-style" href="../../Theme/css/bootstrap.min.css" rel="stylesheet"> <link href="../../Theme/css/bootstrap-responsive.min.css" rel="stylesheet"> <link id="base-style" href="../../Theme/css/style.css" rel="stylesheet"> <link id="base-style-responsive" href="../../Theme/css/style-responsive.css" rel="stylesheet"> <link id="font-awesome" href="../../Theme/css/font-awesome.css" rel="stylesheet"> <link id="font-awesomemin" href="../../Theme/css/font-awesome.min.css" rel="stylesheet"> <link href='http://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800&subset=latin,cyrillic-ext,latin-ext' rel='stylesheet' type='text/css'> <!-- end: CSS -->
<h2><i class="halflings-icon plus"></i><span class="break"></span>Add Hostel</h2> <div class="box-icon"> <a href="#" class="btn-minimize"><i class="halflings-icon chevron-up"></i></a> </div> </div> <div class="box-content"> <form class="form-horizontal" action="hostelStudentSavingPage.php" method="GET"> <fieldset> <!-- OBJECT FOR STUDENT & HOSTELS --> <?php $hstObj = new dbHostel(); $stdObj = new dbStudent(); $hostelDetail = $hstObj->getHostelNameFromId($_GET['nHostelId']); $hostelRow = mysqli_fetch_assoc($hostelDetail); extract($hostelRow); $roomDetails = $hstObj->getRoomNameFromId($_GET['nRoomId']); $roomRow = mysqli_fetch_assoc($roomDetails); extract($roomRow); $allStudentData = $stdObj->getAllStudentDatas(); //$allStudent = mysqli_fetch_assoc($allStudentData); //extract($allStudent); ?> <input type = "hidden" name = "nHostelId" value = "<?php echo $_GET['nHostelId']; ?> " />
<?php
include '../../Model/dbStudent.php';
$FirstName = $_POST['firstname'];
$MiddleName = $_POST['middlename'];
$LastName = $_POST['lastname'];
$Gender = $_POST['hostelfor'];
$DOB = $_POST['dateofbirth'];
$HostelStay = $_POST['hostelstay'];
$IsActive = $_POST['isactive'];
$Standard = $_POST['stream'];
$myvalue = array('FirstName' => $FirstName, 'MiddleName' => $MiddleName, 'LastName' => $LastName, 'Gender' => $Gender, 'DOB' => $DOB, 'HostelStay' => $HostelStay, 'IsActive' => $IsActive, 'Standard' => $Standard);
$obj = new dbStudent();
$obj->insertStudentData('tblstudent', $myvalue);
header('location: /schoolNew/View/students/studentList.php');
</ul> <div class="row-fluid sortable"> <div class="box span12"> <div class="box-header" data-original-title> <h2><i class="halflings-icon list"></i><span class="break"></span><b>Student Report</b></h2> <div class="box-icon"> <a href="#" class="btn-minimize"><i class="halflings-icon chevron-up"></i></a> </div> </div> <?php $obj = new dbStudent(); $result = $obj->getAllStudentView(); ?> <div class="box-content"> <table class="table table-striped table-bordered bootstrap-datatable datatable"> <tr> <td style="width: 150px;"> <img src="../user/pokerface.png" height="100" width="150"> </td> <td> <table class="table table-striped table-bordered bootstrap-datatable datatable"> <tr> <td style="width:100px;">GRNO</td>
<h2> <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->getAllStudentDatas(); ?> <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:center">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>
<?php
include '../../Model/dbStudent.php';
$std = $_POST['btStreamGroup'];
$finalArray = array();
foreach ($_POST as $key => $valuesArray) {
if ($key != 'submit') {
if ($key == 'id') {
$id = $valuesArray;
} else {
$finalArray[] = $key . " = '" . $valuesArray . "'";
}
}
}
$obj = new dbStudent();
$conn = $obj->dbconnectModel();
$obj->editAnyData('tblstudent', $finalArray, $id);
$qry1 = "UPDATE tblstudentstandard SET nStandardId = {$std} WHERE nGRNO = {$id} ";
mysqli_query($conn, $qry1);
//echo $std . "" . $id ;
//print_r($finalArray);
header('location: /schoolNew/View/students/studentList.php');
<table class="table table-striped table-bordered bootstrap-datatable datatable">
<thead>
<tr>
<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->getAllStudentDatas();
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;
<?php
include '../../Model/dbHostel.php';
include '../../Model/dbStudent.php';
//include 'roomallocation.php';
$obj = new dbStudent();
echo $_GET['nHostelId'];
echo $_GET['nRoomId'];
// . "<script> alert( ".$_GET['nRoomId']." ) ; </script>";
echo $_GET['total'];
// echo "<script> alert( '".$bb."' ) ; </script>";
$conn = $obj->dbconnectModel();
/*$results = $newObj->getAllFromStudentRoomAllocation();
$row = mysqli_fetch_assoc($results);*/
$updateAllocationQry = " UPDATE " . " tblstudentroomallocation " . " SET " . " isAllocated = 0 " . " WHERE " . " nHostelId = " . $_GET['nHostelId'] . " AND " . " nRoomId = " . $_GET['nRoomId'];
mysqli_query($conn, $updateAllocationQry);
$updateInStudent = "UPDATE " . " tblstudent " . " SET " . " bStaysAtHostel = 0 " . " WHERE " . " nGRNO IN ( " . " SELECT " . " nGRNO " . " FROM " . " tblstudentroomallocation " . " WHERE " . " isAllocated = 0 )";
mysqli_query($conn, $updateInStudent);
$iterator = 1;
while ($iterator <= $_GET['total']) {
if ($obj->checkStudentExistence("tblstudentroomallocation", $_GET[$_GET['nRoomId'] . $iterator]) > 0) {
?>
<script>
alert( "in if=".$iterator ) ;
</script>
<?php
$updateAllocationQry = " UPDATE " . " tblstudentroomallocation " . " SET " . " isAllocated = 1 " . " WHERE " . "nGRNO = " . $_GET[$_GET['nRoomId'] . $iterator];
mysqli_query($conn, $updateAllocationQry);
$updateInStudent = "UPDATE " . " tblstudent " . " SET " . "bStaysAtHostel = 1 " . " Where " . " nGRNO = " . $_GET[$_GET['nRoomId'] . $iterator];
mysqli_query($conn, $updateInStudent);
<?php
include '../../Model/dbStudent.php';
include '../../Controller/student/studentEntryCon.php';
$id = $_GET['id'];
$stan = $_GET['standard'];
echo $id;
echo $stan;
$param = $_GET;
echo print_r($myvalue);
$obj = new dbStudent();
$obj->insertIntoStudentStandard('tblstudentstandard');
//header('location: /schoolNew/View/students/studentList.php');
function master()
{
$stuObj = new dbStudent();
print_r($stuObj->getAllStudentData());
}
<?php
include '../../Model/dbStudent.php';
$id = $_GET['id'];
$obj = new dbStudent();
$conn = $obj->dbconnectModel();
$obj->deleteStudent($id);
$qryStandard = "DELETE FROM tblstudentstandard WHERE nGRNO = {$id}";
mysqli_query($conn, $qryStandard);
header('location: /schoolNew/View/students/studentList.php');
