Configuration Error
Config file not found: admin/includes/config.php
');
}
require_once 'admin/includes/config.php';
// Check database connection
if (!isset($con) || $con->connect_error) {
die('
Database Connection Error
Could not connect to database. Please check config.php
');
}
// Define BASE_URL if not defined
if (!defined('BASE_URL')) {
$protocol = isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? 'https://' : 'http://';
$host = $_SERVER['HTTP_HOST'];
$scriptDir = dirname($_SERVER['SCRIPT_NAME']);
define('BASE_URL', $protocol . $host . ($scriptDir == '/' ? '' : $scriptDir) . '/');
}
// ===== FUNCTION: Only declare if not already exists =====
if (!function_exists('photo_upload')) {
function photo_upload($file,$path)
{
$allowedExts = array("gif","jpeg","jpg","png");
$temp = explode(".",$_FILES[$file]["name"]);
$extension = end($temp);
$return = array();
if((($_FILES[$file]["type"] == "image/gif")
||($_FILES[$file]["type"] == "image/jpeg")
||($_FILES[$file]["type"] == "image/jpg")
||($_FILES[$file]["type"] == "image/pjpeg")
||($_FILES[$file]["type"] == "image/x-png")
||($_FILES[$file]["type"] == "image/png"))
&& in_array($extension, $allowedExts))
{
if($_FILES[$file]["error"]>0)
{
echo 'Return Code: '.$_FILES[$file]["error"].'
';
}
else
{
$_FILESName = $temp[0].".".$temp[1];
$temp[0] = rand(0,3000);
if(file_exists("uploads/".$path.'/'.$_FILES[$file]["name"]))
{
$return['error'] = ''.$_FILES[$file]["name"].'Already Exists
';
}
else
{
$originalFilename = $_FILES[$file]["name"];
$fileExtension = pathinfo($originalFilename, PATHINFO_EXTENSION);
$uniqueIdentifier = uniqid();
$newfilename = 'product__' . $uniqueIdentifier . '.' . $fileExtension;
$aa = 'product__'.$newfilename;
$a = 'uploads/'.$path.'/'.$aa;
$photo_address = '../uploads/';
$z = move_uploaded_file($_FILES[$file]["tmp_name"], $a);
$return['file_name'] = $aa;
$return['status'] = 1;
}
}
}
else
{
$return['status'] = 0;
}
return $return;
}
}
// Start session if not started
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
if(isset($_POST['status']) && $_POST['status']=='center_login')
{
$post = $_POST;
$username = mysqli_real_escape_string($con,$post['username']);
$password = mysqli_real_escape_string($con,$post['password']);
$login = $con->query("SELECT * FROM centers where username = '".$username."' AND password = '".$password."' AND status = 1");
if($login && $login->num_rows)
{
$row = $login->fetch_assoc();
$rand = rand(111111,999999);
$_SESSION['center']['id'] = $row['id'];
$_SESSION['center']['session_id'] = $rand;
$_SESSION['center']['login'] = TRUE;
$sess = $con->query("INSERT INTO `check_session` (`id`, `timestamp`, `user_id`, `session_id`) VALUES (NULL, CURRENT_TIMESTAMP, ' ".$row['id']."','".$rand."')");
if($sess){
echo '';
}
}
else
{
echo '';
}
}
if(isset($_POST['status']) && $_POST['status']=='student_login')
{
$post = $_POST;
$username = mysqli_real_escape_string($con,$post['username']);
$password = mysqli_real_escape_string($con,$post['password']);
$login = $con->query("SELECT * FROM students where username = '".$username."' AND password = '".$password."' AND status = 1");
if($login && $login->num_rows)
{
$row = $login->fetch_assoc();
$rand = rand(111111,999999);
$_SESSION['student']['id'] = $row['id'];
$_SESSION['student']['session_id'] = $rand;
$_SESSION['student']['login'] = TRUE;
$con->query("INSERT INTO `check_session` (`id`, `timestamp`, `user_id`, `session_id`) VALUES (NULL, CURRENT_TIMESTAMP, '".$row['id']."', '".$rand."')");
echo '';
}
else
{
echo '';
}
}
if(isset($_POST['status']) && $_POST['status']=='contact_query')
{
if(isset($_SESSION['digit']) && $_SESSION['digit']==$_POST['captcha'])
{
$name = mysqli_real_escape_string($con, $_POST['name']);
$mobile = mysqli_real_escape_string($con, $_POST['mobile']);
$email = mysqli_real_escape_string($con, $_POST['email']);
$message = mysqli_real_escape_string($con, $_POST['message']);
$chk = $con->query("INSERT INTO `contact_query` (`id`, `timestamp`, `name`, `mobile`, `email`, `message`) VALUES (NULL, CURRENT_TIMESTAMP, '".$name."', '".$mobile."', '".$email."', '".$message."')");
echo '';
}
else
{
echo '';
}
}
// Initialize settings array
$setting = [];
// Fetch settings with error handling
$set = $con->query("SELECT * FROM setting");
if ($set) {
while($rr = $set->fetch_assoc()) {
$setting[$rr['type']] = $rr['value'];
$setting[$rr['id']] = $rr['value'];
}
}
// Fetch logo with fallback
$logo = ['logo' => '', 'favicon' => '', 'footer_logo' => ''];
$logoQuery = $con->query("SELECT * FROM logo_setting where id = 1");
if ($logoQuery && $logoQuery->num_rows > 0) {
$logo = $logoQuery->fetch_assoc();
}
// Build logo URL properly with file_exists check
$logoUrl = '';
if (!empty($logo['logo']) && file_exists('uploads/logo/'.$logo['logo'])) {
$logoUrl = BASE_URL . 'uploads/logo/' . $logo['logo'];
}
$faviconUrl = '';
if (!empty($logo['favicon']) && file_exists('uploads/logo/'.$logo['favicon'])) {
$faviconUrl = BASE_URL . 'uploads/logo/' . $logo['favicon'];
}
// Footer Logo URL with fallback
$footerLogoUrl = '';
if (!empty($logo['footer_logo']) && file_exists('uploads/logo/'.$logo['footer_logo'])) {
$footerLogoUrl = BASE_URL . 'uploads/logo/' . $logo['footer_logo'];
} else if (!empty($logo['logo']) && file_exists('uploads/logo/'.$logo['logo'])) {
$footerLogoUrl = BASE_URL . 'uploads/logo/' . $logo['logo'];
}
define('WEB_LOGO', $logoUrl);
define('WEB_FAVICON', $faviconUrl);
define('FOOTER_LOGO', $footerLogoUrl);
if (!function_exists('getSetting')) {
function getSetting($key, $res=''){
global $setting;
if(isset($setting[$key])){
$res = $setting[$key];
}
return $res;
}
}
// Fetch SEO settings with fallback
$seoSettings = [];
$seoQuery = $con->query("SELECT * FROM seo_settings");
if ($seoQuery && $seoQuery->num_rows > 0) {
$seoSettings = $seoQuery->fetch_assoc();
}
$webTitle = isset($seoSettings['web_title']) && !empty($seoSettings['web_title']) ? $seoSettings['web_title'] : 'Vidyapath Teacher Education College';
$metaDescription = isset($seoSettings['meta_description']) ? $seoSettings['meta_description'] : '';
$metaKeywords = isset($seoSettings['meta_keywords']) ? $seoSettings['meta_keywords'] : '';
$metaAuthor = isset($seoSettings['meta_author']) ? $seoSettings['meta_author'] : '';
// Fetch social links with fallback
$socialLinks = [];
$socialQuery = $con->query("SELECT * FROM social_links");
if ($socialQuery && $socialQuery->num_rows > 0) {
$socialLinks = $socialQuery->fetch_assoc();
}
$headerMobile = isset($socialLinks['header_mobile']) ? $socialLinks['header_mobile'] : '';
$headerEmail = isset($socialLinks['header_email']) ? $socialLinks['header_email'] : '';
$headerFacebook = isset($socialLinks['header_facebook']) ? $socialLinks['header_facebook'] : '';
$headerTwitter = isset($socialLinks['header_twitter']) ? $socialLinks['header_twitter'] : '';
$headerInstagram = isset($socialLinks['header_instagram']) ? $socialLinks['header_instagram'] : '';
$headerLinkedin = isset($socialLinks['header_linkedin']) ? $socialLinks['header_linkedin'] : '';
$headerYoutube = isset($socialLinks['header_youtube']) ? $socialLinks['header_youtube'] : '';
// Fetch courses from courses table - SMART QUERY
$courses = [];
$tableExists = $con->query("SHOW TABLES LIKE 'courses'");
if ($tableExists && $tableExists->num_rows > 0) {
$hasStatus = false;
$columnsQuery = $con->query("SHOW COLUMNS FROM courses LIKE 'status'");
if ($columnsQuery && $columnsQuery->num_rows > 0) {
$hasStatus = true;
}
$sql = $hasStatus ? "SELECT * FROM courses WHERE status = 1 ORDER BY id ASC" : "SELECT * FROM courses ORDER BY id ASC";
$coursesQuery = $con->query($sql);
if ($coursesQuery && $coursesQuery->num_rows > 0) {
while($course = $coursesQuery->fetch_assoc()) {
$courses[] = $course;
}
}
}
if (empty($courses)) {
$courses = [
['id' => 1, 'course_name' => 'B.Ed', 'slug' => 'b-ed'],
['id' => 2, 'course_name' => 'D.El.Ed', 'slug' => 'd-el-ed'],
['id' => 3, 'course_name' => 'M.Ed', 'slug' => 'm-ed'],
];
}
?>
<?=htmlspecialchars($webTitle)?>