회사에서 필요해서 만들어달라는거... 여기저기 구글링 해가면서 겨우겨우 만들어냈는데...
너무 뿌듯해서 여기에 올려둡니당...
필요하신분들 잘 쓰시길 ㅠ_ㅠ;;
우선 Mysql DB 구조...
==================================================================================================
create table eventuser(
no int unsigned NOT NULL auto_increment primary key,
name varchar(20),
phone1 varchar(6),
phone2 varchar(8),
phone3 varchar(8),
sex varchar(8),
married varchar(8),
age varchar(10)
) ENGINE=MyISAM CHARSET=euckr;
==================================================================================================
0. dbconn.inc.php (DB설정파일)
==================================================================================================
<?
$host_name='localhost';
$db_id='데이터베이스아이디';
$db_name='데이터베이스이름';
$db_pass='데이터베이스비밀번호';
$connect = mysql_connect($host_name,$db_id,$db_pass) or die(mysql_error('접속이 안되네요'));
mysql_select_db($db_name,$connect) or die(mysql_error());
?>
==================================================================================================
1. insert.php (실제 입력받는 페이지)
==================================================================================================
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr" />
<HTML>
<head>
<TITLE> New Document </TITLE>
</HEAD>
<form method="post" name="theForm" action="save.php">
이름 : <input type="text" name="name"><br><br>
전화번호 : <select name="phone1">
<option value="010">010</option>
<option value="011">011</option>
<option value="016">016</option>
<option value="017">017</option>
<option value="018">018</option>
<option value="019">019</option></select>-
<input name="phone2" type="text" size="4" maxlength="4">-
<input name="phone3" type="text" size="4" maxlength="4"><br><br>
<input type="radio" name="sex" value="남성">남성
<input type="radio" name="sex" value="여성">여성
<Br><Br>
<input type="radio" name="married" value="기혼">기혼
<input type="radio" name="married" value="미혼">미혼
<Br><Br>
<input type="radio" name="age" value="20대">20대
<input type="radio" name="age" value="30대">30대
<input type="radio" name="age" value="40대">40대
<input type="radio" name="age" value="50대">50대
<input type="radio" name="age" value="기타">기타
<Br><Br>
<Input type="submit" value="저장">
</form>
<BODY>
</BODY>
</HTML>
==================================================================================================
2. save.php (데이터 저장처리하는 파일)
==================================================================================================
<?
include "dbconn.inc.php";
$name = $_POST['name'];
$phone1 = $_POST['phone1'];
$phone2 = $_POST['phone2'];
$phone3 = $_POST['phone3'];
$sex = $_POST['sex'];
$married = $_POST['married'];
$age = $_POST['age'];
echo iconv("utf-8","euc-kr",$_POST['name']);
echo iconv("utf-8","euc-kr",$_POST['phone1']);
echo iconv("utf-8","euc-kr",$_POST['phone2']);
echo iconv("utf-8","euc-kr",$_POST['phone3']);
echo iconv("utf-8","euc-kr",$_POST['sex']);
echo iconv("utf-8","euc-kr",$_POST['married']);
echo iconv("utf-8","euc-kr",$_POST['age']);
mysql_query("INSERT IGNORE INTO eventuser (name, phone1, phone2, phone3, sex, married, age) values('". $name ."', '". $phone1 ."', '". $phone2 ."', '". $phone3 ."', '". $sex ."', '". $married ."', '". $age ."')");
?>
<Script Type='Text/Javascript' Language='Javascript'>
<!--
alert("저장 되었습니다.");
document.location = "print.php";
//-->
</Script>
==================================================================================================
3. print.php (결과물 보여주는 페이지)
==================================================================================================
<?
include "dbconn.inc.php";
$sql = "select * from eventuser";
$result = mysql_query($sql, $connect);
$fields = mysql_num_fields($result);
echo "<table>
<tr>
<td align='center'>순번</td>
<td align='center'>이름</td>
<td align='center'>휴</td>
<td align='center'>대</td>
<td align='center'>폰</td>
<td align='center'>성별</td>
<td align='center'>결혼여부</td>
<td align='center'>연령대</td>
</tr>";
while($row = mysql_fetch_row($result)){
echo"<tr>";
for($i=0; $i<=$fields; $i++){
echo"<td align='center'>".$row[$i]."</td>";
}
echo "</tr>";
};
echo "</table>";
?>
==================================================================================================
간단한 코드이지만... 저도 인터넷에 글 써놓으신 분들의 도움을 받아서 코딩했기때문에...
저도 이렇게 인터넷에 올려둡니당 ㅎㅎ;
문의는 댓글보단 트위터 멘션이 더 빠릅니다. @Polarislr
