±ÂµðÀÚÀλçÀÌÆ®
Áö½Äâ°í
°ü·Ã¼½Ä ÀÚ·á
Áö½Äâ°í
Ȩ > °í°´¼¾ÅÍ > Áö½Äâ°í
Ä«Å×°í¸®
Ç÷¡½Ã
Á¦¸ñ
DBÀÇ ³»¿ëÀ» PHP·Î ÆĽÌÀ» Çؼ xmlÆÄÀÏ·Î ÀúÀå
DBÀÇ ³»¿ëÀ» PHP·Î ÆĽÌÀ» Çؼ xmlÆÄÀÏ·Î ÀúÀå½ÃÅ°´Â ¹æ¹ýÀÌ ÀÖ½À´Ï´Ù.
¿¹Á¦·Î DB³»ÀÇ ³»¿ëÀÌ ¾Æ·¡¿Í °°´Ù¸é
+----------+------+------------+
| searchW | cnt | date |
+----------+------+------------+
| ½ÎÀÌ¿ùµå | 1784 | 2006-11-27 |
| ¾ßÈÄ | 709 | 2006-11-27 |
| ¿Á¼Ç | 643 | 2006-11-27 |
+----------+------+------------+
ÆĽ̽ÃÅ°´Â ¿¹Á¦¼Ò½º´Â ¾Æ·¡¿Í °°½À´Ï´Ù.
<?
##DB¿¬°á
$sql = "select * from table"; //DB¿¡¼ Á¤º¸°¡Á®¿À±â
$rs = mysql_query($sql);
while($result = mysql_fetch_array($rs)){
$searchW = $result[searchW];
$cnt = $result[cnt];
$date = $result[date];
//DB¿¡¼ °¡Á®¿Â Á¤º¸·Î Xml¹®¼ÀÇ Element¸¦ ±¸¼º
$xmlList.="<word><searchW>$searchW</searchW><cnt>$cnt</cnt>
<date>$date</date></word>";
}
mysql_free_result($rs);
//ÅëÇÕ XmlDocÀÇ ³»¿ëÀ» ±¸¼º
$xmlDoc="<?xml version='1.0' encoding='euc-kr'?> <root>$xmlList</root>";
//XmlDocÀÇ ³»¿ëÀ» °¡Áö°í xmlÆÄÀÏ »ý¼ºÇϱâ
$fp = fopen("test.xml","w");
fput($fp, $xmlDoc);
fclose($fp);
##DB¿¬°áÇØÁ¦
?>
±×·¸´Ù¸é ¸¸µé¾îÁø °á°ú¹° test.xmlÆÄÀÏÀº ¾Æ·¡¿Í °°Àº ³»¿ëÀÇ xmlÆÄÀÏÀÌ µÉ°Ì´Ï´Ù.
test.xml::
<root>
<word>
<searchW>½ÎÀÌ¿ùµå</searchW>
<cnt>1784</cnt>
<date>2006-11-27</date>
</word>
<word>
<searchW>¾ßÈÄ</searchW>
<cnt>709</cnt>
<date>2006-11-27</date>
</word>
<word>
<searchW>¿Á¼Ç</searchW>
<cnt>643</cnt>
<date>2006-11-27</date>
</word>
</root>
[Ãâó]
DB¿¡¼ ²¨³½ µ¥ÀÌÅ͸¦ PHP¸¦ ÀÌ¿ëÇØ XML·Î º¯È¯
÷ºÎÆÄÀÏ