list

Function: databasemysql
To make use of the ‘list‘ Action, the following parameters must be sent:

• • key: Key authorized by Api administrator
  • action: list
  • user: Account username

– Possible answers:

• • status -> OK, msj -> array of databases
  • status -> Error, msj -> Can not query database as root

Example of code in php

$data = array(“key” => “MYKEY”,”action”=>’list’, ”user”=>’USER’);
$url = “https://IPSERVERAPI:2304/v1/databasemysql”;
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, “POST”);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt ($ch, CURLOPT_POSTFIELDS, http_build_query($data));
curl_setopt ($ch, CURLOPT_POST, 1);
$response = curl_exec($ch);
curl_close($ch);