This is a free form-mail PHP script with a back-end database.
The script allows visitors to fill a web form and send
the form data to a web site administrator. The script also saves the form data
to a MySQL database
so the administrator can search, view, edit, and delete
the forms from a web browser.
You can manually customize form fields or use the online tool,
Form2DB Builder to set them up.
Hi Tom, Need some custom form with hidden fields & Date input and edit/update above fields in admin Panel. Scenario: Customer submits product service form. Tracking issues, updating status whether ... Read More
Hi Tom. I have made numerous modifications to your software and it runs perfectly. My situation is this: I have a front end that grabs an input value from the user. The user is then directed to my ... Read More
Hi Tom. I have been using your software for almost three years now. I'm totally happy with it. However the machine that i was running on crashed and i had to take my original re-programming and ... Read More
Thanks for your prompt reply. We want to make a registration form in a database with information not the user is typing and will not appear on the form. The automatic information will be presented by ... Read More
Thanks Tom, The second part and important part of my question was, does the person sending the form also see the result of that hidden field if I configure the form to email the user the copy of ... Read More
Tom, I would like to add a hidden field containing an access code to be sent to the user of the form once the form is submitted. I understand I will need to change a part of the code so that the user ... Read More
Thank you Mr.Tom for your reply and I respect your help and support to me. Actually ya i didnt got any error message. Form was successfully send. But didnt reached up to my mail box. I even tried it ... Read More
Thank you very much for such wonderful support. Your website is truely amzaing. I had customized and downloaded forms from here. Form is getting feeded in DB but it is not getting mailed. Email is ... Read More
Did you get any error message when you submited the form? Since you didn't write it, I'll assume there were no error messages. Then most likely the form was successfully passed to your mail server ... Read More
Hi, is there a way to update the records on the staff edit area and stay on the same page, is redirecting back to the search page. Is difficult when there are several records to be updated . ... Read More
Hi, your configurations look fine to me. Of course, I can never be sure if you supplied correct information. For example, the email you typed may not exist or the password you typed could be wrong. ... Read More
Hi. thank you for this best scripts. i installed thsi script but i want change some functions. 1. don't show all members info in Search Results. i want show result which i search in Search ... Read More
Hello, In form2db script, i created a form with several textarea fields. The problem is in the admin page (staff) which need to print the form but the content is not displayed as there is a scroll ... Read More
include/tpl.sr.top_bar.inc.php contains more than the delete button, so you should open the file and edit the delete button only. Use the following the code snippet to create admin-only lines in the ... Read More
Tom, The form works and the database script works but I'm not getting email. I have tried to test it by having the submitted form sent directly to my @live email account and to my email forwarding ... Read More
Hi, if the form didn't show any error messages when you submitted the form, then the email was successfully passed to your mail server. For some reasons, the email was not delivered to the recipient. ... Read More
Sorry, currently there isn't an easy way to add a new staff type. It's definitly possible though. The currently available function is $sys->IsAdmin() only. The function tells whether the user is an ... Read More
Hi, I like your script very much ! But I've a little bit problem with this script. You know very well, when someone filled up this form, it automatically makes him/her "Active". But, I need him/her ... Read More
Tom, Thank you! This sounds VERY promising! However when I removed the 'tpl.frame.login.inc.php' file, I get a message reading: "Location : CSysCmd/Output Message : Tempalte ( tpl.frame.login.inc.php ... Read More
Hi, first sorry for my english.... When I submit the Form, I receive the following message: "This form has already been submitted" The first Form could be sendet..... Starting from the second try, it ... Read More
Hi! Do we have a form to prevent duplicate entries based on a certain field? Say, the username is an input... and I want to check against the DB that the same username is not already registered. On ... Read More
Is it possible to add a new 'record' in FormMail, just like in the "Lead Follow-Up Database. So only a Staff can make an new record and the admin can only delete it. I have tried to add "Add New" ... Read More
Do you need to make the size of a field larger/smaller? The following guide will show you an example for changing the size of a field. In this guide, you change the size of the tel field (of the Form table) from 36 chars to 60 chars.
Please follow the steps below *AFTER* you install the script!
Use phpMyAdmin to change the size of "tel" field of the table, tbl_form to 60 chars.
If you prefer to use a sql statement, use the following command:
Do you need another field similar to an exsiting field in the script? If so, the following step-by-step guide will help you. In this guide, you will add a copy of the tel field to the script. Let's call it "tel2."
Please follow the steps below *AFTER* you install the script!
Use phpMyAdmin to create a new field named "tel2" in the table, tbl_form. The attributes of the tel2 field should be exactly the same as the tel field except the field name.
If you prefer to use a sql statement to create the tel2 field, use the following statement:
ALTER TABLE `tbl_form` ADD `tel2` VARCHAR( 36 ) NULL AFTER `tel`;
Find the following code in web/codelib/asc/df.fl.form.inc.php.
Log in the staff area and check the detail page of one of form records. You will see the tel2 field and it's ready to use!
Optionally, you can add the tel2 field to the Search page.
To add it as a search criteria, see Adding a Search Criteria.
To display it in the Search Results table, see Adding a Field to Search Results table.