facNBA06.php0000644000175100017510000001556310426340625012023 0ustar hsraihsrai Civil Engineering Department
"; echo "Guru Nanak Dev Engg. College - Ludhiana"; echo "

Departmental Performa for Faculty

"; $thisID = $row[16]; $dob="xyz"; $resRai = mysql_query("select DATE_FORMAT('$row[17]','%D %b %Y')"); while ($row1 = mysql_fetch_array($resRai) ) { $dob=$row1[0] ; } echo ""; $row_color1 = ($row_count % 2) ? $color1 : $color2; $srCount = 1; echo ""; echo ""; echo ""; $myPhoto= "photo/faculty/nba_".$row[16].".jpg"; echo "\n"; // Add 1 to the row count $row_count++; echo "
"; echo "$srCount. Name:
"; $srCount++; echo "$srCount. Date of birth:
"; $srCount++; echo "$srCount. Educational Qualifications:"; $facTable ='fac3'; $result3 = mysql_query("SELECT * FROM $facTable where id = $thisID order by degree desc", $db); $facTable = 'fac2'; $result4 = mysql_query("SELECT * FROM $facTable where id = $thisID", $db); $srCount2 = 1; echo ""; echo ""; while ($row3 = mysql_fetch_array($result3) ) { $row_color1 = ($row_count % 2) ? $color1 : $color2; // Echo your table row and table data that you want to be looped over and over here. echo ""; echo ""; echo ""; echo ""; echo "\n"; $srCount2++; } echo "
Sr. No. Course Year of Passing
"; echo "$srCount2."; echo "$row3[1]"; echo "$row3[2]
"; // ============= echo "		"; echo "$row[0] $row[1] $row[2]"; echo "
$dob"; echo "		"; if (file_exists($myPhoto)){ echo "\"Photograph\""; } echo "
"; $srCount++; //= ============== echo "
$srCount. Work Experience\n
\n"; $facTable ='fac4'; $result3 = mysql_query("SELECT * FROM $facTable where id = $thisID order by dateFrom desc", $db); $srCount2 = 1; echo ""; echo ""; while ($row3 = mysql_fetch_array($result3) ) { $row_color1 = ($row_count % 2) ? $color1 : $color2; $resRai = mysql_query("select DATE_FORMAT('$row3[3]','%D %b %Y')"); while ($row1 = mysql_fetch_array($resRai) ) { $dobFrom=$row1[0] ; } $resRai = mysql_query("select DATE_FORMAT('$row3[4]','%D %b %Y')"); while ($row1 = mysql_fetch_array($resRai) ) { $dobTo=$row1[0] ; } if ($row3[4] > '2006-03-01') $dobTo = "continuing"; // Echo your table row and table data that you want to be looped over and over here. echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n"; $srCount2++; } echo "
Employer From To Capacity
"; echo "$row3[1]"; echo "$row3[2]"; echo "$dobFrom"; echo "$dobTo"; echo "$row3[5]
"; // ============= //= ============== $srCount++; echo "
$srCount. Area of Specialisation:\n $row[9]
\n"; $srCount++; echo "$srCount. Subjects Teaching at\n
\n"; $facTable ='fac5'; $result3 = mysql_query("SELECT * FROM $facTable where id = $thisID order by level desc", $db); $srCount2 = 1; $ugSubject = ""; $pgSubject = ""; while ($row3 = mysql_fetch_array($result3) ) { $row_color1 = ($row_count % 2) ? $color1 : $color2; // Echo your table row and table data that you want to be looped over and over here. if ($row3[1]=='Under-Graduate') $ugSubject .= "$row3[2] , "; if ($row3[1] == 'Post-Graduate') $pgSubject .= "$row3[2] , "; $srCount2++; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
Under-Graduate level$ugSubject
Post-Graduate level$pgSubject
"; // ============= while ($row4 = mysql_fetch_array($result4) ) { $srCount++; echo "
$srCount. Research Guidance:\n

\n"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
Master's"; if ($row4[2] != 0) echo $row4[2]; else echo "Nil"; echo "
Ph.D.'s"; if ($row4[3] != 0) echo $row4[3]; else echo "Nil"; echo "
No. of papers published in"; echo "
National Journals"; if ($row4[4] != 0) echo $row4[4]; else echo "Nil"; echo "
International Journal"; if ($row4[5] != 0) echo $row4[5]; else echo "Nil"; echo "
Conferences"; if ($row4[6] != 0) echo $row4[6]; else echo "Nil"; echo "
"; $srCount++; echo ""; echo "\n "; $srCount++; echo "\n "; $srCount++; echo "\n "; $srCount++; echo "\n "; $srCount++; echo "\n "; echo "
$srCount. Project Carried out: "; if ($row4[7] != 0) echo $row4[7]; else echo "Nil"; echo "
$srCount. Patents: "; if ($row4[8] != 0) echo $row4[8]; else echo "Nil"; echo "
$srCount. Technology Transfer: "; if ($row4[9] != 0) echo $row4[9]; else echo "Nil"; echo "
$srCount. Research Publication: "; if ($row4[10] != 0) echo $row4[10]; else echo "Nil"; echo "
$srCount. No. of Books published with details: "; if ($row4[11] != 0) echo $row4[11]; else echo "Nil"; echo "
"; echo "

(Signature)\n

"; //echo "

"; } //echo "End of Degree table"; // Add 1 to the row count $row_count++; } ?> facNBA.php0000644000175100017510000000336110424162121011635 0ustar hsraihsrai "; echo " Name Photo Designation Specialisation Date of Birth "; $result = mysql_query("SELECT * FROM faculty where department = 'Civil' ",$db); while ($row = mysql_fetch_array($result) ) { $row_color1 = ($row_count % 2) ? $color1 : $color2; // $row_color2 = ($row_count % 2) ? $color2 : $color1; // Echo your table row and table data that you want to be looped over and over here. echo " "; echo "$row[0] $row[1] "; if ($row[15] != 'url.com') { echo ""; } echo "$row[2]"; if ($row[15] != 'url.com') { echo "";} echo ""; $myPhoto= "photo/faculty/nba_".$row[16].".jpg"; echo ""; if (file_exists($myPhoto)) { echo "\"Photograph\""; } $dob="xyz"; $resRai = mysql_query("select DATE_FORMAT('$row[17]','%D %b %Y')"); while ($row1 = mysql_fetch_array($resRai) ) { $dob=$row1[0] ; } echo " $row[6] $row[9] $dob \n"; // Add 1 to the row count $row_count++; } echo " "; ?>