Ʋ¸° ºÎºÐ¸¸ ÁöÀûÇÏ°Ú½À´Ï´Ù.
[Á¤ÀÍ]´ÔÀÌ ³²±â½Å ±Û:
>»ç¿ëȯ°æÀ» ¾ËÂ¥ ·¹µåÇò 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');
>
------------>
ÀÌ¿Í °°ÀÌ Ãß°¡Çß´Ù¸é
DB ¼¹ö : localhost
DB À¯Àú : user
À¯Àú Æнº¿öµå : password
DB À̸§ : ????
ÀÌ¿Í °°ÀÌ ¼³Á¤ÇÑ °æ¿ì ÀÔ´Ï´Ù...
µû¶ó¼....
>ÀÌ·¸°Ô ¸¸µé°í
>
>create table info(id varchar(30);name varchar(30);tel varchar(30));
>
>Å×À̺íÀ» »ý¼ºÇÏ°í³ª¼
>
----------->
info Å×À̺íÀ» ¾î´À DB¿¡ ³Ö¾ú³ª¿ä?
Ȥ½Ã "mysql" À̶ó´Â DB À̸§¿¡ ³ÖÁö´Â ¾Ê¾Ò´ÂÁö¿ä?
>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>
DB¿¡ µé¾î°¡ °¢ Ä÷³°ú CGI ÆûÀÇ °¢°¢ÀÇ º¯¼ö À̸§À» °°°Ô ÇÒ
ÇÊ¿ä´Â ¾øÁö¸¸
ÀϹÝÀûÀ¸·Î °°Àº À̸§À¸·Î ¸¹ÀÌ »ç¿ëÇÕ´Ï´Ù.
Áï info Å×ÀÌºí¿¡¼
¾ÆÀ̵ð : id Ä÷³
À̸§ : name Ä÷³
ÀüȹøÈ£ : tel Ä÷³
À̹ǷÎ
CGI Æû¿¡¼´Â
<td> ¾ÆÀ̵ð</td>
<td> <input type="text" name="id"
size="30"></td>
</tr>
<tr>
<td> ÀÌ ¸§</td>
<td> <input type="text" name="name"
size="30"></td>
</tr>
<tr>
<td> Àü È</td>
<td> <input type="text" name="text"
size="30"></td>
</tr>
¿Í °°ÀÌ ¼öÁ¤ÇϽʽÿÀ...
CGI ÀÔ·ÂÆû¿¡¼ name="id"
´Â id ¶ó´Â º¯¼ö($id)¸¦ PHP¿¡¼ ¹Ù·Î »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
><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");
>
------------------>
DB ¼¹ö : localhost
DB À¯Àú : user
À¯Àú Æнº¿öµå : password
DB dÀ̸§ : dbname // info Å×À̺íÀÌ µé¾î°¡ ÀÖ´Â DB À̸§
À̹ǷÎ
À§ÀÇ $connection ºÎºÐÀ»
$connection =
mysql_connect("localhost","user","password");
ÀÌ¿Í °°ÀÌ ¹Ù²Ù¾î ÁֽʽÿÀ....
>mysql_select_db("myuserdb",$connection);
¸¶Âù°¡Áö·Î
À§ÀÇ ºÎºÐµµ
mysql_select_db("dbname",$connection);
ÀÌ¿Í °°ÀÌ ¼öÁ¤ÇϽʽÿÀ...
>$dbresult=mysql_quary("insert into info values('$id', $name', '$tel')",
$connection);
>
¾Õ¿¡¼ mysql_quary() °¡ ¾Æ´Ï¶ó mysql_query()
¿ÀŸÀÎ°Í °°±º¿ä....
>if($dbresult=="")
>{
> echo("
> <script>
> window.alert('µ¥ÀÌÅÍ
ÀԷ¿À·ù!!!')
> history.go(-1)
> </script>
> ");
> exit;
>}
>?>
>
>·Î ÇÏ°í ¿þºê¶ó¿ìÀú¿¡¼ ½ÇÇà½ÃÅ°¸é
>
>ÀÏ´Ü ¿¡·¯´Â ¾Èº¸ÀÔ´Ï´Ù.
>
>ÇÏÁö¸¸ mysql¿¡ °¡¼
>
>select * from info;
>
>ÇÏ¸é ºñ¾î ÀÖ´Ù°í ³ª¿É´Ï´Ù.
>
>mysql¿¡¼ Á÷Á¢³ÖÀ¸¸é µé¾î°¡´Âµ¥....
>
>µµ¿ò ºÎŹµå¸³´Ï´Ù.
========================================
ÀÌ¿Í °°ÀÌ ¼öÁ¤Çϸé ÀÏ´Ü À¥¿¡¼ MySQL Å×ÀÌºí¿¡ ÀÚ·á ÀÔ·ÂÇÒ ¼ö ÀÖ½À´Ï´Ù.
´ÙÀ½Àº
À§ÀÇ ³»¿ëÀ» Á»´õ °£ÆíÇÑÇÑ ¹æ¹ýÀ̱⵵ ÇÕ´Ï´Ù...
input.php3------------------------------
<?
$db_server = "localhost"; DB ¼¹ö
$db_user = "user"; DB »ç¿ëÀÚ
$db_passwd = "password"; // user À¯Àú¿¡ ÇØ´çÇÏ´Â Æнº¿öµå
$db_name = "db_name"; // "db_name"À̶ó´Â
DB¿¡ info Å×À̺íÀÌ Ãß°¡µÇ¾úÀ» °æ¿ì
$table = "info"; // Å×À̺í À̸§
if(!$id || !$name){
echo("<script>
windows.alert('¾ÆÀ̵ð/À̸§À»
³ÖÀ¸¼¼¿ä')
history.go(-1)
</script>
");
exit;
}
// ÀÌÇÏ º¯¼ö´Â °íÄ¥ ÇÊ¿ä´Â ¾ø½À´Ï´Ù..
$connection =
mysql_connect("$db_server","$db_user","$db_passwd");
mysql_select_db("$db_name",$connection);
$dbresult=mysql_query("insert into $table values('$id', $name', '$tel')",
$connection);
if(!$dbresult)
{
echo("
<script>
window.alert('µ¥ÀÌÅÍ
ÀԷ¿À·ù!!!')
history.go(-1)
</script>
");
exit;
}
?>
---------------------------------------------
ÀÌ»óÀÔ´Ï´Ù........
|