using web form to query and display...

User 458848 Photo


Registered User
39 posts

Is it possible to create a form that I use offline and retreive information out of my Mysql DB? Ofcourse on submit it needs to connenct online to the DB.
Why an offline form so nobody can reteive my db info.
At this point I have to log in to MYphpadmin to view the data.
User 2147626 Photo


Ambassador
2,958 posts

Not without writing and installing a lot of your own code I think.
Try this out...there is a freeware version with a few limitations but I use it for basic access...There may be other free alternatives. http://www.sqlmanager.net/products/mysql/manager/
Graphics for the web, email, blogs and more!
-------------------------------------
https://sadduck.com
User 187934 Photo


Senior Advisor
20,181 posts

I'm doing this all the time. I have several variations where I'm actually populating dropdowns in my forms from Mysql databases. Your going to want to make a php login then setup you code to display the database results the way you like. For most databases html tables are the best but not required.
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 458848 Photo


Registered User
39 posts

Don't want to buy a software package and allways see myself liking the features and see oppurtunities to use them that are only included in the non free version. :-(
User 458848 Photo


Registered User
39 posts

@ Eric to you have an example that i may view?
User 187934 Photo


Senior Advisor
20,181 posts

Do you want to populate a html 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
User 458848 Photo


Registered User
39 posts

@Eric At this point I don't think it matters to much. As long as i can get a proper print out of it.
Although I do prefer working with divs.
User 187934 Photo


Senior Advisor
20,181 posts

Here's a quick one I through together. I didn't test it but it did come from one I was using. I removed a lot of the html so you had a bare structure to start from. It will make a html table that has alternating row colors.:cool: If you get any errors look on your server for the error_log. It will point you in the correct direction. Or post back here and I can help you out. I include the css in the head of the page for this but I use a style sheet for mine.
Attachments:
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 1743776 Photo


Registered User
74 posts

Anything new with this? I am now ready to populate form from mysql. Does EM SQL Manager work with CC Web Forms? What the mysqltable.txt ?
Using the fabulous RSD!
Live in a steady joy!
User 187934 Photo


Senior Advisor
20,181 posts

Anything with getting results from the database need to be done from outside the app.
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.