It would be best if I started out be explaining the situation:
A while ago I created a Property/Real Estate management system using PHP and MySQL. It works great and I have a lot of customers using it now but I would like to expand its capabilities to wordpress. I know a little bit about plugin development, but I do not know how to approach the project or how to design it.
Basically I want to create a plugin that takes information from a database (the one with all the property information) and displays it in wordpress. I need to create 3 parts: a search form, a results list and a page to display the property information. Here are some important points:
- I do not want to add the property information to the posts table. For example, on posts/custom-post-type per property. I want to retrieve the data directly from another table.
- I want to be able to use friendly URLs. For example: http://mysite.com/property/56
- I want to be able to set the title and description (in the head section) with data from each property
- All of this has to happen from the plugin and CANNOT rely on the theme.
So, what are your ideas? How should I approach this challange? Here is what I have been thinking, but I am not sure if it will work: 1. Create a custom post type called 'Property'. 2. Create a template file for displaying the property information. 3. Create a template file to show the search form and results. This could be like and archive template 4. That is as far as I got. I don't know how to make wordpress display a post that actually is not there.
Anyways, what are your ideas?
I appreciate the help.