PHP - 열일곱째날 (1213)
게시판 - 검색조회
list.html - 추가소스
<a href=write.html><!--img src=http://www.pcall.co.kr/img/88.gif border=0 width=70 height=50-->글쓰기</a>
<!--검색조회1213 *시작-->
<br><hr>
<form method=post action=search.html>
<select name=choice>
<option value=name>이름
<option value=subject>제목
<option value=content>내용
</select>
<input type=text name=search>
<input type=submit value=전송>
</form>
<!--검색조회1213 *끝-->
</BODY>
<BODY>
<br>
<?
//파일명: search.html
echo choice --- $choice<br>;
echo search --- $search<br>;
$query=select * from board1 ;//공백
$endquery= order by num desc;// 공백
if($choice ==
ame){
$fullquery=$query . where name=$search\ . $endquery;
}else if($choice == subject) {
$fullquery=$query . where subject like \%$search%\ . $endquery;
}else if($choice == content) {
$fullquery=$query . where content like \%$search%\ . $endquery;
}
include connect.php;
$result=mysql_query($fullquery);
?>
<font size=5 color=#ff0000>검색된 게시물</font>
<table border=1 width=700>
<tr>
<td>번호</td>
<td>이름</td>
<td>제목</td>
<td>등록날짜</td>
<td>조회수</td>
</tr>
<?
while($row=mysql_fetch_array($result)){
echo <tr>
<td>$row[num]</td>
<td>$row[name]</td>
<td>$row[subject]</td>
<td>$row[reg_date]</td>
<td>$row[cnt]</td>
</tr>;
}
?>
</table>
</BODY>
php스터디 2004 12 13
소스에러없이 보기
http://www.6VJ.com/php/php1213.txt
| 
방송
