PHP-MySQL nunaneersorneq pillsuussineq login systemip ilaarneqatischeorneq, ullumikkut PHP-MySQL ilisarnissaat tammaat erfalasuat, username illit isigalugu pillugu oqimaasumik, passwordiilluunniit tunngaviussaq, nutaaliorsinnaasut erfalasuat tamaat ullaakkut.
Tassa allatut kisitsisarniut peqatigiiffiat PHP-MySQL-mik nutaat ilisarniartitsisut peqatigiiffiata allaffigu. 

Tamatut, ilisarniartitsisut peqatigiiffiat ilisimatuupput qatanngutitut sananeqaatitaqarfik, qatanngutitut tamaat peqatigiiffiata allaffigut: 

```SQL
CREATE TABLE users (
  id INT NOT NULL AUTO_INCREMENT,
  username VARCHAR(50) NOT NULL,
  password VARCHAR(255) NOT NULL,
  PRIMARY KEY (id)
);
```

PHP-koodi peqatigiiffiata allaffigisat tamatut tamaat peqatigiiffiata allaffigut: 

```PHP
<?php
// start a session
session_start();

// connect to the MySQL database using PDO
$db = new PDO('mysql:host=localhost;dbname=myDatabase', 'username', 'password');

// check if the form has been submitted
if (isset($_POST['submit'])) {
  // get the username and password from the form
  $username = $_POST['username'];
  $password = $_POST['password'];

  // prepare a SQL statement to select the user from the database
  $stmt = $db->prepare('SELECT * FROM users WHERE username = :username');
  $stmt->execute(['username' => $username]);
  $user = $stmt->fetch(PDO::FETCH_ASSOC);

  // check if the user exists and the password is correct
  if ($user && password_verify($password, $user['password'])) {
    // login successful, store the user information in the session
    $_SESSION['user_id'] = $user['id'];
    $_SESSION['username'] = $user['username'];
    header('Location: home.php'); // redirect to the home page
    exit;
  } else {
    // login failed, display an error message
    $error = 'Invalid username or password';
  }
}
?>

<!-- The HTML form for the login page -->
<!DOCTYPE html>
<html>
<head>
  <title>Login</title>
</head>
<body>
  <?php if (isset($error)): ?>
    <p><?= $error ?></p>
  <?php endif; ?>
  <form method="post">
    <label for="username">Username:</label>
    <input type="text" name="username" id="username">
    <label for="password">Password:</label>
    <input type="password" name="password" id="password">
    <input type="submit" name="submit" value="Login">
  </form>
</body>
</html>
```