list.html
위치:추가목록-블럭페이지수 칼라&크기 변경
for($go_page=$first_page+1;$go_page<=$last_page;$go_page++){
//블럭페이지수 칼라&크기 변경 *시작
if($go_page==$page){
echo [<a href=list.html?page=$go_page><font color=red><b>$go_page</b></font></a>];//go_page:현재페이지
}else{
echo [<a href=list.html?page=$go_page>$go_page</a>];
}
//블럭페이지수 칼라&크기 변경 *끝
}
search.html
위치:자료검색후 링크연결
<?
while($row=mysql_fetch_array($result)){
echo <tr>
<td>$article_num</td>
<td><a href=view.html?num=$row[num]&mode=search>$row[subject]</a></td>
<td>$row[num]</td>
<td>$row[name]</td>
<td>$row[subject]</td>
<td>$row[reg_date]</td>
<td>$row[cnt]</td>
</tr>;
$article_num--;
}
?>
:::::::::::::::::::::::::
view.html
위치:
<tr>
<td>글쓴날짜</td>
<td><?echo $row[reg_date];?> </td>
<td>접속IP</td>
<td><?echo $row[userip];?> </td>
</tr>
</table>
<br>
<?
if($mode==search){
?>
<a href=javascript:history.back();>
검색리스트</a>
<?
}
?>
<a href=list.html>리스트</a>
<a href=modifycheck.html?num=<?echo $num;?>>수 정</a>
:::::::::::::::::::::::::::::::::::
-관련소스 전체보기
파일명: list.html
<HTML>
<HEAD>
<style type= ext/css>
<link rel=stylesheet type= ext/css href=my.css>
a {text-decoration:none;}
.my1 {font-weight: bold; color:olive;}
</style>
<TITLE> New Document </TITLE>
</HEAD>
<BODY>
<br>
<font color=#006666 size=5>
MyBoard ver 1.0
</font>
<br>
<table border=1 width=700>
<tr>
<td>번 호</td>
<td>제 목</td>
<td>이 름</td>
<td>등록날짜</td>
<td>조회수</td>
</tr>
<?
include connect.php;
$query=select count(*) from board1;
$result=mysql_query($query);
$total_record=mysql_result($result,0,0);
$num_per_page=5; //페이지나누기***
$total_page=ceil($total_record/$num_per_page);
//페이지나눔 *시작
if(!$page){$page=1;}//페이지변수초기화
$first=($page-1) * $num_per_page;
// (1-1)*10 (2-1)*10 (3-1)*10
//0,10,20,30
//자동순서로출력하기
$article_number=$total_record-$first;
$query=select * from board1 order by num desc limit $first,$num_per_page;
$result=mysql_query($query);
while($row=mysql_fetch_array($result)){
$subject=stripslashes($row[subject]);
echo <tr>
<!--<td>$row[num]</td>-->
<td>$article_number</td>
<td><a href=view.html?num=$row[num]>$subject</a></td>
<td>$row[name]</td>
<td>$row[reg_date]</td>
<td>$row[cnt]</td>
</tr>;
$article_number--;// $atricle_number=$article_number-1;
}
?>
<!--
<tr>
<td></td>
<td><?echo $row[reg_date];?> </td>
<td>접속IP</td>
<td><?echo $row[userIp];?> </td>
</tr>
-->
</table>
<br>
<!--페이지나눔 *시작 -->
<?
/*
for($i=1;$i<=$total_page;$i++){
echo [<a href=list.html?page=$i>$i</a>];
}
*/
?>
<?
//<!--페이지나눔 *끝 -->
//<!--페이지블럭나눔 *시작 -->
$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 lock --- $block<br>;
//echo otal_block --- $total_block<br>;
//echo otal_page --- $total_page<br>;
if($block>=$total_block){
$prev=$first_page;
echo [<a href=list.html?page=1>처음</a>];
echo [<a href=list.html?page=$prev>이전</a>];
}
for($go_page=$first_page+1;$go_page<=$last_page;$go_page++){
//블럭페이지수 칼라&크기 변경 *시작
if($go_page==$page){
echo [<a href=list.html?page=$go_page><font color=red><b>$go_page</b></font></a>];//go_page:현재페이지
}else{
echo [<a href=list.html?page=$go_page>$go_page</a>];
}
//블럭페이지수 칼라&크기 변경 *끝
}
if($block<$total_block){
$next=$last_page+1;
echo [<a href=list.html?page=$next>다음</a>];
echo [<a href=list.html?page=$total_page>마지막</a>];
}
?>
<a href=write.html><!--img src=http://www.pcall.co.kr/img/90.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>
</HTML>
:::::::::::::::::::::::::::::::::
파일명: search.html
<!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN>
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
</HEAD>
<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);
$article_num=mysql_num_rows($result);//검색시 순서를 1번부터 출력
echo 검색된 게시물 갯수 --- $article_num<br>;//검색시 출력된갯수파악
?>
<font size=5 color=#ff0000>검색된 게시물</font>
<table border=1 width=700>
<tr>
<td>갯수</td>
<td>번호</td>
<td>이름</td>
<td>제목</td>
<td>등록날짜</td>
<td>조회수</td>
</tr>
<?
while($row=mysql_fetch_array($result)){
echo <tr>
<td>$article_num</td>
<td><a href=view.html?num=$row[num]&mode=search>$row[subject]</a></td>
<td>$row[num]</td>
<td>$row[name]</td>
<td>$row[subject]</td>
<td>$row[reg_date]</td>
<td>$row[cnt]</td>
</tr>;
$article_num--;
}
?>
</table>
<br>
<a href=javascript:history.back();>이전</a>
</BODY>
</HTML>
::::::::::::::::::::::::::::::::
파일명: view.html
<html>
<body>
<br>
<br>
<?
echo 넘어온 글번호 --- $num<br>;
include connect.php;
//조회수 증가
$query=update board1 set cnt=cnt+1 where num=$num\;
$result=mysql_query($query);
$query=select * from board1 where num=$num\;
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$content=nl2br($row[content]);
?>
<table border=1 width=700>
<tr>
<td>이 름</td>
<td><?= $row[name];?> </td>
<td>조회수</td>
<td><?= $row[cnt];?> </td>
</tr>
<tr>
<td>이메일</td>
<td><?echo $row[email];?> </td>
<td>홈페이지</td>
<td><?echo $row[hpage];?> </td>
</tr>
<tr>
<td>제 목</td>
<td colspan=3><?echo $row[subject];?> </td>
</tr>
<tr>
<td colspan=4 height=200>
<?echo $content;?>
</td>
</tr>
<tr>
<td>글쓴날짜</td>
<td><?echo $row[reg_date];?> </td>
<td>접속IP</td>
<td><?echo $row[userip];?> </td>
</tr>
</table>
<br>
<?
if($mode==search){
?>
<a href=javascript:history.back();>
검색리스트</a>
<?
}
?>
<a href=list.html>리스트</a>
<a href=modifycheck.html?num=<?echo $num;?>>수 정</a>
<a href=deletecheck.html?num=<?echo $num;?>>삭 제</a>
<hr color=orange align=left width=700>
<form method=post action=memoinput.php?num=<?echo $num;?>>
<table border=1 width=700>
<tr>
<td width=150>이 름</td>
<td><input type=text name=memoname></td>
<td width=150>비밀번호</td>
<td><input type=password name=memopass></td>
</tr>
<tr>
<td width=150>메 모</td>
<td colspan=2><input type=text name=memo size=60></td>
<td><input type=submit value=입력></td>
</tr>
</table>
<br>
<table border=1 width=700>
<tr>
<td>이 름</td>
<td>메 모</td>
<td>삭 제</td>
</tr>
<?
$query=select * from memo where pid=$num order by step asc;
$result=mysql_query($query);
while($row=mysql_fetch_array($result)){
echo <tr>
<td>$row[memoname]</td>
<td>$row[memo]</td>
<td><a href=memodelcheck.html?num=$num&step=$row[step]>삭제</a></td>
</tr>;
}
?>
<!--//$query=select * from memo where pid=$num order by step desc;-->
</table>
</body>
</html>
PHP스터디 2004 12 14
소스자세히 정확하게보기
(더자세히는 해당문서에서 오른쪽마우스로 소스보기하세요)
http://www.6VJ.com/php/php1214.txt
| 
방송
