Ãâó: http://cafe.naver.com/q69/7015
¿¢¼¿ÀÇ µ¥ÀÌŸ´Â .xls¶ó´Â È®ÀåÀÚÀÌ´Ù º¸Åë ¿¢¼¿¿¡¼ ·ÎµùÀ» ÇÑÈÄ ´Ù¸¥À̸§À¸·Î ÀúÀå½Ã ÅÇÀ¸·Î ºÐ¸®µÇ´Â txt¿Í ÄÞ¸¶·Î ºÐ¸®µÇ´Â csvÆÄÀÏ·Î ÀúÀåÇÒ ¼ö ÀÖ´Ù.
µÑ´Ù °ð¹Ù·Î mysql¿¡´Â load¹®À¸·Î ÀÔ·ÂÇÒ¼öÀÖ´Ù ´ç¿¬È÷ table±¸Á¶µµ ¿¢¼¿±¸Á¶¿Í °°¾Æ¾ß ÇÑ´Ù. ÇÏÁö¸¸ °ð¹Ù·Î ³Ö±âÀü¿¡ ¾à°£ÀÇ °¡°øÀÌ ÇÊ¿äÇÏ´Ù¸é Áß°£¿¡ php½ºÅ©¸³Æ®·Î 󸮸¦ Çؼ sqlÆÄÀÏ·Î ¸¸µé¾î¼ º¹¿øÇÏ´Â°Ô ÁÁ´Ù.
±×¸®°í ¹Ý´ë·Î mysql¿¡¼ ¿¢¼¿·ÎÀÇ ¹æ¹ýµµ ¿©·¯°¡ÁöÀÌ´Ù.
µ¥ÀÌŸ¸¦ »Ì¾Æ³»¼ tableÀ» ¸¸µé¾î »ó´Ü¿¡ ¿¢¼¿´Ù¿îÇØ´õ¸¦ Ãß°¡Çؼ ´Ù¿îÀ» ¹Þ°Ô Çϴ¹æ¹ý°ú
ex)»ó´Ü¿¡ ´ÙÀ½ÀÇ ¼Ò½º¸¦ ±â¼úÇϸç filenameºÎºÐÀ» filename.xls(¿¢¼¿) filename.txt(ÅؽºÆ®ÆÄÀÏ)
filename.cvs(cvsÆÄÀÏ)·Î ¿øÇÏ´Â ´Ù¿î ÆÄÀÏ·Î ¹Ù²ÛÈÄ
¿¢¼¿ex) ÅÇÀ¸·Î ³ª´®
header( "Content-type: application/vnd.ms-excel; charset=ks_c_5601-1987" );
header( "Content-Disposition: attachment; filename=leejunsik.xls" );
header( "Content-Description: PHP4 Generated Data" );
echo "atatatatarn";
echo "atatatatarn";
cvs ex) YÇ¥·Î ³ª´®(,)
header( "Content-type: application/vnd.ms-excel; charset=ks_c_5601-1987" );
header( "Content-Disposition: attachment; filename=leejunsik.cvs" );
header( "Content-Description: PHP4 Generated Data" );
echo "a,a,a,a,arn";
echo "a,a,a,a,arn";
txt ex) ÅÇÀ¸·Î ³ª´®
header( "Content-type: application/vnd.ms-excel; charset=ks_c_5601-1987" );
header( "Content-Disposition: attachment; filename=leejunsik.txt" );
header( "Content-Description: PHP4 Generated Data" );
echo "atatatatarn";
echo "atatatatarn";
mysqlµ¥ÀÌŸ¸¦ »Ì¾Æ³»¼ ÆÄÀÏ¿¡ tabÀ¸·Î ³ª´©¸é¼ ÆÄÀÏ¿¡ ½á¼ txt·Î ÀúÀåÇϰųª ,·Î ºÐ¸®Çؼ ÆÄÀÏ¿¡ ÀúÀåÇÏ¿© scv·Î ¸¸µé¾î¼ ¿¢¼¿¿¡¼ ·ÎµùÇصµ µÈ´Ù.
¿¢¼¿_htmlÇü½ÄÀ¸·Î ex)html¹®¹ý »ç¿ë
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=leejunsik.xls");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
header("Pragma: public");
?>
¼ø¹ø À̸§ °ª
001 ¼ø½Å ³ë·®ÇØÀü
¹æ¹ý1
$srcfn = "dat.txt";
$linebuf = file($srcfn);
//ÆÄÀÏÀÇ ³»¿ëÀ» ¹è¿·Î n´ÜÀ§·Î Àß¶ó¼ ´ëÀÔÇÑ´Ù.(ÁÁÀºÇÔ¼ö)
$fp = fopen("insert.sql","w");
//¾²±â ¸ðµå·Î ¾øÀ¸¸é ¸¸µé¸ç ÀÖÀ¸¸é µ¤¾î¾¯¿î´Ù.
for($i=0;$i
$tok = explode("t",$linebuf[$i]);
$aaa=trim($tok[0]);
//ºó°ø°£Á¦°Å
$bbb=trim(ereg_replace(",","", $tok[1]));
//ºó°ø°£Á¦°Å¿Í,Á¦°Å
...
$ccc=trim($tok[7]);
$query = "INSERT INTO table (aaa, bbb, ..., ccc) VALUES ($aaa, '$bbb', ..., '$ccc');";
fputs($fp,$query,strlen($query));
fputs($fp,"n",strlen("n"));
//ÀԷ½à ¿£Å͸¦ Áà¾ß ÁٹٲÞÀ» ÇÑ´Ù.
}
fclose($fp);
¹æ¹ý2
$file = "°æ·Î/ÆÄÀÏ.csv";
$fp = fopen($file,"r");
$data = "";
while($buffer = fread($fp,4096)) $data .= $buffer;
$rows = explode("n",$data); // ÇÑÁÙ¾¿ ³ª´²¼ ¹è¿¿¡ ÀúÀå
for($i=0; $i
$field = explode(",",$rows[$i]);
$sql = "insert into table values('$field[0]', '$field[1]', '$field[2]', '$field[3]')";
mysql_query($sql);
}
¹æ¹ý3
csv¸¦ ÀÌ¿ëÇÏ´Â °ÍÀº ƯÁ¤ ¸ñ·ÏÀ» PHP¿¡¼ ºÒ·¯´Ù°¡ ÀνÄÇÏ¿© ó¸®ÇϱⰡ ÆíÇϱ⠶§¹®ÀÔ´Ï´Ù.
csv ÆÄÀÏÀ» ¿¾îº¸¸é ·¹Äڵ尡 ÁÙº°·Î ³ª´©¾îÁö°í ÇÑ ÇàÀº ,(ÄÞ¸¶)¸¦ ±âÁØÀ¸·Î Çʵ尡 ³ª´©¾î¼ ÀúÀåÀÌ µË´Ï´Ù.
a, 1, 1, 1
b, 2, 2, 2
c, 3, 3, 3
À§¿Í °°ÀÌ ÀúÀåÀÌ µÈ csv ÆÄÀÏÀÌ ÀÖ´Ù¸é ÀÌ°ÍÀ» php¿¡¼´Â fopen()ÇÔ¼ö¸¦ ÀÌ¿ëÇÏ¿© ºÒ·¯µéÀÔ´Ï´Ù.
$file = "°æ·Î/ÆÄÀÏ.csv";
$fp = fopen($file,"r");
$data = "";
while($buffer = fread($fp,4096)) $data .= $buffer; //¸ðµçÀÚ·á¹Þ¾Æ¿È
$rows = explode("n",$data); // ÇÑÁÙ¾¿ ³ª´²¼ ¹è¿¿¡ ÀúÀå
for($i=0; $i
$field = explode(",",$rows[$i]);
$sql = "insert into table values('$field[0]', '$field[1]', '$field[2]', '$field[3]')";
mysql_query($sql);
}
file ÇÔ¼ö·Î ÀÌ¿ëÇϽøé Æí¸®ÇÕ´Ï´Ù.
¿¹)
while ($line = file($file)) {
$value = str_replace(",","','",$line);
$sql = "insert into table values('".$value."')";
mysql_query($sql);
}
**csvº¸´Ù´Â txtÆÄÀÏÀÌ ÁÁÀºÀÌÀ¯´Â ´Ü¾î Áß¿¡ , °¡ µé¾îÀÖÀ¸¸é ±×°Íµµ ºÐ¸®°¡ µÇ¼ ¿¡·¯°¡ ³¯°¡¸Á¼ºµµ ÀÖ´Ù. txtÆÄÀÏ¿¡¼ÀÇ ÅÇ(t)Àº º¸Åë ÀÔ·ÂÀ» ¾ÈÇϹǷΠÀ§¿¡ ¿À·ù°¡ ÀϾ È®·üÀÌ Àû´Ù.
[Ãâó] ¿¢¼¿°ú mysqlÀÇ µ¥ÀÌÅÍÀ̵¿|ÀÛ¼ºÀÚ ¹ÚÈñ¿µ
|