Menu
Community /Pin to ProfileBookmark
@NogDogNov 26.2011 — #I might consider a second column in the table just for the domain, then use [url=http://php.net/parse_url]parse_url[/url] to get the domain name portion of the url to be stored in that field. (You might want to consider stripping any leading "www." from the result so that someone cannot submit both "http://www.example.com/page1 " and "http://example.com/page2 ".
URL comparisons
Hi,
I’m trying to figure out a simple way to prevent multiple link submissions to a site. URLs are stored in a table and I can prevent exact repeats easily enough. The trouble is preventing for example, ‘
when ‘
I’ve tried various methods using LIKE and REGEXP in a mysql search, but in cases like the above example, it always misses them and allows it.
Any suggestions?
Thanks
Sign in
to post a comment1 Comments(s) ↴
0
@NogDogNov 26.2011 — #I might consider a second column in the table just for the domain, then use