Database Manager - GetDatabases

Version: 1

HCnix Build: 3.00 and later

API Build: 1.00 and later

 

Database Manager - GetDatabases  retrieves databases under a specified owner. This web service call can be made as http://your-domain.com/HCnixAPI/DatabaseManager.php?op=GetDatabases.

 

Input Parameters

 

Output Parameters

 

 

Sample Optional Parameters

 

<Parameters>

<Parameter Name = "WebsiteName">MyDomain.com</Parameter>

<Parameter Name = "DatabaseName">MyDatabase</Parameter>

<Parameter Name = "Language">French</Parameter>

</Parameters>

 

Sample SOAP Request

 

 

POST /HCnixAPI/DatabaseManager.php HTTP/1.1

Host: your-domain.com

Content-Type: text/xml; charset=utf-8

Content-Length: length

SOAPAction: "http://tempuri.org/GetDatabases"

<?xml version="1.0" encoding="utf-8"?>

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

  <soap:Body>

    <GetDatabases xmlns="http://tempuri.org/">

      <HostUserName>host</HostUserName>

      <HostPassword>host123</HostPassword>

      <OwnerName>david</OwnerName>

      <OptionalParam>xml</OptionalParam>

    </GetDatabases>

  </soap:Body>

</soap:Envelope>

 

 

Sample HTTP Request

 

 

POST /HCnixAPI/DatabaseManager.php/GetDatabases HTTP/1.1

Host: your-domain.com

Content-Type: application/x-www-form-urlencoded

Content-Length: length

HostUserName=host&HostPassword=host123&OwnerName=david&OptionalParam=xml

 

 

Sample PHP Code

 

 

function GetDatabases($strHostUserName, $strHostPassword, $strOwnerName, $OptionalParam)  

{

        $response="";

        $soapPacket = "<?xml version=\"1.0\" encoding=\"utf-8\"?>

        <soap:Envelope

            xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"

            xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"

            xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">

            <soap:Body>

                  <GetDatabases xmlns=\"http://tempuri.org/\">

                   <HostUserName>$strHostUserName</HostUserName>

                   <HostPassword>$strHostPassword</HostPassword>

                   <OwnerName>$strOwnerName</OwnerName>

                   <OptionalParam>$OptionalParam</OptionalParam>

                  </GetDatabases>

            </soap:Body>

        </soap:Envelope>";

        // where $domain_name is where HCnix APIs are installed

        $fp = fsockopen($domain_name, 80, $errNo, $errString, 90);

        if($fp)  

        {

            // where $name is the Virtual Directory name for HCnix APIs

            $header = "POST /$name/UserManager.php HTTP/1.1\r\n";

            $header .= "HOST: $domain_name\n";

            $header .= "Content-Type: text/xml;charset=\"utf-8\"\r\n";

            $header .= "Content-Length: ".strlen($soapPacket)."\r\n\r\n";

            fwrite($fp, $header.$soapPacket);

        

            while (true)

            {  

                  $buffer = fread($fp, 1000);

                  if( $buffer != "" )

                      $response .= $buffer;  

                  if(strstr($response, '</SOAP-ENV:Envelope>') || $buffer == "" )  

                      break;

                  $buffer = "";  

              }

            fclose($fp);

            $result = explode("<?xml",$response);

            return "<?xml".$result[1];

        }

}

 

 

Sample Response

 

 

<Response>

    <Method>GetDatabases</Method>

    <Status>true</Status>

    <ErrorCode>74900001</ErrorCode>

    <ErrorDescription>Operation completed successfully.</ErrorDescription>           

    <Result/>

       <Databases xmlns="">

           <RecordRow>

             <DatabaseID>470</DatabaseID>

             <DatabaseName>MyDatabase</DatabaseName>

             <OwnerName>david</OwnerName>

             <ResellerName>john</ResellerName>

             <WebsiteName>MyDomain.com</WebsiteName>

             <ServerName>abc</ServerName>

             <Connectivity>127.0.0.1:3306</Connectivity>

          </RecordRow>

              .......

              .......

              .......            

          </Databases>

       </Result>

</Response>