ARI Soft - 3 databases on Localhost

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show Cart

Recent Events

31/12/2023 New Year SALE

We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

more...
21/11/2023 BLACK FRIDAY 23 is coming

BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.

more...

2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

3 databases on Localhost

(1 viewing) (1) Guest

Page: 12

TOPIC: 3 databases on Localhost

Forum Tools

#49164

3 databases on Localhost 10 Years, 2 Months ago	Karma: 0
Hi, Newbie here. I have 3 DB on my localhost server and would like to show information from one. How can I indicate that in the back end? I only see the option for Joomla Database (singular). Also, I tried indicating the specific DB in my query but received and error message at the front end. BTW: I'm using 2 modules to access different information fro the same database. Thanks, D. Ashley

zanni

The administrator has disabled public write access.

#49169

Re:3 databases on Localhost 10 Years, 2 Months ago

Karma: 748

Hello,

When "- Joomla! database -" option is selected, the extension will retrieve data from the database which is used by Joomla! instance where the module installed (Joomla! use one database). If you want to connect to not Joomla! database, set "Choose DB type" parameter to "External database" and configure connection parameters. It is not possible to choose a database in "SELECT" SQL query.

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#49243

[Connection Form?] Re:3 databases on Localhost 10 Years, 2 Months ago	Karma: 0
Hi another noob question - how do I get to the database connection form shown above (image: www.ari-soft.com/images/fbfiles/images/DB_query.png) and in other threads? I have been testing with directly editing the text connection string. Thanks. Sudhi

sudhi_muk@hotmail.com

Last Edit: 2014/05/04 05:42 By sudhi_muk@hotmail.com.Reason: added url to form image

The administrator has disabled public write access.

#49244

Re:[Connection Form?] Re:3 databases on Localhost 10 Years, 2 Months ago	Karma: 748
If you want to connect to an external database, set "Choose DB type" parameter to "External database" and configure connection parameters: Regards, ARI Soft

admin

The administrator has disabled public write access.

#49245

Re:[Connection Form?] Re:3 databases on Localhost 10 Years, 2 Months ago	Karma: 0
Thanks for the quick response. How do I get to that screen/form (Choose DB Type) is my question? I can't seem to find it anywhere. I am using Joomla 3.3 as base. And ARI Smart Content v. 1.9.3. Is my version too old? Sudhi

sudhi_muk@hotmail.com

Last Edit: 2014/05/04 06:09 By sudhi_muk@hotmail.com.

The administrator has disabled public write access.

#49246

Re:[Connection Form?] Re:3 databases on Localhost 10 Years, 2 Months ago Karma: 748

This is topic is about ARI Data Tables extension, it is not "ARI Smart Content" extension.

If you want to connect to an external database using "ARI Smart Content" via "ARI SQL Table" plugin, specify connection parameters in {ariconnectionstring} tag. The sample code below:

Code:



{arisqltable}

    {ariconnectionstring dbHost="localhost" dbUser="user" dbPass="pass" dbName="womenabo_db4" dbType="mysqli"}

    {arisqltablequery}

SELECT *

FROM gavg_users

    {/arisqltablequery}

{/arisqltable}

Regards,
ARI Soft

admin

The administrator has disabled public write access.

Page: 12

Useful Links