http://buycialisonlineworldwidestore.com/
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.

SP_READ_MORE

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

SP_READ_MORE

A view can be created by running a CREATE VIEW command on your database.

 

  • Open your database administration tool (usually PhpMyAdmin) and open a SQL query window. 
  • Create a view using the CREATE VIEW syntax (for starters, try something simple like "CREATE VIEW test AS SELECT * FROM oneofmydatabasetables"). 
  • Save the view within the database and display it. if it displays fine and without SQL syntax error within your database, go to your Tools JX admin screen. 
  • In "Connection", hit the "Check and list tables" button, the new view "test" should display in the "Table Names in Database" dropdown list in the "Table Settings section". 
  • Select "test" from the dropdown list, set up "test" in the Tools JX admin screen like you would set up any other of the databases' tables to be displayed in a grid in an article.

 

CREATE VIEW examples

Create a view "ViewName" that pulls 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

 

Create a view pulling data from two tables using INNER JOIN

CREATE VIEW ViewName AS

SELECT *FROM Table1 t1
INNER JOIN Table2 t2

ON t1.ID = t2.ID

 

Create a view that enables you to dislay images in the Table JX or Card View JX. It creates a <img> tag from a field where only an URL of an image is stored.  

CREATE VIEW ViewName AS 
SELECT field1, field2, field3, CONCAT('<img src="', image_field, '" />') AS image
FROM mytable
 
Create a view that displays true/false images according to the "flag" field.
 
CREATE VIEW YourView AS
SELECT
(case
(when flag = True) then '<img src="pic1.gif" alt="P1" />'
(when flag = False) then '<img src="pic2.gif" alt="P2" />'
end) As Pic
FROM YourTable
 
Two views that help to display the most recent article from each category.  Unfortunately mysql does not support a subselect in 'from' clause at creating a view. This is why we need to create two views. First one selects the last date and the category for each category from the articles' table. 
 
CREATE VIEW mxHelpView AS
SELECT catid, MAX(created) AS LastDate
FROM jos_content
GROUP BY catid
 
With the help of this view we select the most recent articles from each category.
 
CREATE VIEW LatestArticles AS SELECT jos_content . *
FROM jos_content
INNER JOIN myHelpView ON myHelpView.catid = jos_content.catid
AND myHelpView.LastDate = jos_content.created

It is obvious that a database view is a very powerfull tool for data manipulation. With the connection with Tools JX you can insert almost any set of data that you want straight into your Joomla article.
 
Maybe you will find the following links usefull:
 

Contact Us

Contact us on Facebook