Save WFB results to a MS SQL Server...
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...
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...
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
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
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.
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.
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
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
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?
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?
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
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
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.
Basically, nothing happens and I get a blank page and no emails are sent.
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'].
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>
<?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
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.