PHP - 열일곱째날 (1213) 게시판 - 검색조회 list.html - 추가소스 글쓰기
***파일명: search.html
"; echo "search --- $search
"; $query="select * from board1 ";//공백 " $endquery=" order by num desc";//" 공백 if($choice == "name"){ $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); ?> 검색된 게시물 "; } ?>
번호 이름 제목 등록날짜 조회수
$row[num] $row[name] $row[subject] $row[reg_date] $row[cnt]
::::::::::::::::::::::::::::::::::::: New Document
MyBoard ver 1.0
"; $article_number--;// $atricle_number=$article_number-1; } ?>
번 호 제 목 이 름 등록날짜 조회수
$article_number $subject $row[name] $row[reg_date] $row[cnt]

$i]"; } */ ?> // $num_per_block=5; //블럭나누기*** $total_block=ceil($total_page/$num_per_block); //토탈페이지 $block=ceil($page/$num_per_block); //현재블럭 // 23/10=2.3 ->3 $first_page=$num_per_block *($block-1);//첫 끝페이지값구함 $last_page=$num_per_block * $block; //마지막페이지 if($block>=$total_block){ $last_page=$total_page; } //echo "block --- $block
"; //echo "total_block --- $total_block
"; //echo "total_page --- $total_page
"; if($block>=$total_block){ $prev=$first_page; echo "[처음]"; echo "[이전]"; } for($go_page=$first_page+1;$go_page<=$last_page;$go_page++){ echo "[$go_page]"; } if($block<$total_block){ $next=$last_page+1; echo "[다음]"; echo "[마지막]"; } ?> 글쓰기
::::::::::::::::::::::::::::::::::::::::::::::::: list.html---------------------------- New Document
MyBoard ver 1.0
"; $article_number--;// $atricle_number=$article_number-1; } ?>
번 호 제 목 이 름 등록날짜 조회수
$article_number $subject $row[name] $row[reg_date] $row[cnt]

$i]"; } */ ?> // $num_per_block=5; //블럭나누기*** $total_block=ceil($total_page/$num_per_block); //토탈페이지 $block=ceil($page/$num_per_block); //현재블럭 // 23/10=2.3 ->3 $first_page=$num_per_block *($block-1);//첫 끝페이지값구함 $last_page=$num_per_block * $block; //마지막페이지 if($block>=$total_block){ $last_page=$total_page; } //echo "block --- $block
"; //echo "total_block --- $total_block
"; //echo "total_page --- $total_page
"; if($block>=$total_block){ $prev=$first_page; echo "[처음]"; echo "[이전]"; } for($go_page=$first_page+1;$go_page<=$last_page;$go_page++){ echo "[$go_page]"; } if($block<$total_block){ $next=$last_page+1; echo "[다음]"; echo "[마지막]"; } ?> 글쓰기
::::::::::::::::::::::::::::::::::::::::::::::::: ***search.html---------------------------- New Document
"; echo "search --- $search
"; $query="select * from board1 ";//공백 " $endquery=" order by num desc";//" 공백 if($choice == "name"){ $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); $article_num=mysql_num_rows($result);//검색시 순서를 1번부터 출력 echo "검색된 게시물 갯수 --- $article_num
";//검색시 출력된갯수파악 ?> 검색된 게시물 "; $article_num--; } ?>
갯수 번호 이름 제목 등록날짜 조회수
$article_num $row[num] $row[name] $row[subject] $row[reg_date] $row[cnt]