PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Hi, I'm new to php and I want to write a script that can look in a mysql database and search for different criteria depending on the input from an HTML form. for example, I would have a HTML page that asks the user (via a HTML form) different questions, and then submits (or posts) the info to a php file which looks in the mysql database. The mysql database would contain different ski resorts (because that is what the website will be about) and the php file will show resorts that are good for skiing with a family for a complete beginner (or whatever else the user selects). The resorts in the mysql database may also turn up for more than one search. eg. a resort named "test" may turn up if the user selects the options shown in the picture below, or if the select the same options in the picture except the level, which could be 2 also. Then I want the php file to show a list of resorts from the mysql file suitable for the user that submitted the form.
Ok so best place to start is with your MySQL database. Set that up with your data - then once you've created your form and had a go at using Select Statements to search your database for the correct data we'll be able to help you out a bit more (rather than just writing it for you )