alert(\"이미지원 하셨습니다.\") ; history.back() ; " ; include $_SERVER ["DOCUMENT_ROOT"] . "/admin/common/dbclose.inc"; } } else if ( $mode == "insert_proc" ) { $teacher_identity = $_POST[identity1].$_POST[identity2].$_POST[identity3] ; // 주민등록번호 $teacher_tel = $teacher_tel1 . "-" . $teacher_tel2 . "-" . $teacher_tel3 ; // 전화번호 $teacher_hp = $teacher_hp1 . "-" . $teacher_hp2 . "-" . $teacher_hp3 ; // 휴대폰번호 $address_total = $address . " " . $address2 ; // 주소 $teacher_email = $teacher_email . "@". $teacher_email2 ; // E-mail if ( $photo ) { //####### 업로드 파일을 저장한 디렉토리 ######## $savedir = $_SERVER ["DOCUMENT_ROOT"] . "/admin/teacher/photo/"; //$savedir = "../admin/teacher/photo/"; //현재 날짜 및 시간 구하기 $date_write = date("Y/m/d H:i:s"); $date_file = date("YmdHis"); //접속 클라이언트 IP $ip = getenv("REMOTE_ADDR"); //파일 업로드 처리하기... if(file_exists($photo)) { ######### 허용불가 파일 판별 ######## $full_filename = explode(".", basename($photo)); $extension = $full_filename[sizeof($full_filename)-1]; if(!strcmp($extension, "html") || !strcmp($extension, "htm") || !strcmp($extension, "php") || !strcmp($extension, "php3") || !strcmp($extension, "phtml") || !strcmp($extension, "inc") || !strcmp($extension, "pl") || !strcmp($extension, "cgi") || !strcmp($extension, "txt") || !strcmp($extension, "asp") || !strcmp($extension, "exe") || !strcmp($extension, "bmp") || !strcmp($extension, "psd") || !strcmp($extension, "")) { echo ("선택하신 파일은 업로드가 금지되어 있습니다."); exit; }; $savename = $date_file . "." . $extension; if ( $img_file ) { unlink("$savedir$img_file") ; } copy($photo,"$savedir$savename"); $temp = $savename ; } } /** * 트랜잭션 성공여부를 저장하는 변수 선언 */ $success = true; /** * 트랜잭션 시작 */ mysqli_query($db_conn, "START TRANSACTION" ); $query = " INSERT INTO teacher_information (teacher_id, teacher_pwd, teacher_level_common, teacher_kor_name, teacher_eng_name, teacher_chinese_name, sex, teacher_tel, teacher_hp, teacher_identity, teacher_email, post, address, img_file, registration_date, school_kind_1, schools_1, school_name_1, school_major_1, school_place_1, school_date_S_1, school_date_E_1, grade_1, grade_total_1, school_kind_2, schools_2, school_name_2, school_major_2, school_place_2, school_date_S_2, school_date_E_2, grade_2, grade_total_2, school_kind_3, schools_3, school_name_3, school_major_3, school_place_3, school_date_S_3, school_date_E_3, grade_3, grade_total_3, school_kind_4, schools_4, school_name_4, school_major_4, school_place_4, school_date_S_4, school_date_E_4, grade_4, grade_total_4, fran_code, place1, place2, place3, lesson_time, lesson_number, marriage, marriage_date, date_type, religion, birthday, birth_type, taste, special, channel, introduce, support ) VALUES ( '$teacher_id', '$teacher_pwd', '1', '$teacher_kor_name', '$teacher_eng_name', '$teacher_chinese_name', '$sex', '$teacher_tel', '$teacher_hp', '$teacher_identity', '$teacher_email', '$post', '$address_total', '$temp', NOW(),'$school_kind_1', '$schools_1', '$school_name_1', '$school_major_1', '$school_place_1', '$school_date_S_1', '$school_date_E_1', '$grade_1', '$grade_total_1', '$school_kind_2', '$schools_2', '$school_name_2', '$school_major_2', '$school_place_2', '$school_date_S_2', '$school_date_E_2', '$grade_2', '$grade_total_2', '$school_kind_3', '$schools_3', '$school_name_3', '$school_major_3', '$school_place_3', '$school_date_S_3', '$school_date_E_3', '$grade_3', '$grade_total_3', '$school_kind_4', '$schools_4', '$school_name_4', '$school_major_4', '$school_place_4', '$school_date_S_4', '$school_date_E_4', '$grade_4','$grade_total_4', '$fran_code', '$place1', '$place2', '$place3', '$lesson_time', '$lesson_number', '$marriage', '$marriage_date', '$date_type', '$religion', '$birthday', '$birth_type', '$taste', '$special', '$channel', '$introduce', '$support' )"; $ret=execSqlUpdate($query); if ( !$ret ) { $success = false; } for($i=0;$i<=count($career_name);$i++){ if($career_name[$i] !=''){ $query2 = "INSERT INTO teacher_career (teacher_id, career_date1, career_date2, career_name, career_type, career_situation, career_estate, kind_job) VALUES ('$teacher_id', '".$HTTP_POST_VARS['career_stdate'.$i]."', '".$HTTP_POST_VARS['career_eddate'.$i]."', '$career_name[$i]', '$career_type[$i]', '$career_situation[$i]', '$career_estate[$i]', '$kind_job[$i]') " ; $ret=execSqlUpdate($query2); if ( !$ret ) { $success = false; } } } for($i=0;$i<=count($license_name);$i++){ if($license_name[$i] !=''){ $query3 = "INSERT INTO teacher_license (teacher_id, acquisition_date, license_name, issue) VALUES ('$teacher_id', '".$HTTP_POST_VARS['acquisition_date'.$i]."', '$license_name[$i]', '$issue[$i]') " ; $ret=execSqlUpdate($query3); if ( !$ret ) { $success = false; } } } /** * 커밋 또는 롤백 */ if ( $success == true ) { mysqli_query($db_conn, "COMMIT" ); echo ""; include $_SERVER ["DOCUMENT_ROOT"] . "/admin/common/dbclose.inc"; go_href("./online.html"); } else { mysqli_query($db_conn, "ROLLBACK" ); include $_SERVER ["DOCUMENT_ROOT"] . "/admin/common/dbclose.inc"; echo mysqli_errno(); echo ""; //put_msg_and_go("지원서 작성 실패. 잠시후 다시 하시기 바랍니다.", $history_back_url); } } ?>

온라인 지원

기초사항

기초사항
이름
생년월일
아이디
비밀번호
우편번호
주소
전화번호 - -
휴대폰 - -
이메일 @
성별
결혼여부 > >
사진업로드

학력사항

학력사항
학교명 기간 전공 졸업여부
고등학교

~
대학

~
대학교

~
대학원

~

경력사항

경력사항
근무처 기간 담당업무 근무여부

~

~

~

자격증

자격증
자격증명 취득일 발행처

기타사항

기타사항
레슨희망지역
희망지사
희망레슨인원
지원경로
소개자
취미 및 특기

자기소개

자기소개
자기소개
취소 신청