42 lines
1.3 KiB
PHP
42 lines
1.3 KiB
PHP
<?php
|
|
|
|
/*
|
|
|--------------------------------------------------------------------------
|
|
| Load Composer and .env
|
|
|--------------------------------------------------------------------------
|
|
| This file is inside: cmccopiaoriginale/public/
|
|
| vendor and .env are inside: cmccopiaoriginale/
|
|
*/
|
|
|
|
require_once __DIR__ . '/../vendor/autoload.php';
|
|
|
|
$dotenv = Dotenv\Dotenv::createImmutable(__DIR__ . '/../');
|
|
$dotenv->safeLoad();
|
|
|
|
/*
|
|
|--------------------------------------------------------------------------
|
|
| Database configuration from .env
|
|
|--------------------------------------------------------------------------
|
|
*/
|
|
|
|
$host = $_ENV['DB_HOST'] ?? getenv('DB_HOST') ?? 'localhost';
|
|
$username = $_ENV['DB_USERNAME'] ?? getenv('DB_USERNAME') ?? '';
|
|
$password = $_ENV['DB_PASSWORD'] ?? getenv('DB_PASSWORD') ?? '';
|
|
$database = $_ENV['DB_DATABASE'] ?? getenv('DB_DATABASE') ?? '';
|
|
|
|
/*
|
|
|--------------------------------------------------------------------------
|
|
| MySQLi connection
|
|
|--------------------------------------------------------------------------
|
|
*/
|
|
|
|
$con = mysqli_connect($host, $username, $password, $database);
|
|
|
|
// Check connection
|
|
if (mysqli_connect_errno()) {
|
|
echo "Failed to connect to MySQL: " . mysqli_connect_error();
|
|
exit;
|
|
}
|
|
|
|
mysqli_set_charset($con, "utf8mb4");
|