DMXzone Database Connector PHP Support Product Page


MySQL Custom SQL Statements

Shared 11 May 2014 16:54:16
like this idea
11 May 2014 16:54:16 Randy Riesterer posted:
re: Custom SQL statements
I use PremiumSoft's Navicat as my MySQL database manager which includes a very nice query builder to create custom SQL queries. Any chance that you could add another tab to your Datasource Query Builder that would display an open screen where one could paste the SQL statement generated by a third-party query builder and use that code block to generate custom data displays on a PHP webapge? This would be an AWSOME addition to your product for those of us who need to quickly build such functionality into our sites.


Replied 12 May 2014 08:51:47
12 May 2014 08:51:47 Teodor Kuduschiev replied:
Hello Randy,
Thank you for sharing your idea with us.
We are currently discussing the best way to integrate such an option inside the extension. You will be notified as soon as there are news about this.
Replied 10 Aug 2015 08:58:34
10 Aug 2015 08:58:34 Arnold Jansen replied:
Hello, is there any progress on this yet? This will complete an awesome package of new extensions
Replied 19 Dec 2015 20:37:23
19 Dec 2015 20:37:23 Terrel Pochert replied:
I love to know if there is any solution yet as well. I have to used nested joins to pull two different values from a joined table2. I can create these in Navicat, but have no way to use these more complex (or custom) statements with in the Database Connector. To be able to use complex SQL states requires me to use a previous version of Dreamweaver and the older connection method. Unless, of course, I'm missing something with the current DMXzone Connector. If any users of suggestions, I'd love to hear them.
Replied 05 Sep 2016 23:09:04
05 Sep 2016 23:09:04 Carlos Koba replied:
That would be fantastic!! if you tell me that will soon I buy
Replied 21 Feb 2017 15:24:03
21 Feb 2017 15:24:03 User  replied:
Any word on this? I'm used to being able to edit the SQL statements in my PHP page code.

I am alsop potentially migrating sites to the DMX zone extensions, so being able to paste in the SQL statements would be extremely useful.

In fact, not being able to do so might be a deal breaker if I can't use expressions such as COUNT, GROUP BY or HAVING, or include nested queries.

Or, if it is possible to use those expressions using the builder somehow, is there a tutorial?
Replied 08 Jan 2020 11:36:25
08 Jan 2020 11:36:25 Teodor Kuduschiev replied:
It's now possible to write your own SQL queries using DMXzone Custom Database Query:

Reply to this topic