특정필드의 값만 검색되게 하는방법좀 알려주세요. > 그누4 질문답변

매뉴얼 FAQ
그누보드5
데모
자료실
  • 다운로드
  • 매뉴얼
  • Q&A
    • 창작마당
  • 팁자료실
  • 스킨
  • 빌더
  • 테마
  • 플러그인
  • 사용후기
    • 영카트5
    데모
    자료실
    창작마당
    정기결제
    데모
    자료실
    Q & A
    궁금한 게 있으신가요? 지금 질문해보세요!
    솔루션
    프로그래밍
    서버
    사이트운영
    컨텐츠몰
    나의 재능을 팔아보세요!
    부가서비스
    국내최저! 신용카드 결제수수료 2.85%
    제작의뢰
    커뮤니티
    커뮤니티
    소모임
    스터디
    AI 🌟
    강좌
    기타

    그누4 질문답변

    그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
    기존 게시물은 열람만 가능합니다.

    특정필드의 값만 검색되게 하는방법좀 알려주세요. 정보

    특정필드의 값만 검색되게 하는방법좀 알려주세요.

    본문

    회원DB가 있습니다.

    그정 특정필드 day 에 값이 1인 회원만 보이게 하고 싶거든요.

    아래 소스를 올려드리는게 어떻게 수정해야하는지 잘 몰라서요.

    꼭좀 도움 부탁드립니다.

    물론 다른상황의 경우 2인 회원만 보이게도 하고 싶습니다. ㅠㅠ

    <?
    require "$DOCUMENT_ROOT/_ADMIN/admin_check.php";

    $p = $_GET[p];
    $keyword = $_GET[keyword];
    $keyfield = trim($_GET[keyfield]);
    $cod = $_GET[cod];
    $dbo = $_GET[dbo];

    if(!$p || !ereg("[0-9]",$p)) $p=1;
    $Query = "";
    $Where = 0;
    if($keyfield && $keyword){
    $keyword = metaRemove($keyword);
    $encoded_key = urlencode($keyword);
    if($Where > 0) $Query .= "AND $keyfield like '%$keyword%'";
    else $Query .= "WHERE $keyfield like '%$keyword%'";
    $Where++;
    }

    if($dbo && $dbo <> "all")
    {
    if($Where > 0) $Query .= "AND day = '$dbo'";
    else $Query .= "WHERE  day = '$dbo'";
    $Where++;
    }

    if($dbo && $dbo == "all")
    {
    if($Where > 0) $Query .= "AND day = ''";
    else $Query .= "WHERE  day = ''";
    $Where++;
    }


    $real_link = "p=$p&dbo=$dbo&cod=$cod&keyfield=$keyfield&keyword=$encoded_key";
    $p_link =  "dbo=$dbo&cod=$cod&keyfield=$keyfield&keyword=$encoded_key";
    $pernum = 50;
    $que = mysql_query("select count(*) from $WIZ[member_table] $Query") or die(sql_error());
    $total = mysql_result($que,0,0);
    $total_page = ceil($total / $pernum);

    if($total_page == 0) $first = 0;
    else $first = $pernum * ($p-1);

    $stitle = "회원종합관리";
    $tit_img = "tit_12.gif";

    HtmlHeader($stitle);
    ?>
    <style type="text/css">
    <!--
    .style12 {color: #FFFFFF}
    -->
    </style>

    <body bgcolor="#FFFFFF" text="#000000" leftmargin="20" topmargin="15" marginwidth="20" marginheight="15">
    <?=HtmlTitle($stitle)?>
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td >

    <!-- 컨텐츠 시작 -->
    <table width="98%" border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td>&nbsp;</td>
    </tr>

    <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">



    <tr>
    <td style="background-color:#F6F6F6; padding:7px;"><table width="99%" border="0" cellpadding="6" cellspacing="1" bgcolor="#E2E2E2">
    <tr>
    <td bgcolor="#FFFFFF">
    <table WIDTH=100% border="0" cellspacing="4" cellpadding="0">
    <tr>
    <td>

    <table border="0" cellspacing="4" cellpadding="0">
    <form NAME="search" method=get action="">
    <tr>
    <td>
    <SELECT NAME="dbo" onChange="this.form.submit();">
    <option value="">전체회원</option>
    <option value="all" <? if($dbo=="all") echo "selected";?>>테스트</option>
    <?
    $que100 = mysql_query("SELECT * FROM $WIZ[dealer_table]") or die(mysql_error());
    while($row100 = mysql_fetch_array($que100))
    {
    ?>
    <option value="<?=$row100[day];?>" <? if($dbo==$row100[day]) echo "selected";?>><?=htmlchars($row100[d_name]);?></option>
    <?
    }
    ?>

    </SELECT>
    <SELECT NAME="keyfield" class=datebox style="width:100px">
    <option value="name" <? if($keyfield=="name") echo "selected";?>>이름</option>
    <option value="ename" <? if($keyfield=="ename") echo "selected";?>>영문이름</option>
    <option value="dbco_id" <? if($keyfield=="dbco_id") echo "selected";?>>아이디</option>
    <option value="email" <? if($keyfield=="email") echo "selected";?>>이메일</option>
    <option value="tel" <? if($keyfield=="tel") echo "selected";?>>전화번호</option>
    <option value="jtel" <? if($keyfield=="jtel") echo "selected";?>>전화번호(회사)</option>
    <option value="ptel" <? if($keyfield=="ptel") echo "selected";?>>전화번호</option>
    <option value="mobile" <? if($keyfield=="mobile") echo "selected";?>>휴대폰번호</option>
    <option value="pmobile" <? if($keyfield=="pmobile") echo "selected";?>>휴대폰번호</option>
    <option value="dbco_conti" <? if($keyfield=="dbco_conti") echo "selected";?>>이동</option>
    </SELECT>

    <input type="text" name="keyword" value="<?=$keyword;?>" maxlength=100 size=50 /></td>
    <td align=right>
    <TABLE border=0  cellpadding=0 cellspacing=0>
    <TR>
    <TD><IMG SRC="../img/btn_l.gif" WIDTH="9" HEIGHT="24"></TD>
    <TD class="btnbg sp hand" onclick="document.search.submit();"><span class="style12"><font class=red><B>검색을</B></font>합니다</span>.</TD>
    <TD><IMG SRC="../img/btn_r.gif" WIDTH="9" HEIGHT="24"></TD>
    </TR>
    </TABLE>
    </td>
    <td width=50><a href="member.regi.html"><img src="../img/btn_regi.gif" border=0></a></td>
    <td><a href="memberExcel.php"><img src="../img/btn_ex_down.gif" border=0></a></td>

    </tr>
    </form>
    </table>

    </td>
    </tr>
    </table>
    </td>
    </tr>
    </table>

    </td>
    </tr>
    <tr>
    <td height='10'></td>
    </tr>






    </table></td>
    </tr>



    <tr>
    <td>

    <!-- 리스트 시작 -->
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td height="2" bgcolor="005CDC"></td>
    </tr>
    <tr>
    <td><table width="100%" border="0" cellpadding="4" cellspacing="0" bgcolor="E2E2E2">
    <tr>
    <td width="3%" align="center" bgcolor="F6F6F6">No.</td>
    <td width="1%" align="center" bgcolor="F6F6F6"><img src="../img/ba_img.gif" width="1" height="11" /></td>
    <td align="center" bgcolor="F6F6F6">이름<BR>)</td>
    <td width="1%" align="center" bgcolor="F6F6F6"><img src="../img/ba_img.gif" width="1" height="11" /></td>
    <td align="center" bgcolor="F6F6F6">아이디<BR>패스워드</td>
    <td width="1%" align="center" bgcolor="F6F6F6"><img src="../img/ba_img.gif" width="1" height="11" /></td>
    <td align="center" bgcolor="F6F6F6">회원<BR></td>
    <td width="1%" align="center" bgcolor="F6F6F6"><img src="../img/ba_img.gif" width="1" height="11" /></td>
    <td align="center" bgcolor="F6F6F6">전화번호<BR>휴대폰<BR>이메일</td>
    <td width="1%" align="center" bgcolor="F6F6F6"><img src="../img/ba_img.gif" width="1" height="11" /></td>
    <td align="center" bgcolor="F6F6F6">적립금</td>
    <td width="1%" align="center" bgcolor="F6F6F6"><img src="../img/ba_img.gif" width="1" height="11" /></td>

    <td align="center" bgcolor="F6F6F6">이동횟수</td>
    <td width="1%" align="center" bgcolor="F6F6F6"><img src="../img/ba_img.gif" width="1" height="11" /></td>
    <td align="center" bgcolor="F6F6F6">로그인횟수</td>
    <td width="1%" align="center" bgcolor="F6F6F6"><img src="../img/ba_img.gif" width="1" height="11" /></td>
    <td align="center" bgcolor="F6F6F6">최근로그인</td>
    <td width="1%" align="center" bgcolor="F6F6F6"><img src="../img/ba_img.gif" width="1" height="11" /></td>
    <td align="center" bgcolor="F6F6F6">등록일<br>최초이동일<br>이동종료일</td>
    <td width="1%" align="center" bgcolor="F6F6F6"><img src="../img/ba_img.gif" width="1" height="11" /></td>
    <td width="3%" align="center" bgcolor="F6F6F6">수정</td>
    <td width="1%" align="center" bgcolor="F6F6F6"><img src="../img/ba_img.gif" width="1" height="11" /></td>
    <td width="3%" align="center" bgcolor="F6F6F6">삭제</td>
    </tr>
    <tr>
        <td height="1" bgcolor="E2E2E2"></td>
        <td bgcolor="E2E2E2"></td>
        <td height="1" bgcolor="E2E2E2"></td>
    <td bgcolor="E2E2E2"></td>
    <td height="1" bgcolor="E2E2E2"></td>
        <td bgcolor="E2E2E2"></td>
        <td height="1" bgcolor="E2E2E2"></td>
    <td bgcolor="E2E2E2"></td>
    <td height="1" bgcolor="E2E2E2"></td>
        <td bgcolor="E2E2E2"></td>
        <td height="1" bgcolor="E2E2E2"></td>
    <td bgcolor="E2E2E2"></td>
    <td height="1" bgcolor="E2E2E2"></td>
        <td bgcolor="E2E2E2"></td>
        <td height="1" bgcolor="E2E2E2"></td>
    <td bgcolor="E2E2E2"></td>
    <td height="1" bgcolor="E2E2E2"></td>
        <td bgcolor="E2E2E2"></td>
        <td height="1" bgcolor="E2E2E2"></td>
    <td bgcolor="E2E2E2"></td>
    </tr>

    <?
    $que1 = mysql_query("SELECT *  FROM $WIZ[member_table] $Query ORDER BY uid DESC LIMIT $first,$pernum") or die(sql_error());
    $real_number = $total - $pernum * ($p-1);
    while($row = mysql_fetch_array($que1))
    {
    $edate = $row[edate];
    if(!$edate || $edate=="0000-00-00")
    {
    $MEMBER_TYPE = "회원";
    }
    else
    {
    $edate = split("-",$row[edate]);
    $mktime = mktime(23,59,59,$edate[1],$edate[2],$edate[0]);
    if($mktime>time()) $MEMBER_TYPE = "<FONT COLOR=ff0000><B>회원</B></FONT>";
    else $MEMBER_TYPE = "회원";
    }

    ?>

    <tr  align="center" bgcolor="#FFFFFF" onMouseOver=this.style.backgroundColor="#FFFF95" onMouseOut=this.style.backgroundColor="">
    <td><?=$real_number;?></td>
    <td>&nbsp;</td>
    <td><?=htmlstripchars($row[name]);?> <BR>(<?=htmlstripchars($row[ename]);?>)</td>
    <td>&nbsp;</td>
    <td><?=htmlstripchars($row[dbco_id]);?><BR><?=htmlstripchars($row[dbco_pw2]);?></td>
    <td>&nbsp;</td>
    <td><?=$MEMBER_TYPE;?><BR><B><?=htmlstripchars($row[lev_gubun]);?></B> <FONT COLOR="ff0000"><?=htmlstripchars($row[lev_name]);?></FONT></td>
    <td>&nbsp;</td>
    <TD><!-- <img src="../img/tel.gif" title="<?=htmlspecialchars(stripslashes($row[tel]));?>"> --><?=htmlspecialchars(stripslashes($row[tel]));?>
    <BR><A HREF="#" <? if($row[mobile]){?>onClick="smsOpen('<?=htmlspecialchars(stripslashes($row[mobile]));?>');"<?}?>><!-- <img src="../img/phone.gif" title="<?=htmlspecialchars(stripslashes($row[mobile]));?>"> --><?=htmlspecialchars(stripslashes($row[mobile]));?></A><BR><A href="mailto:<?=htmlspecialchars(stripslashes($row[email]));?>"><!-- <img src="../img/email.gif" title="<?=htmlspecialchars(stripslashes($row[email]));?>"> --><?=htmlspecialchars(stripslashes($row[email]));?></A></TD>
    <TD>&nbsp;</TD>
    <TD><?=number_format($row[point]);?><IMG SRC="../img/ico_view.gif" WIDTH="11" HEIGHT="11" align=absmiddle  onClick="window.open('point.pop.html?no=<?=$row[uid];?>','11','width=500 ,height=360, top=200, left=200, scrollbars=yes')" style="cursor:hand;"></TD>
    <TD>&nbsp;</TD>
    <TD><?=$row[dbco_conti];?></TD>
    <TD>&nbsp;</TD>
    <TD><?=$row[logview];?></TD>
    <TD>&nbsp;</TD>
    <td><?=$row[lastlogin];?></td>
    <td>&nbsp;</td>
    <td><?=substr($row[regdate],0,10);?><br><?=$row[sdate];?><br><?=$row[edate];?></td>
    <td>&nbsp;</td>
    <td><img src="../img/btn_modify.gif" width="23" height="23" border="0" onClick="window.open('member.modi.html?no=<?=$row[uid];?>','WinMem','width=800,height=650,top=0,left=0,toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=no');" style="cursor:hand;" /></td>
    <td>&nbsp;</td>
    <td><A HREF="member.del.proc.php?<?=$real_link;?>&no=<?=$row[uid];?>"><img src="../img/btn_delete.gif" width="23" height="23" border="0"  onClick="return Really();"></A></td>
    </tr>
    <tr>
        <td height="1" bgcolor="E2E2E2"></td>
        <td bgcolor="E2E2E2"></td>
        <td height="1" bgcolor="E2E2E2"></td>
    <td bgcolor="E2E2E2"></td>
    <td height="1" bgcolor="E2E2E2"></td>
        <td bgcolor="E2E2E2"></td>
        <td height="1" bgcolor="E2E2E2"></td>
    <td bgcolor="E2E2E2"></td>
    <td height="1" bgcolor="E2E2E2"></td>
        <td bgcolor="E2E2E2"></td>
        <td height="1" bgcolor="E2E2E2"></td>
    <td bgcolor="E2E2E2"></td>
    <td height="1" bgcolor="E2E2E2"></td>
        <td bgcolor="E2E2E2"></td>
        <td height="1" bgcolor="E2E2E2"></td>
    <td bgcolor="E2E2E2"></td>
    <td height="1" bgcolor="E2E2E2"></td>
        <td bgcolor="E2E2E2"></td>
        <td height="1" bgcolor="E2E2E2"></td>
    <td bgcolor="E2E2E2"></td>
    <td height="1" bgcolor="E2E2E2"></td>
    </tr>
    <?
    $real_number--;
    }
    ?>

    </table>

    </td>
    </tr>

    <tr>
    <td height="2" bgcolor="005CDC"></td>
    </tr>
    </table>
    <!-- 리스트 끝 -->


    </td>
    </tr>

    <tr>
    <td height="50" align="center"><?include("../inc/_page.php");?></td>
    </tr>
    </table></td>
    </tr>
    </table>
    <!-- 컨텐츠 끝 -->

    </td>
    </tr>
    </table>

    댓글 전체

    전체 66,554 |RSS
    그누4 질문답변 내용 검색

    회원로그인

    (주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1402호 / E-Mail: admin@sir.kr
    사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
    © SIRSOFT