Re: [PHP-DB] spell checking and did you mean?
I believe Google Suggest uses the Levenshtein method. I would tend to go with that rather than soundex in order to avoid being too english-language-centric with your implementation. --bemansell On 3/23/06, peter lovatt [EMAIL PROTECTED] wrote: Hi All I am looking to check whether a keyword a user has entered already exists in the database I can find exact matches, but I am having trouble with typos. I am looking for something like Google's did you mean if you type in a close match. SO if someone types in saet it returns did you mean seat ? Any suggestions which is best - SOUNDEX in MySql or the php functions levenshtein(), soundex(),metaphone() or similar_text() on the returned result. Any other suggestions welcome. Thanks Peter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] ODBC support
Take a look at ADODB (It's a good database library that supports a variety of systems): http://php.weblogs.com/ADODB Here's a quick intro: http://www.databasejournal.com/features/php/article.php/651 -Original Message- From: Galbreath, Mark A [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 2:04 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] ODBC support Yes, I'm a newbie to PHP, but I got a phpBB2 BBS online in a day and I'm psyched. My problem is, the PHP docs and API mention that ODBC is built into PHP 4.x but I can't figure out how to use it. I would like to access the M$ Access JET engine directly from a PHP page. Any clues? tia, Mark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php