Word Match

faheem786

Hi experts,

I have searched answers for my problem but takes a while to find out. So I post here hoping to get some answers

I have a website where people can register company names

I have to do some checking for the words before they submit. The reserved words are stored in database and I have to check whether the words entered by the user is not a resticted word(s)

For eg:

Money Exchange, Change, Trust, ABC Bank, A B C Bank are reserved words

if the user enters Money Exchange it's an error
if the user enters Exchange it's not an error
if the user enters Trust it's an error
if the user enters Trustee it's not an error

I could loop through the resticted words records and check whether the whole word exist in the user entered value strpos

===========

But the problem is if the user enters Trustee it comes as error even though Trustee is not restrcited where as Trust is restricted

If split the user entered words as array then I cannot check because some of the resticted words are more then one word but when we split the user enterd words to array by space it stores single word in each row. So I could not check.

Also I have a restricted word A B C BANK

If the user enters A B C BANK and I split this into array it is splitted as 4 rows which I cannot check against the restricted word
===========

I don't know how to do this. Help me plsssss

Thanks
Ahmad
Hong Kong

bo0

What does your script look like?

faheem786

$engName = isset( $POST["engName "] ) ? $POST["engName"] : "";

$SQL = "SELECT * FROM restricted_words jurisdiction = '{$jurisdiction}' ";
$result = mysql_query($SQL);
$numRows = mysql_num_rows($result);

//***************************************************//
if ($numRows > 0 )
{

while ($row = mysql_fetch_assoc($result)) {
$restrictedWord = $row['word'];

 $pos = strpos(strtolower($engName), strtolower($restrictedWord) );

 if ($pos !== false) {
   $errorWords .= "\"" . $restrictedWord . "\", ";
 }

}

}

kakki

hello,
why dont you try to let the db handle the problem?
like:

$engName = isset( $POST["engName "] ) ? $POST["engName"] : "";
if ( strlen( $engName ) > 0 )
{
$SQL = "SELECT count(*) FROM restricted_words WHERE name LIKE '".$engName.'";
$result = mysql_query($SQL);
$line=mysql_fetch_row( $result );
if ( $line[0] > 0 )
{
echo 'ERROR, NAME EXISTS ALREADY';
}
}

faheem786

Thanks a lot

But the problem as I mentioned before is

Bank is restricted word but not Banking
Trust is restricted but not Trustee
Also if the user enters "ABC Bank Limited" it means that the whole "ABC Bank Limited" will not be in restricted_words table but only the word Bank

Do you have any idea?

Thanks

leatherback

Hi,

How about adding a space before and after the keywordstring.
$engName = " ".$engName ." ";

and query with that?

faheem786

leatherback wrote:
Hi,

How about adding a space before and after the keywordstring.
$engName = " ".$engName ." ";

and query with that?

It won't work even if we add spaces because if the user types

ABC Bank and the restricted words have (Bank) I cannot query for the ABC Bank in restricted words but I can check whether the restricted word exists in the user data

leatherback

THen I think you are getting towards using a regular expression for this. Unfortuantely.. My RegExp skills are next to zero 🙁

Antyrael

If you're using static names that are reserved, why use 'LIKE' in the MySQL query?
If you want exact matches, isn't it easier to just use '=' instead?

leatherback

Well,
it looks like there is a need for:
- exact matches (Could use =)
- Submatches, which submitted string has spaces (= doesn't work)
- Submatches, where reserved words have spaces (= doesn't work)

faheem786

leatherback wrote:
Well,
it looks like there is a need for:
- exact matches (Could use =)
- Submatches, which submitted string has spaces (= doesn't work)
- Submatches, where reserved words have spaces (= doesn't work)

Thanks

For eg:

The user enters "ABC Bank Trustee"
The reserved words in the database are ('Bank', "Trust", "School")

? Could you please suggest me a sql

If we use

"SELECT * FROM restrcited_words WHERE word = 'ABC Bank Trustee' " will give me no results because I don't have such values

"SELECT * FROM restrcited_words WHERE word LIKE '%ABC Bank Trustee%' " will give me no results

Hope this helps more

Thanks
Ahmad

leatherback

You can do a full string match in the database, and a match against the exploded-by-space string. That still leaves the problem of restricted words with a space in the database though.

xblue

Ahmad,

try it the other way round

SELECT * FROM restrcited_words WHERE 'ABC Bank Trustee' LIKE CONCAT('%', word, '%')

I think this should work. I would not it does not address the issue with word boundaries though. That would probably require regular expression, but I am not very experienced with the mysql regex flavour. My first try would be

SELECT * FROM restrcited_words WHERE 'ABC Bank Trustee' REGEXP CONCAT('[[:<:]]', word, '[[:>:]]')

(Note that this is completely untested. Even if it should work, I'm not sure if this is the most efficient way)