list.html 위치:추가목록-블럭페이지수 칼라&크기 변경 for($go_page=$first_page+1;$go_page<=$last_page;$go_page++){ //블럭페이지수 칼라&크기 변경 *시작 if($go_page==$page){ echo "[$go_page]";//go_page:현재페이지 }else{ echo "[$go_page]"; } //블럭페이지수 칼라&크기 변경 *끝 } search.html 위치:자료검색후 링크연결 $article_num $row[subject] $row[num] $row[name] $row[subject] $row[reg_date] $row[cnt] "; $article_num--; } ?> ::::::::::::::::::::::::: view.html 위치: 글쓴날짜   접속IP  
검색리스트 리스트    >수 정 ::::::::::::::::::::::::::::::::::: -관련소스 전체보기 파일명: 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++){ //블럭페이지수 칼라&크기 변경 *시작 if($go_page==$page){ echo "[$go_page]";//go_page:현재페이지 }else{ 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[subject] $row[num] $row[name] $row[subject] $row[reg_date] $row[cnt]

이전 :::::::::::::::::::::::::::::::: 파일명: view.html

"; 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]); ?>
이 름   조회수  
이메일   홈페이지  
제 목  
 
글쓴날짜   접속IP  

검색리스트 리스트    >수 정    >삭 제
>
이 름 비밀번호
메 모

"; } ?>
이 름 메 모 삭 제
$row[memoname] $row[memo] 삭제
:::::::::::::::::::::::::::::::::::::::::::::::: -MYSQL------------------------------------- Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. C:\Documents and Settings\Administrator>cd \ C:\>mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 to server version: 4.0.22-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +------------+ | Database | +------------+ | appledb | | bananadb | | grapedb | | index_test | | jsptestdb | | mysql | | test | +------------+ 7 rows in set (0.01 sec) mysql> mysql> use appledb; Database changed mysql> show tables; +-------------------+ | Tables_in_appledb | +-------------------+ | aaa | | bd_02 | | bd_3 | | board | | board1 | | memo | | mymemo | +-------------------+ 7 rows in set (0.00 sec) mysql> mysql> select subject from board1 limit 10; +-----------------------+ | subject | +-----------------------+ | subject | | subject | | wrgs | | 테스트 | | 111111111111111 | | 222222222222 | | 333333333333333333333 | | sfgfg | | rtyrty | | ggdfgg | +-----------------------+ 10 rows in set (0.00 sec) mysql> mysql> mysql> exit Bye C:\>mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 74 to server version: 4.0.22-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> mysql> mysql> show databases; +------------+ | Database | +------------+ | appledb | | bananadb | | grapedb | | index_test | | jsptestdb | | mysql | | test | +------------+ 7 rows in set (0.00 sec) mysql> mysql> mysql> show databases; +------------+ | Database | +------------+ | 6vjcom | | appledb | | bananadb | | grapedb | | index_test | | jsptestdb | | mysql | | test | +------------+ 8 rows in set (0.00 sec) mysql> mysql> show databases; +------------+ | Database | +------------+ | 6vjcom | | appledb | | bananadb | | grapedb | | index_test | | jsptestdb | | mysql | | test | +------------+ 8 rows in set (0.01 sec) mysql> mysql> use 6vjcom Database changed mysql> show tables; +--------------------+ | Tables_in_6vjcom | +--------------------+ | agreement | | app09 | | auc_apps | | auc_goods | | auc_part | | auth | | bank | | board09 | | board_112 | | board_city | | board_family | | board_ijournal | | board_journal | | board_neighbor | | board_scratch | | buy_list | | com_info | | goods | | goods09 | | guestbook | | imsi_buy | | maker_logo | | member | | motor | | news_actor | | news_animal | | news_debut | | news_display | | news_economy | | news_gallery | | news_health | | news_history | | news_human | | news_international | | news_models | | news_museum | | news_musiction | | news_nataure | | news_politi | | news_record | | news_science | | news_society | | news_stars | | news_tallent | | notice | | part_info | | pds | | postcode | | wwwuser | +--------------------+ 49 rows in set (0.00 sec) mysql> mysql> select * from bank; Empty set (0.00 sec) mysql> select * from notice; Empty set (0.00 sec) mysql> select * from part_info; Empty set (0.00 sec) mysql> mysql> select * from wwwuser; Empty set (0.00 sec) mysql> mysql> PHP스터디 2004 12 14 소스자세히 정확하게보기 (더자세히는 해당문서에서 오른쪽마우스로 소스보기하세요) http://www.6VJ.com/php/php1214.txt