FM / includes

/var/www/vhosts/m-auto.co/httpdocs/includes/

/var/www/vhosts/m-auto.co/httpdocs/includes

Name	Size	Mode	Actions
7-6-2026.zip	5145	0644	edit dl rm
config.php	1937	0644	edit dl rm
db.php	694	0644	edit dl rm
db_production.php	1301	0644	edit dl rm
footer.php	6648	0644	edit dl rm
header.php	9757	0644	edit dl rm
header.zip	2656	0644	edit dl rm
odoo_api.php	11622	0644	edit dl rm
odoo_config.php	1150	0644	edit dl rm
permissions.php	1927	0644	edit dl rm

Edit: /var/www/vhosts/m-auto.co/httpdocs/includes/db_production.php (1301B)

<?php
// Include configuration
require_once 'config.php';

// Create connection using configuration constants
$conn = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD);

// Check connection
if ($conn->connect_error) {
    if (!$is_production) {
        die("Connection failed: " . $conn->connect_error);
    } else {
        // In production, log error instead of displaying it
        error_log("Database connection failed: " . $conn->connect_error);
        die("Database connection error. Please try again later.");
    }
}

// Set charset to utf8mb4 for full Arabic support
$conn->set_charset(CHARSET);

// Create database if it doesn't exist (only in development)
if (!$is_production) {
    $sql = "CREATE DATABASE IF NOT EXISTS `" . DB_NAME . "` CHARACTER SET " . CHARSET . " COLLATE utf8mb4_general_ci";
    if ($conn->query($sql) === TRUE) {
        // Database created or already exists
    } else {
        echo "Error creating database: " . $conn->error;
    }
}

// Select the database
$conn->select_db(DB_NAME);

// Function to safely close connection
function closeConnection() {
    global $conn;
    if ($conn) {
        $conn->close();
    }
}

// Register shutdown function to close connection
register_shutdown_function('closeConnection');
?>

connect_error) { if (!$is_production) { die("Connection failed: " . $conn->connect_error); } else { // In production, log error instead of displaying it error_log("Database connection failed: " . $conn->connect_error); die("Database connection error. Please try again later."); } } // Set charset to utf8mb4 for full Arabic support $conn->set_charset(CHARSET); // Create database if it doesn't exist (only in development) if (!$is_production) { $sql = "CREATE DATABASE IF NOT EXISTS `" . DB_NAME . "` CHARACTER SET " . CHARSET . " COLLATE utf8mb4_general_ci"; if ($conn->query($sql) === TRUE) { // Database created or already exists } else { echo "Error creating database: " . $conn->error; } } // Select the database $conn->select_db(DB_NAME); // Function to safely close connection function closeConnection() { global $conn; if ($conn) { $conn->close(); } } // Register shutdown function to close connection register_shutdown_function('closeConnection'); ?>