Jump to content

Custom module to enter details to an SQL database


Recommended Posts

Hi,

 

We currently run bouncybookings.co.uk and in order to create a new client we have to manually login to the SQL database and create a new client entry, the details for this entry are below.

The fields within the table should be fairly self explanatory but I'll cover them here.

id-> Auto increments so no need to fill out

login-> The login given to the client to access the bouncy bookings control panel

password-> The password given to the client to access the bouncy bookings control panel

package-> Not currently used but can be useful as a record

dbname-> name of the clients mysql database

dbuser-> user name for the clients mysql database

dbpass-> password for the clients mysql database

dbip-> IP address of the server hosting the mysql database

expires-> Not currently used but useful as a record

FTPIP-> IP address or URL of ftp server

FTPuser-> FTP User name

CalEmail-> The email address used for google calendar

FTPpath-> The path to the directory where files will be uploaded to. Defaults would normally be 'public_html/' or left blank

 

As we are looking to use whmcs for account management we are wanting it to auto create this information and also terminate it.

Look forward to your comments.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated