create new db via php mysql script in app

I am totally lost on how to tie this in with my app.During registration my app automatically creates a new db per user and I have it working locally via mamp with my php sql script but I need to change the sql code to do this via cpanel. Ive tried to use this code via github but just get a blank page

require("xmlapi.php"); // this can be downlaoded from https://github.com/CpanelInc/xmlapi-php/blob/master/xmlapi.php
$xmlapi = new xmlapi("your cpanel domain");   
$xmlapi->set_port( 2083 );   
$xmlapi->password_auth($opts['user">,$opts['pass">);    
$xmlapi->set_debug(0);//output actions in the error log 1 for true and 0 false 

$cpaneluser=$opts['user">;
$databasename="something";
$databaseuser="else";
$databasepass=$opts['pass">;

//create database    
$createdb = $xmlapi->api1_query($cpaneluser, "Mysql", "adddb", array($databasename));   
//create user 
$usr = $xmlapi->api1_query($cpaneluser, "Mysql", "adduser", array($databaseuser, $databasepass));   
//add user 
$addusr = $xmlapi->api1_query($cpaneluser, "Mysql", "adduserdb", array("".$cpaneluser."_".$databasename."", "".$cpaneluser."_".$databaseuser."", 'all'));

But I think the areas that need to be edited are not clear to me, can someone give me a dummy guide through this . Thank you in advance

cPanelMichael

January 19, 2015 14:32

Hello :) The following document is a good place to start: cPanel API 2 Functions - MysqlFE::createdb Also, here's an older thread that describes how to do this: Create Database through PHP Script Note that this thread references cPanel API 1, so you would have to modify it to use cPanel API 2. Thank you.

create new db via php mysql script in app

Comments

Didn't find what you were looking for?