묻고답하기

  2. Support
  3. 묻고답하기

php관련 질문드립니다...답변 부탁드리요!

2004.02.20 16:16

Yup2.com

어렵게 질문 드립니다...
고수분들의 답변 부탁드려요..

아래에 보시면 원본 소스입니다...
제로보드를 이용해서 db는 구성되었고요..

다름이 아니라...
전체 회원들은 모두 표시가 됩니다..
그런데...
몇명 즉 원하는 회원들만 표시 할 수 있는 방법이 있는지.. (exDB의 NO값이 있는데. NO가 10에서 20 사이의 회원면 표시한다듯지.. 아니면 특정값이 얼마 이상일때만 표시한다든지..)

어떻게 하면 그런 함수를 넣어서 만들수 있을까요??

PHP초보라서 아래 소스도 여러개를 보고 만든거라서... 잘 모르겠네요...

제발 부탁드립니다....꼭 답변 부탁드립니다...

======================================= >>>원본소스

<?
require "lib.php";
if(!$connect) $connect = dbconn();
$View_Level="10"; // 최소레벨지정
$memoNum="5"; // 한페이지당 출력될 목록의 수
$pageNum="26"; // 페이지의 수
$admin_id="rockbug"; // 목록보기에서 제외시킬 아이디

// 최소레벨 이하회원 접근금지
if(!$member) $member = member_info();
if($member[level]>$View_Level) Error("로그인후 사용하세요.");

// 전체회원 계산
$tot_list=mysql_fetch_array(mysql_query("select count(*) from zetyx_member_table"));
$total_list=$tot_list[0];

?>
<html>

<body>
<center><p><Br>
<table cellpadding="0" cellspacing="0" width="640">
    <tr>
        <td width="640">

        </td>
    </tr>
</table>
<table cellpadding="0" cellspacing="0" width="640" height="1">
    <tr>
        <td width="640" height="5">
            <p><span style="font-size:1pt;">                         </span>
</p>
        </td>
    </tr>
</table>
<?
            $connect=dbconn();
            if(!$member_view) $member_view = 1;
            if($key){
            $key=addslashes($key);
            $s_que=" name like '%$key%'";
            $key=stripslashes($key);
            }
            if($key&&$admin_id) $s_que.=" or";

            if($admin_id) {
                $s_que.=" user_id not like '$admin_id'";
            }

            if($s_que) $s_que="where ".$s_que;

            $temp=mysql_fetch_array(mysql_query("select count(*) from $member_table"));
            $total=$temp["count(*)"];
            if(!$page) $page=1;
            $startNum=20;
            $totalpage=(int)(($total-1)/$memoNum)+1;
            $point_list="user_id";  
                
            $result=mysql_query("select * from $member_table $s_que order by $point_list asc limit $startNum, $memoNum");

