<?php
// db_connection.php - Combined version with both PDO and MySQLi
$host = 'localhost';
$dbname = 'riseinve_busdb';
$username = 'riseinve_mawla';
$password = 'Michuna25!@#';

// PDO connection (for existing portal use)
try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8mb4", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    error_log("PDO Connection failed: " . $e->getMessage());
    $pdo = null;
}

// MySQLi connection (for Pinterest automation)
$conn = new mysqli($host, $username, $password, $dbname);

if ($conn->connect_error) {
    error_log("MySQLi Connection failed: " . $conn->connect_error);
    $conn = null;
} else {
    // Set charset
    $conn->set_charset("utf8mb4");
}

// In db_connection.php or a separate file
function getAdSources() {
    global $pdo;
    $stmt = $pdo->query("SELECT DISTINCT adsource FROM ads_table ORDER BY adsource");
    return $stmt->fetchAll(PDO::FETCH_COLUMN);
}

function getAdUnits($source) {
    global $pdo;
    $stmt = $pdo->prepare("SELECT DISTINCT adunit FROM ads_table WHERE adsource = ? ORDER BY adunit");
    $stmt->execute([$source]);
    return $stmt->fetchAll(PDO::FETCH_COLUMN);
}

function getBannerSizes() {
    global $pdo;
    $stmt = $pdo->query("SELECT id, size FROM banner_sizes ORDER BY width, height");
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}
?>