• ÇÁ¸®Ä«¿îÅÍ
  • Ç÷¡½ÃºÏ
  • ÇÁ¸®º¸µå
  • Àü±¤ÆÇ
  • À¥°øºÎ¹æ
  • Ä¿¹Â´ÏƼ
[php] ¿¢¼¿ÆÄÀÏÀ» php·Î º¯È¯ 2008.04.17 10:40
±Û¾´ÀÌ : ¿î¿µÀÚ Á¶È¸ : 345 Ãßõ : 0

http://www.codeplex.com/PHPExcel/

 

<?
require_once("../class/errorCode.php");
require_once("../class/mysqlDbConn.php");//db Á¢¼Ó
require_once 'Excel/reader.php';
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('euc-kr'); // À̺κи¸ ¹Ù²å½À´Ï´Ù.
$data->read('test.XLS');

error_reporting(E_ALL ^ E_NOTICE);
$f_arr = array("","no","title","c_quarter","control","start_date","end_date","ext1","ext2","cont","readnum","control2");//ÇÊµå ¹è¿­
for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
 if($i != 1){//¿¢¼¿ÆÄÀÏÀÇ Ã¹ÁÙÀº ÇÊµå µ¥ÀÌÅ͵éÀÌ ¾Æ´Ñ Ä÷³¸íÀ¸·Î µÇ¾î À̺κÐÀº ±×³É continuÇϵµ·Ï Çϱâ À§ÇÑ Á¶°Ç ÀÔ´Ï´Ù.
     ${'data'.$i} = "";
     for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
            if($j == 1){//Äõ¸®ÀÇ Ã³À½ ºÎºÐ¿¡´Â ,¸¦ »©±âÀ§ÇÑ Á¸°Ç ÀÔ´Ï´Ù.
                $chumbu = "";
            }else{
                $chumbu = ",";
            }
            ${'data'.$i} .= $chumbu." ".$f_arr[$j]." = '".$data->sheets[0]['cells'][$i][$j]."'";//º¯¼ö¿¡ ÀúÀåÇÒ table field ¸íÀ» ³Ö½À´Ï´Ù.
     }
     mysql_query("insert into study_work set ".${'data'.$i});//mysql excute
 }
}
echo "<script>alert('end');</script>";exit;
?>

ÀλýÀº ª½À´Ï´Ù.
±×·¯¹Ç·Î ´Ù¸¥ »ç¶÷ÀÌ ¿ä±¸ÇÏ´Â »îÀ» »ì¸é¼­ ½Ã°£À» ³¶ºñÇؼ­´Â ¾È µË´Ï´Ù.
µ·°ú ¸í¿¹¸¦ ¾òÁö ¸øÇÏ´õ¶óµµ ³¡±îÁö ÀÚ½ÅÀÇ ±æÀ» °íÁýÇϽʽÿÀ
¸ñ·Ï À­±Û ¾Æ·§±Û
³»¾Ë FREECOUNT.NET ÇÁÄ«³Ý »ý±ä³¯ 2003.12.20 Ȩ | Ä«¿îÅÍ | Ç÷¡½ÃºÏ | ÇÁ¸®º¸µå | Àü±¤ÆÇ | À¥°øºÎ¹æ | Ä¿¹Â´ÏƼ | ÂÊÁöÇÔ