Questions & Answers

Q: I'm evaluating your Form1 MySQL for use with a web database I've set up. I'm consistently getting "Error MySQL Form Submissions" sent to my e-mail when I try to send basic data to a test file. I've checked details like consistent datatypes (txt) and have that covered but I can't get data into the database.

A: This error email indicates that the set MYSQL table could not be accessed. Check all the variables outlined in the MYSQL section of the Help file. In particular make sure that MYSQL Support is enabled in the server php configuration, also it is recommended that the form is run on the same server as your MYSQL database.

Question and Answer Item 233 - Browse All Question and Answer Items

Q: Form1 MySQL can be used to enter data. Can it be used to update data?

A: Not using the standard structure, each form submission is treated as a new record and added to the table. It does not read or update existing data.

Question and Answer Item 234 - Browse All Question and Answer Items

Q: I need turn key basic business form set on mysql php can you help me ? ie inquiry form, basic questionnaire forms. Has anyone built an application that is lay person friendly and well explained?

A: Try our Form1 Builder MYSQL https://bizpep.com/form1/ you can use the Designer form to build a form with the add the required fields (simple click and add). To have the form data set in a MYSQL database your server host must provide you with a MYSQL database in which the form data can be added by the processing code. You can give it test run full details are included in the Help file.

Question and Answer Item 235 - Browse All Question and Answer Items

Q: Just been testing trial download of Form1 Builder MySQL. When the form processing code identifies that required fields are missing it provides a button to return to form to fill out the missing value. It also clears all fields on the form which would be very annoying if someone has just spent a long time filling out other valid fields on the form. Is this supposed to happen/is there a way of preventing this or do users have to use the 'Back' button to preserve previous values?

A: You can insert some code into your form to maintain form content until it is sent. See the Maintaining Form Content section (4) in the Help file for details. This has the benefit that it will work with all browsers, all the time, as opposed to some browsers some of the time. Alternatively if you wish to use the browser back button method then you can set up your own message pages and tell the user to click the browser back button.

Question and Answer Item 236 - Browse All Question and Answer Items

Q: I have successfully built a form using Form1Builder MySQL trial download and it inserts into database as required. I have then used the 'Existing Form functionality' but it does not seem to be able to allow ongoing 'edits' of the form. Is the process one-way, i.e. generation can only happen once and the designer view cannot be used to view existing fields and add more?

A: Existing Form allows you to use a previously set up form, either from a prior Form1 Builder session or a form that has been built by other means. When using Existing Form there must be no code (including form1 processing code) above the html start tag. If a file includes code above the html start tag open the file in a text editor and delete it before using the

Existing Form function. The Existing Form function is not designed for further editing although you can direct edit the code in the text area if required. It is recommended you set up your initial form layout either using a web editor or the Designer Form function or a combination of both. Keep in mind however that once you have added the processing code to the form it should only be edited using a text editor as html editors can corrupt the php coding.

Q: I am new to php and mySQL, which is why I am interested in your product. Will this tool allow me to create a form that will generate data for two tables at once? The first table would contain info on a person and the second would have multiple records linked to a record from the first table via a foreign key. Does your tool support that?

A: Each form submission will only update one database table but you can achieve what you require by linking two forms together. For example build the first form with the personal detail input and set it up to add this to the personal details table. In this form set the thank you url to point to the second form that has the additional detail required and set this up so that when it is submitted this data is added to the second table. The only issue would be the key, but you could pass it as a get variable between forms and add it as a hidden field for submission on the second form (this would require some additional php coding).

Question and Answer Item 237 - Browse All Question and Answer Items

<< < Page 271 272 273 274 275 276 277 278 279 280 > >>