Пример #1
0
function getInfo($uid)
{
    global $data;
    if ($data == NULL) {
        $dbh = \Pasteque\get_local_auth_database();
        $stmt = $dbh->prepare('SELECT * FROM pasteque_databases WHERE user_id = :user_id');
        $stmt->bindParam(':user_id', $uid);
        $stmt->execute();
        $result = $stmt->fetchAll();
        if (count($result) != 1) {
            die("No database found for " . $uid);
        }
        $data = $result[0];
    }
    return $data;
}
Пример #2
0
     }
 }
 if ($_POST['password'] != $_POST['confirm_password']) {
     array_push($errors, \i18n("Password confirmation incorrect"));
 }
 $email = filter_input(INPUT_POST, "email", FILTER_VALIDATE_EMAIL);
 if ($email == NULL) {
     array_push($errors, \i18n("Invalid email"));
 }
 if (count($errors) == 0) {
     $firstName = $_POST["first_name"];
     $lastName = $_POST["last_name"];
     $login = $_POST["login"];
     // TODO : insert data in database
     $password = $_POST["password"];
     $dbh = \Pasteque\get_local_auth_database();
     $extraFields = '';
     $extraPlaceholders = '';
     if ($_POST["website"]) {
         $extraFields .= ', website';
         $extraPlaceholders .= ', :website';
     }
     $query = "INSERT INTO pasteque_users (creation_date, user_id, first_name, last_name, email, password, newsletter, coffee_shop, token {$extraFields}) VALUES (now(), :login, :first_name, :last_name, :email, :password, :newsletter, :coffee_shop, :token {$extraPlaceholders});";
     $stmt = $dbh->prepare($query);
     $stmt->bindValue(':login', $login);
     $stmt->bindValue(':first_name', $firstName);
     $stmt->bindValue(':last_name', $lastName);
     $stmt->bindValue(':email', $email);
     $stmt->bindValue(':password', \Pasteque\local_hash_password($password));
     if ($_POST["subscribe_newsletter"]) {
         $stmt->bindValue(':newsletter', 1);