<?php
// Database Configuration
define('DB_HOST', 'localhost');
define('DB_USER', 'u752449863_pshadmin'); // Replace with your database username
define('DB_PASS', 'S@n@h2016'); // Replace with your database password
define('DB_NAME', 'u752449863_psh');     // Replace with your database name

// Site Configuration
define('SITE_URL', 'https://paidsurveyhub.in'); // Replace with your domain
define('SITE_NAME', 'Paid Survey Hub India');
define('ADMIN_PATH', '/management');

// Email Configuration
define('SMTP_FROM', 'signupverification@paidsurveyhub.in'); // Replace with your email
define('SMTP_FROM_NAME', 'Registrations - Paid Survey Hub India');

// Create database connection
try {
    $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
    
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    
    $conn->set_charset("utf8mb4");
} catch (Exception $e) {
    die("Database connection error: " . $e->getMessage());
}

// Start session if not already started
if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

// Helper function to check if user is logged in (member)
function is_member_logged_in() {
    return isset($_SESSION['member_id']);
}

// Helper function to check if admin is logged in
function is_admin_logged_in() {
    return isset($_SESSION['admin_id']);
}

// Helper function to redirect
function redirect($url) {
    header("Location: " . $url);
    exit();
}

// Helper function to sanitize input
function clean_input($data) {
    global $conn;
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $conn->real_escape_string($data);
}

// Helper function to send email
function send_email($to, $subject, $message) {
    $headers = "From: " . SMTP_FROM_NAME . " <" . SMTP_FROM . ">\r\n";
    $headers .= "Reply-To: " . SMTP_FROM . "\r\n";
    $headers .= "MIME-Version: 1.0\r\n";
    $headers .= "Content-Type: text/html; charset=UTF-8\r\n";
    
    return mail($to, $subject, $message, $headers);
}

// Get setting value
function get_setting($key) {
    global $conn;
    $key = clean_input($key);
    $sql = "SELECT setting_value FROM settings WHERE setting_key = '$key'";
    $result = $conn->query($sql);
    
    if ($result && $result->num_rows > 0) {
        $row = $result->fetch_assoc();
        return $row['setting_value'];
    }
    
    return '';
}

// Update setting value
function update_setting($key, $value) {
    global $conn;
    $key = clean_input($key);
    $value = clean_input($value);
    
    $sql = "UPDATE settings SET setting_value = '$value' WHERE setting_key = '$key'";
    return $conn->query($sql);
}
?>