setting up webhosting with php/mysql

[babil]

Hello all,
is it possible to do the following thing with php/mysql?

1. user registers
2. upon clicking the "submit" button a php script creates a mysql DB
with a unique name ( So far so good, till there I have no prob)
3. the specific user gets SELCT INSERT UPDATE rights for his database only.
4. Mysql quota is set to 10MB
5. user directory with write permission only by the specific user gets created
under the www directory.
6. Syncronization of Disk quota and mysql quota e.g. 9MB pictures in the user directory,
means 1MB left for mysql or the oposite 9MB mysql data, 1mb free in the user directory.

This whole thing must run on its own without someone to create the accounts

thanks in advance
Vassilis

PS: As someone suggested in another forum, a possible solution is to connect php to a perl demon and the execute then system related actions. ( php should not execute scripts as root due to security reasons). Any good link to start reading about this or maybe another idea?

[jatar_k]

off the top of my head I am not sure if all that could be done through php, probably, though I would test it as I went.

If I was to set that up i would probably use a shell script that could be fired by php or by cron.

[coopster]

I was thinking the same a shell script -- but at the same time I think I would rather be notified of the request as opposed to just firing it off. Unless a confirmed credit card transaction or otherwise has already occurred ;)