엑셀 업로드 질문 드립니다.
스규스규
1년 전
조회 1,722
Fatal error: Uncaught Error: Undefined constant "ex_type" in /finenuts05/www/skin/board/basic/excel_free_up2.php:11 Stack trace: #0 {main} thrown in /finenuts05/www/skin/board/basic/excel_free_up2.php on line 11
이런 에러가 나와서 원인은 찾았습니다..
excel_up1에서 신규파일의 라디오 체크값을 못 넘겨서 그러는거 같은데..
아무리해도 저 라디오 버튼이 활성화가 안되서 이도저도 못하는 상황입니다..
저 부분이 문제 인건지..
아니면 다른 문제가 있는건지..
알려주실 수 있나요.. ㅠ
http://sir.kr/data/editor/2401/237007248_1704436362.3192.png" width="100%" />
excel_up1
</p>
<p><?php</p>
<p>include_once("_common.php");</p>
<p>$g5['title'] = "엑셀 업로드";</p>
<p>include_once(G5_PATH.'/_head.php');</p>
<p>?></p>
<p><style></p>
<p>.new_excel{border-radius:20px;background:#fff;box-shadow:rgba(149, 157, 165, 0.1) 0px 8px 24px; padding:20px 20px 20px 20px; margin-top:20px;}</p>
<p>.new_excel h1{margin:10px 0;}</p>
<p>.excel_info {margin-bottom:10px; line-height:18px;}</p>
<p>.btn_confirm {margin-top:15px;}</p>
<p>.excel_desc{margin-top: 50px;}</p>
<p>.excel_desc .excel_tit{font-size: 1.333em;font-weight:700;}</p>
<p>.excel_desc .excel_con{margin-bottom:50px;margin-top: 20px;}</p>
<p>.excel_desc .excel_con p{padding-bottom: 10px;line-height:26px;}</p>
<p>.excel_desc .excel_con img{width: 100%;border:1px solid #ccc;}</p>
<p></style></p>
<p> </p>
<p><div class="new_excel"></p>
<p> <h1><?php echo $g5['title']?></h1></p>
<p> </p>
<p> <div class="excel_info"></p>
<p> <p></p>
<p> 엑셀파일을 저장하실 때는 <strong>Excel 97 - 2003 통합문서 (*.xls)</strong> 로 저장하셔야 합니다.</p>
<p> </p></p>
<p> </div></p>
<p> </p>
<p> <form name="fitemexcelup" id="fitemexcelup" method="post" action="./excel_company_up2.php" enctype="MULTIPART/FORM-DATA" autocomplete="off"></p>
<p> <input type="hidden" name="bo_table" value="<?php echo $bo_table ?>"></p>
<p> <div id="excelfile_upload" style="text-align:center;"></p>
<p> <label for="excelfile">파일유형 선택</label></p>
<p> <input type="radio" name="ex_type" value="1">신규파일 </p>
<p> <input type="file" name="excelfile" id="excelfile"></p>
<p> </div></p>
<p> </p>
<p> <div class="btn_confirm01 btn_confirm"></p>
<p> <input type="submit" value="엑셀파일 등록" class="btn_submit"></p>
<p> <a href="<?php echo G5_BBS_URL?>/board_company.php?bo_table=<?php echo $bo_table?>" class="btn_submit" style="color:#FFF; text-decoration:none;">게시판 바로가기</a></p>
<p> </div></p>
<p> </p>
<p> </form></p>
<p> </p>
<p></div></p>
<p> </p>
<p><?</p>
<p>include_once(G5_PATH.'/_tail.php');</p>
<p>?></p>
<p>
</p>
<p> </p>
<p> </p>
<p><?php</p>
<p>include_once('./_common.php');</p>
<p> </p>
<p>if(!$_POST['ex_type']){</p>
<p> alert("파일유형을 선택해주세요");</p>
<p>}</p>
<p>// 상품이 많을 경우 대비 설정변경</p>
<p>set_time_limit ( 0 );</p>
<p>ini_set('memory_limit', '50M');</p>
<p> </p>
<p>if(!$_FILES['excelfile']['tmp_name']) {</p>
<p> alert("등록하실 파일이 없습니다");</p>
<p>}</p>
<p>if($_FILES['excelfile']['tmp_name']) {</p>
<p> $file = $_FILES['excelfile']['tmp_name'];</p>
<p> </p>
<p> include_once(G5_LIB_PATH.'/Excel/reader.php');</p>
<p> </p>
<p> $data = new Spreadsheet_Excel_Reader();</p>
<p> </p>
<p> // Set output Encoding.</p>
<p> $data->setOutputEncoding('UTF-8');</p>
<p> </p>
<p> /***</p>
<p> * if you want you can change 'iconv' to mb_convert_encoding:</p>
<p> * $data->setUTFEncoder('mb');</p>
<p> *</p>
<p> **/</p>
<p> </p>
<p> /***</p>
<p> * By default rows & cols indeces start with 1</p>
<p> * For change initial index use:</p>
<p> * $data->setRowColOffset(0);</p>
<p> *</p>
<p> **/</p>
<p>
</p>
<p> /***</p>
<p> * Some function for formatting output.</p>
<p> * $data->setDefaultFormat('%.2f');</p>
<p> * setDefaultFormat - set format for columns with unknown formatting</p>
<p> *</p>
<p> * $data->setColumnFormat(4, '%.3f');</p>
<p> * setColumnFormat - set format for column (apply only to number fields)</p>
<p> *</p>
<p> **/</p>
<p> </p>
<p> $data->read($file);</p>
<p> </p>
<p> /*</p>
<p>
</p>
<p> $data->sheets[0]['numRows'] - count rows</p>
<p> $data->sheets[0]['numCols'] - count columns</p>
<p> $data->sheets[0]['cells'][$i][$j] - data from $i-row $j-column</p>
<p> </p>
<p> $data->sheets[0]['cellsInfo'][$i][$j] - extended info about cell</p>
<p> </p>
<p> $data->sheets[0]['cellsInfo'][$i][$j]['type'] = "date" | "number" | "unknown"</p>
<p> if 'type' == "unknown" - use 'raw' value, because cell contain value with format '0.00';</p>
<p> $data->sheets[0]['cellsInfo'][$i][$j]['raw'] = value if cell without format</p>
<p> $data->sheets[0]['cellsInfo'][$i][$j]['colspan']</p>
<p> $data->sheets[0]['cellsInfo'][$i][$j]['rowspan']</p>
<p> */</p>
<p> </p>
<p> error_reporting(E_ALL ^ E_NOTICE);</p>
<p> </p>
<p> </p>
<p> $write_table = "g5_write_{$bo_table}";</p>
<p> </p>
<p> for ($i = 2; $i <= count($data->sheets[0]["cells"]); $i++) { //$i == 몇번째 라인부터 등록할건지</p>
<p> $total_count++;</p>
<p> </p>
<p> if($_POST[ex_type] == "2"){</p>
<p> $wr_1 = addslashes($data->sheets[0]['cells'][$i][2]); //필드1</p>
<p> $wr_2 = addslashes($data->sheets[0]['cells'][$i][3]); //필드2</p>
<p> $wr_3 = addslashes($data->sheets[0]['cells'][$i][4]); //필드3</p>
<p> $wr_4 = addslashes($data->sheets[0]['cells'][$i][5]); //필드4</p>
<p> $wr_5 = addslashes($data->sheets[0]['cells'][$i][6]); //필드5</p>
<p> </p>
<p> $wr_6 = addslashes($data->sheets[0]['cells'][$i][7]); //필드6</p>
<p> $wr_7 = addslashes($data->sheets[0]['cells'][$i][8]); //필드7</p>
<p> $wr_8 = addslashes($data->sheets[0]['cells'][$i][9]); //필드8</p>
<p> $wr_9 = addslashes($data->sheets[0]['cells'][$i][10]); //필드9</p>
<p> $wr_10 = addslashes($data->sheets[0]['cells'][$i][11]); //필드10</p>
<p> </p>
<p> $sql = " update {$write_table}</p>
<p> set wr_subject = '$wr_subject',</p>
<p> wr_1 = '$wr_1',</p>
<p> wr_2 = '$wr_2',</p>
<p> wr_3 = '$wr_3',</p>
<p> wr_4 = '$wr_4',</p>
<p> wr_5 = '$wr_5',</p>
<p> wr_6 = '$wr_6',</p>
<p> wr_7 = '$wr_7',</p>
<p> wr_8 = '$wr_8',</p>
<p> wr_9 = '$wr_9',</p>
<p> wr_10 = '$wr_10'</p>
<p> where wr_id = '$wr_id' ";</p>
<p> </p>
<p> sql_query($sql);</p>
<p> </p>
<p> }else{</p>
<p> </p>
<p> $mb_id = $member['mb_id'];</p>
<p> $wr_name = $member['mb_nick'];</p>
<p> $wr_password = $member['mb_password'];</p>
<p> $wr_email = $member['mb_email'];</p>
<p> $wr_homepage = $member['mb_homepage'];</p>
<p> </p>
<p> $wr_num = get_next_num($write_table);</p>
<p> $wr_reply = '';</p>
<p> </p>
<p> $wr_1 = addslashes($data->sheets[0]['cells'][$i][1]); //필드1</p>
<p> $wr_2 = addslashes($data->sheets[0]['cells'][$i][2]); //필드2</p>
<p> $wr_3 = addslashes($data->sheets[0]['cells'][$i][3]); //필드3</p>
<p> $wr_4 = addslashes($data->sheets[0]['cells'][$i][4]); //필드4</p>
<p> $wr_5 = addslashes($data->sheets[0]['cells'][$i][5]); //필드5</p>
<p> </p>
<p> $wr_6 = addslashes($data->sheets[0]['cells'][$i][6]); //필드6</p>
<p> $wr_7 = addslashes($data->sheets[0]['cells'][$i][7]); //필드7</p>
<p> $wr_8 = addslashes($data->sheets[0]['cells'][$i][8]); //필드8</p>
<p> $wr_9 = addslashes($data->sheets[0]['cells'][$i][9]); //필드9</p>
<p> $wr_10 = addslashes($data->sheets[0]['cells'][$i][10]); //필드10</p>
<p> </p>
<p> </p>
<p> $sql = " insert into $write_table</p>
<p> set wr_num = '$wr_num',</p>
<p> wr_reply = '$wr_reply',</p>
<p> wr_comment = 0,</p>
<p> ca_name = '$ca_name',</p>
<p> wr_option = '$html,$secret,$mail',</p>
<p> wr_subject = '$wr_subject',</p>
<p> wr_content = '$wr_subject',</p>
<p> wr_link1 = '$wr_link1',</p>
<p> wr_link2 = '$wr_link2',</p>
<p> wr_link1_hit = 0,</p>
<p> wr_link2_hit = 0,</p>
<p> wr_hit = 0,</p>
<p> wr_good = 0,</p>
<p> wr_nogood = 0,</p>
<p> mb_id = '$mb_id',</p>
<p> wr_password = '$wr_password',</p>
<p> wr_name = '$wr_name',</p>
<p> wr_email = '$wr_email',</p>
<p> wr_homepage = '$wr_homepage',</p>
<p> wr_datetime = '".G5_TIME_YMDHIS."',</p>
<p> wr_last = '".G5_TIME_YMDHIS."',</p>
<p> wr_ip = '{$_SERVER['REMOTE_ADDR']}',</p>
<p> wr_1 = '$wr_1',</p>
<p> wr_2 = '$wr_2',</p>
<p> wr_3 = '$wr_3',</p>
<p> wr_4 = '$wr_4',</p>
<p> wr_5 = '$wr_5',</p>
<p> wr_6 = '$wr_6',</p>
<p> wr_7 = '$wr_7',</p>
<p> wr_8 = '$wr_8',</p>
<p> wr_9 = '$wr_9',</p>
<p> wr_10 = '$wr_10'";</p>
<p> </p>
<p> sql_query($sql);</p>
<p> </p>
<p> $wr_id = sql_insert_id();</p>
<p> </p>
<p> // 부모 아이디에 UPDATE</p>
<p> sql_query(" update $write_table set wr_parent = '$wr_id' where wr_id = '$wr_id' ");</p>
<p> </p>
<p> // 새글 INSERT</p>
<p> sql_query(" insert into {$g5['board_new_table']} ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '{$bo_table}', '{$wr_id}', '{$wr_id}', '".G5_TIME_YMDHIS."', '{$mb_id}' ) ");</p>
<p> </p>
<p> // 게시글 1 증가</p>
<p> sql_query("update {$g5['board_table']} set bo_count_write = bo_count_write + 1 where bo_table = '{$bo_table}'");</p>
<p> </p>
<p> }//type end</p>
<p> </p>
<p> </p>
<p> </p>
<p> }//for end</p>
<p> </p>
<p>alert("업로드 되었습니다",G5_BBS_URL."/board_notebook.php?bo_table=notebook");</p>
<p>}</p>
<p> </p>
<p>?></p>
<p> </p>
<p>
댓글을 작성하려면 로그인이 필요합니다.
답변 2개
답변을 작성하려면 로그인이 필요합니다.
로그인