<?php
error_reporting(E_ALL);
ini_set('display_errors', 'On');
ini_set('display_startup_errors', 'On');
// Your other code follows...
?>
<?php
$db = new PDO('sqlite:lawsite.db');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$db->exec("
CREATE TABLE IF NOT EXISTS laws (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    title TEXT NOT NULL,
    summary TEXT,
    content TEXT NOT NULL,
    proposer TEXT NOT NULL,
    status TEXT DEFAULT 'Pending',
    admin TEXT,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
");

$db->exec("
CREATE TABLE IF NOT EXISTS admins (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT UNIQUE NOT NULL,
    password TEXT NOT NULL
);
");

// Example admin creation (run once, then comment/remove)
$hash = password_hash("admin123", PASSWORD_DEFAULT);
$db->exec("INSERT OR IGNORE INTO admins (username, password) VALUES ('admin', '$hash')");
?>