|
|
|
|
[PHP]
mysql Å×À̺íÀÌ Á¸ÀçÇÏ´ÂÁö ¾Ë¾Æ³»´Â ÇÔ¼ö |
±Û¾´ÀÌ : dalsoo
³¯Â¥ : 11-06-06 10:50
Á¶È¸ : 1032
|
|
|
$dbname ÀÌ GLOBAL ·Î ¼±¾ðµÇ¾îÀ־ ÇÑ´Ù. include µÇ¾îÀÖ´ø°¡.
<?
# Å×À̺íÀÌ Á¸ÀçÇÏ´ÂÁö ¾Ë¾Æ³»´Â ÇÔ¼ö
function table_exist($t_name)
{
global $dbname;
$res = mysql_list_tables ($dbname);
$i = 0;
while ($i < mysql_num_rows ($res)) {
if($t_name==mysql_tablename ($res, $i))
return true;
$i++;
}
return false;
}
<?
// mysql ±×´©º¸µå Å×À̺íÀÇ À¯¹«¸¦ È®ÀÎÇÔ.
function bo_table_is($tbl){
global $mysql_db; //dbconfig¿¡¼ ¼±¾ð
## $con = @mysql_connect("$mysql_host","$mysql_user","$mysql_password");
$rest = @mysql_list_tables($mysql_db);
$rowc = @mysql_num_rows($rest);
$search_tbl = "g4_write_".$tbl;
for($bi=0; $bi<$rowc; $bi++){
if(@mysql_tablename($rest,$bi)==$search_tbl)
return true;
}
return false;
## @mysql_close($con);
}
?>
¡Ø Æ÷Åп¡¼ °Ë»öµÈµÚ ¿øÇϽô ¸µÅ©°¡ ¾øÀ» °æ¿ì
È¸é »ó´ÜÀÇ Àüü°Ë»öÀ» ÀÌ¿ëÇϽʽÿÀ.
|
|
|