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 [2026/02/18 15:40] (current) – [Description] mnewnham
@@ 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. The array contains 2 mandatory keys, and may also contain additional database-specific information. If writing portable applications, use driver-specific branches if accessing these additional keys.
+^ Key  ^ Description  ^
+| ''version''     | Database server's version number |
+| ''description'' | Additional information about the database server |
+===== Usage =====
+<code php>
+/*
+* Connecting to a SQL Server database
+*/
+$info = $db->serverInfo();
+print_r($info)
+/*
+* Returns
+Array
+(
+    [description] => test-sqlserver.local connected to testdb
+    [version] => 17.00.0925
+)
+*/
+</code>
+===== 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>