PHP Mysql create folder and new database for new registered user in my site

Question

i wanna ask something..

Here is my explanation.

1. i have a php system that user can register and use my accounting system on it.
2. My accounting system is finished it can install / create database by itself when go to example : www.mysystem.com/install/
3. it is impossible for my system when new a user register. it creates a new database on my server and create subdomain like newuser.mysystem.com and automatically install my accounting system on his/her subdomain folder??
4. if its impossible, what the next step i should do?
5. let me know if you guys don't understand my explanation. English is my 2nd language.

Answer 1

I'd like to know how good this worked for you. I sure hope it is future proof (and safe to a certain extent). Add a user only with CREATE and dump privileges to stay a little safe.

edit permission for temp files chmod 1777 /tmp

<?php
/* this is for a test website I was building */
 $dbusername = "admin_user";
$dbuserpass = "secretPa$$";
$dbname="new_customer_DB"; //use a more unique name
 $mysqli = new mysqli("localhost", $dbusername, $dbuserpass, "your_admin_db");

    $sql = "CREATE DATABASE `".$dbname."` /*!DEFAULT CHARACTER SET utf8 */;";


if ($mysqli->query($sql) ) {
    printf("$dbname successfully created.\n");
}

// dump database from master db into newly created one.
// dbname and masterdb are important
$masterdb ="customer_db_template";
$olduser= $dbusername;




$file = tempnam("/tmp", "FOO");

 $content= "[client]\n";
$content.= "user=$dbusername \n";
$content.= "password=$dbuserpass \n";
$content.= "host=localhost";
file_put_contents($file, $content);

print "<hr> ";

$cmd = "mysqldump --defaults-extra-file=$file --routines --opt $masterdb | mysql --defaults-extra-file=$file --host=localhost -C $dbname;";
print $cmd;
print "<pre>"; 

  system( $cmd   );  
unlink($file); //delete right away
mysqli::close ($mysqli );
print "</pre>";
?>

power answerers : how did I do?