[Á¤ÀÍ]´ÔÀÌ ³²±â½Å ±Û:
><html>
><?
>mysql_connect("localhost","esperanz","");
>mysql_select_db("countdb");
>$result=mysql_query("SELECT view_count FROM homecount where
hostname='homepage'"
>);
>if(mysql_num_rows($result)){
> $view=mysql_result($result,0,"view_count")+1;
> mysql_query("UPDATE homecount set view_count = $view where hostname =
'h
>omepage'");
> echo "$view ¹ø° ¼Õ´ÔÀÔ´Ï´Ù.";
> }else
> {
> echo "Table¾È¿¡ ÇØ´çÇÏ´Â ·¹Äڵ尡 ¾ø½À´Ï´Ù.";
> }
>?>
></html>
>
>¶ó°í ¸¸µé¾î¼ óÀ½À¸·Î Çغ¸¾Ò´Âµ¥
>
>Fatal error: Call to unsupported or undefined function mysql_connect() in
/home/httpd/html/testmysql.php3 on line 3
>
>¶ó°í¸¸ ¶ß´Âµ¥ ÀÌÀ¯¸¦ ¾Ë¼ö ÀÖÀ»±î¿ä
>
>Àú´Â sqlÀº ¹°·Ð phpµµ óÀ½ÀÔ´Ï´Ù.
>
>¿ì¿©°îÀý³¡¿¡ php¿Í mysqlÀ» ¼³Ä¡ÇÏ°í È®ÀÎÇߴµ¥ ÈæÈæ
>
>°í¼ö´ÔÀÇ °¡¸£Ä§À» ºÎŹµå¸³´Ï´Ù.
========================================
Àúµµ ¸¹Àº °É ¾Ë°í ÀÖÁö ¾Ê±â ¶§¹®¿¡
Ʋ¸° ºÎºÐ¸¸ ÁöÀûÇÏ°Ú½À´Ï´Ù.
mysql_connect("localhost","esperanz","");
¿©±â¿¡¼ esperanz ¶ó´Â »ç¿ëÀÚ°¡ mysql DBÀÇ user Å×ÀÌºí¿¡
µî·ÏµÇ¾î ÀÖ¾î¾ßÇÕ´Ï´Ù.
½Ã½ºÅÛ °èÁ¤ À¯Àú¿Í º°°³ÀÔ´Ï´Ù.
´ÙÀ½°ú °°ÀÌ °íÃĺ¸¼¼¿ä..(Á¦°¡ ÁÖ·Î »ç¿ëÇÏ´Â ¹æ¹ýÀÔ´Ï´Ù.)
//* ¼³Á¤ °ª º¯¼ö·Î ÁöÁ¤ ****************//
$db_host = "localhost";
$db_user = "esperanz";
$db_passwd = "";
$db = "countdb";
$table = "homecount";
//************************************//
$CONT =
mysql_connect("$db_host","$db_user","$db_passwd");
mysql_select_db("$db", $CONT);
$RT = mysql_query("SELECT * FROM $table WHERE hostname='homepage'",
$CONT);
//$TOTAL = mysql_num_rows($RT);
$view=mysql_result($RT,0,"view_count");
echo "$view ¹ø° ¼Õ´ÔÀÔ´Ï´Ù.";
$view = $view +1;
mysql_query("UPDATE $table SET view_count = $view WHERE hostname =
'homepage'", $CONT);
mysql_close($CONT);
¸Â°Ô °íÃÆ´ÂÁö ¸ð¸£°Ú³×¿ä....
¿¡·¯°¡ ³´Ù¸é °¢ Å×À̺í Ä÷³ À̸§À» Á¦°¡ Á¤È®ÇÏ°Ô ¸ð¸£±â
¶§¹®¿¡ ¸Â°Ô °íÃĺ¸½Ã±æ ¹Ù¶ø´Ï´Ù.
|