1. Home
  2. Docs
  3. Developer Guide
  4. API Manager
  5. Functions
  6. MySQL Databases
  7. list

list

Functiondatabasemysql
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);
Was this article helpful to you? Yes No 1