Questions & Answers

Q: I understand that I can use this version of your software to gather info from users through forms and that I send the data directly to specific mySQL databases that I have set up. Does the package perform validation of the form data that is entered so malicious code is not sent automatically to my MySQL database?

A: Form1 Builder MYSQL uses the php function mysql_real_escape_string() to clean data before placing it in a MYSQL database. It is designed to make data safe before sending a query to MySQL. For more detail on this function see http:// www.php.net/manual/en/function.mysql-real-escape-string.php .

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

Q: Am I correct in thinking that the code is configured specifically for the form created by the program or does it dynamically pick up the field names?

A: No the processing code will process all the form fields (based upon the settings ie Upper Case etc), it is dynamic. So you can use the same processing code with any form. The processing code simply looks for any posted fields and processes them in line with the set variables. But remember for data to be added to a MYSQL database fields must be set in the database that match the form fields.

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

Q: I am receiving the following email error message (Error MYSQL TEST). Have you got any suggestions on what I may be doing wrong. I have followed all the requirements and set up the table 'abc'.

A: This error indicates that the data cannot be added the specified database table. Recheck MYSQL Server Name, MYSQL User Name, MYSQL User Password, MYSQL Database Name, MYSQL Table Name. These must match existing settings in the MYSQL database. Also recheck that the existing table (MYSQL Table Name) has field names that correspond to form field names and text variable types are used. Remember if your form field is First_Name it displays as First Name in your browser but the MYSQL field must be First_Name. It is also recommended that the form is run on the same server as your MYSQL database. Also make sure that any MYSQL table fields that are not skipped can accept the MYSQL Empty Value or NULL values. If you have access to the error log files for your server you may be able to identify the problem by checking the error log entries. If you still have difficulty try stripping your form and database down to a single field ie subject to eliminate/minimize potential data mismatches and determine if it is an access or data issue.

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

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

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