트리플님 전체 게시판관리 에서 아이디검색을 제목검색으로 할려고합니다.

트리플님 전체 게시판관리 에서 아이디검색을 제목검색으로 할려고합니다.

QA

트리플님 전체 게시판관리 에서 아이디검색을 제목검색으로 할려고합니다.

본문

트리플님 전체 게시판관리 에서 아이디검색을 제목검색으로 할려고합니다.

 

<label for="stx" class="sound_only">검색어</label>
<input type="text" name="stx" value="<?php echo $stx ?>" id="stx" class="frm_input">
<input type="submit" value="검색" class="btn_submit">

 

이거를 아래처럼 변경햇는데 검색이 않됩니다.

 

<select name="sfl" id="sfl">
    <option value="wr_subject"<?php echo get_selected($_GET['sfl'], "wr_subject"); ?>>제목</option>
</select>
<label for="stx" class="sound_only">검색어<strong class="sound_only"> 필수</strong></label>
<input type="text" name="stx" value="<?php echo $stx ?>" id="stx" class="frm_input">
<input type="submit" class="btn_submit" value="검색">

 


이거를 어떻게 수정 하면은 제목 검색으로 됩니까?

 

고수님 도와주세요 

감사 합니다

 

 

 

 

<?php
$sub_menu = "300900";
include_once('./_common.php');

auth_check($auth[$sub_menu], 'r');

$sql_common = " from {$g5['board_new_table']} a, {$g5['board_table']} b, {$g5['group_table']} c 
               where a.bo_table = b.bo_table and b.gr_id = c.gr_id and b.bo_use_search = '1' ";

if ($gr_id){
    $sql_common .= " and b.gr_id = '$gr_id' ";
    $qstr .= "&gr_id=$gr_id";
}

if ($bo_table){
    $sql_common .= " and a.bo_table = '$bo_table' "; //여기가 추가된 부분 
    $qstr .= "&bo_table=$bo_table";
}

if ($view == "w"){
    $sql_common .= " and a.wr_id = a.wr_parent ";
    $qstr .= "&view=$view";
}

else if ($view == "c") {
     $sql_common .= " and a.wr_id <> a.wr_parent ";
     $qstr .= "&view=$view";
}

if ($mb_id) {
     $sql_common .= " and a.mb_id = '$mb_id' ";
     $qstr .= "&mb_id=$mb_id";
     //출석 체크
    if($member['mb_id']) chulcheck($member[mb_id]);
}
   
if (!$sst) {
$sst  = "a.bn_id";
$sod = "desc";
}

if($sst) {
     $qstr .= "&sst=$sst";
     $qstr .= "&sod=$sod";
}

$sql_order = " order by $sst $sod";
$sql = " select count(*) as cnt $sql_common ";
$row = sql_fetch($sql);

$total_count = $row[cnt];
if ($pgview) {
    $rows = $pgview;
    $qstr .= "&pgview=$pgview";
} else {
    $rows = $config[cf_new_rows];
}

$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함

$group_select = "<select name=gr_id id=gr_id onchange='select_change();'><option value=''>전체그룹";
$sql = " select gr_id, gr_subject from {$g5['group_table']} order by gr_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) 
{
    $selected = ($gr_id == $row['gr_id']) ? "selected=selected" : "";
    $group_select .= "<option $selected value='$row[gr_id]'>$row[gr_subject]";
}
$group_select .= "</select>";
$board_select = "<select name=bo_table id=bo_table onchange='select_change();'><option value=''>전체게시판";

if($gr_id)
    $sql_extra  = "where gr_id = '$gr_id'";
$sql = " select bo_table, bo_subject from {$g5['board_table']} $sql_extra order by bo_table";

$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) 
{
    $selected = ($bo_table == $row['bo_table']) ? "selected=selected" : "";
    $board_select .= "<option $selected  value='$row[bo_table]'>$row[bo_subject]";
}
$board_select .= "</select>";

$list = array();
$sql = " select a.*, b.bo_subject, c.gr_subject, c.gr_id
          $sql_common
          $sql_order
          limit $from_record, $rows ";

