How to show data stored in Liferay database in another website?
I'm developing a WordPress website in which I have to show data/information stored inside a Liferay database. I am new to Liferay, so I don't know the best practices to access data stored into Liferay's DB and show them to my website.
I want to know if there are some guides or documentation that can explain to me how I can access data, in the same way that I access a MySQL DB with PHP. I also took a look at the official Liferay documentation, but it only describes accesses through the usage of PHP portlets.
Is there another way to connect to database and get back data from a query, or do I have to perform a sort of "middleware" translation from data in Liferay to my website?
My CMS contains data formatted in XML, so have I to do a translation from XML to PHP-style variables? Also, do I need to create a sort of correspondence from XML objects to PHP variables?
I can think of three ways you can get data from Liferay to display in your website:
Directly through Liferay database, if you have access.
But to get data directly from the Database tables of liferay you should have a fair amount of understanding as to what each table is for. Liferay DB schema would have been helpful but I think Liferay likes providing puzzles to its users ;-). Still the tables and columns are not so complex to understand if you can give some time. Or post a specific query and will answer if I know about it.
Another recommended way of accessing liferay's data is through Liferay web-services, all the assets, users, organizations and sites are available as services. So you can build web-service clients and consume the data.
Another way is through Sharing of Portlets. The User-guide will help you understand this. You can directly embed portlets in your site just like we can embed video player from youtube in any site with youtube's embed script.
Hope I have understood what you require and hope this helps.
- A Linux, Apache, MySQL, PHP (LAMP) stack is a combination of open source software that is typically installed together to enable a server to host dynamic […]
- MySQL is an the most popular open-source database management system, in most of hosting company its has been bundle by LAMP(Linux, Apache, MySQL, PHP/Python/Perl) stack. Another alternative […]
- MySQL is the world’s most popular open-source database. Despite its powerful features, MySQL is simple to set up and easy to use. Below are some instructions […]