File Manager

✏️ Edit File: /home/coemyoza/public_html/portal/data/functions.php

<?php 
//include 'config.php';
//require_once 'database.php';
require_once('uniques.php');

if(!isset($_SESSION)){  session_start(); }

function getallstaff($pdo){
		$sql = "SELECT *
			FROM `staff`";
	$result = $pdo->query($sql) ;
		$row =$result->rowcount();
		return $row;
}
function getallstudents($pdo){
		$sql = "SELECT *
			FROM `students`";
	$result = $pdo->query($sql) ;
		$row =$result->rowcount();
		return $row;
}

function getallcourses($pdo){
		$sql = "SELECT *
			FROM `course`";
	$result = $pdo->query($sql) ;
		$row =$result->rowcount();
		return $row;
}

function getallprogrammes($pdo){
		$sql = "SELECT *
			FROM `programmes`";
	$result = $pdo->query($sql) ;
		$row =$result->rowcount();
		return $row;
}

function staffname($username,$pdo){
	$name='';
		$sql = "SELECT *
			FROM `staff` 
			WHERE `username` ='$username'";
	$result = $pdo->query($sql) ;
		$row =$result->fetch();
		$name = ucwords($row['names']);
		return $name;
}
function studentname($username,$pdo){
	$name='';
		$sql = "SELECT *
			FROM `students` 
			WHERE `matno` ='$username'";
	$result = $pdo->query($sql) ;
		$row =$result->fetch();
		$name = ucwords($row['names']);
		return $name;
}

function getcoursetitle($code,$pdo){
	$name='';
		$sql = "SELECT *
			FROM `course` 
			WHERE `code` ='$code'";
	$result = $pdo->query($sql) ;
		$row =$result->fetch();
		$name = ucwords($row['title']);
		return $name;
}

function passportstaff($username,$pdo){
	$path = "passports/";
	$pic='passports/user.png';	
	
		$sql = "SELECT *
			FROM `staff` 
		WHERE  `username` ='$username'";
	$result = $pdo->query($sql) ;
		$row =$result->fetch();
	
		if (file_exists($row['image'])) {
			$pic = $row['image'];
	}else{
		
		}
	$_SESSION['PASSPORT']=$pic;
	return $pic;

}
function staffdetail($username,$pdo){
	$students='';	
	$sql = "SELECT *
			FROM `teacher` 
			WHERE `username` = '$username' or loginid='$username'";
		$result = $pdo->query($sql);
		$row = $result->fetch();
		if (file_exists('../passports/'.$row['passport'])) {
			$pic = $row['passport'];
	}else{
			if($row['sex']=='Male'){
			$pic='../passports/user.png';
		}else{  $pic='../passports/staff_female.png';}
			
		}
		$students = $row['firstname'].' '.$row['lastname'].'-'.$row['username'].'-'.$pic.'-'.$row['position'];
	//}
	$_SESSION['PASSPORT']=$pic;
	return $students;
}
function staffsubject($subj,$user, $pdo){
	$names='';	
	$sql = "SELECT  `studentsubjects`.`class`, `studentsubjects`.`subject`, `teacher_subjects`.`staff`, `teacher`.`firstname`, `teacher`.`lastname`, `teacher`.`passport`, `teacher`.`username` FROM `studentsubjects` inner join `teacher_subjects` on `studentsubjects`.`class`=`teacher_subjects`.`class` and `studentsubjects`.`subject` =`teacher_subjects`.`subject` inner join `teacher` on `teacher_subjects`.`staff`=`teacher`.`username` WHERE `studentsubjects`.`std_id`='".$user."' and `studentsubjects`.`subject`='".$subj."'";
		$result = $pdo->query($sql);
		$row = $result->fetch();
		if (file_exists($row['passport'])) {
			$pic = $row['passport'];
	}else{
			$pic='passports/user.png';
			
		}
		$names = $row['firstname'].' '.$row['lastname'].'-'.$row['username'].'-'.$pic;
	//}
	return $names;
}

function staffchatcounter($username,$pdo){
	$name='';
		$sql = "SELECT *
			FROM `bae_chat` 
			 where `std_id`='".$_SESSION['BAE']."' and `staff`='".$username."' and `poster`='0' and `status`='unread'";
	$result = $pdo->query($sql) ;
		$row =$result->num_rows;
		//$name = ucwords($row['firstname']. ' ' .$row['lastname']);
		return $row;
}

function passportstudent($username,$pdo){
	$path = "passports/";
	$pic='student.png';	
	
		$sql = "SELECT *
			FROM `students` 
			WHERE `matno` = '$username'";
	$result = $pdo->query($sql) ;
		$row =$result->fetch();
	
		if (file_exists('../passports/'.$row['images'])) {
			$pic = $row['images'];
	}else{
			$pic='student.png';
			
		}
	
	return '../passports/'.$pic;

}
function getcollegename($id,$pdo){
	$name='';
		$sql = "SELECT *
			FROM `colleges` 
			WHERE `id` ='$id'";
	$result = $pdo->query($sql) ;
		$row =$result->fetch();
		$name = ucwords($row['college']);
		return $name;
}
function getcenter($id,$pdo){
	$name='';
		$sql = "SELECT *
			FROM `studycenters` 
			WHERE `id` ='$id'";
	$result = $pdo->query($sql) ;
		$row =$result->fetch();
		$name = ucwords($row['centers']);
		return $name;
}

function getschoolname($id,$pdo){
	$name='';
		$sql = "SELECT *
			FROM `schools` 
			WHERE `id` ='$id'";
	$result = $pdo->query($sql) ;
		$row =$result->fetch();
		$name = ucwords(@$row['school']);
		return $name;
}

function getdeptname($id,$pdo){
	$name='';
		$sql = "SELECT *
			FROM `departments` 
			WHERE `dept_id` ='$id'";
	$result = $pdo->query($sql) ;
		$row =$result->fetch();
		$name = ucwords(@$row['names']);
		return $name;
}

function getprogname($id,$pdo){
	$name='';
		$sql = "SELECT *
			FROM `programmes` 
			WHERE `prog_id` ='$id'";
	$result = $pdo->query($sql) ;
		$row =$result->fetch();
		$name = ucwords(@$row['programme']);
		return $name;
}
function getfeesstatus($id,$level, $semester, $pdo){
	$name='';
		$sql = "SELECT `id`, `matno`, `type`, `session`, `semester`, `level`, `pay_type`, `amount`, `status` FROM `payment_status` WHERE matno = '".$id."' and `type`='School Fees' and `semester`='".$semester."' and `level`='".$level."' and `status`='unpaid' GROUP BY `matno`, `type`, `session`, `semester`, `level`, `pay_type`, `amount`, `status` order by created_at desc";
	$result = $pdo->query($sql);
	$tot = $result->rowCount();
		return $tot;
}

<?php

Batal

⬅ Naik ke portal 10 item

Nama	Tipe	Ukuran	Diubah	Aksi
🌐account.html	html	41 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘database.php	php	1.2 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘db.php	php	5 KB	2025-04-07 10:09	✏️ Edit 👁️ View
📄eyaimas.code-workspace	code-workspace	61 B	2024-07-21 13:45	✏️ Edit 👁️ View
🐘forgot.php	php	1.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘functions.php	php	8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🌐index.html	html	0 B	2024-07-21 13:45	✏️ Edit 👁️ View
🐘login.php	php	4.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🗃️nigerpoly.sql	sql	3.3 MB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘uniques.php	php	2.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View