API Commands
[All Commands]

Info_Web_Hosting_MySQL_Database


Information about a MySQL database.

Input:

string ssid token from Login
string webhosting Web Hosting code
string database name of the database

Output:

string status ok | error
string database name of the database
array users list of users with access to this database
string username MySQL username
string permissions read/readwrite permissions of this user to this database

Example:


<?php

$client 
= new SoapClient(null, [
    
'location' => 'http://subreg.cz/soap/cmd.php',
    
'uri' => 'http://subreg.cz/soap'
]);

$login_input = [
    
'login' => 'demo',
    
'password' => 'demouser'
];

$login_output $client->__call('Login', ['data' => $login_input]);

$input = [
    
'ssid' => $login_output['data']['ssid'],
    
'webhosting' => 'NGHTFH',
    
'database' => 'mysqldb_a'
];

$output $client->__call('Info_Web_Hosting_MySQL_Database', ['data' => $input]);

print_r($input);
print_r($output);
$input: Array ( [ssid] => 51aca4e95c12821b56a9045babc943e7 [webhosting] => NGHTFH [database] => mysqldb_a ) $output: Array ( [status] => ok [database] => mysqldb_a [users] => Array ( [0] => Array ( [username] => mysqlaccount_a [permissions] => readwrite ) ) )

API Manual - version from 2020-10-08 23:58:51