2011. 9. 3. 00:35

[html+php+mysql]홈페이지 만들기.

Code/web

만든이 : 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
Posted by I_co

티스토리툴바