<td width="78%" align="center" valign="top" > <table align="center" width="100%"><tr><td colspan="3" > <?php $f_result = mysql_query("SELECT * FROM faculty_master where f_id='" . $_GET['f_id'] . "'"); //echo "SELECT * FROM faculty_master where f_id='".$_POST['f_id']."'"; $f_myrow = mysql_fetch_array($f_result); //print_r($f_myrow); ?> <tr> <td align="center"><?php echo $f_myrow['f_name'] . ' ' . $f_myrow['l_name']; ?> (<?php echo branch_name($f_myrow['b_id']); ?> ) </td> </table> <table width="480px"> <tr > <td align="left" ><a href="faculty.php" class="button" >Back</a></td> <td align="right"><a href='add_subject.php?f_id=<?php echo $_GET['f_id']; ?> ' class="button">Add Subject</a></td> </tr> </table>
<?php // Honor the IE do-not-track-header, // even though it's set automatically. $respectIE = true; // Set the DNT variables. include __DIR__ . '/../backend/here-miss.php'; include __DIR__ . '/../backend/function.branchname.php'; $sitewide['branch_root'] = branch_name(); date_default_timezone_set('UTC'); $sitewide['title'] = 'elementary'; $sitewide['author'] = 'elementary LLC'; $sitewide['description'] = 'A fast and open replacement for Windows and OS X. Pay what you want or download for free.'; $sitewide['image'] = ''; $sitewide['theme-color'] = '#3892E0'; // Autodetect website root path $serverRoot = $_SERVER['DOCUMENT_ROOT']; $websiteRoot = dirname(__DIR__); $requestUri = parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH); $sitewide['root'] = ''; $sitewide['path'] = $requestUri; if ($serverRoot == $websiteRoot) { $sitewide['root'] = '/'; } elseif (strpos($websiteRoot, $serverRoot) === 0) { $sitewide['root'] = substr($websiteRoot, strlen($serverRoot)) . '/'; } else { $websiteArray = explode('/', $websiteRoot); $reqArray = array_filter(explode('/', $requestUri)); foreach ($websiteArray as $websiteOffset => $websiteDir) { foreach ($reqArray as $reqOffset => $reqDir) { if ($websiteDir != $reqDir) {
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; }
continue; } if (!($arrier >= $this->input->post('arrier_min') && $arrier <= $this->input->post('arrier_max'))) { // echo "here1"; continue; } $privacy_settings = array("privacy_profile_pic" => $student["privacy_profile_pic"], "privacy_personal" => $student["privacy_personal"], "privacy_academic" => $student["privacy_academic"], "privacy_resume" => $student["privacy_resume"]); //print_r($privacy_settings); $relation = find_relation($student, $session); if ($relation == "superuser" || isCoordinator($student, $session) || privacy_check($relation, $privacy_settings["privacy_profile_pic"])) { $pic = "<img class='profile_pic_table' src='" . base_url() . "profile_pics/" . $student["pic"] . "'>"; } else { $pic = "protected"; } $link = "<div><a onclick='load_details(\"" . $enc_usr . "\",\"here\")'>View Profile</a></div><div><a onclick='load_details(\"" . $enc_usr . "\",\"newtab\")'>Open in a new tab</a></div>"; if ($relation == "superuser" || isCoordinator($student, $session) || privacy_check($relation, $privacy_settings["privacy_academic"])) { $name = humanize($student["name"]); } else { $name = "protected"; $link = "protected"; $name = "protected"; $pic = "protected"; } if ($relation == "superuser" || isCoordinator($student, $session)) { $temp_array = array($pic, $name, humanize(branch_name($student["branch"], $branch_details)), $student["year_pass"], $percent . " %", $cgpa, $arrier, $link, $student["perm_addr"], $student["dob"], $student["email"], $student["mobno"], $student["admnno"], $student["regno"]); } else { $temp_array = array($pic, $name, humanize(branch_name($student["branch"], $branch_details)), $student["year_pass"], $percent . " %", $cgpa, $arrier, $link); } array_push($output, $temp_array); } echo '{ "data":' . json_encode($output) . "}";
<td>Branch </td> <td><label> <?php $sel_b = "select * from branch_master"; $res = mysql_query($sel_b) or die(mysql_error()); while ($b_combo = mysql_fetch_array($res)) { $branch_combo[] = array('id' => $b_combo['b_id'], 'text' => $b_combo['b_name']); } //echo tep_draw_pull_down_menu('b_name',$branch_combo,$default,' tabindex="3" '); ?> <input type="hidden" name="b_name" value="<?php echo $result_para['b_id']; ?> "/> <?php echo branch_name($result_para['b_id']); ?> </label></td> </tr> <tr> <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 'students' . $student['student_id']; ?> "> <td> <?php echo $student['username']; ?> </td> <td> <?php echo humanize($student['name']); ?> </td> <td> <?php echo branch_name($student['branch'], $branch_details); ?> </td> <td> <?php echo $student['email']; ?> </td> <td> <?php echo $student['admnno']; ?> </td> <td> <?php echo $student['regno'];
<td width="17%" > <?php include 'left_side.php'; ?> </td> <td width="83%" align="center" valign="top" bgcolor="#FFFFFF"> <p> <table width="480px" align="center"><tr><td colspan="3" align="right"><a href='add_faculty.php' class="button">Add Faculty</a></td></tr></table> </p> <table id="rounded-corner" border="0" align="center" cellpadding="0" cellspacing="0" > <?php $group_by = mysql_query("SELECT distinct(b_id) FROM faculty_master ORDER BY b_id"); //echo '<tr><td align="center">Faculty Id</td><td align="center">Faculty Name</td><td align="center"> </td></tr>'; while ($group_b_id = mysql_fetch_array($group_by)) { echo '<tr><th colspan=3 class="rounded-q1" align=center><b>' . branch_name($group_b_id['b_id']) . '</b></th></tr>'; $result = mysql_query("SELECT * FROM faculty_master where b_id='" . $group_b_id['b_id'] . "' ORDER BY b_id,f_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 echo '<tr>'; echo "<td align=center>" . $i . "</td>"; $i++; echo "<td align=center>" . $myrow['f_name'] . ' ' . $myrow['l_name'] . "</td>"; //echo "<td align=center>".branch_name($myrow['b_id'])."</td>"; echo "<td align=center>" . "<a href=\"subject.php?f_id={$myrow['f_id']}\">Subject List</a> / <a href=\"edit_faculty.php?f_id={$myrow['f_id']}\">edit</a> /" . "<a href=\"delete_faculty.php?f_id={$myrow['f_id']}\">delete</a>" . "</td>"; echo '</tr>'; } //end of loop
<?php error_reporting(error_reporting() & ~E_NOTICE); $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) {
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>'; } }
<th scope="col" class="rounded-q4" align="center"> </th> </tr> </thead> <?php $result = mysql_query("SELECT * FROM feedback_para"); //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>" . batch_name($myrow['batch_id']) . "</td>"; echo "<td align=center>" . branch_name($myrow['b_id']) . "</td>"; echo "<td align=center>" . sem_name($myrow['sem_id']) . "</td>"; echo "<td align=center>" . division_name($myrow['division_id']) . "</td>"; echo "<td align=center>" . "<a href=\"edit_admin_para.php?para_id={$myrow['para_id']}\" class=\"button\">edit</a> <!--/" . "<a href=\"delete_batch.php?batch_id={$myrow['batch_id']}\">delete</a>-->" . "</td>"; echo '</tr>'; //echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a> // || <a href=\"edit_news.php?newsid=$myrow[newsid]\">Edit</a> // || <a href=\"delete_news.php?newsid=$myrow[newsid]\">Delete</a><br><hr>"; } //end of loop } else { echo '<tr><td colspan=4 align=center>No record found!</td></tr>'; } ?> </table> </td>
<label><b>College/Department Name</b></label></td> <td width="400px"><?php echo college_name($std['college'], $college_details); ?> <br></td></tr> <tr><td width="100px"> <label><b>Degree Name</b></label></td> <td width="400px"><?php echo degree_name($std['degree'], $degree_details); ?> <br></td></tr> <tr><td width="100px"> <label><b>Course Name</b></label></td> <td width="400px"><?php echo branch_name($std['branch'], $branch_details); ?> <br></td></tr> <tr><td width="100px"> <label><b>Gender</b></label></td> <td width="400px"><?php echo $std["gender"]; ?> <br></td></tr> <tr><td width="100px"> <label><b>Nationality</b></label></td> <td width="400px"><?php