I have created a simple form that takes the data that was input, and submits it to a mySQL database. I initially created the form using a free web-hose (000webhost.com) and everything worked great. I had it submitting the data correctly to the mySQL database, the confirmation page worked like it should, and the automatic emails were correct.

Now, this website is for my work, so once I had it operating properly, I needed to transfer it to a local internal server for internal work use only. I had my IT dept set up the server, they used a box with Win 7, and installed xampp 1.7.7. Now, my form doesn't quite work right, and I'm not sure why. The data is being submitted to the new mySQL database just fine. It is attempting to send the automatic emails, but I need to set it up with our local SMTP server for it to work correctly - so that's something I can work through. My problem though is on the form submission confirmation page. It either shows up completely blank, or shows up with a string of errors (depending on if I turn on strict error reporting in my php.ini file or not). Some of the errors I get are:

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\Engineering Request Form\fbapp\php\formcontroller.cls.php on line 22

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\Engineering Request Form\fbapp\php\formcontroller.cls.php on line 23

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\Engineering Request Form\fbapp\inc\validator.inc.php on line 28

That's just a few of them.

The xampp 1.7.7 is running: PHP 5.3.8, Apache 2.2, mySQL 5.5.16, PHP sessions are enabled.

I'm sure this is probably a server setup issue, but neither I nor my IT dept can understand what is missing.

Thanks for your help!

I see you are on a Windows. You may want to make sure you meet the minimum requirements first:

http://www.coffeecup.com/help/articles/ … m-builder/

On that article you can also find instructions for setting up custom SMTP settings.

I have gone back and verified the minimum requirements:

PHP 5.2 or higher - Running PHP 5.3.8

cURL extensions - Turned on (php.ini file in xampp set to: extension = php_curl.dll)

PHP sessions enabled - yes. To double check ran the servertest.php file that came with Web Form builder, and this is what was output: PHP Sessions: Cool, sessions are usable!

To install the software on your local computer, you need Windows XP/S3+, Vista or Windows 7 and Internet Explorer 7+ - Running Windows 7 Professional, SP1, with IE 8

So I think I have all of the minimum requirements set, but I still have the same issue with the confirmation page. Works fine on the external host, but when I copy the files to the local web server (and modify the mySQL info), I get nothing for the confirmation.

Did you customize your SMTP Settings? Since you are on a Windows server, you must do that as well.

I am working on the SMTP settings now. Is this required to even get to the confirmation page once the form is submitted?


Thanks again for your help!

Ryan

Yes, because the email needs to be sent before it can go to MySQL or confirmation page.

Ok, I have the SMTP settings correct now, and I get both the confirmation email (to the originator) and the submitted email (to the form owner)

But I am still not getting the confirmation page, it comes back blank, or it comes back with alot of errors (if I set strict error reporting - see first post). The form data is correctly inserted into the mySQL database, emails are correctly sent, I just can't get that confirmation page.

Thanks

Ryan

This form was working perfectly well on an external webhost, before I moved it local. I've modified all the settings to get the mySQL and emails working just like I want, but I can't figure out why I'm not getting the confirmation page.

I am not sure if I can help you on that one Ryan since it is on your local computer. In theory if your server settings are the same, it should work. If you turn off CSV and MySQL, does it work?

I just googled this. may be something to check. I use Wamp to check my forms but I have never tried to email locally



I have never tried this but it was given as a solution.
Don't you just love the world wide encyclopaedia