Linking an outside db to certain pages

Permalink
Hopefully, ya'll can shed some insight on how to tackle this problem.

I'm building a simple travel website that showcases certain vacation properties. The availability of each property is propagated by a different website outside of concrete5. So to search availability, I've built a search query through php that pulls from the outside database and returns the results on it's own concrete5 page-type with hard coded php.

I've also created a page in concrete5 for each specific property. My question is how to sync the outside database and the pages in concrete5.

So, the user will search for specific dates and the results show all the properties that are available with that date. However, I want to display the page's attributes, like title and description, that are associated with the property's page.

Any ideas? Thanks!

 
ScottC replied on at Permalink Best Answer Reply
ScottC
you are using a page type so you can hook up a controller. Give each page a collection attribute that links somehow to your external data source and show the data from that, be it an api or an external database.
sllecks replied on at Permalink Reply
Right. Simple really.

Thanks for your help.