I have imported a [url removed, login to view] CSV file into a MySQL database which has various hotel description fields (e.g. Hotel name, description, contact details, price and longitude/latitude coordinate details, etc, etc) - there are just over 200 hotel details in this database.
I am looking for a PHP Coder to create a PHP script which will enable me to output the details of the MySQL database within the design of a .php page (e.g. within empty <div> tags). I'd like the details to be displayed within a table-less design which validates (e.g. no <table> use please).
There are around 200 hotel records so the hotel listing page summaries will need to paginate at 10 hotel summaries per page and use a nice page number navigation row built in. When a visitor clicks on a 'full details' link within each summary list, I would like another single/individual page opened within my design which will display all the database details for each hotel, with the hotel images, and also be integrated with a Google Map (or other map provider) which displays the hotel map image location from the longitude/latitude database record.
I already have a design to use so hotel summary listings (10 each page) will need to easily slot into this enabling me to style it using CSS and also be added to each single page of the design when clicked on as detailed above.
URLs will need to be SEO friendly (e.g. not [url removed, login to view] it will need to be hotels/[url removed, login to view] and so on).
A script would also still need to work when I update the MySQL file weekly with a new CSV file overwrite from Late Rooms.
I hope these details all make sense(!), but please get in touch for clarification or more information if required - this is an urgent request and I need the work completed as soon as possible, preferably within the next 24 hours please.