$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) 
{
    $tmp_write_table = $g5['write_prefix'] . $row[bo_table];

    if ($row[wr_id] == $row[wr_parent]) // 원글
    {
        $comment = "";
        $comment_link = "";
        $row2 = sql_fetch(" select * from $tmp_write_table where wr_id = '$row[wr_id]' ");
        $list[$i] = $row2;
        $name = get_sideview($row2[mb_id], cut_str($row2[wr_name], $config[cf_cut_name]), $row2[wr_email], $row2[wr_homepage]);
        // 당일인 경우 시간으로 표시함
        $datetime = $row2[wr_datetime];
    }
    else // 코멘트
    {
        $comment = "<font color='#FF0000'>[코]</font> ";
        $comment_link = "#c_{$row[wr_id]}";
        //$row2 = sql_fetch(" select * from $tmp_write_table where wr_id = '$row[wr_parent]' ");
        $row2 = sql_fetch(" select * from $tmp_write_table where wr_id = '$row[wr_id]' ");
        $row3 = sql_fetch(" select mb_id, wr_name, wr_email, wr_homepage, wr_datetime from $tmp_write_table where wr_id = '$row[wr_id]' ");
        $list[$i] = $row2;
        $list[$i][mb_id] = $row3[mb_id];
        $list[$i][wr_name] = $row3[wr_name];
        $list[$i][wr_email] = $row3[wr_email];
        $list[$i][wr_homepage] = $row3[wr_homepage];
        $name = get_sideview($row3[mb_id], cut_str($row3[wr_name], $config[cf_cut_name]), $row3[wr_email], $row3[wr_homepage]);
        $datetime = $row3[wr_datetime];
        $row2[wr_subject] = $row2[wr_content];
    }
    $list[$i][gr_id] = $row[gr_id];
    $list[$i][bo_table] = $row[bo_table];
    $list[$i][name] = $name;
    $list[$i][comment] = $comment;
    $list[$i][href] = "../bbs/board.php?bo_table=$row[bo_table]&wr_id=$row2[wr_id]{$comment_link}";
    $list[$i][datetime] = $datetime;
    $list[$i][gr_subject] = $row[gr_subject];
    $list[$i][bo_subject] = $row[bo_subject];
    $list[$i][wr_subject] = $row2[wr_subject];
}
$html_title = '전체 게시판 HIT 관리';
$g5['title'] = $html_title;
include_once('./admin.head.php');
?>
<style>
.frm_input {
    height: 22px;
    line-height: 22px;
    border: 1px solid #d5d5d5;
}
</style>
<!-- 분류 시작 -->
<form name="fnew" id="fnew" class="local_sch01 local_sch" method="get">
    <?=$group_select?>
    <?=$board_select?>
<label for="view" class="sound_only">전체게시물,원글,코멘트중에 선택하세요</label>
<select name='view' id='view' onchange="select_change()">
    <option value=''>전체게시물
    <option value='w'>원글만
    <option value='c'>코멘트만
</select>
<label for="pgview" class="sound_only">출력개수를 선택하세요</label>
<select name='pgview' id='pgview' onchange="select_change()">
    <option value=''>출력개수
    <option value='1'>1개
    <option value='15'>15개
    <option value='30'>30개
    <option value='50'>50개
    <option value='100'>100개
    <option value='150'>150개
    <option value='200'>200개
    <option value='300'>300개
    <option value='500'>500개
</select>

<select name="sfl" id="sfl">
    <option value="wr_subject"<?php echo get_selected($_GET['sfl'], "wr_subject"); ?>>제목</option>
</select>
<label for="stx" class="sound_only">검색어<strong class="sound_only"> 필수</strong></label>
<input type="text" name="stx" value="<?php echo $stx ?>" id="stx" class="frm_input">
<input type="submit" class="btn_submit" value="검색">
</form>
<!-- 분류 끝 -->

<form name="fboardlist" id="fboardlist" action="./new_hit_list_update.php" onsubmit="return fboardlist_submit(this);" method="post">
<input type=hidden name='gr_id' value='<?php echo $gr_id; ?>' />
<input type=hidden name='bo_table' value='<?php echo $bo_table; ?>' />
<input type=hidden name='view' value='<?php echo $view; ?>' />
<input type=hidden name='mb_id' value='<?php echo $mb_id; ?>' />
<input type=hidden name='pgview' value='<?php echo $pgview; ?>' />
<input type=hidden name='page' value='<?php echo $page; ?>' />
<input type=hidden name='sst' value='<?php echo $sst; ?>' />
<input type=hidden name='sod' value='<?php echo $sod; ?>' />

