Changeset 6262 for temp/trunk/data

Timestamp:

2006/10/13 13:14:41 (20 years ago)

Author:

naka

Message:

* empty log message *

Location:

temp/trunk/data

Files:

• class/SC_DbConn.php (modified) (1 diff)
• lib/slib.php (modified) (1 diff)

temp/trunk/data/class/SC_DbConn.php

@@ -20 +20 @@
     var $dsn;
     var $err_disp = true;
-
     
     // ¥³¥ó¥¹¥È¥é¥¯¥¿

temp/trunk/data/lib/slib.php

@@ -20 +20 @@
 // ¥¢¥Ã¥×¥Ç¡¼¥È¤ÇÀ¸À®¤µ¤ì¤¿PHP¤òÆɤ߽Ф¹
 sfLoadUpdateModule();
+
+/* ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Ð¡¼¥¸¥ç¥ó½êÆÀ */
+function sfGetDBVersion($dsn = DEFAULT_DSN) {
+    $objQuery = new SC_Query($dsn);
+    list($db_type) = split(":", $dsn);
+    if($db_type == 'mysql') {
+        $arrRet = $objQuery->getAll("SHOW VARIABLES");
+        foreach($arrRet as $array) {
+            if($array[0] == 'version') {
+                $version = "MySQL " . $array[1];
+                break;
+            }
+        }
+    }
+    if($arrRet['db_type'] == 'pgsql') {
+        $arrRet = $objQuery->getAll("select version()");
+        $arrLine = split(" " , $arrRet[0][0]);
+        $version = $arrLine[0] . " " . $arrLine[1];
+    }
+    return $version;
+}
 
 /* ¥Æ¡¼¥Ö¥ë¤Î¸ºß¥Á¥§¥Ã¥¯ */