The latest articles on DEV Community by AI E8 (@labslingua). https://dev.to/labslingua https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F316048%2Ffe00fcee-fbe7-49fa-90ea-b891789144b0.png https://dev.to/labslingua en AI E8 Mon, 13 Jan 2020 07:49:28 +0000 https://dev.to/labslingua/php-mysql-url-filtering-3i0k https://dev.to/labslingua/php-mysql-url-filtering-3i0k <p>Hi everyone.<br> I have a database that I would like the user to be able to filter using a drop down which will then take the user to a new page with the filtered parameters carried on the URL. Example:</p> <p>Database contains 3 columns (Spain, France, Germany), rows are cities such as:<br> For Spain: Madrid, Barcelona<br> For France: Paris, Marseille<br> For German: Berlin, Koln</p> <p>I would like that when the user picks using a drop-down: Spain and France, they will be taken to a URL such as: <a href="http://www.example.com/country=france&amp;country=spain">www.example.com/country=france&amp;country=spain</a> <br> in that link they will see only France and Spain and their city in a table. <br> So total will be 3 elements: (mysql database, page1 with drop down list, page2 with table with the filtered data). <br> Can anyone help with this? Thank you so much!!!</p> php mysql url filtering