만든이 : i_co
Daun..
2011 09 02.
폴더트리가 이렇게 되어야 합니다.
htdocs -(폴더)homepage - (폴더) login - dbcon.php
- login.html
- login.php
- loginJoin.html
- loginJoin.php
- (폴더) board - board.php
- boardRead.php
- boardWrite.html
-boardWrite.php
- dbcon.php
- homepage.html
- menu.html
dbcon.php
<?
$dbc = mysql_connect("localhost","root","apmsetup");
mysql_select_db("homepage");
?>
login.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<form method = "get" action = "login.php">
<table>
<tr>
<td>
아 이 디 :
</td>
<td>
<input type = "text" name = "id">
</td>
</tr>
<tr>
<td>
비 밀 번 호 :
</td>
<td>
<input type = "password" name = "password">
</td>
</tr>
<tr>
<td>
<input type = "submit" value = "로그인">
</form>
</td>
<td>
<form method = "get" action = "loginJoin.html">
<input type = "submit" value = "회원가입">
</form>
</td>
</tr>
</table>
</BODY>
</HTML>
login.php
<?php
include 'dbcon.php';
$ID = $_GET['id'];
$PASSWORD = $_GET['password'];
$query = "SELECT * FROM login";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
$correct = 0;
$dbid = $row['id'];
$dbpassword = $row['password'];
if($ID == $dbid)
{
if($dbpassword == $PASSWORD)
{
$correct=1;
break;
}
}
}
if($correct == 0)
{
?>
<script language = "javascript">
<!--
window.location = "login.html";
alert("아이디를 잘못 입력하셧습니다.");
//-->
</script>
<?php
}
else
echo("로그인 완료");
?>
loginJoin.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<form action = "loginJoin.php" method = "get">
<table>
<tr>
<td>
아이디 :
</td>
<td>
<input type = "text" name = "id">
</td>
</tr>
<tr>
<td>
비밀번호 :
</td>
<td>
<input type = "text" name = "password">
</td>
</tr>
<tr>
<td>
<input type = "submit" value = "작성완료">
</td>
<td>
<input type = "reset" value = "다시작성">
</td>
</tr>
</table>
</form>
</BODY>
</HTML>
loginJoin.php
<?php
include 'dbcon.php';
$ID = $_GET['id'];
$PASSWORD = $_GET['password'];
$query = "INSERT INTO login VALUE('$ID','$PASSWORD')";
mysql_query($query);
?>
<script language = "javascript">
window.location = "login.html"
alert = ("회원가입 완료. 다시 로그인 해주세요.");
</script>
board.php
<?php
include 'dbcon.php'
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<h1>게시판 </h1>
- 게시판 입니다.
<table>
<tr>
<td width = "80">
글 번호
</td>
<td width = "300">
글 제목
</td>
<td width = "80">
글쓴이
</td>
</tr>
<?php
$query = "SELECT * FROM board ORDER BY number DESC";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
$number = $row['number'];
$title = $row['title'];
$name = $row['name'];
echo("<tr><td>$number</td><td><a href = 'http://localhost/homepage/board/boardRead.php?number=$number'>$title</a></td><td>$name</td></tr>");
}
?>
<form method = "post" action = "boardWrite.html">
<input type = "submit" value = "글쓰기">
</form>
</table>
</BODY>
</HTML>
boardRead.php
<?php
include 'dbcon.php';
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<?php
$NUMBER = $_GET['number'];
$query = "SELECT * FROM board where number='$NUMBER'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$number = $row['number'];
$title = $row['title'];
$name = $row['name'];
$text = $row['text'];
?>
<h1>
글 읽기
</h1>
<table>
<tr>
<td>
글번호 :
</td>
<td>
<?php echo("$number")?>
</td>
</tr>
<tr>
<td>
제목 :
</td>
<td>
<?php echo("$title")?>
</td>
</tr>
<tr>
<td>
글쓴이 :
</td>
<td>
<?php echo("$name")?>
</td>
</tr>
<tr>
<td>
내용 :
</td>
<td>
<?php echo("$text")?>
</td>
</tr>
</table>
</BODY>
</HTML>
boardWrite.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<h1>
글쓰기
</h1>
-글을 쓰는 페이지 입니다.
<form action = "boardWrite.php" method = "get">
<table>
<tr>
<td>
제목
</td>
<td>
<input type = "text" name = "title" value = "제목을적으세요" maxlength = "30">
</td>
</tr>
<tr>
<td>
작성자
</td>
<td>
<input type = "text" name = "name" value = "이름" maxlength = "10">
</td>
</tr>
<tr>
<td>
글 내용
</td>
<td>
<textarea cols = 80" rows = "40" name = "text">
입력해주세요
</textarea>
</td>
</tr>
<tr>
<td>
<input type = "submit" value = "작성완료">
</td>
<td>
<input type = "reset" value = "다시작성">
</td>
</tr>
</table>
</form>
</BODY>
</HTML>
boardWrite.php
<?php
include 'dbcon.php';
$TITLE = $_GET['title'];
$NAME = $_GET['name'];
$TEXT = $_GET['text'];
$query = "SELECT * FROM board ORDER BY number DESC";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$NUMBER = $row['number'];
$NUMBER++;
$query = "INSERT INTO board VALUE('$NUMBER','$TITLE','$NAME','$TEXT')";
mysql_query($query);
?>
<html>
<body>
<script language = "javascript">
window.location="board.php"
</script>
</body>
</html>
homepage.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<frameset rows = "50,*" border = "0" noresize>
<frame name = "title">
<frameset cols = "400,*">
<frameset rows = "150,*">
<frame src = "login/login.html" name = "login">
<frame name = "ad">
</frameset>
<frameset rows = "100,*">
<frame src = "menu.html" name = "menu">
<frame name = "middle">
</frameset>
</frameset>
</frameset>
</HTML>
menu.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<a href = "board/board.php" target = "middle">
게시판
</a>
</BODY>
</HTML>
--------------------------
애초에 나름 심혈을 기울여서 만든거는 다 훌렁훌렁 포맷과 함께 날려버리고
결국 하루를 다시 더 투자하여 복구해놓은것..
기타 그냥 링크따위는 중요한거 같지 않아서
그냥 게시판과 로그인 기능만 만들었다.
javascript와 css를 아직 사용하지 않은 것이 걸리지만..
홈페이지를 두번이나 만들면서 진을 다 뺀거 같기에..
당분간 보류..
조만간 수정을 보게되면 좀더 이쁜 홈페이지로 돌아오겟지..
여기서 실행시켜야할것은 homepage.html입니다~!!
get타입이라 보완에 취약.
mysql이용~!
database homepage;
create table board(number int, title varchar(30),name varchar(10),text varchar(3200));
create table login(id varchar(10),password varchar(20));
insert into board values('0','hello','daun','heloo');
가 DB에 선언되어 있어야함.!
'Code > web' 카테고리의 다른 글
[web]php 쿠키설정 (0) | 2012.01.21 |
---|