The Query Builder allows plugin users to execute any SQL command (DCL, DDL and DML) from the WordPress dashboard, as long as the user has the necessary credentials. The tool is available for admin users only and restricts access to WordPress tables. Multiple queries can be edited simultaneously. Queries can be stored per WordPress user account and can be reused at a later time. Output can be exported to CSV, JSON and XML. The Query Builder lets a plugin user access local as well as remote databases. The raw server response can be examined for further research.
Is it possible to create a search box on the front-end (i.e., on the website) in which users can input sql command instead of a keyword based search box?
Hi Ian,
It is possible but too risky. WordPress uses one user account to connect to the database. That user account can access all tables in your WordPress database. If you give website visitors access to sql, you give them accesss to your WordPress tables…
For publications you might consider the search builder. The search builder has some restrictions but allows visitors to create field based queries. A demo can be found here:
https://wpdataaccess.com/search-builder-demo/
Hope this helps,
Peter
once I have created a successful SQL query can I move it to a WordPress page or can I only run it from SQL app
Hi Rick,
Any query ran with our SQL Query Builder is valid. For example, if you run a Create Table query, a table will be created in your WordPress database, and you can then use it however you wish in your site. Hope that helps!
when I import a local data base and set it up so users can modify it am I modifying the table on my hosting server or is the new table stored elsewhere.
Hi Rick,
If you modify/alter the table using WP Data Access, you are modifying the table in your database directly. No new table is created unless you duplicate your table. Hope that answers your question!