Database Manager - AddDatabase

Version: 1

HCnix Build: 3.00 and later

API Build: 1.00 and later

Database Manager - AddDatabase adds database under a specified website. This web service call can be made as http://your-domain.com/HCnixAPI/DatabaseManager.php?op=AddDatabase.

Input Parameters

HostUserName
HostPassword
OwnerName - user name for whom you want to add database
DatabaseName - name of the database you want to add
DatabaseLogin - login name of the database
DatabasePassword - password of the database login
InstanceName - name of the database instance
WebsiteName - name of the website under which you want to add database
OptionalParam

Language

Output Parameters

N/A

Sample Optional Parameters

<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/AddDatabase"

<?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>

<OwnerName>david</OwnerName>

<DatabaseName>MyDatabase</DatabaseName>

<InstanceName>localhost</InstanceName>

<WebsiteName>MyDomain.com</WebsiteName>

</AddDatabase>

</soap:Body>

</soap:Envelope>

Sample HTTP Request

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

Host: your-domain.com

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

Content-Length: length

HostUserName=host&HostPassword=host123&OwnerName=david&DatabaseName=MyDatabase

&DatabaseType=MySQL&DatabaseLogin=Mydb&DatabasePassword=Mydb123&

InstanceName=localhost&WebsiteName=MyDomain.com&OptionalParam=xml

Sample PHP Code

function AddDatabases($strHostUserName, $strHostPassword, $strOwnerName, $DatabaseName, $DatabaseLogin, $DatabasePassword, $InstanceName, $WebsiteName, $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>

<HostUserName>$strHostUserName</HostUserName>

<HostPassword>$strHostPassword</HostPassword>

<OwnerName>$strOwnerName</OwnerName>

<DatabaseName>$strDatabaseName</DatabaseName>

<DatabaseLogin>$strDatabaseLogin</DatabaseLogin>

<DatabasePassword>$strDatabasePassword</DatabasePassword>

<InstanceName>$strInstanceName</InstanceName>

<WebsiteName>$strWebsiteName</WebsiteName>

<OptionalParam>$OptionalParam</OptionalParam>

</AddDatabases>

</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

<Method>AddDatabase</Method>

<ErrorDescription>Database created successfully.</ErrorDescription>

</Response>