ÿØÿà JFIF ` ` ÿþ
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/process/ |
Upload File : |
<?php include $_SERVER['DOCUMENT_ROOT'].'/include/base.php'; include $_SERVER['DOCUMENT_ROOT'].'/process/process_common.php'; if(strpos($_SERVER['HTTP_REFERER'], "/page/join.html") !== false){ if($_POST['join_policy'] == 'on' && $_POST['privacy_policy'] == 'on'){ $tb_name = "TB_MEMBER"; $member_password = trim($_POST['member_password']); $member_password_confirm = trim($_POST['member_password_confirm']); if($member_password == $member_password_confirm){ $member_id = trim($_POST['member_id']); $member_id = $db_connect->escape_string($member_id); //아이디 중복 여부 $sql = "SELECT count(*) AS cnt FROM {$tb_name} WHERE mb_id = '{$member_id}'"; $res = $db_connect->query($sql); $data = $res->fetch_array(MYSQLI_ASSOC); $cnt = $data['cnt']; $result = true; if($cnt > 0){ $msg = _e("사용할 수 없는 아이디입니다."); echo "<script>alert('{$msg}');location.href='/page/login.html';</script>"; exit; } $member_name = trim($_POST['member_name']); $member_email = trim($_POST['member_email']); $member_email = $db_connect->escape_string($member_email); $checkMail = filter_Var($member_email, FILTER_VALIDATE_EMAIL); $mb_sms = 'N'; if($_POST['member_sms'] == 'on'){ $mb_sms = 'Y'; } if($checkMail){ $member_tel_number = trim($_POST['member_tel_number']); $member_tel_number = $db_connect->escape_string($_POST['member_tel_number']); $mb_password = sha1($pw_salt_value.$member_password); $sql = "INSERT INTO {$tb_name} SET mb_id = '{$member_id}' "; $sql .= ", mb_pwd = '{$mb_password}' "; $sql .= ", mb_nm = '{$member_name}' "; $sql .= ", mb_sms_yn = '{$mb_sms}' "; $sql .= ", mb_email = '{$member_email}' "; $sql .= ", mb_phone = '{$member_tel_number}' "; if($db_connect->query($sql)){ $errMsg = _e("가입이 완료되었습니다."); // echo $errMsg; // echo "<script>alert('{$errMsg}'); location.href='/page/login.html'</script>"; exit; }else{ $errMsg = _e("가입 실패"); // echo $errMsg; echo "<script>alert('{$errMsg}');location.href='/page/login.html';</script>"; exit; } }else{ $errMsg = _e("이메일 유효성 오류"); echo "<script>alert('{$errMsg}');location.href='/page/login.html';</script>"; exit; } }else{ $errMsg = _e("비번 불일치"); echo "<script>alert('{$errMsg}');location.href='/page/login.html';</script>"; exit; } }else{ $errMsg = _e("동의 필요"); echo "<script>alert('{$errMsg}');location.href='/page/login.html';</script>"; exit; } }else{ $errMsg = _e("잘못된 접근입니다."); //잘못된 접근 echo "<script>alert('{$errMsg}');location.href='/page/login.html';</script>"; exit; } ?>