I need a fairly simple php script that will accept queries from a website form and return data from a mysql db.
This script needs to take variables that are entered in a website form and query a mysql db with them and then return the results to the webpage.
The form should have multiple fields, written in html, and the script should be written securely.
I will create the database. It will be a database of offers that are available, some of which will not be available to users from certain countries.
This could take one of two different approaches; the user on the website initially needs to select their country of origin, then select any offers that they have already claimed, then select their minimum spend amount.
The website form should offer a dropdown box of countries which the user can select from; offers not available to that country should be then excluded; next there should be an option to indicate any offers that have already been taken by the user to be excluded; next the minimum spend should be entered, and finally the available offers should be displaed, with the best offer first.