Differences

This shows you the differences between two versions of the page.

--- v5:reference:connection:serverinfo [2023/06/04 11:41] – removed - external edit (Unknown date) 127.0.0.1
+++ v5:reference:connection:serverinfo [2023/06/04 11:52] (current) – Improve description dregad
@@ Line 1: / Line 1: @@
+====== serverInfo ======
+~~NOTOC~~
+<WRAP right box>
+== Syntax ==
+  string[] serverInfo()
+</WRAP>
+===== Description =====
+The function returns an array with general information about the database server.
+^ Key  ^ Description  ^
+| ''version''     | Database server's version number |
+| ''description'' | Additional information about the database server |
+Additional, driver-specific keys may be present.
+<WRAP clear/>
+<WRAP tip>
+In portable applications, always set the fetch mode to ADODB_FETCH_NUM, as the associative key names are not the same across all databases.
+</WRAP>
+===== Usage =====
+<code php>
+/*
+ * Connection to Oracle Database
+ */
+$ar = $db->serverInfo();
+print_r($ar);
+/*
+ * Returns:
+Array
+(
+    [compat] => 11.2.0.0.0
+    [description] => Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
+    [version] => 11.2.0.2.0
+)
+</code>
+<code php>
+/*
+ * Connection to IBM DB2 database
+ */
+$ar = $db->serverInfo();
+print_r($ar);
+/*
+ * Returns:
+Array
+(
+    [version] => DB2 v10.5.0.5:5
+    [fixpack] => 5
+    [description] =>
+)
+</code>