Vim Patior

View file

File name : update_db_v3.php
Content :
<?php
require 'db_config.php';

header('Content-Type: text/plain');

echo "Omni Rewards - Database Updater V4 (Biometrics)\n";
echo "=================================================\n\n";

try {
    $conn = new mysqli($servername, $username, $password, $dbname);
    if ($conn->connect_error) {
        throw new Exception("Connection failed: " . $conn->connect_error);
    }
    echo "Successfully connected to the database.\n\n";

    $tables = ['customers', 'admins'];
    $column_name = 'biometric_token';
    
    foreach ($tables as $table) {
        echo "Checking table `$table`... ";
        $result = $conn->query("SHOW COLUMNS FROM `$table` LIKE '$column_name'");
        if ($result->num_rows == 0) {
            $sql = "ALTER TABLE `$table` ADD COLUMN `$column_name` VARCHAR(255) NULL DEFAULT NULL";
            if ($conn->query($sql) === TRUE) {
                echo "Column added successfully.\n";
            } else {
                echo "Error adding column: " . $conn->error . "\n";
            }
        } else {
            echo "Column already exists.\n";
        }
    }

    echo "\n---------------------------------------\n";
    echo "DATABASE SCHEMA UPDATED FOR BIOMETRICS.\n";
    echo "You can now safely delete this file (update_db_v4.php).\n";

    $conn->close();

} catch (Exception $e) {
    http_response_code(500);
    echo "\n\nAN ERROR OCCURRED:\n" . $e->getMessage() . "\n";
}
?>