File Manager

Editing:setup_admin_orders.php

<?php
include 'config.php';

// Create Admins Table
$conn->query("CREATE TABLE IF NOT EXISTS admins (
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(50) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL
)");

// Insert default admin if not exists
$admin_user = 'admin';
$admin_pass = 'password'; // Plain text as per user request for now, or I'll hash it if I'm being responsible. 
// User said "username - admin password - password", so I'll store it as requested.
$hashed_pass = password_hash($admin_pass, PASSWORD_DEFAULT);
$conn->query("INSERT IGNORE INTO admins (username, password) VALUES ('$admin_user', '$hashed_pass')");

// Create Orders Table
$conn->query("CREATE TABLE IF NOT EXISTS orders (
    id INT PRIMARY KEY AUTO_INCREMENT,
    customer_name VARCHAR(100) NOT NULL,
    customer_phone VARCHAR(20) NOT NULL,
    customer_address TEXT NOT NULL,
    order_details TEXT NOT NULL,
    total_amount DECIMAL(10, 2) NOT NULL,
    status VARCHAR(20) DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");

echo "Database updated with admins and orders tables!";
?>

Cancel

🤩 File Manager - Mr.X

Editing:setup_admin_orders.php