PHP ¿¡¼ MySQL »ç¿ëÇϱâ : Á¢¼Ó È®ÀÎ >>
ÀÛ¼ºÀÚ
- ÀåÇüÈ (hhjang97@venus.uos.ac.kr)
- http://php.pe.kr
======================= connect_mysql.php =========================
echo "MySQL Test
";
// È£½ºÆ®À̸§, »ç¿ëÀÚÀ̸§, »ç¿ëÀÚ ºñ¹ø
mysql_connect("localhost", "root", "");
// »ç¿ëÇÒ DB ¸í
mysql_select_db("mysql");
$query = "show tables";
$re = mysql_query($query) or die (mysql_error());
while($row = mysql_fetch_row($re)){
echo "$row[0]
";
}
mysql_free_result($re);
mysql_close();
echo "
Å×ÀÌºí ¸®½ºÆ®°¡ ³ª¿À¸é Á¤»óÀûÀÎ °ÍÀÔ´Ï´Ù. ----------------------------------- columns_priv db func host tables_priv user -----------------------------------"; ?> ======================= /connect_mysql.php =========================