Exemplo n.º 1
0
<?php

/**
  Login page. Compares entered password to the 
  user's password. Sets session id if successful.
**/
// configuration
require "../includes/config.php";
$user = CS50::getUser(RETURN_TO);
if ($user !== false) {
    // query database for user
    $rows = query("SELECT * FROM users WHERE name = ?", $user["identity"]);
    // if we found user,
    if (count($rows) == 1) {
        // first (and only) row
        $row = $rows[0];
        // remember that user's now logged in by storing user's ID in session
        $_SESSION["id"] = $row["id"];
        //print("Logged in.");
        // redirect to portfolio
        redirect("/");
    } else {
        // insert new user into database
        $result = query("INSERT INTO users (name, password, email, admin, realname) VALUES(?, ?, ?, 0, ?)", $user["identity"], "", $user["email"], $user["fullname"]);
        // if user not added, notify user
        if ($result === false) {
            echo "The new user could not be added.";
        }
        //obtain most recently allocated user id
        $rows = query("SELECT LAST_INSERT_ID() AS id");
        $id = $rows[0]["id"];