10. Mysql을 이용한 메모장 (1) -php-
10. Mysql을 이용한 메모장 (1) -php-
-memo.php
-memo_insert.php
-mysql_connect()
-mysql_select_db()
-mysql_close()
*Mysql의 DB연결, 선택, 닫기 :
<?
$connect=mysql_connect(DB 서버명, 아이디, 비밀번호); //서버 연결
mysql_select_db(DB명); // DB 선택
mysql_close($connect); // DB 닫기
?>
memo.php
<table style="width:500px; height:50px; border:5px #cccccc solid;">
<tr>
<td align="center" valign="middle" colspan="3" >
메모장
</td>
</tr>
<tr>
<td align="center" valign="middle">
메모 목록 보기
</td>
<td align="center" valign="middle">
<a href="memo_insert.php"> 메모 작성하기 </a>
</td>
</tr>
</table>
memo_insert.php
<?
include "memo.php";
?>
<br>
<form name="iform" method="post" action="memo_update.php">
<table style="width:500px; height:50px; border:5px #cccccc solid;">
<tr>
<td align="center" valign="middle">
메모 작성 하기
</td>
</tr>
</table>
<table style="width:500px; height:50px; border:0;">
<tr>
<td align="center" valign="middle" style="width:100px;">
이름
</td>
<td align="center" valign="middle" style="width:400px;">
<input type="text" name="m_name" style="width:380px;">
</td>
</tr>
<tr>
<td align="center" valign="middle" style="width:100px;">
이메일
</td>
<td align="center" valign="middle" style="width:400px;">
<input type="text" name="m_email" style="width:380px;">
</td>
</tr>
<tr>
<td align="center" valign="middle" style="width:100px;">
비밀번호
</td>
<td align="center" valign="middle" style="width:400px;">
<input type="text" name="m_pass" style="width:380px;">
</td>
</tr>
<tr>
<td align="center" valign="middle" style="width:100px;">
내용
</td>
<td align="center" valign="middle" style="width:400px;">
<input type="text" name="m_memo" style="width:380px;">
</td>
</tr>
<tr>
<td align="center" valign="middle" colspan="2">
<input type="submit" value="저장">
</td>
</tr>
</table>
</form>