묻고답하기

  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 남기남
stub363 암호화 관련 질문... [3] 2007.08.10
cocoroo asp파일에 인클루드 하는 태그좀 알려주세요~ [1] 2007.08.10
한승혁 서버를 이전했는데요 [1] 2007.08.10
이상규 해킹을 당했습니다. 도와주세요. [4] 2007.08.10
이상규 APM을 회사에서 사용할때 저작권은? [1] 2007.08.10
박군의그녀 폰트 질문이요 [1] 2007.08.10
Yup2.com php관련 질문드립니다...답변 부탁드리요! [2] 2007.08.10
서승준 아래 두 소스가 같은 결과를 나타내나요? (php, jsp)  
koreaP-3000.com php로도 검색로봇을 만드는게 가능한건지  
Homp 노프레임의 홈페이지를 만들고 메뉴 추가나 업데이트 할때요  
전재근 아주 초보적인 session 질문인가요??? [3] 2007.08.10
Anie 프레임을 숨기려면.. (소스있음) [3] 2007.08.10
김경애 DB이전방법 [2] 2007.08.10
양명길 illustrator CS에서여 이전버전의 ai화일로 저장이 안되나여? [2] 2007.08.10
yaho. :-D 백그라운드 이미지 고정 시키는 방법좀.. [1] 2007.08.10
이상민 제로카운터에 싸이월드 미니홈에 있는 이벤트 hit 만들려면...? [2] 2007.08.10
윤자영 표에서 그림을 삽입하려고 하는데요... [3] 2007.08.10
cannibal 제로카운터 사용하는데여 제가 외국이라... [1] 2007.08.10
이송곤 메인페이지 만드는 법 질문입니다 [1] 2007.08.10
조한웅 php 관련 몇가지 함수 질문 드립니다. [4] 2007.08.10
권명진 플래쉬에 대해서... [2] 2007.08.10
김인무 회원관리를 단일화시킬 수 있을까요? [1] 2007.08.10
손영대 프레임 나눌때 슬라이딩메뉴 에러! [1] 2007.08.10
REDsky 홈페이지 질문좀 할께요 ^_^ [2] 2007.08.10
Allong 도무지 해결이 안되는 홈페이지 에러... [2] 2007.08.10
돌사진 쪽지가 실시간이 안되는 것 같아요. [2] 2007.08.10
이세호 window 의 width 값을 알아내려면 어떻게 해야하나요? [2] 2007.08.10
shin2chi 링크에 관한 질문인데요;; [2] 2007.08.10
김윤희 로그인후 .. 어쩌면 바보같은 질문일지도.. [3] 2007.08.10
한상빈 -_- 메인 바꾸고 싶어요 [2] 2007.08.10
태그 쓰기