Forum


List Manager Support

List Manager support
Forums
Public write access is disabled. Please login

Connect to MySQL Database 28.12.2018 04:53

Hello

I am very inexperienced with Web Design so forgive the simple questions.

I am wondering how to connect to a MYSQL database and display/edit/delete the contents of a table on my website via Joomla. Is there some instruction how to do this seemingly simple task?

thank you
Tony

Re: Connect to MySQL Database 28.12.2018 10:19

Hello,
the list manager allows managing data lists created with the extension. In order to publish the list you need to create first the list manager table, go to list manager main administration page and click 'new'. Then fill the 'fields' you will want to manage (the columns of the table), at the tab 'fields'.
Then you can import data to fill the list, you have several options to do that, both of them at 'manage data' option:

- if you have a csv file you can use its contents in order to make a first bulk upload.
- if you can write down a sql query able to return all data, you can use this option to make the first load.

After these steps you can publish the list. However we are not sure what do you mean when you say 'a mysql database'. It's an external database 'outside' joomla? Then you would have to export this information and upload using csv in order to fill the list manager table.

Please let us know if you need further help with any of the steps.

Regards
Moonsoft Team
www.moonsoft.es
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect

Our clients' feedback