|
Just to start off, Joomla does work with remote database connections.
I am going to put what I posted earlier in a better format.
To connect a Joomla site to a remote database, (not on your host account) you will need to make changes to the following in the configuration.php file in Joomla. You will also need to give the remote joomla database the ip address of the server you will connect with.
This is what needs changing in the Joomla configuration.php file to connect to the new database: |
|
Click To Download... [How to Connecting to Remote MYSQL database in joomla]
|
|
Generic database connector class.
An instance of this class, called $database, is created using the current Joomla configuration variables when each page is loaded. Therefore you do not generally need to create new instance of this object. If you need to access to $database within a function then remember to declare it as global.
Beginning with version 1.1, Joomla is being adapted to use the ADOdb database abstraction library (adodb.sourceforge.net). Some new methods have been added and some minor changes to existing methods have been made in order to accommodate this and these changes have been documented appropriately. Joomla versions prior to 1.1 support the MySQL database (www.mysql.com) only.
Joomla version |
|
Click To Download... [joomla database class and Functions]
|
|
A client wants to search a table within the Joomla database . Create a SELECT query to search this table based on user-defined criteria and present the list of results with navigational aids.
- Your organization uses an external accounting system running on an SQL database. Stakeholders want to be able to view a summary of expenses at any time. Create a SELECT query using SUM and GROUP BY to provide a report via the website.
|
|
Click To Download... [joomla database query]
|
|
|
|
joomla database