Changeset 16089
- Timestamp:
- 2007/09/27 16:04:18 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update/data/class/pages/forgot/LC_Page_Forgot.php
r16069 r16089 69 69 //メアド入力時 70 70 $_POST['email'] = strtolower($_POST['email']); 71 $sql = "SELECT * FROM dtb_customer WHERE email ILIKE? AND status = 2 AND del_flg = 0";71 $sql = "SELECT * FROM dtb_customer WHERE email = ? AND status = 2 AND del_flg = 0"; 72 72 $result = $conn->getAll($sql, array($_POST['email']) ); 73 73 … … 81 81 $this->tpl_mainpage = 'forgot/secret.tpl'; 82 82 } else { 83 $sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE? AND status = 1 AND del_flg = 0"; //仮登録中の確認83 $sql = "SELECT customer_id FROM dtb_customer WHERE email = ? AND status = 1 AND del_flg = 0"; //仮登録中の確認 84 84 $result = $conn->getAll($sql, array($_POST['email']) ); 85 85 if ($result) { … … 96 96 // ヒミツの答えの回答が正しいかチェック 97 97 98 $sql = "SELECT * FROM dtb_customer WHERE email ILIKE? AND del_flg = 0";98 $sql = "SELECT * FROM dtb_customer WHERE email = ? AND del_flg = 0"; 99 99 $result = $conn->getAll($sql, array($_SESSION['forgot']['email']) ); 100 100 $data = $result[0];
Note: See TracChangeset
for help on using the changeset viewer.