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>
