|
# **********************************************************
# 顧客データ読出し
# **********************************************************
function GetData( &$SQL ) {
global $ErrMessage;
$Query = 'select * from 顧客マスタ';
$Query .= " where メールアドレス = '{$_POST['In1Email']}'";
$Column = $SQL->QueryEx( $Query );
if ( $Column ) {
$_POST['In2Name'] = $Column['氏名'];
$_POST['In2Zip'] = $Column['郵便番号'];
$_POST['In2Address'] = $Column['住所'];
$_POST['In2Sex'] = $Column['性別'];
$_POST['In2Tel'] = $Column['TEL'];
$_POST['In2Mobile'] = $Column['携帯番号'];
$_POST['In2Pass'] = $Column['パスワード'];
$Birth = explode( "-", $Column['誕生日'] );
$_POST['In2Yyyy'] = $Birth[0];
$_POST['In2Mm'] = $Birth[1];
$_POST['In2Dd'] = $Birth[2];
return TRUE;
}
$ErrMessage = "該当するデータは存在しません";
return FALSE;
}
| |