File Manager

✏️ Edit File: /home/coemyoza/results.coeminna.edu.ng/data/db.php

<?php if (!isset($_SESSION)) {
    session_start();
}
// Set appropriate cache headers
header("Expires: Tue, 01 Jan 2000 00:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");

// Database configuration (move this to a separate config file)
$pass = 'Gigbadi01@'; $user =  'coemyoza_portal';
$db_config = [
    'host' => 'localhost',
    'username' => 'coemyoza_portal',
    'password' => 'Gigbadi01@',
    'dbname' => 'coemyoza_portal',
];

// Create a PDO connection with proper options
try {
    $dsn = "mysql:host={$db_config['host']};dbname={$db_config['dbname']};charset=utf8mb4";
    $options = [
        PDO::ATTR_EMULATE_PREPARES => false,
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    ];
    $pdo = new PDO($dsn, $db_config['username'], $db_config['password'], $options);
    $pdo->exec("SET collation_connection = 'utf8mb4_general_ci'");
    $pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
} catch (PDOException $pe) {
    die($pe->getMessage());
}

// Set the default timezone
date_default_timezone_set("Africa/Lagos");

// Function to clean input strings
function cleanstring($string) {
    $string = htmlentities($string, ENT_COMPAT, 'utf-8');
    $string = filter_var($string, FILTER_SANITIZE_STRING);
    return trim($string);
}

// Handle logout
if (isset($_GET["logout"])) {
    if (ini_get("session.use_cookies")) {
        $params = session_get_cookie_params();
        setcookie(session_name(), '', time() - 42000, $params["path"], $params["domain"], $params["secure"], $params["httponly"]);
    }
    // Finally, destroy the session
    session_unset();
    echo '<script>window.location.replace("index");</script>';
    exit; // Add an exit to prevent further execution
}

$error = '<div class="alert alert-danger"><a href="javascript:void" class="close" data-dismiss="alert">&times;</a>';
$success = '<div class="alert alert-success"><a href="javascript:void" class="close" data-dismiss="alert">&times;</a>';
$close = '</div>';
$refresh = '<script>setTimeout(function(){location.reload()}, 500)</script>';

$email_id = '';
    
$config = $pdo->prepare("SELECT * FROM `config`");
$config->execute();
$row_config= $config->fetch();

$_SESSION['session']=$row_config['sessions'];

$_SESSION['semester']=$row_config['semester'];
$site_title = $row_config['school'];

$school_names =$row_config['school'];
$school_address =$row_config['add'];
$school_abb =$row_config['abb'];
$school_gsm =$row_config['contact'];
$school_email =$row_config['email'];
$school_website =$row_config['website'];
$school_status =$row_config['status'];
$school_results =$row_config['results'];
$school_activesession =$row_config['sessions'];
$school_activesemester =$row_config['semester'];
$school_payment =$row_config['payment'];
$school_course_registration =$row_config['course_registration'];
$school_accommodation =$row_config['accomodation'];
$school_late_registration =$row_config['late_registration'];
$school_admission_batch =$row_config['admission_batch'];
$school_app_year = $row_config['application_year'];
$school_results_view = $row_config['results'];
$school_results_upload = $row_config['upload'];
if ($school_status <> "active") {
//echo'<script>window.location="maintenance";</script>';
die("<h1>UNDER MAINTENANCE! Kindly check back shortly... </h1>");
//break;
}
function encryptor($action, $string) {
    $output = false;

$encrypt_method = "AES-256-CBC";
    //pls set your unique hashing key
    $secret_key = date('dd MM yyyy');
    $secret_iv = date('dd MM yyyy');
    
    $key = hash('sha256', $secret_key);

// iv - encrypt method AES-256-CBC expects 16 bytes - else you will get a warning
    $iv = substr(hash('sha256', $secret_iv), 0, 16);

//do the encyption given text/string/number
    if( $action == 'encrypt' ) {
        $output = openssl_encrypt($string, $encrypt_method, $key, 0, $iv);
        $output = base64_encode($output);
    }
    else if( $action == 'decrypt' ){
    	//decrypt the given text/string/number
        $output = openssl_decrypt(base64_decode($string), $encrypt_method, $key, 0, $iv);
    }

return $output;
}

$res_config = $pdo->query("SELECT * FROM `config_res`");
$res_conf = $res_config->fetch();

$conf_semester = $res_conf['semester'];
$conf_session = $res_conf['sessions'];
//$semester_arr = array(1=>"First Semester", 2=>"Second Semester", 3=>"Third Semester");
$semester_arr = array(1=>"First Semester", 2=>"Second Semester");?>

Batal

⬅ Naik ke results.coeminna.edu.ng 12 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁fpdf186	dir	—	2024-07-21 11:43	📂 Buka
📄.DS_Store	ds_store	6 KB	2024-07-21 11:43	✏️ Edit 👁️ View
🌐account.html	html	41 KB	2024-07-21 11:43	✏️ Edit 👁️ View
🐘database.php	php	1.2 KB	2024-07-21 11:43	✏️ Edit 👁️ View
🐘db.php	php	4.7 KB	2025-06-14 07:29	✏️ Edit 👁️ View
📄eyaimas.code-workspace	code-workspace	61 B	2024-07-21 11:43	✏️ Edit 👁️ View
🐘forgot.php	php	1.1 KB	2024-07-21 11:43	✏️ Edit 👁️ View
🐘functions.php	php	7.2 KB	2024-07-21 11:43	✏️ Edit 👁️ View
🌐index.html	html	0 B	2024-07-21 11:43	✏️ Edit 👁️ View
🐘login.php	php	4.7 KB	2024-07-21 11:43	✏️ Edit 👁️ View
🗃️nigerpoly.sql	sql	3.3 MB	2024-07-21 11:43	✏️ Edit 👁️ View
🐘uniques.php	php	2.7 KB	2024-07-21 11:43	✏️ Edit 👁️ View