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;
?>