Importing Swear Words into database

lrgorby1150

New Member
Wurlie User
Aug 23, 2011
17
0
0
If anyone is interested, you can import words from a list file that you do not want anyone to use as a short URL.

Here is how you can do it.

If you have Excel, open it.

First you need to create a column of incremental numbers. For example numbers ranging from 1 to 50. put the number 1 in the "A" column and first row. Next put a 2 in the second row in the "A" column. Now select both columns with the shift key and drag your cursor to the bottom of Excel or wherever your list will end.

2nd. Grab a list of words that you do not want included into your website URLs and here is a good list to begin with:
http://www.bannedwordlist.com/lists/swearWords.txt. Copy and paste all of the words into Excel starting at Row 1, column B. If your words were copied in a txt file in a vertical fashion, they should be pasted from the top down in your Excel document.

3rd. There is no need to add the date and time if you do not want to. Simply save the file as a .CSV file.

4th and final step. Go to your hosting account phpMyAdmin panel and go to your "banned_words" table and select import. Select the file and there you have it. A whole selection of words that cannot be used.

Hope this helps someone