?>
               <?
                        
                $num=$startNum+1;

                                while($data=mysql_fetch_array($result))
                {
                                
                unset($temp);
$img_width = 100;
$img_height = 100;
$bbs_width = 100;
$bbs_height = 100;
                    $no=$data[no];    
                  
                    if ($data[picture]) { $pic=stripslashes($data[picture]);
                                        $img_name =$data[picture];
                                        $temp=@GetImageSize($img_name);
                    if($temp[0] > $bbs_width) {
                    $ratio=$bbs_width/$temp[0];
                    $img_width=$temp[0]*$ratio;
                    $img_height=$temp[1]*$ratio;
                    }
                    else {
                     $img_width = $temp[0]; // 지정된 크기보다 작을경우 원사이즈대로 출력
                     $img_height = $temp[1];
                          }}

                    else {$pic="../image/m1.gif";}
                        

if ($img_height>100) {
      $ratio=100/$temp[1];
      $img_width=$temp[0]*$ratio;
      $img_height=$temp[1]*$ratio;
      }  

                    $email=stripslashes($data[email]);
                    $juso=stripslashes($data[home_address]);
                    $name=stripslashes($data[name]);
                                        $sd=stripslashes($data[irq]);
                                        $hp=stripslashes($data[handphone]);
                                        $tel=stripslashes($data[home_tel]);
                                        $fax=stripslashes($data[office_tel]);
                                        $job=stripslashes($data[job]);
                                        $id=stripslashes($data[user_id]);
                                        


                ?>

                                
                                
<table cellpadding="0" cellspacing="0" width="640">

    <tr>
        <td width="640" background="../image/ex_menu_bg.jpg">
            <table align="center" cellpadding="0" cellspacing="0" width="640" bgcolor="white" border="0" height="174" namo_layoutbox="10,1,1,10,1,1">
                <tr>
                    <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    <td width="118" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    <td width="259" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    <td width="259" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                </tr>
                    <tr>
                    <td width="1" height="34" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    <td width="118" rowspan="9" height="172" namo_textbox="0,0,0,0,0,0,0,0,0,0">

                        <p align="center">
<img src="<?=$pic?>" width=110 height=140 border="0">
                                                                                                                        
                                                                                                                                                
                        
                                                                                                                                                
                                                                                                                                                
                        
                        
                        <td width="1" height="34" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="259" height="34" namo_textbox="0,0,0,0,0,0,0,0,0,0">
                        <p align="left"><b><font color="black"> 이름 : </font></b><font color="black"><left><?=$name?></left> (</font><font color="black"><left><?=$id?></left>)</font></p>
                    </td>
                        <td width="1" height="34" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="259" height="34" namo_textbox="0,0,0,0,0,0,0,0,0,0">
                        <p align="left"><b><font color="black"> 학번 :</font></b><font color="black"> </font><font color="black"><left><?=$sd?></left> </font></p>
</td>
                        <td width="1" height="34" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                </tr>
                    <tr>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="259" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="259" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                </tr>
                    <tr>
                        <td width="1" height="35" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="35" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    <td width="259" height="35" namo_textbox="0,0,0,0,0,0,0,0,0,0">

                        <p align="left"> <b><font color="black"> 직업 :</font></b><font color="black"> <left><?=$job?></left></font></p>
                    </td>
                        <td width="1" height="35" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    <td width="259" height="35" namo_textbox="0,0,0,0,0,0,0,0,0,0">

                        <p align="left"><b><font color="black"> 휴대전화 : </font></b><font color="black"><left><?=$hp?></left> </font></p>
</td>
                        <td width="1" height="35" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                </tr>
                    <tr>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="259" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="259" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                </tr>
                    <tr>
                        <td width="1" height="35" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="35" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    <td width="259" height="35" namo_textbox="0,0,0,0,0,0,0,0,0,0">

                        <p align="left"><b><font color="black"> 전화번호 : </font></b><font color="black"><left><?=$tel?></left> </font></p>
                    </td>
                        <td width="1" height="35" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    <td width="259" height="35" namo_textbox="0,0,0,0,0,0,0,0,0,0">

                        <p align="left"><b><font color="black"> FAX : </font></b><font color="black"><left><?=$fax?></left> </font></p>
</td>
                        <td width="1" height="35" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    </tr>
                    <tr>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="259" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="259" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    </tr>
                    <tr>
                        <td width="1" height="30" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="30" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="519" height="30" colspan="3" namo_textbox="0,0,0,0,0,0,0,0,0,0">
                            <p align="left"><font color="black"> <b>E-Mail :</b><a href="mailto:<?=$data[email]?>">    <left><?=$data[email]?></left></a> </font></p>
                    </td>
                        <td width="1" height="30" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    </tr>
                    <tr>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="259" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="259" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    </tr>
                    <tr>
                        <td width="1" height="34" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="34" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    <td width="519" height="34" colspan="3" namo_textbox="0,0,0,0,0,0,0,0,0,0">
                        <p><b><font color="black"> 주소 : </font></b><font color="black"><left><?=$juso?></left></font></p>
</td>
                        <td width="1" height="34" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    </tr>
                    <tr>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="118" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="259" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="259" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                        <td width="1" height="1" bgcolor="black" namo_textbox="0,0,0,0,0,0,0,0,0,0"></td>
                    </tr>
            </table>
        </td>
    </tr>
</table>
<table cellpadding="0" cellspacing="0" width="640" height="1">
    <tr>
        <td width="640" height="5">
        </td>
    </tr>

</table>
<?
}

                $num++;
                }
                ?><br> <table cellpadding="0" cellspacing="0" width="728" height="1">
    <tr>
        <td width="728">

            <p align="center"><?
                        $i=1;
                                                
                                        
                        $start_page=(int)(($page-1)/$pageNum)*$pageNum;
                        while($i+$start_page<=$totalpage&&$i<=$pageNum) {
                            $move_page=$i+$start_page;
                            if($page==$move_page)echo"[<b>$move_page</b>] ";
                            else echo"[<a href=$PHP_SELF?page=$move_page&member_view=$member_view>$move_page</a>] ";
                            $i++;
                        }
                                                
                                                ?>
                                                    <form method=get action='<?=$PHP_SELF?>'>
                <p align="center"><input type=hidden name=member_view value='<?=$member_view?>'><input type=text name=key size=20 title='찾고자 하는 동문의 이름을 입력하세요' style='background-color:ffffff; border:1 #666666 solid; height:18'><input type=submit value=' 검 색 ' style='background-color:#000000; border:1 #666666 solid; font-family:웹정; font-size:9pt; color:#ffffff; cursor:hand; height:18'><input type=submit onClick=location.href('javascript:history.back(1)') value=' 취 소 ' style='background-color:#000000; border:1 #666666 solid; font-family:웹정; font-size:9pt; color:#ffffff; cursor:hand; height:18'></p>
