프로젝트

** myadmin db 에서 비우기 : delete // 삭제 : drop

구성

- 폴더

- db

CREATE TABLE member (
	id varchar(20) NOT NULL,
	pass varchar(20) NOT NULL,
	name varchar(20) DEFAULT '',
	email varchar(50) DEFAULT '',
	level varchar(4) DEFAULT '1',
	PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;


CREATE TABLE notice (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `id` varchar(16) NOT NULL DEFAULT '',
  `name` varchar(20) NOT NULL DEFAULT '',
  `subject` varchar(100) NOT NULL DEFAULT '',
  `comment` text,
  `signdate` varchar(30) DEFAULT '',
  `ref` int(11) DEFAULT '0',
  `gongji` enum('1','2','3') DEFAULT '2',
  `file1` varchar(40) DEFAULT '',
  `file1_o` varchar(40) DEFAULT '',
  `file1_s` varchar(40) DEFAULT '',
  `fid` int(11) default 0,
  `thread` varchar(20) DEFAULT '',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

CREATE TABLE qna (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `id` varchar(16) NOT NULL DEFAULT '',
  `name` varchar(20) NOT NULL DEFAULT '',
  `subject` varchar(100) NOT NULL DEFAULT '',
  `comment` text,
  `signdate` varchar(30) NOT NULL DEFAULT '',
  `ref` int(11) NOT NULL DEFAULT '0',
  `gongji` enum('1','2','3') NOT NULL DEFAULT '2',
  `file1` varchar(40) NOT NULL DEFAULT '',
  `file1_o` varchar(40) NOT NULL DEFAULT '',
  `file1_s` varchar(40) NOT NULL DEFAULT '',
  `fid` int(11),
  `thread` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

CREATE TABLE gallery (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `id` varchar(16) NOT NULL DEFAULT '',
  `name` varchar(20) NOT NULL DEFAULT '',
  `subject` varchar(100) NOT NULL DEFAULT '',
  `comment` text,
  `signdate` varchar(30) NOT NULL DEFAULT '',
  `ref` int(11) NOT NULL DEFAULT '0',
  `gongji` enum('1','2','3') NOT NULL DEFAULT '2',
  `file1` varchar(40) NOT NULL DEFAULT '',
  `file1_o` varchar(40) NOT NULL DEFAULT '',
  `file1_s` varchar(40) NOT NULL DEFAULT '',
  `fid` int(11),
  `thread` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

CREATE TABLE comment (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `tb_table` varchar(20) NOT NULL DEFAULT '',
  `tb_uid` int(11) ,
  `tb_id` varchar(20) NOT NULL DEFAULT '',
  `tb_name` varchar(10) NOT NULL DEFAULT '',
  `tb_comment` text,
  `tb_date` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

index.php

<? 
include $DOCUMENT_ROOT.("C:/APM_Setup/htdocs/include/header.php"); //절대경로 처리 
?>

<table width=100% border=0 class="min-hei">
	<tr>
		<td align=center>인덱스 내용</td>
	</tr> 
</table>


<? include $DOCUMENT_ROOT.("C:/APM_Setup/htdocs/include/footer.php"); ?>

include dir

- header.php

<? session_start(); // 세션을 초기화 합니다. (세션을 쓰겠다라고 알려주는 역할) ?>
<? include $DOCUMENT_ROOT.("C:/APM_Setup/htdocs/include/dbcon.php"); //절대경로 처리 ?>

<!doctype html>
<html>
<head>
	<meta charset="utf-8">
	<title>akdaldboard</title>
	<link href="/img/dancepkt.ico" rel="shortcut icon" type="image/x-icon"> <? //블로그이름 옆에 이미지 띄움 ?>
	<link rel="stylesheet" href="/aaa/css/basic.css">
</head>
<body>

session id : <?=$_SESSION['id']?><br>
session name : <?=$_SESSION['name']?><br>
session level : <?=$_SESSION['level']?><br>

<table width=100% height=50 border=0>
	<tr>
		<td>
			<a href="/aaa/"><img src="/img/gift2.png" width="100"></a>
		</td>
		<td align=right>
			<?if($_SESSION['id'] == ""){?>
				<a href="/member/login.php">[로그인]</a>
				<a href="/member/join.php">[회원가입]</a>
			<?}else{?>
				<a href="/member/logout.php">[로그아웃]</a>
				<a href="/member/joinup.php">[회원수정]</a>
			<?}?>
		</td>
	</tr>
</table>
<div style="border-top:1px solid #ccc"></div>

- footer.php

<div style="border-top:1px solid #ccc"></div>
<table width=100% height=50 border=0>
	<tr>
		<td align=center>카피라이터</td>
	</tr>
</table>

</body>
</html>

- dbcon.php

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

<?
// 데이터베이스 연결설정 인자 (서버명, 사용자명, 비밀번호, 데이터베이스명)
$host= "localhost";
$user= "root"; 
$password= "apmsetup";
$db= "test"; 

// 데이터베이스에 연결한다.
$conn = @mysql_connect($host,$user,$password);
if(!$conn) {
   echo "데이터베이스 연결실패";
   exit;
}

// 작업대상 데이터베이스를 선택한다.
$dbnum = mysql_select_db($db,$conn);

mysql_query("set names utf8");

if(!$dbnum) {
   echo "데이터베이스 선택실패";
   exit;
}
?>

css dir

- basic.css

@charset "utf-8";

html,body {
	margin:0;padding:0;font-size:11px;font-family:dotum;
}

table, td{
	border-spacing: 0px;
}

a {
	text-decoration: none;
}

.min-hei{
	min-height:100px;
}

member dir

- join.php

<? include $DOCUMENT_ROOT.("C:/APM_Setup/htdocs/include/header.php"); //절대경로 처리 ?>

<style>
.table_title {
	font-weight:bold;
	font-size:14px;
}

input {
	width:98%;
}
</style>


<table width=100% border=0>
	<tr>
		<td></td>
		<td align=center width=500>
			<form action="join_insert.php" method="post">
			<table width=100% border=1 class="min-hei">
				<tr>
					<td colspan=2 align=center class="table_title">회원가입</td>
				</tr>
				<tr>
					<td>아이디</td>
					<td><input name="id" value=""></td>
				</tr>
				<tr>
					<td>비밀번호</td>
					<td><input name="pass" value=""></td>
				</tr>
				<tr>
					<td>이름</td>
					<td><input name="name" value=""></td>
				</tr>
				<tr>
					<td>메일주소</td>
					<td><input name="email" value=""></td>
				</tr>
				<tr>
					<td colspan=2 align=center>
						<button>가입하기</button>
					</td>
				</tr>
			</table>
			</form>
		</td>
		<td></td>
	</tr>
</table>

<? include $DOCUMENT_ROOT.("C:/APM_Setup/htdocs/include/footer.php"); ?>

- join_insert.php

<? include $DOCUMENT_ROOT.("C:/APM_Setup/htdocs/include/header.php"); //절대경로 처리 ?>

<?
$id = $_POST[id]; // "" '' 없음 세개 다 가능
$pass = $_POST["pass"];
$name = $_POST[name];
$email = $_POST[email];

//회원 존재 여부
$query = "select count(*) as cnt from member where id = '$id'";
$result = mysql_query($query);
$rows = mysql_fetch_array($result);
$total_record = $rows[cnt];

if($total_record != 0){ //아이디 존재
?>
	<script>
		alert("존재하는 아이디 입니다.");
		history.back();  
	</script>
<?
}else{
	$query = "insert into member (id,pass,name,email) values ('$id','$pass','$name','$email')";
	mysql_query($query);
?>
	<script>
		alert("회원가입을 축하합니다.");
		location.href="/"; // index로 이동
	</script>
<?
}
?>

- login.php

<? include $DOCUMENT_ROOT.("C:/APM_Setup/htdocs/include/header.php"); //절대경로 처리 ?>

<style>
.table_title {
	font-weight:bold;
	font-size:14px;
}

input {
	width:98%;
}
</style>

<table width=100% border=0>
	<tr>
		<td></td>
		<td align=center width=500>
			<form action="login_ok.php" method="post">
			<table width=100% border=1 class="min-hei">
				<tr>
					<td colspan=2 align=center class="table_title">로그인</td>
				</tr>
				<tr>
					<td>아이디</td>
					<td><input name="id" value=""></td>
				</tr>
				<tr>
					<td>비밀번호</td>
					<td><input name="pass" value=""></td>
				</tr>
				<tr>
					<td colspan=2 align=center><button>로그인</button></td>
				</tr>
			</table>
			</form>
		</td>
		<td></td>
	</tr>
</table>

<? include $DOCUMENT_ROOT.("C:/APM_Setup/htdocs/include/footer.php"); //절대경로 처리 ?>

- login_ok.php

<? include $DOCUMENT_ROOT.("C:/APM_Setup/htdocs/include/header.php"); //절대경로 처리 ?>

<?
$id = $_POST["id"];
$pass = $_POST["pass"];

//회원 존재 여부
$query = "select * from member where id = '$id' and pass = '$pass'";
$result = mysql_query($query);
$rows = mysql_fetch_array($result);

if($rows[id] != ""){ //회원존재
	//세션 생성
	$_SESSION['id'] = $rows[id];
	$_SESSION['name'] = $rows[name];
	$_SESSION['level'] = $rows[level];
}else{
?>
	<script>
		alert("정보가 없습니다.\n다시 확인하세요.");
		history.back();
	</script>
<?
}
?>

<script>
	location.href="/";
</script>

저작자표시

'기타 > PHP' 카테고리의 다른 글

기본4 (0)	2023.06.13
기본3 (0)	2023.06.12
기본2 (0)	2023.06.12
기본1 (0)	2023.06.12
설치&설정 (0)	2023.06.12

일	월	화	수	목	금	토
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31

구성

- db

index.php

include dir

css dir

member dir

'기타 > PHP' 카테고리의 다른 글

검색 태그

티스토리툴바