API Commands
[All Commands]

List_Web_Hosting_MySQL_Databases


List of MySQL databases.

Input:

string ssid token from Login
string webhosting Web Hosting code

Output:

string status ok | error
array databases list of databases
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://regtons.com/soap/cmd.php',
    
'uri' => 'http://regtons.com/soap'
]);

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

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

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

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

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

API Manual - version from 2023-05-12 12:15:50