I need a simple php script to manage a list small membership (about 50). You can see the current html version of the directory at oahi.org. (list of qualified home inspectors).
Here's how I think it would go.
It needs to have a table with the following fields?
- Business Name
- Contact First Name
- Contact Last Name
- Street 1
- Street 2
- More information
Also, if it isn't too much more expensive, I'd like to have three custom fields that I can define through the admin side.
The directory would have two views. The first view would basically be a spreadsheet/table showing just the Contact First & Last Name, the company name and the phone number. When you click on one of the listings it would give you the more detailed information. I would prefer that this information is pulled into the same window instead of showing up as a popup like it does now.
All of the pages will be in PHP so I can include the membership directory through a php include line.
I need a simple admin interface. This does not need a user database or protection as I'll protect it through the .htaccess, unless you give me some reason to believe that is not a good idea.
In the admin interface you should be able to add/edit/delete listings as well as modify the custom fields if we choose to use those.
Wish List (When Bidding Please Acknowledge if your bid includes these items)
1)Custom Fields (described above)
2)Templates for the two views (the templates wouldn't need to cover the whole page just the html directly effecting the look of the listing)
I was assuming that we'd build this with MySQL, though we could do it through a flat file if you don't feel it would be slow with a small directory.