엑셀파싱관련질문드려요~ 정보
엑셀파싱관련질문드려요~
본문
안녕하세요 영카트카테고리의상품을
html코드로 엑셀파일로뽑고싶은데 방법을잘모르겠습니다.
<?
$g4_path = "..";
include_once($g4_path."/common.php");
$g4[title] = "$row[it_name] ($it_id)";
echo $imagefile;
$query=mysql_query("select *from yc4_item where ca_id='101020'");
while($row=mysql_fetch_array($query)){
$cnt = 0;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l1")) $cnt++;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l2")) $cnt++;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l3")) $cnt++;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l4")) $cnt++;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l5")) $cnt++;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l6")) $cnt++;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l7")) $cnt++;
echo "
<table width='800' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr>
<td valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td><img src='http://superface.cafe24.com/open/title.jpg' /></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td height='10'></td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>1</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>2</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>3</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>4</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>5</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>6</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>7</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td height='10'></td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'>
";
for ($i=1; $i<=$cnt; $i++)
{
echo "
<table width='600' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td>";
echo "<img src='http://superface.cafe24.com/data/item/".$row[it_id]."_l{$i} ' width='600' height='600' style='border:1 solid #E4E4E4; margin-bottom:10px; '>";
echo "
</td>
</tr>
</table>
";
}
echo " </td>
</tr>
<tr>
<td><img src='http://superface.cafe24.com/open/br_size.gif' /></td>
</tr>
</table></td>
</tr>
</table>
//////////////
";
}
?>
어떤식으로추가를해야할지 팁좀주세요~
html코드로 엑셀파일로뽑고싶은데 방법을잘모르겠습니다.
<?
$g4_path = "..";
include_once($g4_path."/common.php");
$g4[title] = "$row[it_name] ($it_id)";
echo $imagefile;
$query=mysql_query("select *from yc4_item where ca_id='101020'");
while($row=mysql_fetch_array($query)){
$cnt = 0;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l1")) $cnt++;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l2")) $cnt++;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l3")) $cnt++;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l4")) $cnt++;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l5")) $cnt++;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l6")) $cnt++;
if (file_exists($g4[path]."/data/item/".$row['it_id'] . "_l7")) $cnt++;
echo "
<table width='800' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr>
<td valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td><img src='http://superface.cafe24.com/open/title.jpg' /></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td height='10'></td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>1</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>2</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>3</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>4</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>5</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>6</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td>7</td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'><table width='800' border='0' cellpadding='0' cellspacing='0'>
<tr valign='top'>
<td height='10'></td>
</tr>
</table></td>
</tr>
<tr>
<td align='center' valign='top'>
";
for ($i=1; $i<=$cnt; $i++)
{
echo "
<table width='600' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td>";
echo "<img src='http://superface.cafe24.com/data/item/".$row[it_id]."_l{$i} ' width='600' height='600' style='border:1 solid #E4E4E4; margin-bottom:10px; '>";
echo "
</td>
</tr>
</table>
";
}
echo " </td>
</tr>
<tr>
<td><img src='http://superface.cafe24.com/open/br_size.gif' /></td>
</tr>
</table></td>
</tr>
</table>
//////////////
";
}
?>
어떤식으로추가를해야할지 팁좀주세요~
댓글 전체