function getUser($email, $password, $dbh) { $sql = "select * from users where email = :email and password = :password limit 1"; $stmt = $dbh->prepare($sql); $stmt->execute(array(":email" => $email, ":password" => getSha1Password($password))); $user = $stmt->fetch(); return $user ? $user : false; }
function getUser($email, $password, $dbh) { $sql = "SELECT * FROM account WHERE email = :email AND password = :password LIMIT 1"; $stmt = $dbh->prepare($sql); $stmt->execute(array(":email" => $email, ":password" => getSha1Password($password))); $user = $stmt->fetch(); return $user ? $user : false; }
function getUser($user_name, $password, $dbh) { $sql = "select * from users where user_name = :user_name and password = :password limit 1"; $stmt = $dbh->prepare($sql); $stmt->execute(array(":user_name" => $user_name, ":password" => getSha1Password($password))); // 返り値のPDOオブジェクトに対してfetchメソッドを実行し、結果セットを配列で取得している $user = $stmt->fetch(); return $user ? $user : false; }
function getUser($email, $pass, $dbh) { $sql = "select * from user_info where status = 'active' and email = :email and pass = :pass limit 1"; $stmt = $dbh->prepare($sql); $stmt->execute(array(":email" => $email, ":pass" => getSha1Password($pass))); $user = $stmt->fetch(); // error_log($stmt); return $user ? $user : false; //条件式(return $user = $userに戻り値があれば) ? 式1 : 式2(条件式を評価し、TRUEであれば式1、FALSEであれば式2を返します) // var_dump($user); }
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) { $error['email'] = "メールアドレスの形式が正しくありません"; } // メールアドレスが空かどうか if ($email == '') { $error['email'] = 'メールアドレスを入力してください'; } // パスワードが空かどうか if ($password == '') { $error['password'] = '******'; } // 登録処理 if (empty($error)) { $sql = "insert into users\n\t\t\t\t(name, email, password, created, modified)\n\t\t\t\tvalues\n\t\t\t\t(:name, :email, :password, now(), now())"; $stmt = $dbh->prepare($sql); $params = array(":name" => $name, ":email" => $email, ":password" => getSha1Password($password)); $stmt->execute($params); header('Location: ' . SITE_URL . 'login.php'); exit; } } ?> <!DOCTYPE html> <html lang="ja"> <head> <meta charset="utf-8"> <title>新規ユーザー登録</title> </head> <body>
$err = array(); if (empty($name)) { $err['name'] = 'ユーザ名を入力してください'; } if (checkExistingName($name)) { $err['name'] = 'このユーザ名はすでに使われています'; } if (empty($password)) { $err['password'] = '******'; } if (empty($password2)) { $err['password2'] = 'パスワード(確認用)を入力してください'; } if (empty($err)) { //DB接続 $sha1password = getSha1Password($password); echo $sha1password; exit; //DBにデータを入れる $q = sprintf("insert into users (name , password , created_at , updated_at) values ( '%s' , '%s' , now() , now())", r($name), $sha1password); $rs = mysql_query($q); //login.phpへ飛ばす } } else { echo $_SERVER['REQUEST_METHODS']; } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html lang="en"> <head>
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) { $err['email'] = 'メールアドレスの形式に間違いがあります。'; } if ($email = '') { $err['email'] = 'メールアドレスを入力してください。'; } if (!emailExists($email, $dbh)) { $err['email'] = '既に登録されています。'; } if ($password == '') { $err['password'] = '******'; } if (empty($err)) { $sql = "insert into users\n (user_name, password, email, created, modified)\n values\n (:user_name, :password, :email, now(),now())"; $stmt = $dbh->prepare($sql); $params = array(":user_name" => $name, ":password" => getSha1Password($password), ":email" => $email); $stmt->execute($params); header('Location: ' . SITE_URL . 'login.php'); exit; } } ?> <!DOCTYPE html> <html lang="ja"> <head> <meta charset="UTF-8"> <title>ENTRY</title> <link rel="styleSheet" type="text/css" href="css/signup.css"> </head> <body> <header>