foto1
Make it simple to transparently display data on a website. Tools JX is a set of database reporting tools for Joomla! All of them are made to be very intuitive and as simple to use as possible.
foto1
Paid Downloads is a solution for you! It is a lightweight and simple-to-use extension, that makes your e-commerce simple and manageable. It uses PayPal's service to execute transactions.


Tools JX

Joomla plugins



Live Graph JX

Graph JX Live Graph JX 3.5
Price: 
9.99 EUR


For Joomla! 3.6.x

Learn more...

Table JX

Table JX 3.5
Price:
14.99 EUR


For Joomla! 3.6.x

Learn more...

Card View JX

CardView Card View JX 3.5
Price: 
9.99 EUR


For Joomla! 3.6.x

Learn more...

Setting up environment

First of all you have to make sure, that your PHP server is able to conect to Mycrosoft SQL server at all. This requires a PHP extension named SQLSRV which you can download from the Mycrosoft'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 Mycrosoft'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.

Log In

Like us on Facebook

Yoin us on LinkedI

View Tools JX users & developers's profile on LinkedIn