[±è¼º¹Î]´ÔÀÌ ³²±â½Å ±Û:
>¾È³çÇϼ¼¿ä.
>
>´Ù¸§ÀÌ ¾Æ´Ï¶ó, mysql db¸¦ º¹¼ö·Î »ç¿ëÇÒ ¶§ ¹®ÀÇ°¡ À־ä..
>
>### conf.php ###
>
>$xSystem['mysql_host'] = "localhost"; // Host
>$xSystem['mysql_id'] = "test"; // User
>$xSystem['mysql_pw'] = "1111"; // Pass
>$xSystem['mysql_db1'] = "test1"; // DB
>$xSystem['mysql_db2'] = "test2"; // DB
>
>### func.php ###
>
>function dbConnect_1(){
> global $xSystem;
> $dbconn1 = @mysql_connect($xSystem['mysql_host'], $zxSystem['mysql_id'],
$zxSystem['mysql_pw']) or die("CONNECT ERROR");
> $status = @mysql_select_db($xSystem['mysql_db1'], $dbconn1) or die("SELECT
ERROR");
>}
>
>function dbClose_1(){
> global $dbconn1;
> @mysql_close($dbconn1);
>}
>
>function dbConnect_2(){
> global $xSystem;
> $dbconn2 = @mysql_connect($xSystem['mysql_host'], $zxSystem['mysql_id'],
$zxSystem['mysql_pw']) or die("CONNECT ERROR");
> $status = @mysql_select_db($xSystem['mysql_db2'], $dbconn2) or die("SELECT
ERROR");
>}
>
>function dbClose_2(){
> global $dbconn2;
> @mysql_close($dbconn2);
>}
>
>### test.php ###
>
><?
> require_once "conf.php";
> require_once "func.php";
>
> dbConnect_1();
> // ¾î¼±¸ Àú¼±¸.........
>
> dbConnect_1() À» ¿¬°áÇؼ ¾²´Ù°¡
>
> dbConnect_2();
> // ¾î¼±¸ Àú¼±¸.........
>
> ÀÌ·¸°Ô Àá±ñ dbConnect_2() ¸¦ ¿¬°áÇؼ ¾²µµ·Ï ÇÒ¶ó´Ï±î ¿¬°áÀº µÇ´Âµ¥,
> À̼ø°£ dbConnect_1() ÀÌ ²÷¾îÁö´Â°Í °°½À´Ï´Ù.
>
> dbConnect_1();
> // ¾î¼±¸ Àú¼±¸.........
>
> dbConnect_1() À» ¿¬°áÇؼ ¾²´Ù°¡
>
> dbConnect_2();
> // ¾î¼±¸ Àú¼±¸.........
>
> dbConnect_1() <- ´Ù½Ã È£ÃâÇØ¾ß ÇÏ°í ¸¶Âù°¡Áö·Î dbConnect_2() °¡
²÷¾îÁü
>?>
>
>ÇÑ ÆäÀÌÁö¿¡¼ 1°³ ÀÌ»óÀÇ db ¸¦ ¿¬°áÇؼ ¾²°íÀÚ ÇÔÀε¥ ¹¹°¡ À߸øµÈ ºÎºÐÀÌ ÀÖ´ÂÁö
Çؼ ¹®Àǵ帳´Ï´Ù.
>À̸®Àú¸® º¯¼ö¸¦ ¹Ù²ã°¡¸é¼ ÇغÁµµ ¸¶Âù°¡Áö´õ¶ó°í¿ä..
========================================
mysql_host °¡ ÇϳªÀ̹ǷΠconnect resoure Àº »ý·«Çصµ µË´Ï´Ù.
function db_connect($xSystem)
{
$link = @mysql_connect($xSystem['mysql_host'], $zxSystem['mysql_id'],
$zxSystem['mysql_pw']) or die("CONNECT ERROR");
return $link; // resoure link
}
function db_close()
{
return @mysql_close();
}
db_connect($xSystem);
...
...
...
db_close();
ÀÌ·±½ÄÀ¸·Î Çصµ µÇ±¸¿ä.
sql À» ´ÙÀ½°ú °°ÀÌ
SELECT .... FROM dbname.table WHERE ...
ÀÌ·±½ÄÀ¸·Î `table' À̸§ ¾Õ¿¡ `dbname' ±×¸®°í Á¡(.)À» ÀÔ·ÂÇØ ÁÖ¸é µË´Ï´Ù.
¶Ç´Â
mysql_db_query($dbname,$sql)
ÇÔ¼ö¸¦ »ç¿ëÇصµ µË´Ï´Ù.
|