header("Location: {$URL['login']}"); exit; } if (!$pn) { $pn = 1; } /* DB접속 */ $dbh = dbconnect(); $start_num = ($pn - 1) * $max_list; $end_num = $pn * $max_list; /* 전체 설문수 */ $query = "select count(poll_idx) from poll_data"; $sth = dbquery($dbh, $query); list($total_count) = dbselect($sth); /* 페이지 계산 */ list($pagelist, $page_count) = make_page_list("{$URL['list']}?m=list", $max_list, $total_count, $pn); $total_page = $page_count; $article_num = $total_count - $pn * $max_list + $max_list; print_header(); echo "\n<br>\n<script language=JavaScript>\nfunction result_window(idx)\n{\n\twindow.open('{$URL['result']}?m=view&idx='+idx, 'result','width=400,height=400,marginwidth=0,marginheight=0,resizable=1,scrollbars=1'); \n} \n</script>\n<table border=0 width=600 cellspacing=0 cellpadding=0>\n<tr width=100%>\n <td colspan=8 align=right><font size=2>\n 전체 : <font color=RED>{$total_count}</font> \n 현재페이지 : <font color=RED>{$pn} / {$total_page}</font>\n </font> \n </td>\n</tr>\n<tr><td align=right>\n<!--본문 테이블 시작 -->\n\n<table border=1 bordercolor=white bordercolorlight=silver cellpadding=2 cellspacing=0 width=100%>\n<tr bgcolor=#f6f6f6> \n <th width=30><font size=2>번호</font></th>\n <th><font size=2>제목</font></th>\n <th width=45><font size=2>문항수</font></th>\n <th width=80><font size=2>시작일</font></th>\n <th width=80><font size=2>종료일</font></th>\n <th width=85><font size=2>기타</font></th>\n</tr>\n"; /* 데이터 $max_list 만큼 뽑아서 @LIST_DATA 에 저장. */ $query = "select * from poll_data order by poll_idx desc limit {$start_num},{$max_list}"; $sth = dbquery($dbh, $query); $i = 0; while ($field = dbselect($sth)) { list($poll_idx, $question, $sdate, $edate, $status, $answer_no, $answer[1], $answer[2], $answer[3], $answer[4], $answer[5], $answer[6], $answer[7], $answer[8], $answer[9], $answer[10]) = $field; $answer_list = ""; for ($i = 1; $i <= $answer_no; $i++) { $answer_list .= "[{$i}]{$answer[$i]}\n"; } if ($status == 1) {
<?php /* 명함관리 (명함목록출력) 2001.06 by Jungjoon Oh */ print_header("명함 목록"); print_location_bar($location_bar); list($pagelist, $page_count) = make_page_list("{$URL['list']}?m={$m}&group={$group}&id={$id}&where={$where}&k={$keyword}", $max_list, $total_count, $pn); $total_page = $page_count; echo "\n<br>\n<table width=700 border=0 cellspacing=1 cellpadding=4 bgcolor=#FFFFFF align=center>\n <tr bgcolor=#FFFFFF width=100%>\n <td colspan=8 align=right><font size=2>\n <font color=BLUE>* 이름이나 회사명을 클릭하시면 자세한 내용을 볼수있습니다.</font> \n 전체 : <font color=RED>{$total_count}</font> \n 현재페이지 : <font color=RED>{$pn} / {$total_page}</font></font>\n </td>\n </tr>\n <tr bgcolor=#BBDDFF> \n <th><font size=2>번호</font></th>\n <th><font size=2>분류</font></th>\n <th><font size=2>이름</font></th>\n <th><font size=2>회사</font></th>\n <th><font size=2>부서</font></th>\n <th><font size=2>직함</font></th>\n <th><font size=2>전화</font></th>\n <th><font size=2>등록일</font></th>\n </tr>\n"; if (!$LIST_DATA) { echo "\n <tr bgcolor=#F0F0F0> \n <td colspan=8 align=center>\n <font size=2>등록된 데이터가 없습니다.</font>\n </td>\n </tr>\n"; } else { $article_num = $total_count - $pn * $max_list + $max_list; foreach ($LIST_DATA as $list) { list($nc_index, $nc_id, $nc_group, $nc_name, $nc_company, $nc_depart, $nc_title, $nc_tel, $nc_date, $nc_email) = explode("|", $list); if ($nc_email) { $nc_name = "<a href=\"mailto:{$nc_email}\">{$nc_name}</a>"; } echo "\n <tr bgcolor=#F0F0F0> \n <td align=center><font size=2>\n <a href=\"{$URL['read']}?m=read&idx={$nc_index}&{$from_string}\">\n {$article_num}</a></font></td>\n <td align=center><font size=2>{$GROUP_NAME[$nc_group]}</font></td>\n <td align=center><font size=2>{$nc_name}</font>\n </td>\n <td align=center><font size=2>\n <a href=\"{$URL['read']}?m=read&idx={$nc_index}&{$from_string}\">\n {$nc_company}</a></font>\n </td>\n <td align=center><font size=2>{$nc_depart}</font></td>\n <td align=center><font size=2>{$nc_title}</font></td>\n <td align=center><font size=2>{$nc_tel}</font></td>\n <td align=center><font size=2>{$nc_date}</font></td>\n </tr>\n"; // 글번호 하나씩 감소 $article_num--; } // foreach } echo "\n <tr bgcolor=#FFFFFF>\n <td colspan=8 align=center><font size=2>{$pagelist}</a>\n </td>\n </tr>\n <tr bgcolor=#FFFFFF>\n <td colspan=8 align=right><a href=\"{$URL['write_form']}\">\n {$BUTTON['write']}</a> \n </td>\n </tr>\n</table>\n<script language=JavaScript>\n<!--\nfunction checkForm(form)\n{\n\tif(form.k.value==''){\n\t\talert('검색어를 입력하세요. ');\n\t\tform.k.focus();\n\t\treturn false;\n\t}\n\treturn true;\n}\n//-->\n</script>\n\n<table width=700 align=center>\n<form action=\"{$URL['search']}\" method=GET name=f onSubmit=\"return checkForm(document.f);\">\n<tr><td colspan=2><hr size=1</td></tr>\n<tr><td width=30% align=right><font size=2><b>검 색 어:</b></font></td>\n <td width=70%>\n <input type=text name=k value=\"{$k}\" size=21 maxlength=20>\n\t<input type=submit value=\" 검색 \">\n\t<select name=\"group\">\n\t<option value=\"\">분류</option>\n\t<option value=1>기업</option>\n\t<option value=2>언론사</option>\n\t<option value=3>정계</option>\n\t<option value=4>학교</option>\n\t<option value=5>개인</option>\n\t<option value=9>기타</option>\n </td>\n</tr>\n<tr><td align=right><font size=2><b>검색대상:</b></font></td>\n <td><font size=2>\n <input type=radio name=where value=\"name\" checked>이름 \n <input type=radio name=where value=\"company\">회사명 \n <input type=radio name=where value=\"depart\">부서명 \n <input type=radio name=where value=\"title\">직함 \n <input type=radio name=where value=\"id\">등록자ID\n </font>\n </td>\n</tr>\n</form>\n</table>\n"; print_footer(); exit;
<?php /* 게시판 (글목록 출력) 2001.06 by Jungjoon Oh */ require $header; list($pagelist, $page_count) = make_page_list("{$URL[$from]}?m={$m}&db={$db}&{$from_string}", $max_list, $total_count, $pn); $total_page = $page_count; echo "\n<br>\n<table width=700 border=0 cellspacing=1 cellpadding=4 bgcolor=#FFFFFF align=center>\n <tr bgcolor=#FFFFFF width=100%>\n <td colspan=8 align=right><font size=2>\n 전체 : <font color=RED>{$total_count}</font> \n 현재페이지 : <font color=RED>{$pn} / {$total_page}</font></font>\n </td>\n </tr>\n <tr bgcolor=#BBDDFF> \n <th width=50><font size=2>번호</font></th>\n <th><font size=2>제목</font></th>\n <th width=100><font size=2>글쓴이</font></th>\n <th width=80><font size=2>날짜</font></th>\n <th width=50><font size=2>조회</font></th>\n </tr>\n"; if (!$LIST_DATA) { echo "\n <tr bgcolor=#F0F0F0> \n <td colspan=8 align=center>\n <font size=2>등록된 데이터가 없습니다.</font>\n </td>\n </tr>\n"; } else { $article_num = $total_count - $pn * $max_list + $max_list; foreach ($LIST_DATA as $list) { list($idx, $replynum, $name, $email, $hit, $date, $subject, $filename) = explode("|", $list); if ($email) { $name = "<a href=\"mailto:{$email}\">{$name}</a>"; } $subject_space = ""; if ($replynum > 1) { $subject_space .= " ☞"; } if ($filename) { $filelink = " {$BUTTON['disk']}"; } else { $filelink = ""; } if ($k) { if ($w == 'subject' || $w == 'both') { $subject = ereg_replace($k, "<font color=RED><b>{$k}</b></font>", $subject);