Find Jobs
Hire Freelancers

PHP/MySQL Cruise Search

$100-500 USD

Closed
Posted almost 20 years ago

$100-500 USD

Paid on delivery
I am looking for a php/mySQL programmer for the following project. Could you provide me with a price either in US$ or GB£. PHP based search script powered by mySQL 1) Search script to query mySQL database through eight possible criteria a) Cruise region dropdown (Caribbean, Mediterranean, Baltic...etc) b) Earliest departure date dropdowns c) Latest departure date dropdowns d) Preferred duration dropdown e) Cruise line dropdown (P&O Cruises, Royal Caribbean Cruises, Cunard...etc) – choosing a cruise line would populate the cruise ship dropdown of cruise ships with that cruise line f) Specific cruise ship (Explorer of the seas, QE2, Adonia…etc) – cruise ships available once a cruise line has been selected from the cruise line dropdown. g) 2 x radio button for “Show results by date” or “Show results by price” The submit button would query the mySQL database for the closest matching cruises to clients criteria (no more than thirty days results) and display the results in a results page either by price or by date, depending on which radio button is selected. The results page would show a table of cruises matching the client’s requirements with a “click here for further details” link for each cruise. This would send the client onto a detailed description of that particular cruise including ports of call, ship photo, cruise line description etc. This ‘further details’ page ultimately would need to have the URL rewritten using the Apache module “Mod_Rewrite” in the .htaccess to convert from a dynamic URL into a static URL to be search engine friendly. If possible, the title and Meta content created ‘on the fly’ to include details of the particular cruise in question, again to create a more search engine friendly page. Results page to use our website template. 2) A feature to enable me to create the database offline in excel and import into mySQL via a CSV text file or something along those lines. This will save me time from working online via a control panel and enable me to delete expired cruise dates. 3) The database structured by your, I have never worked with databases before, but I do understand the importance of structuring a database correctly. 4) A feature to power individual cruise line pages with cruises, pulling the top 5 or top 10 best value cruises for that particular cruise line from the database and displaying them in a table on each cruise line page. Each cruise given a score (cost of cruise/number of nights) and lowest score to 5th/10th lowest score displayed in a table with a link to the “further details” page. 5) Full ownership / copyright to the script. I have based this on the search facility found at [login to view URL], however, we don’t want this to be copied from them, just based on that idea, with added benefit of being able to power results for certain cruise lines on each corresponding cruise line page.
Project ID: 2094

About the project

34 proposals
Remote project
Active 17 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED KINGDOM
Preston, United Kingdom
0.0
0
Member since Jun 4, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.