joomla database

Import users from external database csv file

You can import the csv file using phpmyadmin if it has the correct information in the correct order, or you can put it in the correct order but it may not be the easiest thing.
I think at minimum you need name, username, email, password to import into jos_users.
I think you will have to make the salted md5 password + salt that it is stored in the Joomla database before importing or the added users won't be able to log in.

How to Connecting to Remote MYSQL database in joomla

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:

joomla database class and Functions

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

joomla database query

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.

More...

[ Back ]

Free Joomla Templates

Import users from external database csv file

How to Connecting to Remote MYSQL database in joomla

joomla database class and Functions

joomla database query