What are the advantages and disadvantages of using SQLite as an alternative to MySQL for a single user login system in PHP?

When considering using SQLite as an alternative to MySQL for a single user login system in PHP, some advantages include its simplicity, portability, and ease of setup. However, some disadvantages include limited scalability and performance compared to MySQL. 

<?php
$db = new SQLite3('database.db');

$username = $_POST['username'];
$password = $_POST['password'];

$query = "SELECT * FROM users WHERE username = :username AND password = :password";
$stmt = $db->prepare($query);
$stmt->bindValue(':username', $username, SQLITE3_TEXT);
$stmt->bindValue(':password', $password, SQLITE3_TEXT);
$result = $stmt->execute();

if ($row = $result->fetchArray()) {
    echo "Login successful!";
} else {
    echo "Login failed. Please try again.";
}

$db->close();
?>

Keywords

SQLite MySQL single user login system PHP advantages.

Related Questions