Changeset 22580


Ignore:
Timestamp:
2013/02/22 14:28:41 (4 years ago)
Author:
habu
Message:

#2159 意味が無いLIKE

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_12-dev/data/class/pages/forgot/LC_Page_Forgot.php

    r22567 r22580  
    155155        $errmsg = NULL; 
    156156        $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    157         $where = '(email Like ? OR email_mobile Like ?) AND name01 Like ? AND name02 Like ? AND del_flg = 0'; 
     157        $where = '(email = ? OR email_mobile = ?) AND name01 = ? AND name02 = ? AND del_flg = 0'; 
    158158        $arrVal = array($arrForm['email'], $arrForm['email'], $arrForm['name01'], $arrForm['name02']); 
    159159        $result = $objQuery->select('reminder, status', 'dtb_customer', $where, $arrVal); 
     
    205205        $cols = 'customer_id, reminder, reminder_answer, salt'; 
    206206        $table = 'dtb_customer'; 
    207         $where = '(email Like ? OR email_mobile Like ?)' 
    208                     . ' AND name01 Like ? AND name02 Like ?' 
     207        $where = '(email = ? OR email_mobile = ?)' 
     208                    . ' AND name01 = ? AND name02 = ?' 
    209209                    . ' AND status = 2 AND del_flg = 0'; 
    210210        $arrVal = array($arrForm['email'], $arrForm['email'], 
Note: See TracChangeset for help on using the changeset viewer.