create_test_user.php

<?php
require_once 'config/database.php';

// Check if user exists
$username = 'testuser';
$email = 'test@example.com';
$password = 'password123';

$stmt = $pdo->prepare("SELECT * FROM users WHERE username = ? OR email = ?");
$stmt->execute([$username, $email]);

if ($stmt->rowCount() > 0) {
    echo "User already exists. Updating password...\n";
    
    // Update password
    $hashedPassword = password_hash($password, PASSWORD_DEFAULT);
    $stmt = $pdo->prepare("UPDATE users SET password = ? WHERE username = ?");
    $stmt->execute([$hashedPassword, $username]);
    
    echo "Password updated for user $username.\n";
} else {
    // Create user
    $hashedPassword = password_hash($password, PASSWORD_DEFAULT);
    
    $stmt = $pdo->prepare("INSERT INTO users (username, email, password, is_admin) VALUES (?, ?, ?, ?)");
    $stmt->execute([$username, $email, $hashedPassword, 0]);
    
    echo "Created new user: $username\n";
}

// Verify user
$stmt = $pdo->prepare("SELECT * FROM users WHERE username = ?");
$stmt->execute([$username]);
$user = $stmt->fetch();

echo "User ID: " . $user['id'] . "\n";
echo "Username: " . $user['username'] . "\n";
echo "Email: " . $user['email'] . "\n";
echo "Is Admin: " . ($user['is_admin'] ? 'Yes' : 'No') . "\n";
echo "Password hash length: " . strlen($user['password']) . "\n";
?>