<div class="tbl_head01 tbl_wrap">
<table>
    <caption><?php echo $g5['title']; ?> 목록</caption>
    <colgroup>
        <col width="30px" />
        <col width="120px" />
        <col width="120px" />
        <col width="" />
        <col width="120px" />
        <col width="120px" />
        <col width="300px" />
        <col width="120px" />
        <col width="120px" />
    </colgroup>
    <thead>
    <tr>
        <th scope="col">
            <label for="chkall" class="sound_only">전체선택</label>
            <input type="checkbox" name="chkall" value="1" id="chkall" onclick="check_all(this.form)">
        </th>
        <th scope="col"><?=subject_sort_link("gr_id",$qstr)?>그룹</a></th>
        <th scope="col"><?=subject_sort_link("bo_table",$qstr)?>게시판</a></th>
        <th scope="col"><?=subject_sort_link("bo_subject",$qstr)?>제목</a></th>
        <th scope="col"><?=subject_sort_link("mb_id",$qstr)?>이름</a></th>
        <th scope="col"><?=subject_sort_link("mb_id",$qstr)?>작성자</a></th>
        <th scope="col"><?=subject_sort_link("bn_datetime",$qstr)?>일시</a></th>
        <th scope="col">추천</th>
        <th scope="col">조회</th>
    </tr>
    </thead>
    <tbody>
<?php
for ($i=0; $i<count($list); $i++)
{
    $gr_subject = cut_str($list[$i][gr_subject], 20);
    $bo_subject = cut_str($list[$i][bo_subject], 20);
    $wr_subject = get_text(cut_str($list[$i][wr_subject], 80));
    $datetime3 = substr($list[$i][wr_datetime],0,19);

    $bg = 'bg'.($i%2);

    if($list[$i][wr_hit] >= 500){
        $random=rand(1,2);
    } else if($list[$i][wr_hit] >= 300){
        $random=rand(1,3);
    } else {
        $random=rand(2,7);
    }
    
////////////////// 추천 랜덤조작 시작 //////////////////
    $random_good=rand(0,2);
////////////////// 추천 랜덤조작 시작 //////////////////

/*
////////////////// 작성일 랜덤조작 시작 //////////////////
    $random_D=rand(14,14);//일
    $random_H=rand(8,15);//시
    $random_I=rand(1,59);//분

    $timestamp = strtotime(date("2020-05-".$random_D." ".$random_H.":".$random_I.":s")."");
    $time = date("Y-m-d H:i:s", $timestamp);
////////////////// 작성일 랜덤조작 끝 //////////////////
*/
?>
    <tr class="<?php echo $bg; ?>">
        <td class="td_chk">
            <label for="chk_<?php echo $i; ?>" class="sound_only"><?php echo $list[$i][wr_id] ?>번글 선택</label>
            <input class='chk' type="checkbox" name="chk[]" value="<?php echo $i; ?>">
            <input type=hidden name=set_table[<?=$i?>]  value='<?=$list[$i]['bo_table']?>'>
            <input type=hidden name=set_id[<?=$i?>]  value='<?=$list[$i]['wr_id']?>'>
        </td>
        <td><a href='./new_hit_list.php?gr_id=<?=$list[$i][gr_id]?>'><?=$gr_subject?></a></td>
        <td><a href='<?=G5_BBS_URL ?>/board.php?bo_table=<?=$list[$i][bo_table]?>'><?=$bo_subject?></a></td>
        <td><a href='<?=$list[$i][href]?>'><div style="width:100%; text-align:left;"><?=$list[$i][comment]?><?=$wr_subject?></div></a></td>
        <td style="text-align:left;"><?=$list[$i][name]?></td>
        
        <td><input type=text size=12 name=set_cb_mb_id[<?=$i?>] value="<?=$list[$i][mb_id]; ?>" class="frm_input"></td>
        
        <td align='center'>
            <label for="chk_date<?php echo $i; ?>" class="sound_only"><?php echo $list[$i][wr_id] ?>번글 날짜변경 사용</label>
            
            <!-----
            <input type=text size=16 name=set_date[<?=$i?>]  value='<?php echo $time; ?>' class="frm_input set_date" style="width:120px;">
            ------->
            
            <input type=text size=16 name=set_date[<?=$i?>]  value='<?php echo $list[$i][datetime]; ?>' class="frm_input set_date" style="width:125px;">
            
            <span><?=$list[$i][datetime]?></span>
        </td>

        <td align='center'>
        <input type=text size=3 name=set_good[<?=$i?>]  value='<?php echo ((int)$list[$i][wr_good]+$random_good) ?>' class="frm_input" style="width:50px;">
        <span title='현제 hit' > / <?=$list[$i][wr_good]?></span>
        </td>
        <td style="text-align:left;">
        <input type=text size=3 name=set_hit[<?=$i?>] value='<?php echo ((int)$list[$i][wr_hit]+$random) ?>' class="frm_input" maxlength="5" style="width:50px;">
        <span title='현제 hit' > / <?=$list[$i][wr_hit]?></span>
        </td>
    </tr>
    <?php } 
    if ($i == 0)
        echo '<tr><td colspan="8" class="empty_table">자료가 없습니다.</td></tr>';
    ?>
    </tbody>
