»ç¿ëȯ°æÀ» ¾ËÂ¥ ·¹µåÇò 6.1ÀÌ°í¿ä
±×¸®°í PHP´Â µû·Î ¼³Ä¡ÇÏÁö ¾Ê°í 6.1¼³Ä¡ ÇÏ¸é¼ ±ò¸°°ÍÀ» ±×´ë·Î ¾¹´Ï´Ù.
¶Ç mysqlÀº 3.22.32 ¹öÀüÀ» ¼Ò½º·Î ¹Þ¾Æ¼ ÄÄÆÄÀÏ Çß½À´Ï´Ù.
¸ÕÀú »ç¿ëÀÚ¸¦
mysql>insert into user
values('localhost','user',password('password'),'N','N','N','N','N','N','N','N','N','
N','N','N','N','N');
¸¸µé°í
mysql>insert into db
values('localhost','dbname','user','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
ÀÌ·¸°Ô ¸¸µé°í
create table info(id varchar(30);name varchar(30);tel varchar(30));
Å×À̺íÀ» »ý¼ºÇÏ°í³ª¼
input.htmlÆÄÀÏÀ»
<html>
<head>
<title>php ù¹ø° Å×½ºÆ®</title>
</head>
<body>
<center>
<form action="input.php3" method="post">
<h1>½Å±Ôȸ¿ø °¡ÀÔ½Åû¼</h1>
<br><br>
<h3>°³ÀÎÁ¤º¸¸¦ ÀÔ·ÂÇϽʽÿÀ</h3>
<table>
<tr>
<td> ¾ÆÀ̵ð</td>
<td> <input type="text" name="id"
size="30"></td>
</tr>
<tr>
<td> ÀÌ ¸§</td>
<td> <input type="text" name="id"
size="30"></td>
</tr>
<tr>
<td> Àü È</td>
<td> <input type="text" name="id"
size="30"></td>
</tr>
<tr>
<td colspan=2 align=center>
<input type="submit" value="½Åû"><input
type="reset" value="Áö¿ì±â">
</td>
</tr>
</table>
</center>
</body>
</html>
----------------------------------------------------------------
input.php3 ÆÄÀÏÀ»
<?
if(!$name){
echo("<script>
windows.alert('À̸§À»
³ÖÀ¸¼¼¿ä')
history.go(-1)
</script>
");
exit;
}
$connection =
mysql_connect("localhost","myuser","myuser");
mysql_select_db("myuserdb",$connection);
$dbresult=mysql_quary("insert into info values('$id', $name', '$tel')",
$connection);
if($dbresult=="")
{
echo("
<script>
window.alert('µ¥ÀÌÅÍ
ÀԷ¿À·ù!!!')
history.go(-1)
</script>
");
exit;
}
?>
·Î ÇÏ°í ¿þºê¶ó¿ìÀú¿¡¼ ½ÇÇà½ÃÅ°¸é
ÀÏ´Ü ¿¡·¯´Â ¾Èº¸ÀÔ´Ï´Ù.
ÇÏÁö¸¸ mysql¿¡ °¡¼
select * from info;
ÇÏ¸é ºñ¾î ÀÖ´Ù°í ³ª¿É´Ï´Ù.
mysql¿¡¼ Á÷Á¢³ÖÀ¸¸é µé¾î°¡´Âµ¥....
µµ¿ò ºÎŹµå¸³´Ï´Ù.
|