Appnitro Software Forums » MachForm 2

1. inavran
   Member

   Hi,

   I have been looking for a php/mysql form builder and came arross MacForm.

   At first glance it looks very easy to use and extremely fast to develop in. (i was virtually sold from the start)...

   I do have a question about the way it stores the form data in its MYSQL db.

   I am looking to create a form (for internal office use), that uses 3/4 tables with many to one relationships...

   as an example ill use a simple website sales order system

   Tables summary
   1. Main header table [tabMain] - (contains all the general info on the order)
   2. Products sold table [tabProd] - (contains indivual info on each product sold on this order)
   3. Order Notes table [tabNotes]- (this might be used to keep a log of any
   communications from the customer/supplier.

   from each table there would be an ID, but on the child tables (tabProd/tabNotes) the main id from tabMain would be there as a foreign key to link them all together...

   As Machform handles all the database design internally, how could i tell it what keys were what? and also how could i tell each form to link back to the master?

   Is this going to be possible?

   I would code the whole thing myself, but to be honest my forms wouldn't look half as good (im not a php/ajax coder), and i'd really like to get this whole thing written in under a day...

   Any suggestions/advice would be appreciated.

   Many thanks

   Ian

   Posted 1 year ago #
2. 

   yuniar

   Hello Ian,

   I'm afraid MachForm won't be able to create the table structure as your requirement.
   Basically, MachForm will create one table for each of your form, each field will have its own corresponding column.

   In your case, since you have very specific requirement, I think the best way is to do your own custom form processing code.

   If you love the design of MachForm, you can simply use the HTML form template.
   You can use our free online generator http://www.phpform.org

   ---

   MachForm Founder

   Posted 1 year ago #

3. Saghalie
   Pro Member

   Ian,

   Use the generator. It is a great tool and you can edit the css to make it look any way you want it to. I've used it to create a user system for my wife's business where her clients can sign in and look at images of the babies they have. All using the forms from that generator. I've edited them so that main pages, contact pages etc are shown on the 'form'.

   It works out great and if you have a bright idea, you can edit the CSS to make it look even better.

   Regards,

   Saghalie
   http://www.kcmhosting.com

   Posted 1 year ago #

4. inavran
   Member

   Hi guys,

   Thanks for the reply. i'll take a look at the generator and let you know how i get on.

   Cheers

   Ian

   Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.