Changeset 16087


Ignore:
Timestamp:
2007/09/27 15:44:53 (15 years ago)
Author:
nanasess
Message:

getCustomerDataFromEmailPass() 修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/feature-module-update/data/class/SC_Customer.php

    r16086 r16087  
    5050    } 
    5151 
    52     /* 
    53      * XXX ILIKE で良い? 
    54      */ 
    5552    function getCustomerDataFromEmailPass( $pass, $email, $mobile = false ) { 
    56         $sql_mobile = $mobile ? ' OR email_mobile ILIKE ?' : ''; 
     53        // 小文字に変換 
     54        $email = strtolower($email); 
     55        $sql_mobile = $mobile ? ' OR email_mobile = ?' : ''; 
    5756        $arrValues = array($email); 
    5857        if ($mobile) { 
     
    6059        } 
    6160        // 本登録された会員のみ 
    62         $sql = "SELECT * FROM dtb_customer WHERE (email ILIKE ?" . $sql_mobile . ") AND del_flg = 0 AND status = 2"; 
     61        $sql = "SELECT * FROM dtb_customer WHERE (email = ?" . $sql_mobile . ") AND del_flg = 0 AND status = 2"; 
    6362        $result = $this->conn->getAll($sql, $arrValues); 
    6463        $data = $result[0]; 
Note: See TracChangeset for help on using the changeset viewer.