From: Tom Barrett on 21 Sep 2010 05:48 Hi I need to build a custom client management app, which will build and manage a database per client. This means that on top of the usual sql crud, it needs to be able to create databases, add/edit/delete database users, create tables. Is there a way for me to do this nicely as PHP solution? am I better off incorporating non PHP pieces into this (e.g. shell)? or should I leave the admin tasks (e.g. database creation) as a 'normal' administrative task (commandline/webmin/watever)?
From: Peter Lind on 21 Sep 2010 05:55 On 21 September 2010 11:48, Tom Barrett <tom(a)miramedia.co.uk> wrote: > Hi > > I need to build a custom client management app, which will build and manage > a database per client. This means that on top of the usual sql crud, it > needs to be able to create databases, add/edit/delete database users, create > tables. > > Is there a way for me to do this nicely as PHP solution? am I better off > incorporating non PHP pieces into this (e.g. shell)? or should I leave the > admin tasks (e.g. database creation) as a 'normal' administrative task > (commandline/webmin/watever)? > Seeing as all the "extra" stuff you need is just plain sql commands, I don't see the problem as such. You just need to make sure access to the tool is done right (i.e. a user that can create/destroy databases needs to be aware of this and you need to restrict the access to those specific persons). Regards Peter -- <hype> WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind BeWelcome/Couchsurfing: Fake51 Twitter: http://twitter.com/kafe15 </hype>
From: "Jangita" on 21 Sep 2010 06:20 Possible. Google phpmyadmin I believe it is completely written in PHP and does complete database administration (has some weaknesses on stored procedures though in my view) Jangita | +254 76 918383 | MSN & Y!: jangita(a)yahoo.com Skype: jangita | GTalk: jangita.nyagudi(a)gmail.com -----Original Message----- From: Tom Barrett [mailto:tom(a)miramedia.co.uk] Sent: 21 September 2010 11:48 AM To: PHP General List Subject: [PHP] Database Administration Hi I need to build a custom client management app, which will build and manage a database per client. This means that on top of the usual sql crud, it needs to be able to create databases, add/edit/delete database users, create tables. Is there a way for me to do this nicely as PHP solution? am I better off incorporating non PHP pieces into this (e.g. shell)? or should I leave the admin tasks (e.g. database creation) as a 'normal' administrative task (commandline/webmin/watever)?
From: "Jay Blanchard" on 21 Sep 2010 07:35 [snip] I need to build a custom client management app, which will build and manage a database per client. This means that on top of the usual sql crud, it needs to be able to create databases, add/edit/delete database users, create tables. Is there a way for me to do this nicely as PHP solution? am I better off incorporating non PHP pieces into this (e.g. shell)? or should I leave the admin tasks (e.g. database creation) as a 'normal' administrative task (commandline/webmin/watever)? [/snip] Have you thought about using phpMyAdmin? http://www.phpmyadmin.net/home_page/index.php
From: tedd on 21 Sep 2010 14:20
At 10:48 AM +0100 9/21/10, Tom Barrett wrote: >Hi > >I need to build a custom client management app, which will build and manage >a database per client. This means that on top of the usual sql crud, it >needs to be able to create databases, add/edit/delete database users, create >tables. > >Is there a way for me to do this nicely as PHP solution? am I better off >incorporating non PHP pieces into this (e.g. shell)? or should I leave the >admin tasks (e.g. database creation) as a 'normal' administrative task >(commandline/webmin/watever)? I'm not sure as to what you need, but for me I do all my database creation in phpMyAdmin. From there I populate with php. Cheers, tedd -- ------- http://sperling.com/ |