Should users be stored as rows in a database or directly as DB users for a project management system using PHP?

Storing users as rows in a database is the recommended approach for a project management system using PHP. This allows for more flexibility in managing user data and permissions, as well as better scalability for future enhancements. Using database users directly may limit the functionality and control over user management within the system. 

// Sample code to store users as rows in a database for a project management system

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "project_management";

$conn = new mysqli($servername, $username, $password, $dbname);

// Create a table to store users
$sql = "CREATE TABLE users (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(30) NOT NULL,
    password VARCHAR(30) NOT NULL,
    email VARCHAR(50),
    role VARCHAR(20)
)";

if ($conn->query($sql) === TRUE) {
    echo "Table users created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}

// Insert a sample user into the table
$sql = "INSERT INTO users (username, password, email, role) VALUES ('john_doe', 'password123', 'john.doe@example.com', 'admin')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

// Close the database connection
$conn->close();

Keywords

database DB users project management system PHP rows

Related Questions