Using WordPress with content from another SQL database

  • Sorry if this is a daft question, but if you use WordPress for a site, with a theme for the pages etc. is it possible to incorporate content from another database.

    I currently run a site which has a back end database of holiday properties and they are looking to move it to a WordPress site – is iit possible and fairly straightforward incorporate the existing database content for the holiday properties in a WordPress site?

    Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)

  • No you will need to migrate the content to the new WordPress database.

    Thread Starter johngordon71

    (@johngordon71)

    Thanks – so as long as the tables for all the other data are part of the same main WP database it should be fine?

    I guess I’m just thinking about how it all fits together on pages themselves – for example, if I create a page in WordPress which has the navigation and bare bones layout, can I edit that page in, say, Dreamweaver, and add in data from the tables containing the holiday property stuff?

    Not really and sort of ?? You can place some raw html in a post or a page so you could do it in DW and then cut and paste it in. WordPress’s WYSIWYG editor will strip out some HTML so you have to stay in the text mode to preserve it though (not the ideal work flow).

    Most use the built in editor to create the pages. As far as pulling in the data you will need to code that in using a page template or use a Plugin. The first issue is how you are going to get the holiday property stuff into the data base and how are you going to store it. ie: In custom tables or through Post Meta Data (Preferred).

    There are many many real estate Themes and Plugins so I suggest you search for them and see what suits you best.

    Thread Starter johngordon71

    (@johngordon71)

    Thanks – I had a quick look and some look quite good, but presumably you are limited to the database tables / fields that come as part of the theme.

    Unfortunately we already have a fairly complex database structure – there are the properties themselves, and the owners can log in and update all their details. And there are other users who can log in and vote for the properties in various categories.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Using WordPress with content from another SQL database’ is closed to new replies.