prepare($sqlQuery); $statement->execute(array_merge(array($department), $params)); return $statement->fetchAll(PDO::FETCH_ASSOC); }}if (!function_exists('department_feature_output')) { function department_feature_output($html) { $content = trim((string) $html); if ($content !== '') { echo $content; } }}if (!function_exists('department_render_media_block')) { function department_render_media_block(array $row, $imageFolder, $nameField = '', $designationField = '') { $image = trim((string) ($row['image'] ?? '')); $description = (string) ($row['description'] ?? ''); if ($image !== '') { echo ''; echo '
 . ')
'; if ($nameField !== '' && !empty($row[$nameField])) { echo '
' . htmlspecialchars($row[$nameField], ENT_QUOTES, 'UTF-8') . '
'; } if ($designationField !== '' && !empty($row[$designationField])) { echo '
' . htmlspecialchars($row[$designationField], ENT_QUOTES, 'UTF-8') . '
'; } echo '
'; department_feature_output($description); echo '
'; return; } echo ''; if ($nameField !== '' && !empty($row[$nameField])) { echo '
' . htmlspecialchars($row[$nameField], ENT_QUOTES, 'UTF-8') . '
'; } if ($designationField !== '' && !empty($row[$designationField])) { echo '
' . htmlspecialchars($row[$designationField], ENT_QUOTES, 'UTF-8') . '
'; } department_feature_output($description); echo '
| '; if ($pdf !== '') { echo '' . htmlspecialchars($title, ENT_QUOTES, 'UTF-8') . ''; } else { echo htmlspecialchars($title, ENT_QUOTES, 'UTF-8'); } echo ' |
'; } }}function department_left_menu($department) {$sql = mit_db();$sqlQuery = "select * from cms_pages where department='$department' and status=1 "; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { if($result['type']=="internal_url") { echo ''.$result['page_heading'].''; } else { echo ''.$result['page_heading'].''; } } } }function department_photo_gallery_rows($department, $type, $offset = 0, $limit = 6) {$sql = mit_db();$offset = max(0, (int) $offset); $limit = max(1, (int) $limit); $normalizedType = str_replace(' ', '', (string) $type); $extraCondition = ''; if ($type === 'photo-gallery') { $extraCondition = " or ( g.department = :department_direct and g.cat_id = 0 and (g.type is null or g.type = '') ) "; } $sqlQuery = " select g.* from department_photo_gallery g left join department_cat_photo_gallery c on c.id = g.cat_id and c.status = 1 where g.status = 1 and ( ( g.department = :department_direct and ( g.type = :type_direct or FIND_IN_SET(:type_direct_csv, REPLACE(COALESCE(g.type, ''), ' ', '')) > 0 ) ) or ( c.department = :department_category and FIND_IN_SET(:type_category_csv, REPLACE(COALESCE(c.type, ''), ' ', '')) > 0 ) {$extraCondition} ) order by g.id desc limit {$offset}, {$limit}"; $statement = $sql->prepare($sqlQuery); $statement->execute(array( ':department_direct' => $department, ':type_direct' => $type, ':type_direct_csv' => $normalizedType, ':department_category' => $department, ':type_category_csv' => $normalizedType )); return $statement->fetchAll(PDO::FETCH_ASSOC); }function photo_gallery($department,$type,$limit=6) { $rows = department_photo_gallery_rows($department, $type, 0, $limit); if(count($rows)>0) { foreach($rows as $result) { $imageName = $result['image']; $imageNameEncoded = rawurlencode($imageName); $fullImage = SITE_PATH.'media_image/photo_gallery/'.$imageNameEncoded; $thumbImage = SITE_PATH.'media_image/photo_gallery/thumbs/'.$imageNameEncoded; $title = trim((string) $result['title']); $caption = $title !== '' ? htmlspecialchars($title, ENT_QUOTES, 'UTF-8') : 'Department gallery image'; echo ' 
'.$caption.' '; } } } function photo_gallery1($department,$type) { $rows = department_photo_gallery_rows($department, $type, 6, 30); if(count($rows)>0) { foreach($rows as $result) { echo ' .')
'.$result['title'].' '; } } }function approval() {$sql = mit_db();$sqlQuery = "select * from approval_cat where status=1"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { $t = $result['id']; $sqlQueryy = "select * from approval where cat_id='$t' and status=1 ORDER BY id DESC"; $statementt = $sql->prepare($sqlQueryy); $statementt->execute(); $roww = $statementt->rowCount(); if($row>0) { echo '| '.strtoupper($result['title']).' |
'; while( $resultt = $statementt->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$resultt['title'].' Click Here |
'; } } } } }function nba() {$sql = mit_db();$sqlQuery = "select * from nba where status=1"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo' | '.$result['title'].' Click Here |
'; } } } if (!function_exists('faculty')) {function faculty($department) {$sql = mit_db();$sqlQuery = "select * from faculty where department='$department' and status=1 ORDER BY id"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.$result['faculty_name'].' | '.ucwords(strtolower($result['designation'])).' | '.$result['highest_degree'].' | '; echo'
'; $i++; } } }}if (!function_exists('newsletter')) {function newsletter($department) {$sql = mit_db();$sqlQuery = "select * from newsletter where department='$department' and status=1 ORDER BY id DESC "; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' !['.$result['title'].']('.SITE_PATH.'media_image/newsletter/'.$result['image'].')
'.ucwords(strtolower($result['title'])).'
View '; } } }}if (!function_exists('academic_calendar')) {function academic_calendar($department) {$sql = mit_db();$sqlQuery = "select * from academic_calendar where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.ucwords(strtolower($result['title'])).' | '.$result['year'].' | '.$result['semester'].' | '; if($result['pdf'] !='') { echo' | '; } else { echo ' | '; } echo'
'; $i++; } } }}if (!function_exists('pagination')) {function pagination($page,$department, $tablename) { $i=16; $per_page=16; $url = "https://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']; if(strpos($url, "?")==true) $page_url=$url."&"; else $page_url=$url."?";$sql = mit_db();$sqlQuery = "select COUNT(*) as totalCount FROM $tablename where department='$department' and type='Awards' and status=1"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $rec = $statement->fetch(PDO::FETCH_ASSOC); $total = $rec['totalCount']; $adjacents = "2"; $page = ($page == 0 ? 1 : $page); $start = ($page - 1) * $per_page; $prev = $page - 1; $next = $page + 1; $setLastpage = ceil($total/$per_page); $lpm1 = $setLastpage - 1; $setPaginate = ""; if($setLastpage > 1) { $setPaginate .= "\n"; } return $setPaginate; }}if (!function_exists('awards')) {function awards($department) {$sql = mit_db();$per_page=16; $page=1; if(isset($_GET['page']) && $_GET['page']!="") { $page=$_GET['page']; $i = (16*$page)-15; } else { $i=1; } $start = ($page - 1)* $per_page; $sqlQuery = "select * from achievement where department='$department' and type='Awards' and status=1 ORDER BY id DESC limit $start, $per_page"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); if($row>0) { echo' Awards / Recognitions
| S.No. | Session | Name of Awardee | Date of Award / Recognition | Details of Award / Recognition Award / Recognition Given By |
'; while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { $date = ''; if($result['day']!='' || $result['month']!='' || $result['year']!= '') { if($result['day']!='') { $date = $result['day'].'-' ; } if($result['month']!='') { $date .= $result['month'].'-' ; } if($result['year']!='') { $date .= $result['year']; } } echo ' | '.$i.' | '.$result['session'].' | '.$result['name'].' | '.$date.' | '.$result['description'].' |
'; $i++; } echo'
'; } }}if (!function_exists('achievements')) {function achievements($department) {$sql = mit_db();$sqlQuery = "select * from achievement where department='$department' and type='Achievement' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; $date=""; if($row>0) { echo'Achievements
| S. No. | Session | Date | Short Details of the Achievement |
'; while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { if($result['day']!='' || $result['month']!='' || $result['year']!= '') { $date=''; if($result['day']!='') { $date = $result['day'].'-' ; } if($result['month']!='') { $date .= $result['month'].'-' ; } if($result['year']!='') { $date .= $result['year']; } } echo ' | '.$i.' | '.$result['session'].' | '.$date.' | '.$result['description'].' |
'; $i++; $date=""; } echo '
'; } } }if (!function_exists('total_placements')) {function total_placements($department) {$sql = mit_db();$sqlQuery = "select * from total_placements where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.$result['session'].' | '.$result['year'].' | '.$result['placed'].' | '.$result['offers'].' | '.$result['package'].' |
'; $i++; } } }}if (!function_exists('department_recruiters')) {function department_recruiters() {$sql = mit_db();$sqlQuery = "select * from recruiters where status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' 
'.$result['title'].' '; } } }}if (!function_exists('higher_studies')) {function higher_studies($department) {$sql = mit_db();$sqlQuery = "select * from higher_studies where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.$result['session'].' | '.$result['year'].' | '.ucwords(strtolower($result['student_number'])).' | '; if($result['pdf'] !='') { echo' | '; } else { echo ' | '; } $i++; } } }}if (!function_exists('department_laboratory')) {function department_laboratory($department) {$sql = mit_db();$sqlQuery = "select * from department_laboratory where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo '
| '.$i.' | '.$result['room_number'].' | '.ucwords($result['lab_name']).' | '.ucwords(strtolower($result['system_number'])).' | '; echo'
'; $i++; } } }}if (!function_exists('club')) {function club($department) {$sql = mit_db();$sqlQuery = "select * from club where type='department' and department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.$result['club_name'].' | '.ucwords(strtolower($result['objective'])).' | '.ucwords(strtolower($result['student_convener'])).' | '.ucwords(strtolower($result['faculty_in_charge'])).' | '; if($result['pdf'] !='') { echo' | '; } else { echo ' | '; } echo 'View |
'; $i++; } } }}if (!function_exists('activities_events')) {function activities_events($department) {$sql = mit_db();$sqlQuery = "select * from activities_events where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; $date=""; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { if($result['day']!='' || $result['month']!='' || $result['year']!= '') { $date=''; if($result['day']!='') { $date = $result['day'].'-' ; } if($result['month']!='') { $date .= $result['month'].'-' ; } if($result['year']!='') { $date .= $result['year']; } } echo ' | '.$i.' | '.$result['session'].' | '.$date.' | '.ucwords(strtolower($result['name_of_the_activity'])).' | '.$result['organized_by'].' | '; echo'
'; $i++; $date=""; } } }}if (!function_exists('fdps_seminars')) {function fdps_seminars($department,$type) {$sql = mit_db();$sqlQuery = "select * from fdps_seminars where department='$department' and type='$type' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; $date=""; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { if($result['day']!='' || $result['month']!='' || $result['year']!= '') { $date=''; if($result['day']!='') { $date = $result['day'].'-' ; } if($result['month']!='') { $date .= $result['month'].'-' ; } if($result['year']!='') { $date .= $result['year']; } } echo ' | '.$i.' | '.$result['session'].' | '.$date.' | '.$result['description'].' | '; echo'
'; $i++; $date=""; } } }}if (!function_exists('value_added_courses')) {function value_added_courses($department) {$sql = mit_db();$sqlQuery = "select * from value_added_courses where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; $date=""; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { if($result['day']!='' || $result['month']!='' || $result['year']!= '') { $date=''; if($result['day']!='') { $date = $result['day'].'-' ; } if($result['month']!='') { $date .= $result['month'].'-' ; } if($result['year']!='') { $date .= $result['year']; } } echo ' | '.$i.' | '.$result['session'].' | '.$date.' | '.$result['number_days'].' '.$result['type'].' | '.$result['description'].' | '; echo'
'; $i++; $date=""; } } }}if (!function_exists('industrial_visit')) {function industrial_visit($department) {$sql = mit_db();$sqlQuery = "select * from industrial_visit where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; $date=""; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { if($result['day']!='' || $result['month']!='' || $result['year']!= '') { $date=''; if($result['day']!='') { $date = $result['day'].'-' ; } if($result['month']!='') { $date .= $result['month'].'-' ; } if($result['year']!='') { $date .= $result['year']; } } echo ' | '.$i.' | '.$result['session'].' | '.$date.' | '.ucwords(strtolower($result['description'])).' | '; echo'
'; $i++; $date=""; } } }}if (!function_exists('innovative_practices')) {function innovative_practices($department) {$sql = mit_db();$sqlQuery = "select * from innovative_practices where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.ucwords(strtolower($result['name'])).' | '.$result['description'].' | '; echo'
'; $i++; } } }}if (!function_exists('major_project')) {function major_project($department) {$sql = mit_db();$sqlQuery = "select * from major_projects where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.$result['session'].' | '.ucwords(strtolower($result['title'])).' | '.$result['description'].' | '; echo'
'; $i++; } } }}if (!function_exists('ppagination')) { function ppagination($page,$department, $tablename) { $i=16; $per_page=16; $url = "https://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']; if(strpos($url, "?")==true) $page_url=$url."&"; else $page_url=$url."?";$sql = mit_db();$sqlQuery = "select COUNT(*) as totalCount FROM $tablename where department='$department' and status=1"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $rec = $statement->fetch(PDO::FETCH_ASSOC); $total = $rec['totalCount']; $adjacents = "2"; $page = ($page == 0 ? 1 : $page); $start = ($page - 1) * $per_page; $prev = $page - 1; $next = $page + 1; $setLastpage = ceil($total/$per_page); $lpm1 = $setLastpage - 1; $setPaginate = ""; if($setLastpage > 1) { $setPaginate .= "\n"; } return $setPaginate; }}if (!function_exists('publications')) {function publications($department) {$sql = mit_db();$per_page=16; $page=1; if(isset($_GET['page']) && $_GET['page']!="") { $page=$_GET['page']; $i = (16*$page)-15; } else { $i=1; } $start = ($page - 1)* $per_page; $sqlQuery = "select * from publications where department='$department' and status=1 ORDER BY id DESC limit $start, $per_page"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.$result['year'].' | '.$result['title'].' | '.$result['authors'].' | '.$result['conference'].' | '; if($result['doi']!=null) { if(strpos($result['doi'],'http') !== false) { echo 'View | '; } else { echo ''.$result['doi'].' | '; } } else { echo ' | '; } echo'
'; $i++; } echo''; } }}if (!function_exists('patent')) {function patent($department) {$sql = mit_db();$sqlQuery = "select * from patent where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.$result['year'].' | '.ucwords(strtolower($result['title'])).' | '.ucwords(strtolower($result['applicant'])).' | '.ucwords(strtolower($result['application_number'])).' | '.ucwords(strtolower($result['tstatus'])).' | '; echo'
'; $i++; } } }}if (!function_exists('copyrights')) {function copyrights($department) {$sql = mit_db();$sqlQuery = "select * from copyrights where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.$result['year'].' | '.ucwords(strtolower($result['title'])).' | '.ucwords(strtolower($result['applicant'])).' | '.$result['application_number'].' | '.ucwords(strtolower($result['tstatus'])).' | '; echo'
'; $i++; } } }}if (!function_exists('grants')) {function grants($department) {$sql = mit_db();$sqlQuery = "select * from grants where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.$result['session'].' | '.ucwords(strtolower($result['type'])).' | '.ucwords(strtolower($result['grant_type'])).' | '.$result['title'].' | '.$result['investigator'].' | '.$result['agency'].' | '.$result['grant_amount'].' | '.ucwords(strtolower($result['tstatus'])).' | '; echo'
'; $i++; } } }}if (!function_exists('consultancy')) {function consultancy($department) {$sql = mit_db();$sqlQuery = "select * from consultancy where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.$result['year'].' | '.ucwords(strtolower($result['title'])).' | '.ucwords(strtolower($result['provided_by'])).' | '.$result['amount'].' | '.ucwords(strtolower($result['tstatus'])).' | '; echo'
'; $i++; } } }}if (!function_exists('mous')) {function mous($department) {$sql = mit_db();$sqlQuery = "select * from mous where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { $date = ''; if($result['day']!='' || $result['month']!='' || $result['year']!= '') { if($result['day']!='') { $date = $result['day'].'-' ; } if($result['month']!='') { $date .= $result['month'].'-' ; } if($result['year']!='') { $date .= $result['year']; } } echo ' | '.$i.' | '.$result['year'].' | '.ucwords(strtolower($result['title'])).' | '.$date.' | '.$result['validity'].' | '.$result['broad_coverage'].' | '; if($result['pdf'] !='') { echo' | '; } else { echo ' | '; } echo'
'; $i++; } } }}if (!function_exists('development_activeties')) {function development_activeties($department) {$sql = mit_db();$sqlQuery = "select * from development_activeties where department='$department' and status=1 ORDER BY id DESC"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); $i=1; if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo ' | '.$i.' | '.ucwords(strtolower($result['type'])).' | '.ucwords(strtolower($result['description'])).' | '; if($result['pdf'] !='') { echo' | '; } else { echo ' | '; } echo'
'; $i++; } } }}if (!function_exists('e_resourses')) {function e_resourses($department) {$sql = mit_db();$sqlQuery = "select * from subject where department='$department' and status=1"; $statement = $sql->prepare($sqlQuery); $statement->execute(); $row = $statement->rowCount(); if($row>0) { while( $result = $statement->fetch(PDO::FETCH_ASSOC)) { echo '| '.strtoupper($result['title']).' - '.$result['code'].' |
'; $subject_code = $result['title'].';'.$result['code']; $sqlQueryy = "select * from resourses where department='$department' and subject_code='$subject_code' and status=1 ORDER BY id DESC"; $statementt = $sql->prepare($sqlQueryy); $statementt->execute(); $roww = $statementt->rowCount(); if($row>0) { while( $resultt = $statementt->fetch(PDO::FETCH_ASSOC)) { echo ' | Basic Details | QB/QP | NOTES CO-1 | NOTES CO-2 | NOTES CO-3 | NOTES CO-4 | NOTES CO-5 |
'; } } } } }}?>
Best Engineering Colleges @MIT Meerut | Meerut,UP, Delhi NCR, India
MEERUT
INSTITUTE OF
TECHNOLOGY
Excellence in
Education Since 2007
Loading your experience...
