Description
You can use this Add Database User API to add database user to your Webuzo panel.
Parameters
Sample Code
curl --insecure -d "submituserdb=1" -d "dbuser=username" -d "dbpassword=Password" -u "vishakha:br5VEWqLoF" -X POST "https://151.80.194.206:2003/index.php?api=json&act=dbmanage"
<?php
$user = 'Username';
$pass = 'password';
$host = 'Server Ip or Hostname';
$url = 'https://'.rawurlencode($user).':'.rawurlencode($pass).'@'.$host.':2003/index.php?api=json&act=dbmanage';
$post = array('submituserdb' => '1',
'dbuser' => 'Database name',
'dbpassword' => 'Database name',
);
// Set the curl parameters
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE);
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 5);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
if(!empty($post)){
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($post));
}
// Get response from the server.
$resp = curl_exec($ch);
if(!empty(curl_error($ch))){
echo curl_error($ch); die();
}
// The response will hold a string as per the API response method.
$res = json_decode($resp, true);
// Done ?
if(!empty($res['done'])){
echo "<pre>";
print_r($res['done']['msg']);
echo "</pre>";
}else{
print_r($res['error']);
}
?>
Output
User Added Successfully