<th align="center" scope="col" class="rounded-q4"> </th> </tr> </thead> <?php $result = mysql_query("SELECT * FROM subject_master where f_id='" . $_GET['f_id'] . "' order by batch_id, sem_id, division_id"); //lets make a loop and get all news from the database $i = 1; if (mysql_num_rows($result) > 0) { while ($myrow = mysql_fetch_array($result)) { //begin of loop //now print the results: echo '<tr>'; echo "<td align=center>" . $i . "</td>"; $i++; echo "<td align=center>" . $myrow['sub_name'] . "</td>"; echo "<td align=center>" . sem_name($myrow['sem_id']) . "</td>"; echo "<td align=center>" . batch_name($myrow['batch_id']) . "</td>"; echo "<td align=center>" . division_name($myrow['division_id']) . "</td>"; echo "<td align=center>" . "<a href=\"edit_subject.php?sub_id={$myrow['sub_id']}\">edit</a> /" . "<a href=\"delete_subject.php?sub_id={$myrow['sub_id']}&f_id={$myrow['f_id']}\">delete</a>" . "</td>"; echo '</tr>'; } //end of loop } else { echo '<tr><td colspan=6 align=center>No record found!</td></tr>'; } ?> </table> </td> </tr> </table> </body>
$total_ans6 = 0; $total_ans7 = 0; $total_ans8 = 0; $total_ans9 = 0; while ($arr = mysql_fetch_array($result1)) { $total_ans1 = $total_ans1 + $arr['ans1']; $total_ans2 = $total_ans2 + $arr['ans2']; $total_ans3 = $total_ans3 + $arr['ans3']; $total_ans4 = $total_ans4 + $arr['ans4']; $total_ans5 = $total_ans5 + $arr['ans5']; $total_ans6 = $total_ans6 + $arr['ans6']; $total_ans7 = $total_ans7 + $arr['ans7']; $total_ans8 = $total_ans8 + $arr['ans8']; $total_ans9 = $total_ans9 + $arr['ans9']; } $graphTitle = "Faculty Name: " . faculty_name($arr1['f_id']) . " Subject: " . subject_name($arr1['sub_id']) . " Batch: " . batch_name($arr1['batch_id']) . " - Sem: " . sem_name($arr1['sem_id']) . " - Div: " . division_name($arr1['division_id']) . " ( Feedback " . $arr1['feedback_no'] . " ) Date: " . date('d-m-Y'); $xLabel = "Matrix (Students " . $total_std . ")"; $yLabel = "Score"; $data['Punctuality'] = $total_ans1 / $total_std; $data['Preparedness'] = $total_ans2 / $total_std; $data['Communication Skill'] = $total_ans3 / $total_std; $data['Methodology'] = $total_ans4 / $total_std; $data['Objectives'] = $total_ans5 / $total_std; $data['Solving Queries'] = $total_ans6 / $total_std; $data['Treated Well'] = $total_ans7 / $total_std; $data['Value Addition'] = $total_ans8 / $total_std; $data['Faculty to be cont.'] = $total_ans9 / $total_std; //print_r($data); //exit; //getting the maximum and minimum values for Y $newData = $data;
<div class="container"> <h1>Student Load</h1> <?php $sem_reg_no = 0; $query_reg = mysql_query("SELECT reg_no, sem_id FROM student_registration_t WHERE student_id='{$student_id}' ORDER BY sem_id DESC") or die(trigger_error(trigger_error(mysql_error()))); while ($row_reg = mysql_fetch_assoc($query_reg)) { $sem_reg_no = $row_reg['reg_no']; $load_sem_id = $row_reg['sem_id']; ## $query_sem = mysql_query("SELECT * FROM semester_t WHERE sem_id='{$load_sem_id}'") or die(trigger_error(mysql_error())); $row_sem = mysql_fetch_assoc($query_sem); $sem_no = $row_sem['sem_no']; $ay_id = $row_sem['ay_no']; //get name of semester $sem_name = sem_name($load_sem_id); $query_year = mysql_query("SELECT * FROM academic_year_t WHERE ay_id='{$ay_id}'") or die(trigger_error(mysql_error())); $row_year = mysql_fetch_assoc($query_year); $year_start = $row_year['year_start']; $year_end = $row_year['year_end']; ## ?> <h4><?php echo $sem_name; //." A.Y.".$year_start." - ".$year_end; ?> </h4> <table class="table table-bordered"> <thead>
</head><!--/head--> <body style="overflow:hidden"> <!-- Remove overflow to use scrollbars --> <?php include "resources/navbar.php"; ?> <section id="page-title" class="torquiose peter-river" style=""> <div class="container"> <div class="row"> <h3> <i class="icon-calendar" ></i> Faculty Schedule</h3> <h5>Semester : <?php echo sem_name(semester()); ?> </h5> </div> </div> </section><!--/#services--> <div id="viewport" class="hidden" style="margin:20px; background-color:#FFF; height:460px; border:1px solid #DADADA; padding: 10px;"> <h1>This is it</h1> <i class="icon-linux "></i> </div><!--/#main--> <section class="" style="padding-bottom:0; padding-top:20px; height:90%"> <div id="panel" class="panel panel-default " style="">
break; default: break; } } foreach (array_diff($semesters, $exists) as $sem_) { ?> <option class="form-control margin_bottom_10" value="<?php echo $sem_; ?> " <?php echo $sem_ == $add_semester ? "selected='selected'" : ''; ?> > <?php echo sem_name($sem_); ?> </option> <?php } ?> </select> </td> </tr> </table> <table class="table table-condensed text-left" id="mark_entry" style="<?php if (isset($processed)) { if (!($processed == "TRUE")) { echo "display:none";
function write_xls($sql) { //echo $sql; $sql = str_replace('\\', '', $sql); $excel = new ExcelWriter('excel_report/' . date('m_d_Y_s') . '_feedback_report.xls'); $file_name = date('m_d_Y_s') . '_feedback_report.xls'; if ($excel == false) { echo $excel->error; } $result1 = mysql_query($sql); $arr1 = mysql_fetch_array($result1); $myArr = array("Branch", branch_name($arr1['b_id']), "", "Semester", sem_name($arr1['sem_id'])); $excel->writeLine($myArr); $myArr = array("", "", "", "", "", ""); $excel->writeLine($myArr); $myArr = array("Batch", batch_name($arr1['batch_id']), "", "Feedback No", $arr1['feedback_no']); $excel->writeLine($myArr); $myArr = array("", "", "", "", "", ""); $excel->writeLine($myArr); $myArr = array("Faculty Name:", faculty_name($arr1['f_id']), "", "Subject:", subject_name($arr1['sub_id'])); $excel->writeLine($myArr); $myArr = array("", "", "", "", "", ""); $excel->writeLine($myArr); $myArr = array("", "", "", "", "", ""); $excel->writeLine($myArr); $myArr = array("Remark"); //"Ans1","Ans2","Ans3","Ans4","Ans5","Ans6","Ans7","Ans8","Ans9" $excel->writeLine($myArr); $myArr = array("", "", "", "", "", ""); $excel->writeLine($myArr); $result = mysql_query($sql) or die(mysql_error()); $total_ids = "0"; $r_id = 1; while ($arr = mysql_fetch_array($result)) { if ($arr['remark'] != NULL) { $myArr = array($arr['remark']); //$arr['ans1'],$arr['ans2'],$arr['ans3'],$arr['ans4'],$arr['ans5'],$arr['ans6'],$arr['ans7'],$arr['ans8'],$arr['ans9'] $excel->writeLine($myArr); //$r_id++; } } $myArr = array("", "", "", "", "", ""); $excel->writeLine($myArr); $excel->close(); return $file_name; }
<div class="container"> <div class="container"> <h1 style="float:left;">Payments </h1> <h5 style="float:right;margin-top:40px;font-style:italic"> Transaction posted as of <?php echo $latest_date; ?> </h5> </div> <?php $query_sem = mysql_query("SELECT sem_id FROM accounting_journal_t WHERE student_id='{$student_id}' GROUP BY sem_id ORDER BY sem_id DESC") or die(trigger_error(trigger_error(mysql_error()))); if (mysql_num_rows($query_sem) > 0) { while ($row_sem = mysql_fetch_assoc($query_sem)) { $sem_id = $row_sem['sem_id']; ?> <h4><?php echo sem_name($sem_id); ?> </h4> <table class="table table-bordered" style="width:100%"> <thead> <th >Trans Date</th> <th>Trans Code</th> <th>Ref No</th> <th>Particulars</th> <th>Debit</th> <th>Credit</th> <th>Balance</th> </thead> <tbody>
<td>Semester</td> <td> <?php $sel_sem = "select * from semester_master "; $res_sem = mysql_query($sel_sem) or die(mysql_error()); while ($sem_combo = mysql_fetch_array($res_sem)) { $sem_array[] = array('id' => $sem_combo['sem_id'], 'text' => $sem_combo['sem_name']); } // echo tep_draw_pull_down_menu('sem_name',$sem_array,$default,' tabindex="4" '); ?> <input type="hidden" name="sem_name" value="<?php echo $result_para['sem_id']; ?> "/> <?php echo sem_name($result_para['sem_id']); ?> </td> <td> </td> <td>Division</td> <td> <?php $sel_div = "select * from division_master "; $res_div = mysql_query($sel_div) or die(mysql_error()); while ($div_combo = mysql_fetch_array($res_div)) { $div_array[] = array('id' => $div_combo['id'], 'text' => $div_combo['division']); } // echo tep_draw_pull_down_menu('division',$div_array, $default,' tabindex="4" '); ?> <input type="hidden" name="division" value="<?php echo $result_para['division_id'];
$search_para_str = base64_decode($_GET['str']); //echo $search_para_str; //for question 1 $sql_query_q1 = 'select ans1, count(*), b_id, batch_id, sem_id, division_id, f_id, sub_id from feedback_master where (' . $search_para_str . ') group by ans1 order by ans1'; //print $sql_query_q1; $res = mysql_query($sql_query_q1) or die(mysql_error('sql error')); $i = 0; $data_array = array(); while ($myrow = mysql_fetch_array($res)) { // $myrow["ans1"] = rating // $myrow[1] = student count $data_array[$myrow["ans1"]] = $myrow[1]; if ($i == 0) { $branch_name = branch_name($myrow['b_id']); $batch_name = batch_name($myrow['batch_id']); $sem_name = sem_name($myrow['sem_id']); $division_name = division_name($myrow['division_id']); $faculty_name = faculty_name($myrow['f_id']); $subject_name = subject_name($myrow['sub_id']); } $i++; } ?> <script type="text/javascript"> /* $(function() { var previousPoint = null; $("#que1_data").bind("plothover", function (event, pos, item) { $("#x").text(pos.x.toFixed(2)); $("#y").text(pos.y.toFixed(2));
function write_xls($sql) { $sql = str_replace('\\', '', $sql); $excel = new ExcelWriter('excel_report/' . date('m_d_Y_s') . '_feedback_report.xls'); $file_name = date('m_d_Y_s') . '_feedback_report.xls'; if ($excel == false) { echo $excel->error; } $result1 = mysql_query($sql) or die(mysql_error()); $arr1 = mysql_fetch_array($result1); if (mysql_num_rows($result1) != 0) { $myArr = array("Branch", branch_name($arr1['b_id']), "", "Semester", sem_name($arr1['sem_id'])); $excel->writeLine($myArr); $myArr = array("", "", "", "", "", ""); $excel->writeLine($myArr); $myArr = array("Batch", batch_name($arr1['batch_id']), "", "Division", division_name($arr1['division_id']), "", "Feedback No", $arr1['feedback_no']); $excel->writeLine($myArr); $myArr = array("", "", "", "", "", ""); $excel->writeLine($myArr); $myArr = array("Faculty Name:", faculty_name($arr1['f_id']), "", "Subject:", subject_name($arr1['sub_id'])); $excel->writeLine($myArr); $myArr = array("", "", "", "", "", ""); $excel->writeLine($myArr); $myArr = array("", "", "", "", "", ""); $excel->writeLine($myArr); /*$myArr=array("Remark(s)");//"Ans1","Ans2","Ans3","Ans4","Ans5","Ans6","Ans7","Ans8","Ans9" $excel->writeLine($myArr); $myArr=array("","","","","",""); $excel->writeLine($myArr);*/ $myArr = array("Ans1", "Ans2", "Ans3", "Ans4", "Ans5", "Ans6", "Ans7", "Ans8", "Ans9", "Remark"); $excel->writeLine($myArr); $result = mysql_query($sql) or die(mysql_error()); $total_ids = "0"; $r_id = 1; while ($arr = mysql_fetch_array($result)) { /*if($arr['remark']!=NULL) { $myArr=array(strtolower($arr['remark'])); $excel->writeLine($myArr); $r_id++; }*/ $myArr = array($arr['ans1'], $arr['ans2'], $arr['ans3'], $arr['ans4'], $arr['ans5'], $arr['ans6'], $arr['ans7'], $arr['ans8'], $arr['ans9'], $arr['remark']); $excel->writeLine($myArr); $r_id++; } $myArr = array("", "", "", "", "", ""); $excel->writeLine($myArr); $excel->close(); return $file_name; } else { echo '<p align=center>No Record Found!.</p>'; } }