I’m trying to build my first real website so unfortunately I don’t have any great knowledge of the subject. I can do basic HTML and at one point I could program in Turing but I’m pretty sure that’s worthless. Anyway, I’m trying to build a website that is primarily a search function. It would have a variety of search options (for example, “Price,” “colour,” and other functions). These would then return results that would match all the selected relevant queries. I’m also interested in making the search bars have options (such as for “Price” have a “between” option (eg. Between $10 and $20)). While I have found how to make a search bar in HTML, to my understanding I can’t make a search option this specific in it. So which programming language would you guys recommend for me to approach this in? I’ve heard that PHP is the best for this especially with my very limited skill.
Another big question is would there be a way for me to link the search options to an MS Access database (or MS Excel, but I would imagine Access would be more likely to work). So basically I’d have a database with each row being a product and along it would be all the information for the search (price, colour…etc) and whenever you’d use the search, it would rely off this database.
Sorry this is so much to ask, I’m just more at a loss of where to start (other than get educated which goes back to which language I should use :P). Any help is greatly appreciated. Thank you ahead of time