MSQL in Wamp

User 464893 Photo


Ambassador
1,611 posts

Has anyone been able to get their form outputting to a Wamp MSQL database? If so please give, I for one have been trying many ways and so far have not hit the right buttons.
I have no problems with a hosts database but using Wamp's Localhost no dice. The commands for SQL and MSQL seem the same, even followed that tack.

Sadly I can do it in two moves. Output to a csv, redirect to a php script that finds the last entry in the csv and inserts that into the database. Which is not the point of the frustration and I hate being beaten.

Tell you what, the first person who solves this for me gets a full copy of my large zip file upload and extract online program I created. The one I made to upload WFB files in one go. I would need a copy of a simple form fb file and the database setting.
The Guy from OZ


User 103173 Photo


VP of Software Development
0 posts

I will also toss in 3 months of S-Drive Webbie as well for free. I know we can do this! :)
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 187934 Photo


Senior Advisor
20,192 posts

I did.:D
http://ericrohloff.com/coffeecup/ccforum/formbuilder/images/wampmysql.gif
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 464893 Photo


Ambassador
1,611 posts

Well! Eric there are two offers on the table time to claim. I just emailed someone I ws helping on another project and they said that it could be done but no record left. I guess I will re visit the bugger.

I will start with a new form, Even try my new HTML Editor to do it in. Excuses, Excuses
The Guy from OZ


User 464893 Photo


Ambassador
1,611 posts

I have it working, I think the mistake was to use root instead of creating a user and password. Usually the the user is root and pass 'No'. My Software safe, Unless Scott I could swap your offer for Direct FTP save me creating an online editor.

Anyway what I will do is knock up a simple app that creates the query to create the database to suit the form details. I do not want to go back in a couple of months time and start again.
For those that want to do it themselves without my help this should do it.
Go into Msql_Admin

click on sql top left
type >>>>>> Create Database "your_db" lower case click go
then type >> GRANT ALL ON your_db to user_name@localhost ; click go


This should create a database and add a user. If you have your settings right in WFB you should be right to go.

But you all knew that didn't you, but you were keeping it to yourself :(
The Guy from OZ


User 187934 Photo


Senior Advisor
20,192 posts

Great you got it. I was helping another user and stuffing my face at the same time. It's all in the user and the permissions. But you figured that out didn't you. As far as the offers make a special rolly egg and I'll donate the Webbie service to another user that finds it.:)
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 464893 Photo


Ambassador
1,611 posts

make a special rolly egg and I'll donate the Webbie service to another user that finds it.

Good on you Eric Hearing that Scott. You there Scott ;)

Anyway for what its worth and I created this for my long term memory which is on the decline
My Wamp DB Creator Get it at http://inkmon.coffeecup.com/storage/WampDbCreator.zip
Instructions after creating your form
Server Localhost
Port 3306
User Name Place in top box
Password Place in next box down
Database Name Place in bottom box

>>>> Press Create and copy each query and enter. Press Go each time
WFB creates the table for you

Contact me if you have problems http://inkmon.org/contact.html
The Guy from OZ


User 514723 Photo


Registered User
25 posts

very insightful, i feel much closer to getting this right, however, still no success :( how much do i have to pay either eric or prism to download TeamViewer and do this for me :/ would love to do this all by myself but it just isnt working for me for some reason...
User 2073552 Photo


Registered User
1,625 posts

David Annetts wrote:
how much do i have to pay either eric or prism to download TeamViewer and do this for me :/ would love to do this all by myself but it just isnt working for me for some reason...


$1,000,000!!! <insert picture of Dr. Evil here.>
"An Apple doth not fall far from its tree, yet an orange does."

https://lbwebsitedesign.com - Responsive Web Design & Web Hosting Services.
http://helpsite.sirage.com - HTML5, CSS3 and CC Help Video Blog.
User 514723 Photo


Registered User
25 posts

in that case, i'll pay someone to build my whole website ;)

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.