게시판 엑셀파일 업로드 > 공책

본문 바로가기
010.6356.7610
  • design1001@naver.com
  • @design1001
작업물 전체보기

공책

PHP with GNU 게시판 엑셀파일 업로드

페이지 정보

  • 작성자후야
  • 조회 : 209
  • 작성일 : 2021-05-12 01:34

본문

게시판에 엑셀파일로 대량 데이타 업로드시 사용 


//라이브러리 파일 

include_once(G5_LIB_PATH.'/Excel/reader.php');


//엑셀파일에 날짜형식 오류 방지 

$date = ($data->sheets[0]['cells'][$i][14] - 25569) * 86400;

$datetime = date("Y-m-d", $date);

<form name="fmemberexcel" method="post" action="./xls_update.php" enctype="MULTIPART/FORM-DATA" autocomplete="off">

<div id="excelfile_upload" style="margin:20px;">
	<label for="excelfile">파일선택</label>
	<input type="file" name="excelfile" id="excelfile">
</div>
<input type="submit" value="엑셀파일 등록" class="btn_submit">

</form>


<?php
set_time_limit ( 0 );
ini_set('memory_limit', '50M');

if(!$_FILES['excelfile']['tmp_name']) {
	alert("등록하실 파일이 없습니다");
}

if($_FILES['excelfile']['tmp_name']) {
    $file = $_FILES['excelfile']['tmp_name'];

    include_once(G5_LIB_PATH.'/Excel/reader.php');

    $data = new Spreadsheet_Excel_Reader();
    $data->setOutputEncoding('UTF-8');
    $data->read($file);

    error_reporting(E_ALL ^ E_NOTICE);


    for ($i = 3; $i <= $data->sheets[0]['numRows']; $i++) {

		$mb_id = $member['mb_id'];
		$wr_name = $member['mb_nick'];
		$wr_password = $member['mb_password'];
		$wr_email = $member['mb_email'];
		$wr_homepage = $member['mb_homepage'];
		
		$wr_num = get_next_num($write_table);
		$wr_reply = '';

		$wr_1 = addslashes($data->sheets[0]['cells'][$i][2]);
		$wr_2 = addslashes($data->sheets[0]['cells'][$i][3]);
		$wr_3 = addslashes($data->sheets[0]['cells'][$i][4]);
		$wr_4 = addslashes($data->sheets[0]['cells'][$i][5]);
		$wr_5 = addslashes($data->sheets[0]['cells'][$i][8]);
		$wr_6 = addslashes($data->sheets[0]['cells'][$i][9]);
		$wr_7 = addslashes($data->sheets[0]['cells'][$i][10]);
		$wr_8 = addslashes($data->sheets[0]['cells'][$i][11]);
		$wr_9 = addslashes($data->sheets[0]['cells'][$i][12]);
		$wr_10 = addslashes($data->sheets[0]['cells'][$i][13]);

		$date = ($data->sheets[0]['cells'][$i][14] - 25569) * 86400;
		$datetime = date("Y-m-d", $date);
			
		$sql = " insert into g5_write_companyinfo
                set wr_num = '$wr_num',
                     wr_reply = '$wr_reply',
                     wr_comment = 0,
                     ca_name = '$ca_name',
                     wr_option = '$html,$secret,$mail',
                     wr_subject = '$wr_subject',
                     wr_content = '$wr_content',
                     wr_link1 = '$wr_link1',
                     wr_link2 = '$wr_link2',
                     wr_link1_hit = 0,
                     wr_link2_hit = 0,
                     wr_hit = 0,
                     wr_good = 0,
                     wr_nogood = 0,
                     mb_id = '$mb_id',
                     wr_password = '$wr_password',
                     wr_name = '$wr_name',
                     wr_email = '$wr_email',
                     wr_homepage = '$wr_homepage',
                     wr_datetime = '".G5_TIME_YMDHIS."',
                     wr_last = '".G5_TIME_YMDHIS."',
                     wr_ip = '{$_SERVER['REMOTE_ADDR']}',
                     wr_1 = '$wr_1',
                     wr_2 = '$wr_2',
                     wr_3 = '$wr_3',
                     wr_4 = '$wr_4',
                     wr_5 = '$wr_5',
                     wr_6 = '$wr_6',
                     wr_7 = '$wr_7',
                     wr_8 = '$wr_8',
                     wr_9 = '$wr_9',
                     wr_10 = '$wr_10' ";
					
		sql_query($sql);
		
		$wr_id = sql_insert_id();
			
		// 부모 아이디에 UPDATE
		sql_query(" update g5_write_companyinfo set wr_parent = '$wr_id' where wr_id = '$wr_id' ");
	}
}
?>