</form> </tr>
</table>


</body>
</html>
이 게시물을
좋아요
목록
글쓴이 제목 최종 글
XE 공지 글 쓰기,삭제 운영방식 변경 공지 [16] 2019.03.05 by 남기남
팔공산 모바일에서 메뉴가 나오지를 않네요??? [2] file 2014.05.20 by 팔공산
석전리바이브 지금 xe포럼에서 support메뉴를 눌렀을때 [3] 2014.05.20 by 퍼니엑스이
hughlory 회원 가입 (invitation only?) 관련 질문  
나의해 XE 1.75버전 프리티포토 애드온 안되나요?? [9] 2014.05.19 by 애니즌
나의해 코드 하나만 봐주세요! [29] 2014.05.19 by 나의해
good499 텍스타일처럼 111.xe.com 222.xe.com 같은 도메인을 [14] 2014.05.19 by Lin-e
Lin-e 텍스타일 (혹은 업글타일)에 권한 주는법?  
똥냥이1 회원가입 후 폴더 생성 시 어떤 파일 수정하나요 ? [1] 2014.05.19 by 똥냥이1
yubin0725 위젯null현상 질문 제발요 ㅠㅠ [5] file 2014.05.19 by 애니즌
publicum iframe 세로 방향 짤림문제 + 외부 html은 어떻게 불러오나요? [3] file 2014.05.19 by publicum
카루에몽v 없는 게시글에 반복 접근이 감지된다고 합니다.  
젠장할 메인페이지 위젯에 대해서 질문드립니다. [8] file 2014.05.19 by 나의해
모울 운영하고 있는 홈페이지에, 갑자기 이상한 회원 수가 급격하게 늘었습니다ㅠㅜ [7] file 2014.05.19 by 마야
Wnepddkqjelqjel 신디케이션 연동관련 문의드립니다. [3] 2014.05.19 by 나의해
도메인8295 리그 오브 레전드 (롤) 전적검색 기능을 추가하고싶습니다.  
껭끼 alternative 다르다고 하네요 도와주세요ㅠ [3] 2014.05.19 by 나의해
석전리바이브 위젯이 안보이는이유가뭘까요? [1] 2014.05.19 by 銀童
나의해 [초보] 이미지 리사이즈가 되질 않아요  
DOCHIS xe 외부페이지에서 다른페이지로 이동할때.... [2] file 2014.05.19 by DOCHIS
124adsf12 제로보드 홈페이지 로그인유지 관련. [1] 2014.05.19 by Luatic™
태그 쓰기