검색 기능이 왜 안되나요? 정보
검색 기능이 왜 안되나요?첨부파일
본문
지금 공부를 하고 있는 초보입니다.
검색기능을 만들고 있는데 검색 기능이 안되네요.
혹시 아시는 분은 좀 알려주세요.
아무리 해도 뭐가 잘못된건지를 모르겠어요.
아래 파일 첨부합니다. 부탁드려요.
어제부터 이것때문에 진도가 안나가네요.
댓글 전체
g3군요.
해당 페이지 주소가 없나요?
해당 페이지 주소가 없나요?
쪽지드렸습니다.
여기에 공개를 하시면 더 많은 분이 더 좋은 답변을 주실 겁니다.
g3게시판 페이지 소스 보기하면 다음과 같은 부분이 있습니다.
<form 형식을 참고 하세요.
<table width=100% border=0>
<tr>
<td width=50%>
<a href='./?doc=bbs/gbform.php&w=&bo_table=news'><img src='bbs/skin/board/basic/write.gif' border=0 alt='글쓰기' align=absmiddle></a> </td>
<form name=fsearch method=get action='./'>
<input type=hidden name=doc value='bbs/gnuboard.php'>
<input type=hidden name=bo_table value='news'>
<td width=50% align=right valign=bottom>
<select name=sselect>
<option value='concat(wr_subject,wr_content)'>제목+내용</option>
<option value='wr_name'>이름</option>
<option value='wr_num'>번호</option>
<option value='wr_datetime'>날짜</option>
<option value='wr_subject'>제목</option>
<option value='wr_content'>내용</option>
<option value='wr_hit'>읽음</option>
</select>
<input type=text name=stext size=10 required itemname='검색어' value=''>
<select name=soperator>
<option value='0'>OR</option>
<option value='1'>AND</option>
</select>
<input type=image src='bbs/skin/board/basic/search.gif' border=0 alt='검색' align=absmiddle>
</td>
</form>
</tr>
</table>
g3게시판 페이지 소스 보기하면 다음과 같은 부분이 있습니다.
<form 형식을 참고 하세요.
<table width=100% border=0>
<tr>
<td width=50%>
<a href='./?doc=bbs/gbform.php&w=&bo_table=news'><img src='bbs/skin/board/basic/write.gif' border=0 alt='글쓰기' align=absmiddle></a> </td>
<form name=fsearch method=get action='./'>
<input type=hidden name=doc value='bbs/gnuboard.php'>
<input type=hidden name=bo_table value='news'>
<td width=50% align=right valign=bottom>
<select name=sselect>
<option value='concat(wr_subject,wr_content)'>제목+내용</option>
<option value='wr_name'>이름</option>
<option value='wr_num'>번호</option>
<option value='wr_datetime'>날짜</option>
<option value='wr_subject'>제목</option>
<option value='wr_content'>내용</option>
<option value='wr_hit'>읽음</option>
</select>
<input type=text name=stext size=10 required itemname='검색어' value=''>
<select name=soperator>
<option value='0'>OR</option>
<option value='1'>AND</option>
</select>
<input type=image src='bbs/skin/board/basic/search.gif' border=0 alt='검색' align=absmiddle>
</td>
</form>
</tr>
</table>
네~ 알고 있는데 게시판소스는 그누3에서만 사용이 가능하지 않나요?
저는 다른곳에도 소스를 붙여서 사용하려구요.
근데 아직도 해결을 못했습니다.
제가 보기에는 문제 되는곳이 없어 보이는데.. 생각만큼 잘안되네요.
저는 다른곳에도 소스를 붙여서 사용하려구요.
근데 아직도 해결을 못했습니다.
제가 보기에는 문제 되는곳이 없어 보이는데.. 생각만큼 잘안되네요.
소스는 이것인데 여기서 항목을 검색하는게 안되서 그럽니다
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "STYLE");
if (!$member[mb_id]) {
alert("로그인 하십시오.");
}
$html_title = "PROJECT";
$number = $number;
if ( $number ) $save_option = 'modify';
else $save_option = 'save';
include "./dbconfig.php";
$database = mysql_connect($cfg[mysql_host], $cfg[mysql_user], $cfg[mysql_pass] );
mysql_select_db($cfg[mysql_db], $database);
$query = mysql_query("select * from project
where number = '$number' ", $database);
$row=mysql_fetch_array($query);
$mod_number = $row['number'];
$mod_project_id = $row['project_id'];
$mod_project_title = $row['project_title'];
$mod_project_date = $row['project_date'];
$mod_project_end_date = $row['project_end_date'];
$mod_contents = $row['contents'];
$mod_progress = $row['progress'];
$search_hang = $search_hang;
$search_origin = $search;
$search = "%".$search."%";
if ( $search_hang == '' ) { $search_hang = 'search_id'; }
$query_text = " select * from project order by number desc ";
?>
<script language='javascript'>
function NewWindow(mypage, myname, w, h, scroll) {
var winl = (screen.width - w) / 2;
var wint = (screen.height - h) / 2 - 20;
winprops = 'height='+h+',width='+w+',top='+wint+',left='+winl+',scrollbars='+scroll+',resizable'
win = window.open(mypage, myname, winprops)
if (parseInt(navigator.appVersion) >= 4) { win.window.focus(); }
}
function del(delnumber)
{
if ( confirm( '정말로 삭제하시겠습니까?') )
{
location.href='?doc=project/project_delete.php&number=' + delnumber ;
}
else
{ return ;
}
}
</script>
<div style='padding:10'>
<div align=left style='padding:10;font-size:12pt;font-family:dotum;'><b>프로젝트 List</b></div>
<div align=right style='margin-top:-25px;padding:10;font-size:9pt;font-family:dotum;'><b><a href='?doc=project/project_form.php' onclick="NewWindow(this.href,'project_title','720','500','yes');return false;">프로젝트생성</a></b></div>
<table width='100%' align=center>
<tr>
<?
?>
<form method=post action='?doc=project/project_manager.php'>
<td width=50% align=right><img src='list.gif' border=0 alt='목록' align=absmiddle>
<select name=search_hang>
<option value='search_id' <? if ($search_hang == 'search_id' ) echo "selected"; ?>>개설자</option>
<option value='search_title'<? if ($search_hang == 'search_title' ) echo "selected"; ?>>프로젝트명</option>
<option value='search_date'<? if ($search_hang == 'search_date' ) echo "selected"; ?>>날짜</option>
</select>
<input type=text name=search style='border:1 solid silver;height:20;width:100' value='<?=$search_origin?>' >
<input name=save type=image src='search.gif' border=0 alt='검색' align=absmiddle>
</td></tr></form></table>
<table cellpadding=1 cellspacing=1 bgcolor=ffffff width=100%>
<tr><td align=center bgcolor=ffffff height=23>No</td>
<td align=center bgcolor=ffffff height=23>개설자</td>
<td align=center bgcolor=ffffff height=23>프로젝트명</td>
<td align=center bgcolor=ffffff height=23>세부사항</td>
<td align=center bgcolor=ffffff height=23>프로젝트개설일</td>
<td align=center bgcolor=ffffff height=23>마감일</td>
<td align=center bgcolor=ffffff height=23>진행율</td>
<td align=center bgcolor=ffffff height=23>삭제</td>
</tr>
<tr><td colspan=8 height=1px bgcolor=black></td></tr>
<?
include "./dbconfig.php";
$database = mysql_connect($cfg[mysql_host], $cfg[mysql_user], $cfg[mysql_pass] );
mysql_select_db($cfg[mysql_db], $database);
$query = mysql_query($query_text, $database);
while ( $row=mysql_fetch_array($query) ) {
$number = $row['number'];
$project_title = $row['project_title'];
$project_id = $row['project_id'];
$progress = $row['progress'];
$project_date = $row['project_date'];
$project_end_date = $row['project_end_date'];
$contents = $row['contents'];
if ( !$wr_id ) { $bgcolor = ffffff; }
else { $bgcolor = FFFFff; }
echo "
<div id=number$number style='cursor:hand;'>
<tr>
<td bgcolor=$bgcolor align=center height=24>$number</td>
<td bgcolor=$bgcolor align=center height=24>$project_id</td>
<td bgcolor=$bgcolor align=center height=24><a href='?doc=project/project_manager.php&number=$number'>$project_title</a></td>
<td bgcolor=$bgcolor align=left height=24><pre>$contents</pre></td>
<td bgcolor=$bgcolor align=center height=24>$project_date</td>
<td bgcolor=$bgcolor align=center height=24>$project_end_date</td>
<td bgcolor=$bgcolor align=center height=24>$progress %</td>
<td align=center><a href='javascript:del($number);'><img src=\"bbs/skin/board/imp/icon_delete.gif\" border=0></a></td>
</tr>
</div>
";
}
?>
</table>
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "STYLE");
if (!$member[mb_id]) {
alert("로그인 하십시오.");
}
$html_title = "PROJECT";
$number = $number;
if ( $number ) $save_option = 'modify';
else $save_option = 'save';
include "./dbconfig.php";
$database = mysql_connect($cfg[mysql_host], $cfg[mysql_user], $cfg[mysql_pass] );
mysql_select_db($cfg[mysql_db], $database);
$query = mysql_query("select * from project
where number = '$number' ", $database);
$row=mysql_fetch_array($query);
$mod_number = $row['number'];
$mod_project_id = $row['project_id'];
$mod_project_title = $row['project_title'];
$mod_project_date = $row['project_date'];
$mod_project_end_date = $row['project_end_date'];
$mod_contents = $row['contents'];
$mod_progress = $row['progress'];
$search_hang = $search_hang;
$search_origin = $search;
$search = "%".$search."%";
if ( $search_hang == '' ) { $search_hang = 'search_id'; }
$query_text = " select * from project order by number desc ";
?>
<script language='javascript'>
function NewWindow(mypage, myname, w, h, scroll) {
var winl = (screen.width - w) / 2;
var wint = (screen.height - h) / 2 - 20;
winprops = 'height='+h+',width='+w+',top='+wint+',left='+winl+',scrollbars='+scroll+',resizable'
win = window.open(mypage, myname, winprops)
if (parseInt(navigator.appVersion) >= 4) { win.window.focus(); }
}
function del(delnumber)
{
if ( confirm( '정말로 삭제하시겠습니까?') )
{
location.href='?doc=project/project_delete.php&number=' + delnumber ;
}
else
{ return ;
}
}
</script>
<div style='padding:10'>
<div align=left style='padding:10;font-size:12pt;font-family:dotum;'><b>프로젝트 List</b></div>
<div align=right style='margin-top:-25px;padding:10;font-size:9pt;font-family:dotum;'><b><a href='?doc=project/project_form.php' onclick="NewWindow(this.href,'project_title','720','500','yes');return false;">프로젝트생성</a></b></div>
<table width='100%' align=center>
<tr>
<?
?>
<form method=post action='?doc=project/project_manager.php'>
<td width=50% align=right><img src='list.gif' border=0 alt='목록' align=absmiddle>
<select name=search_hang>
<option value='search_id' <? if ($search_hang == 'search_id' ) echo "selected"; ?>>개설자</option>
<option value='search_title'<? if ($search_hang == 'search_title' ) echo "selected"; ?>>프로젝트명</option>
<option value='search_date'<? if ($search_hang == 'search_date' ) echo "selected"; ?>>날짜</option>
</select>
<input type=text name=search style='border:1 solid silver;height:20;width:100' value='<?=$search_origin?>' >
<input name=save type=image src='search.gif' border=0 alt='검색' align=absmiddle>
</td></tr></form></table>
<table cellpadding=1 cellspacing=1 bgcolor=ffffff width=100%>
<tr><td align=center bgcolor=ffffff height=23>No</td>
<td align=center bgcolor=ffffff height=23>개설자</td>
<td align=center bgcolor=ffffff height=23>프로젝트명</td>
<td align=center bgcolor=ffffff height=23>세부사항</td>
<td align=center bgcolor=ffffff height=23>프로젝트개설일</td>
<td align=center bgcolor=ffffff height=23>마감일</td>
<td align=center bgcolor=ffffff height=23>진행율</td>
<td align=center bgcolor=ffffff height=23>삭제</td>
</tr>
<tr><td colspan=8 height=1px bgcolor=black></td></tr>
<?
include "./dbconfig.php";
$database = mysql_connect($cfg[mysql_host], $cfg[mysql_user], $cfg[mysql_pass] );
mysql_select_db($cfg[mysql_db], $database);
$query = mysql_query($query_text, $database);
while ( $row=mysql_fetch_array($query) ) {
$number = $row['number'];
$project_title = $row['project_title'];
$project_id = $row['project_id'];
$progress = $row['progress'];
$project_date = $row['project_date'];
$project_end_date = $row['project_end_date'];
$contents = $row['contents'];
if ( !$wr_id ) { $bgcolor = ffffff; }
else { $bgcolor = FFFFff; }
echo "
<div id=number$number style='cursor:hand;'>
<tr>
<td bgcolor=$bgcolor align=center height=24>$number</td>
<td bgcolor=$bgcolor align=center height=24>$project_id</td>
<td bgcolor=$bgcolor align=center height=24><a href='?doc=project/project_manager.php&number=$number'>$project_title</a></td>
<td bgcolor=$bgcolor align=left height=24><pre>$contents</pre></td>
<td bgcolor=$bgcolor align=center height=24>$project_date</td>
<td bgcolor=$bgcolor align=center height=24>$project_end_date</td>
<td bgcolor=$bgcolor align=center height=24>$progress %</td>
<td align=center><a href='javascript:del($number);'><img src=\"bbs/skin/board/imp/icon_delete.gif\" border=0></a></td>
</tr>
</div>
";
}
?>
</table>
소스가 좀...
$query_text = " select * from project order by number desc ";
이 부분을 아래와 같이 한번 해 보세요.
$query_text = " select * from project where $search_hang = %".$search."% order by number desc ";
$query_text = " select * from project order by number desc ";
이 부분을 아래와 같이 한번 해 보세요.
$query_text = " select * from project where $search_hang = %".$search."% order by number desc ";