답변 2개
간단하게 예를 들겠습니다.
bbs/contact_form_update.php
bbs/contact_list.php
생성해줍니다.
0. 선행작업
phpmyadmin -> sql 에 아래와 같이 입력해줍니다.
CREATE TABLE IF NOT EXISTS `g5_contact` ( `ct_no` int(11) NOT NULL, `ct_name` varchar(255) NOT NULL DEFAULT '', `ct_hp` varchar(255) NOT NULL DEFAULT '', `ct_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; ALTER TABLE `g5_contact` ADD PRIMARY KEY (`ct_no`), ADD UNIQUE KEY `ct_hp` (`ct_hp`), ADD KEY `ct_datetime` (`ct_datetime`); ALTER TABLE `g5_contact` MODIFY `ct_no` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
1. 정보를 입력받을 파일에 아래 소스 입력
</p>
<p><form id="fcontactform" name="fcontactform" action="<?php echo G5_BBS_URL ?>/contact_form_update.php" onsubmit="return fcontactform_submit(this);" method="post" autocomplete="off">
<table>
<tbody>
<tr>
<th scope="row"><label for="ct_name">성명<strong class="sound_only">필수</strong></label></th>
<td><input type="text" name="ct_name" id="ct_name" required class="frm_input required" minlength="3" maxlength="20"></td>
</tr>
<tr>
<th scope="row"><label for="ct_hp1">연락처<strong class="sound_only">필수</strong></label></th>
<td>
<input type="text" name="ct_hp1" id="ct_hp1" required class="frm_input required" minlength="3" maxlength="3"> -
<input type="text" name="ct_hp2" id="ct_hp2" required class="frm_input required" minlength="4" maxlength="4"> -
<input type="text" name="ct_hp3" id="ct_hp3" required class="frm_input required" minlength="4" maxlength="4">
</td>
</tr>
</tbody>
</table></p>
<p><div class="btn_confirm">
<input type="submit" value="입력하기" id="btn_submit" class="btn_submit" accesskey="s">
<a href="<?php echo G5_URL ?>" class="btn_cancel">취소</a>
</div></p>
<p></form></p>
<p><script>
// submit 최종 폼체크
function fcontactform_submit(f)
{
if (f.ct_name.value.length < 1) {
alert("성명을 입력하세요.");
f.ct_name.focus();
return false;
}
if (f.ct_hp1.value.length < 1) {
alert("연락처를 입력하세요.");
f.ct_hp1.focus();
return false;
}
if (f.ct_hp2.value.length < 1) {
alert("연락처를 입력하세요.");
f.ct_hp2.focus();
return false;
}
if (f.ct_hp3.value.length < 1) {
alert("연락처를 입력하세요.");
f.ct_hp3.focus();
return false;
}</p>
<p> return true;
}
</script></p>
<p>
2. bbs/contact_form_update.php에 아래 소스 입력
</p>
<p><?php
include_once('./_common.php');</p>
<p>// 리퍼러 체크
referer_check();</p>
<p>$ct_name = trim($_POST['ct_name']);
$ct_hp1 = isset($_POST['ct_hp1']) ? trim($_POST['ct_hp1']) : "";
$ct_hp2 = isset($_POST['ct_hp2']) ? trim($_POST['ct_hp2']) : "";
$ct_hp3 = isset($_POST['ct_hp3']) ? trim($_POST['ct_hp3']) : "";
$ct_hp = $ct_hp1.'-'.$ct_hp2.'-'.$ct_hp3;</p>
<p>$sql = " insert into g5_contact set ct_name = '{$ct_name}', ct_hp = '{$ct_hp}', ct_datetime = '".G5_TIME_YMDHIS."' ";
sql_query($sql);</p>
<p>alert('정상적으로 입력 되었습니다.', G5_URL);
?></p>
<p>
3. bbs/contact_list.php에 아래 소스 입력
</p>
<p><?php
include_once('./_common.php');</p>
<p>if (!$member['mb_id'])
{
alert('로그인 하십시오.', G5_BBS_URL.'/login.php?url='.G5_BBS_URL.'/contact_list.php');
}
else if (!$is_admin)
{
alert('최고관리자만 접근 가능합니다.', G5_URL);
}</p>
<p>$sql = " select * from g5_contact order by ct_datetime desc ";
$result = sql_query($sql);
?></p>
<p><table>
<thead>
<tr>
<th scope="col">이름</th>
<th scope="col">연락처</th>
<th scope="col">입력일시</th>
</tr>
</thead>
<tbody>
<?php
for ($i=0; $row=sql_fetch_array($result); $i++) {
?></p>
<p> <tr>
<td><?php echo $row['ct_name']; ?></td>
<td><?php echo $row['ct_hp']; ?></td>
<td><?php echo $row['ct_datetime']; ?></td>
</tr></p>
<p> <?php
}
if ($i == 0)
echo "<tr><td colspan=\"3\" class=\"empty_table\">자료가 없습니다.</td></tr>";
?>
</tbody>
</table></p>
<p>
간단하게 예를 든 것이니 css나 기타 필요한 것들을 수정해서 사용하세요.
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인