使用PHP通过cPanel创建mysql DB并导入* .sql文件

时间:2022-04-05 02:44:38

I want to create a DB for each user who wants to register to my Web-app. When i try this local everything perfectly works. A User can register with his email and pw. A DB is created and a import.sql file is imported so that the DB created for the User is empty on data but the tables and realtioships are given.

我想为每个想要注册我的Web应用程序的用户创建一个数据库。当我尝试这个本地一切都很完美。用户可以注册他的电子邮件和pw。创建数据库并导入import.sql文件,以便为用户创建的数据库在数据上为空,但是会给出表和实际内容。

My Host uses cPanel and phpMyAdmin to create DB and db-user. I want to do this with php like i do it local. Does anyone have an idea how i get this done?

我的主机使用cPanel和phpMyAdmin来创建DB和db-user。我想用PHP做这个,就像我在本地做的那样。有谁知道我怎么做到这一点?

I've already searched and tryed stuff out but nothing works for me.

我已经搜索过并尝试了一些东西,但对我来说没什么用。

If possible some explanations on cPanel maybe would be enough.

如果可能的话,对cPanel的一些解释可能就足够了。

1 个解决方案

#1


0  

            <?php
            require("xmlapi.php"); // this can be downlaoded from https://github.com/CpanelInc/xmlapi-php/blob/master/xmlapi.php
            $xmlapi = new xmlapi("cpanlel host name");   
            $xmlapi->set_port( 2083 );   
            $xmlapi->password_auth('cpanel username','cpanel passsword');    
            $xmlapi->set_debug(0);//output actions in the error log 1 for true and 0 false 

            $cpaneluser='cpanel username';
            $databasename="something";
            $databaseuser="database username";
            $databasepass= 'database password';

            //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('' . $databasename . '', '' . $databaseuser . '', 'all'));
            ?>

Using the above code you will be able to create new database, add new user to database and give all access to user on database.

使用上面的代码,您将能够创建新数据库,将新用户添加到数据库并授予用户对数据库的所有访问权限。

#1


0  

            <?php
            require("xmlapi.php"); // this can be downlaoded from https://github.com/CpanelInc/xmlapi-php/blob/master/xmlapi.php
            $xmlapi = new xmlapi("cpanlel host name");   
            $xmlapi->set_port( 2083 );   
            $xmlapi->password_auth('cpanel username','cpanel passsword');    
            $xmlapi->set_debug(0);//output actions in the error log 1 for true and 0 false 

            $cpaneluser='cpanel username';
            $databasename="something";
            $databaseuser="database username";
            $databasepass= 'database password';

            //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('' . $databasename . '', '' . $databaseuser . '', 'all'));
            ?>

Using the above code you will be able to create new database, add new user to database and give all access to user on database.

使用上面的代码,您将能够创建新数据库,将新用户添加到数据库并授予用户对数据库的所有访问权限。