CSS Form Builder and MySQL

I've been tasked with building a form that populates a MySQL database. The data is then to be viewed from a web page which should be editable so items can be deleted once the request is fulfilled. The issue that I'm having is that I just recently upgraded to SuperSuite and, given it's complexity, I'm not quite sure which tools to use. I figured I'd start by building the form in CSS Form Builder. Is there a tool that will enable me to create a MySQL database and insert the appropriate rows, columns, etc. Also, is there a tool that I can use to build a page to view and delete items in the MySQL database? If all of this is possible, what would the workflow be? .

In Data Bridge, you can use the Data Assist Create pages wizard to crete Insert, update, search, results, and details pages to manage a table in the database.

There are a handful of Application Presets, the application presets can create the table in your database for that preset, but thaose tables may not meet your requirements.

if not, you would need to use a MySQL GUI tool like phpMyAdmin to create a new table in your database and add the required columns prior to use the Data Assist create pages wizard.

the Create pages wizard can be accessd by going to WebAssist -> Database -> Create pages Wizard.

Hi Jason,

Thanks so much for your assistance.I have the first part squared away- I built a custom database w/ phpMyAdmin and used the Create pages wizard to create search, results, detail, insert, etc. pages. Everything is working beautifully so far.

I still need to link the form that I built to the database... but before I do that I've a few questions.

The form will contain credit card info so I'll need to lock the results and detail pages down with security. How do I do that? (Again, I have the full SuperSuite... which tool?)

Also, is there a way of putting an export to csv button on the detail page... and output to email or a directory? Or, even better, export it directly into a FileMaker database? Not to get carried away, but maybe a print shipping label button?

Thanks so much for taking the time to help me build something really special!

Use security assist to create the login page and registration pages.

it sounds like you only need admin login, so after registering the initial user, you can add protection to the registration page so it cannot be accessed.

as for storing credit card details, that is a very bad idea and in many cases can be illegal.

if you do store the credit card details, make sure to use encryption, and make sure to delete the information form the database once you are done.

Universal Email can be used to send information in an email, bit you should never pass credit card information in an email.

exporting the data to CSV would require hand coding to accomplish.