Changeset 16089


Ignore:
Timestamp:
2007/09/27 16:04:18 (17 years ago)
Author:
nanasess
Message:

bugfix

  • 'ILIKE' -> '='
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/feature-module-update/data/class/pages/forgot/LC_Page_Forgot.php

    r16069 r16089  
    6969            //メアド入力時 
    7070            $_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"; 
    7272            $result = $conn->getAll($sql, array($_POST['email']) ); 
    7373 
     
    8181                $this->tpl_mainpage = 'forgot/secret.tpl'; 
    8282            } 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";   //仮登録中の確認 
    8484                $result = $conn->getAll($sql, array($_POST['email']) ); 
    8585                if ($result) { 
     
    9696                // ヒミツの答えの回答が正しいかチェック 
    9797 
    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"; 
    9999                $result = $conn->getAll($sql, array($_SESSION['forgot']['email']) ); 
    100100                $data = $result[0]; 
Note: See TracChangeset for help on using the changeset viewer.