JezK
Edit File: seed_users.php
<?php $host = 'localhost'; $user = 'root'; $pass = ''; try { $pdo = new PDO("mysql:host=$host;dbname=trust_software3;charset=utf8mb4", $user, $pass); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Ensure at least one lab exists $stmt = $pdo->query("SELECT id FROM labs LIMIT 1"); $lab_id = $stmt->fetchColumn(); if (!$lab_id) { $pdo->exec("INSERT INTO labs (lab_code, name, address) VALUES ('LAB-TEST-001', 'HQ Main Center', '123 Health Ave')"); $lab_id = $pdo->lastInsertId(); } $passHash = password_hash('password123', PASSWORD_BCRYPT); // Insert test users explicitly ignore if email exists via INSERT IGNORE $pdo->exec("INSERT IGNORE INTO users (name, email, password_hash, role_id, lab_id) VALUES ('Admin User', 'admin@admin.com', '$passHash', 1, $lab_id), ('Operator Demo', 'operator@admin.com', '$passHash', 2, $lab_id), ('Accountant Demo', 'accountant@admin.com', '$passHash', 4, $lab_id) "); echo "Seed completed."; } catch (PDOException $e) { echo "Error: " . $e->getMessage(); }