Matrix SQL Client

Last Updated: 17 Dec 2015

The matrixsqlclient.php script initiates an interactive database terminal in PHP to run commands against Oracle databases and can be used an alternative to SQL*Plus.

This script is located in the /scripts directory and requires only one parameter, the system root.

An example usage of this script is shown below:

$ php matrixsqlclient.php [system_root]
 
Welcome to matrixsqlclient (version 1.01, r108), the interactive database terminal in PHP.

You are now connected.
Database type: oci.

localhost/matrix=# select * from sq_ast_attr_val where assetid = '7';
 assetid | attrid | contextid | custom_val | use_default  
---------+--------+-----------+------------+-------------
 7       | 672    | 0         | Public     | 1            
 7       | 676    | 0         | User       | 1            
(2 rows)

localhost/matrix=# \timing
Timing is on
localhost/matrix=# select count(*) from sq_internal_msg:
 count (*)
----------
 457622
(1 row)

Time:  2329.879 ms

 


Previous Chapter Next Chapter

The Latest

Let Us Know What You Think

Let us know if you spot any errors or if you have any ideas on how we can improve the Matrix Community Website.

Contact Squiz for Demo

Let us show you the true power of Squiz Matrix by giving you a personalised demonstration.