I have some data in a database that Id like to access on my MODx site. Whats the best way to do this?
If the data is in a MySQL database, you can just do the standard export and import it into the MODx database (using PhppMyAdmin for both). If not, you can export it to a CSV file using whatever tool you have in the database program and then import it into the MODx database using PhpMyAdmin. Once it’s in the MODx database, you can access the data with the MODx DBAPI, usually in a snippet.
Related Questions
- I have the choice of manipulating database data using a String or a java.sql.Clob. Which has best performance?
- I have the choice of manipulating database data using a byte[] or a java.sql.Blob. Which has best performance?
- How do I enter data for a site someone else has already registered on the IOWATER database?
