The best way to pull data from multiple database tables is to create a Database View where the tables are joined and than to use this view with Tools JX.
How to connect to Microsoft SQL Server?
Setting up environment
First of all you have to make sure, that your PHP server is able to conect to Microsoft SQL server at all. This requires a PHP extension named SQLSRV which you can download from the Microsoft's official website and unfortunately only works on newer versions of Windows OS.
You will have to add a line to your php.ini file to tell your PHP script to use the extension. Depepending on your PHP installation you have to use one of the four extension files: php_sqlsrv_53_ts.dll, php_sqlsrv_53_nts.dll, php_sqlsrv_54_ts.dll or php_sqlsrv_54_nts.dll, where ts stands for Thread Safe and nts for Not Thread Safe. If you are not sure which one to use you can go to your Joomla Adninistration > Site > System Information > PHP Information and check your PHP version and a parameter called Thread Safety. Finally you open your php.ini file and insert a new line:
extension=php_sqlsrv_54_ts.dll
In the next step you will have to install a software called Microsoft SQL Server 2012 Native Client, to make the connection work. This is also freely available from Microsoft's website or you can use the download links on the official PHP website.
Now restart your PHP server and you should be good to go.
If you use a shared hosting, you should get in contact with your hosting provider, to set up environment for you.
Connection setting for Tools JX
To connect to a another database than the one thar Joomla uses, you have to select "Other" connection by using the radio button in the "Connection" area. Next, you fill in the connection data. To connect to MSSQL database using SQLSRV use the Database Type "sqlsrv". Other settings are straightforward. Fill in the host address (domain or IP address), database User and Password and Database Name.
On the end hit the "Check and List Tables" button, to test the connection. If ewerything is set properly a dropdown box should appear on the right with all the tables listed. Now you can proceed with selecting the table and columns.
How to connect to remote database?
Connecting to remote database
To connect to a another database than the one thar Joomla uses, you have to select "Other" connection by using the radio button in the "Connection" area. Next, you fill in the connection data. To connect to mysql database use the Database Type "mysql" or "mysqli" if you are connecting to MySQLi database. For other databases see below. Other settings are straightforward. Fill in the host address (domain or IP address), database User and Password and Database Name.
On the end hit the "Check and List Tables" button, to test the connection. If ewerything was allright a dropdown box should appear on the right with all the tables listed. Now you are able to proceed with selecting the table and columns.
SP_READ_MORE
How to create a database View and use it with Tools JX?
A view can be created by running a CREATE VIEW command on your database.
SP_READ_MORE
How to download?
How does it work?
After clicking the "Buy Now" button you will be redirected to the PayPal website to complete the payment. After completing the payment you will be redirected back to our website, where a download link will be available. You will be able to click this link only once. See this article for the screen shots.
Register and re-download
If you register using your PayPal email address (*), you will be able to access the products that you have purchased and some minor updates. Downloads are available from the Download Page. You can find a ling to the download page from the User Menu as well. As a registered user you will also be able to participate in the discussions on our Support Forum.
You can register here.
Do you already have an account?
If you already have an account on our website and you are not able to download the products that you have already purchased, you will have to change your email address to your PayPal email address (*) in your profile.
Minor and Major releases
Minor releases include bug fixes and some minor updates and are available for free once you have purchased a product. Major releases are issued as new products, therefore another purchase is needed to download them. Major releases usually follow up major Joomla! releases, i.e. Table JX 3.1 for Joomla 3.0+ will be a major release.
Questions? Did something go wrong?
Please use our support forum or contact us on This email address is being protected from spambots. You need JavaScript enabled to view it..* PayPal email address is that email address that you use to log in to PayPal before purchasing. SP_READ_MORE
How to pull data from multiple database tables?
The best way to pull data from multiple database tables is to create a Database View where the tables are joined and than to use this view with Tools JX.
SP_READ_MORE
What is a Database View (SQL View)?
A Database view is an object in SQL database.
You can create it by executing a CREATE VIEW command on your database. It is used to format, and combine data from multiple tables in one single table, which is not a real table since it just collects and formats data from other tables. But other applications that connect to the database they threat a table or a view in the same way. So in case of Table JX a database view will show up on the list among with all other tables after it is created.
Create View
The very basic example of an SQL command to create a View "ViewName" that puls data from "Table1" and "Table2" which are connected by fields Table1.ID and Table2.ID:
CREATE VIEW ViewName AS
SELECT * FROM Table1 t1, Table2 t2
WHERE t1.ID = t2.ID
For more information about views please refer to mysql documentation: dev.mysql.com/doc/refman/5.0/en/create-view.html
Copyright © 2021 ToolsJX All rights reserved.