</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');