perky416 Posted May 6, 2011 Share Posted May 6, 2011 Hi everyone, Im trying to create a search box for searching domain names on my website where the domain ends in a keyword entered in a text box. The problem im having is that the tld is hampering the search. As an example lets say im trying to search for the domain "test.com" by typing "est" in the search box. Nothing comes up because the domain stored in my database ends in .com, does anybody know a way i can exclude the tld? If excluding the tld is not possible or is complicated is doing something like the code below possible? I know its not written correctly im just trying to get across what im trying to accomplish. $tld = array('.com','.net','.co.uk'); mysql_query("SELECT domain_name FROM domains WHERE domain_name LIKE '%" . $_POST['keyword'] . $tld); Please could somebody give me some pointers? Many thanks. Link to comment https://forums.phpfreaks.com/topic/235741-problem-searching-for-domains-ending-in/ Share on other sites More sharing options...
efficacious Posted May 7, 2011 Share Posted May 7, 2011 i would look into using some sort of SQL regular expressions http://dev.mysql.com/doc/refman/5.1/en/regexp.html wish i could help you more this is a good thing to learn how to do. Link to comment https://forums.phpfreaks.com/topic/235741-problem-searching-for-domains-ending-in/#findComment-1211795 Share on other sites More sharing options...
perky416 Posted May 7, 2011 Author Share Posted May 7, 2011 Hi efficacious I got it to work simply by adding ".%" after the keyword, so basically the query is searching for anything keyword . anything. Link to comment https://forums.phpfreaks.com/topic/235741-problem-searching-for-domains-ending-in/#findComment-1211917 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.