How to create queries to databases fed with QEWB forms?

Issues related to forms.
Post Reply
sbrantes
Posts: 26
Joined: Wed Mar 09, 2016 2:58 pm

How to create queries to databases fed with QEWB forms?

Post by sbrantes »

Dear Pablo
I am trying to add a query page to a DB using php on my site. I think you can take advantage of the form field since all the connection elements are included.
How could we apply a query to display a table with results?
It would be very good to have tools specially designed to query databases.
User avatar
Pablo
Site Admin
Posts: 3442
Joined: Mon Feb 13, 2006 7:00 am
Location: Europe
Contact:

Re: How to create queries to databases fed with QEWB forms?

Post by Pablo »

There are currently no tool to display data from a MySQL database. You are the first user who has asked for this.
So, you will have to use a custom script to add this functionality to your website.

But you can post your suggestion in the 'Suggestions' section of this form. If more users find this useful then I will consider it for future development.
moris
Posts: 146
Joined: Fri Aug 18, 2017 8:43 am

Re: How to create queries to databases fed with QEWB forms?

Post by moris »

I actually think it's a great idea which can allow us to create more advanced websites.
sbrantes
Posts: 26
Joined: Wed Mar 09, 2016 2:58 pm

Re: How to create queries to databases fed with QEWB forms?

Post by sbrantes »

I have managed to create CRUD tables manually, taking examples from other authors.
These allow us to view and modify records of the same databases that we create in the forms that Pablo includes in QEWB. The forms are very good. For that reason, I think that having a CRUD in the FORMS menus would be very useful and would be another step to get the most out of mySQL databases.
I will post it in suggestions.
Thanks for the interest and the answers.
Post Reply