Save WFB results to a MS SQL Server...

User 315488 Photo


Registered User
90 posts

I know that WFB can save form data to a MySQL database. Unfortunately, I am stuck with a SQL Server database that I have to use.
I need to create a registration form that will save to this SQL server database. Is there anyway to use WFB for the form and then save the data into the SQL Server database?

I expect it would need some custom programming using PHP or similar code, but would like help getting me pointed in the right direction if it's possible. Thanks...
User 187934 Photo


Senior Advisor
20,271 posts

Write your own myformname.php to process the data as needed.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2673761 Photo


Registered User
3 posts

I also have a need to create my own database functions. I am actually using MySQL, but I need a more formal database construct with foreign keys instead of writing multiple records to one column separated with commas like WFB does.

How do I integrate into Web Form Builder? I can just bypass everything after the form validation, but I really like the email capabilities. I just need to know where to put my SQL code.

Thanks.
User 187934 Photo


Senior Advisor
20,271 posts

If I need customization I write my own myformname.php to process the data and send the emails. I have found it easier then trying to alter the forms built in code but I know you could do that.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2673761 Photo


Registered User
3 posts

Thanks, Eric. What I am looking for is the best way to pull in the post variables. I already have my own functions and all of the SQL fields, etc. What I need to know is where in all of the PHP files it would be best to pick up processing.

Basically, I want to send out the email using WFB and then write my data to MySQL. What is the best way to integrate into the existing framework?

Workflow
=======
browse to HTML file
fill out the form
the system sends the email
my PHP file saves the data to MySQL

How do I integrate my PHP file into the current files?
1) The form is built and all files are exported
2) Where/How do I add my stuff? If I have a PHP file called "myformname.php" where does it get inserted in the process?
User 187934 Photo


Senior Advisor
20,271 posts

I write my own myformname.php to process the data as needed and replace the form builders generated one.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2673761 Photo


Registered User
3 posts

I have modified the myformname.php script, but it doesn't work. I can't even see the post variables for some reason.

Basically, nothing happens and I get a blank page and no emails are sent.
User 187934 Photo


Senior Advisor
20,271 posts

When you say modified do you mean you wrote your own or you altered the existing myformname.php? There's nothing on the existing myformname.php that you will need for your own custom script.
This will echo all your form variables. It's a way to test a form submission for the need variables. All the form variables are available by $_POST['myvariblename'] or $_REQUEST['myvariblename'].

<table>
<?php


foreach ($_POST as $key => $value) {
echo "<tr>";
echo "<td>";
echo $key;
echo "</td>";
echo "<td>";
echo $value;
echo "</td>";
echo "</tr>";
}


?>
</table>
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.