215, 1/11 ȸ¿ø°¡ÀÔ  ·Î±×ÀΠ 
   BkeMan
   [Web]php¼Ò½º ÇØ¼®Á¡ ºÎʵ叱°Ô¿ä..

http://www.hackerschool.org/HS_Boards/zboard.php?AllArticle=true&no=32 [º¹»ç]


¾È³çÇϼ¼¿ä..
php¼Ò½º°¡ ÀÌÇØ°¡ À߾ȵǼ­ ÇØ¼®Á¡ ºÎʵ叮°Ú½À´Ï´Ù.
<?php
$connect =mysql_connect('localhost','root','12345');
mysql_select_db('apm_db_01',$connect);
if($result==1)
{
        $tb_name=mysql_list_tables("apm_db_01");
        $tb_count=mysql_num_rows($tb_name);
        for($a=0; $a<$tb_count; $a++)
                if(mysql_tablename($tb_name,$a) == "member") {
                $flag="ok";
                break;
        }
}
if($flag !="ok"){
        $sql ="create table member(
        sno int not null,
        name varchar(10),
        addr varchar(80),
        primary key(sno))";
        $result = mysql_query($sql,$connect)
                or die("<h3><br><br><br><br><br><center>
        ¢Ã member Å×À̺íÀº ÀÌ¹Ì Á¸ÀçÇÕ´Ï´Ù. <br><hr><br>
        <a href=ex9-5.php>ÁÖ¼Ò ÀÔ·Â È­¸é</a>À¸·Î À̵¿Çϼ¼¿ä.<center></h3>");
}
echo "<h3><br><center><br><br><br><br>¢Ã member Å×À̺íÀ» ¼º°øÀûÀ¸·Î ¸¸µé¾ú½À´Ï´Ù.....<br><hr><br>";
echo "<a href=11.php.bak.bak>ÁÖ¼Ò ÀÔ·Â È­¸é</a>À¸·Î À̵¿Çϼ¼¿ä.</center></h3>";
mysql_close($connect);
?>

for¹®À̶û ifÀÖ´ÂÂÊÀÌ »ì¦ ÀÌÇØ°¡¾È°¡³×¿ä ƯÈ÷ if(mysql_tablename($tb_name,$a) == "member") {
À̺κпä..
ºÎʵ叮°Ú½À´Ï´Ù.

  Hit : 4973     Date : 2011/03/06 03:13



    
ÄÚÅл̱â mysql_tablename() ·¹ÆÛ·±½º¸¦ º¸ÀÚ¸é

string mysql_tablename ( resource $result , int $i )

ÀÌ·¸°Ô ³ª¿ÍÀִµ¥¿ä $result´Â mysql_list_tablesÇÔ¼ö¸¦ ½á¼­ ¹ÞÀº °á°úÀ̱¸¿ä
int $i´Â

·¹ÆÛ·±½º¿¡ The integer index (row/table number) ¶ó°í ³ª¿ÍÀÖ±º¿ä

Å×ÀÌºí¼ø¼­ °°³×¿ä..
2011/03/07  
asdwho µðºñ¿¡ ¸â¹ö¶ó´Â Å×À̺íÀÌ ¾øÀ¸¸é ¸¸µé¾îÁÖ´Â ¼Ò½º°°½À´Ï´Ù. 2011/03/21