list.skin.php 를 문서 양식처럼 표현하기(3차배열식) 정보
list.skin.php 를 문서 양식처럼 표현하기(3차배열식)관련링크
http://
265회 연결
본문
보통 list.skin.php 에 응용하심 좋을듯 하구요..
게시판 필드의 분류를....게시판에 직접 적용한 예) 입니다.
가령.. 게시판 화면을.. 일반 멀티형 텍스트 형태로 뿌려줄 경우에 사용하거둥요.
php5로 하면 깔꿈하게 처리 되는데..제가 php4는 좀 미숙하다보니 소스가 길어졌어요..
--------------------------------------------------------------
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
$colspan = 8; // colspan part
//call year start 01
/*
$site_cf[g4_site_bill] = "g4_site_bill"; // site bill basic table
$board_table[bo_table] = "g4_write_$bo_table"; // $bo_table
//->year
$mct = " where po_poll1 = 'year' "; // pro... call year
$view_show = "order by po_poll2 desc"; // view list
$g4_site_sql = " select po_id,po_poll2, po_subject from $site_cf[g4_site_bill] $mct $view_show "; //small speed
$g4_site_result = sql_query($g4_site_sql); // query, php4 cf, after update cat_all setting is php5
$year_count = mysql_num_rows($g4_site_result); // using count
//->year
*/
{?>
<form name="fboardlist" method="post" style="margin:0px;">
<input type='hidden' name='bo_table' value='<?=$bo_table?>'>
<input type='hidden' name='sfl' value='<?=$sfl?>'>
<input type='hidden' name='stx' value='<?=$stx?>'>
<input type='hidden' name='spt' value='<?=$spt?>'>
<input type='hidden' name='page' value='<?=$page?>'>
<input type='hidden' name='sw' value=''>
<?}
// 1단계: 게시판에 등록된경우만 호출, 즉 년도별 고유아이디 호출
$site_cf[g4_site_bill] = "g4_site_bill"; // site bill basic table
$board_table[bo_table] = "g4_write_$bo_table"; // $bo_table
$view_show = "group by wr_1"; // view list
$g4_site_sql = " select wr_1 from $board_table[bo_table] $view_show "; //small speed
$g4_site_result = sql_query($g4_site_sql); // query, php4 cf, after update cat_all setting is php5
$year_count = mysql_num_rows($g4_site_result); // using count
while ($sub_row= sql_fetch_array($g4_site_result)){
$mct = " where po_id = '$sub_row[wr_1]' "; // pro... call year
$view_show = "order by po_poll2 asc"; // view list
$g4_site_sql = " select * from $site_cf[g4_site_bill] $mct "; //small speed
$g4_basic_result = sql_query($g4_site_sql); // query, php4 cf, after update cat_all setting is php5
$year_count = mysql_num_rows($g4_site_result); // using count
//->year
//->year
//year html start 02
while ($row= sql_fetch_array($g4_basic_result)){ // 1 category, year view
// roof [while] ==>> call part start 03
//->part
// 2단계: 즉, 1단계검색으로 년도별 자료중, 단원별 자료가 있는경우만 검색
// 게시판의 wr_2 의 그릅으로 정리한다.
$view_wr_2 = "group by wr_2 asc"; // view list
$g4_site_sql_wr_2 = " select wr_2 from $board_table[bo_table] $view_wr_2 "; //small speed
$g4_site_result_wr_2 = sql_query($g4_site_sql_wr_2); // query, php4 cf, after update cat_all setting is php5
$year_count_wr_2 = mysql_num_rows($g4_site_result_wr_2); // using count
//->part
{?><tr><td height="32" colspan="<?=$colspan?>"> <b><font color="#0C21AB"><?=$row[po_subject]?></font></b></td><tr><?}
while ($part_wr_2= sql_fetch_array($g4_site_result_wr_2)){
//검색
$mct = " po_poll2 = '$row[po_poll2]' "; // pro... call part
$mct .= " and po_id = '$part_wr_2[wr_2]' ";
$g4_site_sql = " select po_id, po_subject from $site_cf[g4_site_bill] where $mct order by po_id "; //match call wr_2
$g4_board_result = sql_query($g4_site_sql); // query, php4 cf, after update cat_all setting is php5
$part_count = mysql_num_rows($g4_board_result); // using count
while ($part= sql_fetch_array($g4_board_result)){
$mct = " where wr_1 = '$row[po_id]' ";
$mct .= " and wr_2 = '$part[po_id]' ";
$view_show = "order by wr_3 desc "; // view list
$g4_write_sql = " select * from $board_table[bo_table] $mct $view_show ";
$g4_write_result = sql_query($g4_write_sql);
$write_list = array();
$write_count = mysql_num_rows($g4_write_result); // using count
{?><tr>
<td width="85" rowspan="<?=$write_count?>"><font color="#3543A2">
<?=$part[po_subject]?>
</font></td><?}
for($i=0; $i<$write_count;$i++){
$write_list = sql_fetch_array($g4_write_result);
if($i>0){// roop not zero
echo '<tr>';
}
{?>
<td width="35" align="center">
<?=$write_list[wr_3]?>회</td>
<td width="180" align="LEFT">
<? if ($member[mb_level] >= 5){?>
<a href="javascript://" onclick="window.open('<?=$board_skin_path?>/movie.php?bo_table=<?=$bo_table?>&wr_id=<?=$write_list[wr_id]?>', '', 'scrollbars=no,resizeable=no,toolbar=no,status=no,top=0,left=100,width=810,height=557');" title='동영상보기'>
<?=$write_list[wr_subject]?>
</a>
<?}
if ($member[mb_level] < 5){?>
<a href="./board.php?bo_table=<?=$bo_table?>&zqq=1">
<?=$write_list[wr_subject]?>
</a>
<?}
?>
</td>
<td width="60" align="center"><font color="#8391CD"><?=$write_list[wr_4]?>분</font></td>
<td width="60" align="center">
<?
if(!$write_list[wr_5]){
echo ' ';
}
else{
echo $write_list[wr_5];
echo 'M';
}
?>
</td>
<td width="70" align=center>
<?
if(!$write_list[wr_6]){
echo ' ';
}
else{
echo $write_list[wr_6];
echo 'M';
}
?>
</td>
<td align=center>
<? if ($is_admin) { ?> <input type=checkbox name=chk_wr_id[] value="<?=$write_list[wr_id]?>"><?}?>
<?
// 가변 파일
$cnt = 0;
$m_img = "<img src='{$board_skin_path}/img/noimg.gif' border=0>";
echo "<a href=\"javascript:file_download('../data/movi/mp3/{$write_list[wr_7]}', '{$write[wr_link1]}');\" title='{$view[file][$i][content]}'>{$m_img}</a>";
if ($member[mb_id]) {
$scrap_href = "../shop/move_update.php?bo_table=$bo_table&wr_id=$write_list[wr_id]";
}
echo "<a href=\"javascript:;\" onclick=\"win_scrap('$scrap_href');\"><img src='$board_skin_path/img/btn_move_all.gif' border='0' align='absmiddle'></a> ";
?>
<?}
}
}
}}
}
// roof [while] ==>> call part end 03
//year html end 02
// call year end 01
?>
</form>
<? if ($member[mb_level] >= 5){?>
<script language="JavaScript">
function file_download(link, file) {
<? if ($board[bo_download_point] < 0) { ?>if (confirm("파일을 다운받은상태에서 다른사람에게 공개하시며 .\n\n저작권 침해가 발생합니다..\n\n 좋은 정보를 제공하도록 하겠습니다."))<?}?>
document.location.href=link;
}
</script>
<?}
else{?>
<script language="JavaScript">
function file_download(link, file) {
$msg = "유료회원에게만 제공합니다.\n\n 로그인후 이용해주세요 ";
alert($msg, "./board.php?bo_table=$bo_table");
}
</script>
<?}
?>
게시판 필드의 분류를....게시판에 직접 적용한 예) 입니다.
가령.. 게시판 화면을.. 일반 멀티형 텍스트 형태로 뿌려줄 경우에 사용하거둥요.
php5로 하면 깔꿈하게 처리 되는데..제가 php4는 좀 미숙하다보니 소스가 길어졌어요..
--------------------------------------------------------------
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
$colspan = 8; // colspan part
//call year start 01
/*
$site_cf[g4_site_bill] = "g4_site_bill"; // site bill basic table
$board_table[bo_table] = "g4_write_$bo_table"; // $bo_table
//->year
$mct = " where po_poll1 = 'year' "; // pro... call year
$view_show = "order by po_poll2 desc"; // view list
$g4_site_sql = " select po_id,po_poll2, po_subject from $site_cf[g4_site_bill] $mct $view_show "; //small speed
$g4_site_result = sql_query($g4_site_sql); // query, php4 cf, after update cat_all setting is php5
$year_count = mysql_num_rows($g4_site_result); // using count
//->year
*/
{?>
<form name="fboardlist" method="post" style="margin:0px;">
<input type='hidden' name='bo_table' value='<?=$bo_table?>'>
<input type='hidden' name='sfl' value='<?=$sfl?>'>
<input type='hidden' name='stx' value='<?=$stx?>'>
<input type='hidden' name='spt' value='<?=$spt?>'>
<input type='hidden' name='page' value='<?=$page?>'>
<input type='hidden' name='sw' value=''>
<?}
// 1단계: 게시판에 등록된경우만 호출, 즉 년도별 고유아이디 호출
$site_cf[g4_site_bill] = "g4_site_bill"; // site bill basic table
$board_table[bo_table] = "g4_write_$bo_table"; // $bo_table
$view_show = "group by wr_1"; // view list
$g4_site_sql = " select wr_1 from $board_table[bo_table] $view_show "; //small speed
$g4_site_result = sql_query($g4_site_sql); // query, php4 cf, after update cat_all setting is php5
$year_count = mysql_num_rows($g4_site_result); // using count
while ($sub_row= sql_fetch_array($g4_site_result)){
$mct = " where po_id = '$sub_row[wr_1]' "; // pro... call year
$view_show = "order by po_poll2 asc"; // view list
$g4_site_sql = " select * from $site_cf[g4_site_bill] $mct "; //small speed
$g4_basic_result = sql_query($g4_site_sql); // query, php4 cf, after update cat_all setting is php5
$year_count = mysql_num_rows($g4_site_result); // using count
//->year
//->year
//year html start 02
while ($row= sql_fetch_array($g4_basic_result)){ // 1 category, year view
// roof [while] ==>> call part start 03
//->part
// 2단계: 즉, 1단계검색으로 년도별 자료중, 단원별 자료가 있는경우만 검색
// 게시판의 wr_2 의 그릅으로 정리한다.
$view_wr_2 = "group by wr_2 asc"; // view list
$g4_site_sql_wr_2 = " select wr_2 from $board_table[bo_table] $view_wr_2 "; //small speed
$g4_site_result_wr_2 = sql_query($g4_site_sql_wr_2); // query, php4 cf, after update cat_all setting is php5
$year_count_wr_2 = mysql_num_rows($g4_site_result_wr_2); // using count
//->part
{?><tr><td height="32" colspan="<?=$colspan?>"> <b><font color="#0C21AB"><?=$row[po_subject]?></font></b></td><tr><?}
while ($part_wr_2= sql_fetch_array($g4_site_result_wr_2)){
//검색
$mct = " po_poll2 = '$row[po_poll2]' "; // pro... call part
$mct .= " and po_id = '$part_wr_2[wr_2]' ";
$g4_site_sql = " select po_id, po_subject from $site_cf[g4_site_bill] where $mct order by po_id "; //match call wr_2
$g4_board_result = sql_query($g4_site_sql); // query, php4 cf, after update cat_all setting is php5
$part_count = mysql_num_rows($g4_board_result); // using count
while ($part= sql_fetch_array($g4_board_result)){
$mct = " where wr_1 = '$row[po_id]' ";
$mct .= " and wr_2 = '$part[po_id]' ";
$view_show = "order by wr_3 desc "; // view list
$g4_write_sql = " select * from $board_table[bo_table] $mct $view_show ";
$g4_write_result = sql_query($g4_write_sql);
$write_list = array();
$write_count = mysql_num_rows($g4_write_result); // using count
{?><tr>
<td width="85" rowspan="<?=$write_count?>"><font color="#3543A2">
<?=$part[po_subject]?>
</font></td><?}
for($i=0; $i<$write_count;$i++){
$write_list = sql_fetch_array($g4_write_result);
if($i>0){// roop not zero
echo '<tr>';
}
{?>
<td width="35" align="center">
<?=$write_list[wr_3]?>회</td>
<td width="180" align="LEFT">
<? if ($member[mb_level] >= 5){?>
<a href="javascript://" onclick="window.open('<?=$board_skin_path?>/movie.php?bo_table=<?=$bo_table?>&wr_id=<?=$write_list[wr_id]?>', '', 'scrollbars=no,resizeable=no,toolbar=no,status=no,top=0,left=100,width=810,height=557');" title='동영상보기'>
<?=$write_list[wr_subject]?>
</a>
<?}
if ($member[mb_level] < 5){?>
<a href="./board.php?bo_table=<?=$bo_table?>&zqq=1">
<?=$write_list[wr_subject]?>
</a>
<?}
?>
</td>
<td width="60" align="center"><font color="#8391CD"><?=$write_list[wr_4]?>분</font></td>
<td width="60" align="center">
<?
if(!$write_list[wr_5]){
echo ' ';
}
else{
echo $write_list[wr_5];
echo 'M';
}
?>
</td>
<td width="70" align=center>
<?
if(!$write_list[wr_6]){
echo ' ';
}
else{
echo $write_list[wr_6];
echo 'M';
}
?>
</td>
<td align=center>
<? if ($is_admin) { ?> <input type=checkbox name=chk_wr_id[] value="<?=$write_list[wr_id]?>"><?}?>
<?
// 가변 파일
$cnt = 0;
$m_img = "<img src='{$board_skin_path}/img/noimg.gif' border=0>";
echo "<a href=\"javascript:file_download('../data/movi/mp3/{$write_list[wr_7]}', '{$write[wr_link1]}');\" title='{$view[file][$i][content]}'>{$m_img}</a>";
if ($member[mb_id]) {
$scrap_href = "../shop/move_update.php?bo_table=$bo_table&wr_id=$write_list[wr_id]";
}
echo "<a href=\"javascript:;\" onclick=\"win_scrap('$scrap_href');\"><img src='$board_skin_path/img/btn_move_all.gif' border='0' align='absmiddle'></a> ";
?>
<?}
}
}
}}
}
// roof [while] ==>> call part end 03
//year html end 02
// call year end 01
?>
</form>
<? if ($member[mb_level] >= 5){?>
<script language="JavaScript">
function file_download(link, file) {
<? if ($board[bo_download_point] < 0) { ?>if (confirm("파일을 다운받은상태에서 다른사람에게 공개하시며 .\n\n저작권 침해가 발생합니다..\n\n 좋은 정보를 제공하도록 하겠습니다."))<?}?>
document.location.href=link;
}
</script>
<?}
else{?>
<script language="JavaScript">
function file_download(link, file) {
$msg = "유료회원에게만 제공합니다.\n\n 로그인후 이용해주세요 ";
alert($msg, "./board.php?bo_table=$bo_table");
}
</script>
<?}
?>
추천
0
0
댓글 0개