I need a simple script (preferably in 4 steps) that will remotely create a database, database user, and add the user to the database, on a cPanel server. The user will enter their cpanel login information, including host ip, and be able to create a database, user, and then add the user to the database.
User enters host IP, cpanel username and password, cpanel skin used, and desired database name. Pressing enter creates the database
If the database was successfully created a message displays saying so, and displays a form for creating a database user.
Information entered in previous step is contained within hidden fields so user does not have to re-enter it. Pressing enter creates the user.
If the user was successfully create a message displays saying so, and displays a final submit button to add the user to the database. Again, info entered in prior fields is contained within hidden fields so user does not have to reenter anything.
Fourth and Final Step
If the user was added successfully, display the database name (with the cpanel username prefixed as usual (ie joe_), database username, (again with the cpanel username prefixed), and the database password.
I would prefer if they weren't presented with a cpanel login prompt or redirected to their cpanel after the steps are performed. If it is unavoidable, perhaps it can be done in a way that does not cause confusion.
I have attached an example of the steps to show an idea of what I am looking for. It should be used only as a guide to the creation of this script.
I need this done ASAP. Please do not bid if you cannot have it done and working within 5 days.
Questions/comments please post me a PM. This project shouldn't take long at all for someone who is familiar with cPanel.
Just to make sure I'm absolutely clear on my goal here, the people utilizing this creator would not be hosted on the same server as me, and would likely only have user/reseller privileges on the server which they are hosted on.
Also, I would like to be able to view a demo prior to payment in full, to ensure it will work as I requested.
Just to clarify, it MUST be able to create databases on other servers, including those that may have APF (Advanced Policy Firewall) installed.