I'm attempting to monetise my experience as a frequent traveller. I'd like a database-driven site that has a drop down country selection and takes payment via PayPal for a fixed fee. Once payment is confirmed as received it will send an email to the customer (from an email address on my domain and a file on my server) with a PDF attachment.
I would like for the city/cities I have visited in that country to display once a country is chosen from the drop down (below the country name) and the file that's attached to be based on that selection.
For the purposes of speed and ease-of-use, this needs to be as simple to use as possible, while delivering my requirements. Thus, if a HTML select tag isn't the way to go and you can imagine something better for visitors - especially those on mobile devices - I'm very open to that.
Based on country selection, the header image and displayed city/ies are populated from the database table. I'd also like the country flag to be shown somewhere on the page. Next to the country name would be nice. I can manually upload two versions of every header image (mobile and desktop) if necessary. However, it would be nice if you can supply a script I can have on my server that will allow me to upload one image and then resize/create multiple sizes for me for common screen sizes and resolutions. I assume all the things I've listed (image location for the pictures - not the image itself) can be stored in a database table. I'm comfortable using phpMyAdmin and need to be able to easily add additional countries, cities and pictures in future, so this seems like a good way to do it. As long as I know the structure/where to upload everything, of course.
I realise that PayPal does currency conversion, but for the sake of those who don't understand that, I'd like to display £10, €13 and $13 as options in a drop down box with the payment button - ideally a PayPal branded button - and to be able to change these values in future. It's fine if I have to use some PayPal tool to do that, as long as it's fairly simple to do so.
Technologies: PHP/MySQL (not WordPress, Shopify or something like that) due to cheap hosting, please.
You can see the basics of the (very badly designed) HTML page here: [login to view URL] I'll be using a different domain, so branding can be very different. I have the domain, but would prefer to discuss that privately.
Whatever you design needs to look better than that page. I'm not necessarily looking for incredible design skills, but certainly something less ugly than what I've done
I'd like a dedicated URL (perhaps [login to view URL] or [login to view URL]) for each selectable destination. I say this because I would like all the cities I've visited while travelling to be shown in small text at the bottom of the page and to be clickable. It would also perhaps help with SEO, though I'm not sure. If you can produce a database-driven country selection (meaning I don't have to manually edit the html dropdown or whatever to add future countries) then great.
I'm terrible at SEO, so any basics you can cover would be good. Nothing super advanced required - or that goes against Google's rules/grey areas - in that area.
This of course needs to be mobile friendly and the static text easy to edit in future. As long as the static text is regular HTML that's fine.
If you think there is something that can be changed to reduce the cost, please let me know.
There would be 26 countries - the majority of which will have only 1 city - in the database.