<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
