|
# **********************************************************
# データベースへの更新
# **********************************************************
function InsertData( &$SQL ) {
global $ErrMessage;
$Query = "insert into 顧客マスタ";
$Query .= " values(";
$Query .= Ss( $_POST['In1Email'] );
$Query .= "," . Ss( $_POST['In1Name'] );
$Query .= "," . Ss( $_POST['In1Zip'] );
$Query .= "," . Ss( $_POST['In1Address'] );
$Query .= "," . $_POST['In1Sex'];
$Query .= "," . Ss( $_POST['In1Tel'] );
$Query .= "," . Ss( $_POST['In1Mobile'] );
$Query .= "," . Ss( $_POST['In1Pass1'] );
$Query .= ",";
$Query .= "'";
$Query .= $_POST['In1Yyyy'] . "/";
$Query .= $_POST['In1Mm'] . "/";
$Query .= $_POST['In1Dd'];
$Query .= "'";
$Query .= ")";
if ( !$SQL->Execute( $Query ) ) {
$ErrMessage = "登録に失敗しました";
return FALSE;
}
return TRUE;
}
| |