Changeset 16198


Ignore:
Timestamp:
2007/10/01 10:00:47 (16 years ago)
Author:
nanasess
Message:

Emailチェック修正

  • SQL に渡す前に strtolower する.
  • ILIKE で検索していたものを "=" に修正
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/feature-module-update/data/class/pages/entry/LC_Page_Entry.php

    r16155 r16198  
    684684        //現会員の判定 → 現会員もしくは仮登録中は、メアド一意が前提になってるので同じメアドで登録不可 
    685685        if (strlen($array["email"]) > 0) { 
    686             $objQuery = new SC_Query(); 
    687             $arrRet = $objQuery->select("email, update_date, del_flg", "dtb_customer","email ILIKE ? ORDER BY del_flg", array($array["email"])); 
     686            $array["email"] = strtolower($array["email")); 
     687            $objquery = new SC_Query(); 
     688            $arrRet = $objQuery->select("email, update_date, del_flg", "dtb_customer","email = ? ORDER BY del_flg", array($array["email"])); 
    688689 
    689690            if(count($arrRet) > 0) { 
Note: See TracChangeset for help on using the changeset viewer.