note 124145 added to function.oci-server-version

From: Date: Tue, 27 Aug 2019 12:25:49 +0000
Subject: note 124145 added to function.oci-server-version
Groups: php.notes 
Request: Send a blank email to php-notes+get-212024@lists.php.net to get a copy of this message
Here's now to extract just the major.minor version number: <?php $link = oci_new_connect($username, $password, $server, "AL32UTF8"); $server_info = oci_server_version($link); $version = preg_replace('~^.* (\d+\.\d+)\.\d+\.\d+\.\d+.*~s', '\1', $server_info); echo "$server_info<br>"; // Oracle Database 11g Release 11.2.0.4.0 - 64bit Production echo "$version<br>"; // 11.2 ?> And here's how to look up version via SQL: https://www.oracle.com/pls/topic/lookup?ctx=db122&id=ADMIN11039 SELECT * FROM PRODUCT_COMPONENT_VERSION; PRODUCT VERSION STATUS ---------------------------------------- ----------- ----------- NLSRTL 12.1.0.0.1 Production Oracle Database 12c Enterprise Edition 12.1.0.0.1 Production PL/SQL 12.1.0.0.1 Production ?> ---- Server IP: 208.43.231.9 Probable Submitter: 185.85.3.168 (proxied: 195.178.95.132) ---- Manual Page -- http://php.net/manual/en/function.oci-server-version.php Edit -- https://master.php.net/note/edit/124145 Del: integrated -- https://master.php.net/note/delete/124145/integrated Del: useless -- https://master.php.net/note/delete/124145/useless Del: bad code -- https://master.php.net/note/delete/124145/bad+code Del: spam -- https://master.php.net/note/delete/124145/spam Del: non-english -- https://master.php.net/note/delete/124145/non-english Del: in docs -- https://master.php.net/note/delete/124145/in+docs Del: other reasons-- https://master.php.net/note/delete/124145 Reject -- https://master.php.net/note/reject/124145 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#212024) next »