Start-up examples please of CC usage,...
Jerry James
Registered User
11 posts
I need example simple sites to use the latest CC web form builder, mysql and mailchimp to allow me to do each of the following steps over-all: display a form, receive the fields into mysql, maintain the received mysql file fields, then lastly print the mysql file. Knowing that this may actually take multiple screens/sites to perform these steps... I just need something for each step to get started... Thx
Eric Rohloff
Senior Advisor
20,190 posts
Eric Rohloff (Rolly) wrote:
This is a great resource. You can connect to your database and set it up in a page and format it to your liking.
http://www.freewebmasterhelp.com/tutorials/phpmysql/1
This automates the display off your data outside the cpanel with just a few mouse clicks.
http://opensource.platon.sk/projects/do … NG-STARTED
I did both and it works pretty slick. Can you say "PHP is cool".
Here's a page that I made and uses data submitted from the new form builder.
<?php
$username="mysql_test";
$password="mypassword";
$database="mysql_formdata";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM formtest";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
$i=0;
while ($i < $num) {
$FirstName=mysql_result($result,$i,"FirstName");
$Lastname=mysql_result($result,$i,"Lastname");
$address=mysql_result($result,$i,"address");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zipcode=mysql_result($result,$i,"zipcode");
$email =mysql_result($result,$i,"email");
$_submitted_ =mysql_result($result,$i,"_submitted_");
$_fromaddress_ =mysql_result($result,$i,"_fromaddress_");
echo "<b>First Name: $FirstName<br>Last Name: $Lastname</b><br> Address: $address<br>City: $city<br>State: $state<br>Zip Code: $zipcode<br>E-mail: $email<br>Date submitted: $_submitted_<br>IP address of user: $_fromaddress_<hr><br>";
$i++;
}
?>
This is a great resource. You can connect to your database and set it up in a page and format it to your liking.
http://www.freewebmasterhelp.com/tutorials/phpmysql/1
This automates the display off your data outside the cpanel with just a few mouse clicks.
http://opensource.platon.sk/projects/do … NG-STARTED
I did both and it works pretty slick. Can you say "PHP is cool".
Here's a page that I made and uses data submitted from the new form builder.
<?php
$username="mysql_test";
$password="mypassword";
$database="mysql_formdata";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM formtest";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
$i=0;
while ($i < $num) {
$FirstName=mysql_result($result,$i,"FirstName");
$Lastname=mysql_result($result,$i,"Lastname");
$address=mysql_result($result,$i,"address");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zipcode=mysql_result($result,$i,"zipcode");
$email =mysql_result($result,$i,"email");
$_submitted_ =mysql_result($result,$i,"_submitted_");
$_fromaddress_ =mysql_result($result,$i,"_fromaddress_");
echo "<b>First Name: $FirstName<br>Last Name: $Lastname</b><br> Address: $address<br>City: $city<br>State: $state<br>Zip Code: $zipcode<br>E-mail: $email<br>Date submitted: $_submitted_<br>IP address of user: $_fromaddress_<hr><br>";
$i++;
}
?>
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
Prism
Ambassador
1,611 posts
Ahh! Jerry
WFB will take your data and load it into a database or CSV file but if you want to do something with that data then you need to look into the ways data in databases is used.
That is beyond the scope of WFB as there would be so many variants. The tasks is not that daunting if you set your mind to it. The simplest way is to export the MSQL/csv data into Open Office or Microsoft Office and print data from there. Otherwise you will find a ton of examples of using php to do the task specific to you.
The help on this forum will get your data safely stored away and we all will attempt to help you go further but each requirement is unique. Your best option get the page and form working then come back.
Read the help pdf file. I can help with an example form but will need your email address for you to trial it yourself. I can be contacted via my domain below.
It may seem daunting at first but at least you have chosen the best program to start with.
So
Read and try the advice of the help file
Ask if you get stuck
Want a form to play with just ask. There are templates inbuilt that you can use, start with a simple one and try with that. There is no magic bullet we all had to learn. You are lucky you have us in your corner
It gets easier
WFB will take your data and load it into a database or CSV file but if you want to do something with that data then you need to look into the ways data in databases is used.
That is beyond the scope of WFB as there would be so many variants. The tasks is not that daunting if you set your mind to it. The simplest way is to export the MSQL/csv data into Open Office or Microsoft Office and print data from there. Otherwise you will find a ton of examples of using php to do the task specific to you.
The help on this forum will get your data safely stored away and we all will attempt to help you go further but each requirement is unique. Your best option get the page and form working then come back.
Read the help pdf file. I can help with an example form but will need your email address for you to trial it yourself. I can be contacted via my domain below.
It may seem daunting at first but at least you have chosen the best program to start with.
So
Read and try the advice of the help file
Ask if you get stuck
Want a form to play with just ask. There are templates inbuilt that you can use, start with a simple one and try with that. There is no magic bullet we all had to learn. You are lucky you have us in your corner
It gets easier
The Guy from OZ
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.
