close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

CSS Form Builder and MySQL

Thread began 5/08/2013 8:20 pm by dc50093 | Last modified 5/13/2013 12:55 pm by Jason Byrnes | 498 views | 3 replies |

dc50093

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? .

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

dc50093

Followup Questions

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!

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...