Page 1 of 1

How to create queries to databases fed with QEWB forms?

Posted: Sun Dec 20, 2020 5:25 pm
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.

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

Posted: Sun Dec 20, 2020 6:32 pm
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.

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

Posted: Thu Dec 24, 2020 4:37 pm
by moris
I actually think it's a great idea which can allow us to create more advanced websites.

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

Posted: Sun Jan 24, 2021 5:15 pm
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.

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

Posted: Sat May 13, 2023 5:26 pm
by dmontaine
Yes! Please!