</table>
</div>
<div class="btn_list01 btn_list"><input type="submit" name="act_button" value="선택수정" onclick="document.pressed=this.value" class="btn_01 btn"></div>
</form>
<?php echo get_paging(G5_IS_MOBILE ? $config['cf_mobile_pages'] : $config['cf_write_pages'], $page, $total_page, $_SERVER['PHP_SELF'].'?'.$qstr.'&page='); ?>
<script language="JavaScript">
function fboardlist_submit(f)
{
    if (!is_checked("chk[]")) {
        alert(document.pressed+" 하실 항목을 하나 이상 선택하세요.");
        return false;
    }
    return true;
}
function select_change()
{
    var f = document.fnew;
    document.fnew.submit();
}
//    document.getElementById("gr_id").value = "<?=$gr_id?>";
//    document.getElementById("bo_table").value = "<?=$bo_table?>";
document.getElementById("pgview").value = "<?=$pgview?>";
document.getElementById("view").value = "<?=$view?>";
</script> 

<script type="text/javascript">
/* Korean initialisation for the jQuery calendar extension. */
/* Written by DaeKwon Kang (*** 개인정보보호를 위한 이메일주소 노출방지 ***). */
jQuery(function($){
    $.datepicker.regional['ko'] = {
        closeText: '닫기',
        prevText: '이전달',
        nextText: '다음달',
        currentText: '오늘',
        monthNames: ['1월(JAN)','2월(FEB)','3월(MAR)','4월(APR)','5월(MAY)','6월(JUN)',
        '7월(JUL)','8월(AUG)','9월(SEP)','10월(OCT)','11월(NOV)','12월(DEC)'],
        monthNamesShort: ['1월','2월','3월','4월','5월','6월',
        '7월','8월','9월','10월','11월','12월'],
        dayNames: ['일','월','화','수','목','금','토'],
        dayNamesShort: ['일','월','화','수','목','금','토'],
        dayNamesMin: ['일','월','화','수','목','금','토'],
        weekHeader: 'Wk',
        dateFormat: 'yymmdd',
        firstDay: 0,
        isRTL: false,
        showMonthAfterYear: true,
        yearSuffix: ''};
    $.datepicker.setDefaults($.datepicker.regional['ko']);

    $('.set_date').datetimepicker({
        
        showOn: 'none',
        // buttonImage: '/img/calendar.gif',
        buttonImageOnly: true,
        buttonText: "달력",
        changeMonth: true,
        changeYear: true,
        showButtonPanel: true,
        dateFormat: 'yy-mm-dd',
        timeFormat:  'HH:mm:ss',
        
        controlType: 'select',
        oneLine: true,
        yearRange: 'c-99:c+99'
    }); 
$('.set_date').on('click focus',function(){
    $(this).datetimepicker('show');
    
});    
});
</script>
<?php
include_once ('./admin.tail.php');
?>

이 질문에 댓글 쓰기 :

답변을 작성하시기 전에 로그인 해주세요.
QA 내용 검색
질문등록
전체 773
© SIRSOFT
현재 페이지 제일 처음으로