묻고답하기

  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 남기남
윤용수 작업한 파일의 등록정보-보안 설정에 관하여...  
고청훈 도와주세요  
강현정 일러스트 10 에서 왼쪽 툴이 안뜨는 이유가... [1] 2007.08.10
*^o^* 포토샾에서 사진을 선명하게 하는 방법을 알 수 없을까요... [2] 2007.08.10
최영숙 포토샵에서 폰트가 이상해요. [2] 2007.08.10
안재복 딩벳 폰트가 먹히질 않아요  
김지영 알ftp랑 다른ftp차이점이 뭔지 좀... [8] 2007.08.10
한일도 Brown님 보세요(절대/상대경로...) [1] 2007.08.10
찌코2 롤오버 이미지 질문입니다 [1] 2007.08.10
김창모 [질문]랜덤으로 로딩되는 플래쉬 무비? [1] 2007.08.10
박정호 [자바 스크립트]메뉴에 관한 질문입니다. [2] 2007.08.10
lacovnk 포토샵에서 jpg로 작업하다보면 왜 용량이 늘지요? ㅡ.ㅠ [2] 2007.08.10
이용일 제로님께서 쓰신 윈도우즈에서 PHP와MySQL 까는 법을 보고 했는데 안되요. [1] 2007.08.10
phase alt나 title 배경색 지정은 어떻게 하나요? [3] 2007.08.10
긍그미~ php 랜덤 그림화일 출력에 관하여요 [3] 2007.08.10
정지훈 http 헤더에 get/post 변수 붙혀서 전송하는 법..  
* JUNE 노프레임에 html문서연결하는것... [4] 2007.08.10
김남순 프레임 링크관련  
김성준 음... 디비에 테이블을 만들었는데요.... [1] 2007.08.10
윤용수 서버컴에서 두개의 랜카드를 활용하는 법? [1] 2007.08.10
태그 쓰기