I have a project that I think is PHP based… may be flash or combo.
We have a real estate website and a custom PHP/MySQL page showing listings. The admin portion allows an admin to add/edit/delete listings and add photos. It is very easy to use and simple. We have added a field to the MySQL database called "featured"
Here is what we would like...
If a listing is marked "featured" we would like it to show up on the home page along with some data from other fields such as main image, price, bedrooms, baths, city, and short description. Then when a photo is clicked or link to more info is clicked they are taken to the listing detail page. This is similar to how the current listing page works.
If there are multiple listings marked as "featured" we would like the home page to randomly display a listing and then fade into another listing. I'm open to other types of transitions as well.
Currently, the admin system allows a person to upload images and it will automatically size the image for a large image with max width of 500 pixels and a thumbnail with a maximum width of 100 pixels. The 500 Pixel image is too big for showing on the home page but the thumbnail is too small. I would like to be able show an image that is about 200-300 pixels wide along with the text. It would be more complex to actually re-write the image handling script to create a third size so I am fine with just pulling the 500 pixel sized image that already exists in the database and just sizing it smaller. I realize this is not the most effective way but will work for our purposes.
The website is [url removed, login to view]
The PHP portion for showing listings is shown when you click on the "featured listings" from the left navigation.
So to summarize:
- We want to randomly show listings marked "featured" in the MySQL database along with an image and text pulled from the database and link to product detail.
- The featured listings should appear randomly and rotate every 5 seconds or so. [For instance, if there were three featured listings, the home page would randomly pick the first listing and then every 5 seconds, the listing would transition to another featured listing.
I'm open to other suggestions if that would make the project simpler. The main thing is to show featured listings randomly on the home page.
We hired a programmer to get this done but he did not quite finish and disappeared. He was very close. The only problem is that the image was really blurry. I think he was just sizing up the small thumbnail image.
Here is the sample page:
[url removed, login to view]