[RESOLVED] similar_text help

msnhockey

I am at work right now and on a phone so I can't get source code added but I have a question regarding similar_text

I have a file that uploads 3 csv files into my database and this works awesome.

We are switching to a different program and it gives the same 3 files and everything looks the same except for the names

Ex- in my current script csv file the name is like this last name and then first name (Carter Michael)
Now in the new program the name is all capitalized
The name is stored in the db like Carter Michael

Is similar_text case sensitive and if so what do you think best solution is
Convert all to lowercase or convert to lower case and upper case first letter in each word

Trying to insert the new csv files everything inserts except anything that has a name next to it

msnhockey

Here is a quick snippet of the code that uses similar text

                                $team_id = $team == $hometeam[1] ? $homeid : $awayid;
                                $all_players = mysql_query("SELECT * FROM players WHERE teamid = $team_id");
                                $player_row = null;
                                while ($player = mysql_fetch_assoc($all_players)) {
                                    similar_text($player['lname'] . " " . $player['fname'], $row[4], $percentage);
                                    if ($percentage >= 85) {
                                        $player_row = $player;
                                    }
                                    $assists = explode(',', $row[5]);
                                    if (count($assists) >= 1) {
                                        similar_text($player['lname'] . " " . $player['fname'], $assists[0], $percentage);
                                        if ($percentage >= 85) {
                                            $assist1 = $player['id'];
                                        }
                                    }

                                if (count($assists) == 2) {
                                    similar_text($player['lname'] . " " . $player['fname'], $assists[1], $percentage);
                                    if ($percentage >= 85) {
                                        $assist2 = $player['id'];

dalecosp

msnhockey wrote:
Trying to insert the new csv files everything inserts except anything that has a name next to it

That's the real problem? Are we inserting into a database? What error message is received? Something about NULL or an empty string, perhaps?

I suppose you could say that [man]similar_text/man is case-sensitive:

php -r "echo similar_text('s','S');"
0

But there are so many great functions for handling text and doing normalization. Why choose similar_text()? You can even test munged values against each other without changing the original values.

In the case you show above, [man]stristr/man is generally used.

msnhockey

this script was made by a programmer last year. Yes i am trying to insert into a database.
Its trying to insert some of the rows that have player names but it only inserts the team name. I thought thats why it might be case sensitive cause that is the only difference in the CSV files from the ones i use now to the ones i will be using.

i did see that stristr() function as well as some levenstein() or something like that

msnhockey

i got it figured out

i added in this
$row[4] =ucwords(strtolower($row[4]));

just before this
while ($player = mysql_fetch_assoc($all_players)) {
similar_text($player['lname'] . " " . $player['fname'], $row[4], $percentage);

i am gonna work on getting that similar text out and try some other options but at least its working for the time being