Php Strpos function is not working

[domino]

I am doing text analysis. I have a table having positive words.The records are being fetched one by one and imploded in an array through mysqli_fetch_array.

while(($rowx = mysqli_fetch_array($resultx,MYSQLI_NUM)))
{

 $wordx = implode("", $rowx);

    if(strpos($text, $wordx) !== FALSE) 

    {

        $count1 = substr_count($text, $wordx);
        $pos_prob += .2 * $count1;
        echo "pos prob is".$pos_prob;
    }
}

But strpos is not able to match the string that is being fetched from the table.i.e. if text is “It’s an excellent book” the if condition is never true. Even though the word excellent is present in the table. And if I hard code the value $wordx as

$wordx='excellent';

Only then it works. Does anyone has any idea why this is happening? Any help would be much appreciated

[droopsnoot]

When you retrieve the row from the table and implode it into $wordx, what would $wordx look like at that point?

[Dormilich]

@domino

if text is “It’s an excellent book” the if condition is never true. Even though the word excellent is present in the table.

strpos() does a full match of the needle, not a partial match. but your search string is a list of words and only if that search string as created (!) exists in the text, it will return true.

[domino]

It’s a simple positive word. I even tried echo “strpos($text, $wordx)”; to check the input but there was no problem in that.
And I get this output:
strpos(Its an excellent book, excellent)
strpos(Its an excellent book, excellently)

[domino]

But when I hard code the value it shows results. If it’s doing full-match then that wouldn’t have been the case.

[droopsnoot]

Therefore it must be something to do with assigning the value to $wordx. What happens if you try:

$wordx = $rowx[0];

instead of using implode()?

Also after you’ve assigned $wordx, can you var_dump both that and $text and show the results?

[domino]

It gives exact same result as implode function

[droopsnoot]

OK, and the var_dump() results?

[domino]

Here’s the output:
string ’ a+’ (length=3)
array (size=1)
0 => string ’ a+’ (length=3)
string ’ abound’ (length=7)
array (size=1)
0 => string ’ abound’ (length=7)
string ’ abounds’ (length=8)
array (size=1)
0 => string ’ abounds’ (length=8)
string ’ abundance’ (length=10)
array (size=1)
0 => string ’ abundance’ (length=10)

[domino]

Results for $wordx and $text:
string ’ a+’ (length=3)
string ‘Its an excellent book’ (length=21)
string ’ abound’ (length=7)
string ‘Its an excellent book’ (length=21)
string ’ abounds’ (length=8)
string ‘Its an excellent book’ (length=21)
string ’ abundance’ (length=10)
string ‘Its an excellent book’ (length=21)
string ’ abundant’ (length=9)
string ‘Its an excellent book’ (length=21)
string ’ accessable’ (length=11)
string ‘Its an excellent book’ (length=21)
string ’ accessible’ (length=11)
string ‘Its an excellent book’ (length=21)

[droopsnoot]

And can you show the section where one value of $wordx is present in the $text string?

Presumably the array you show in post #9 is the $rowx that comes from the query results?

[domino]

string ‘Its an excellent book’ (length=21)
string ’ excellent’ (length=10)
string ‘Its an excellent book’ (length=21)
string ’ excellently’ (length=12)

I think this is what you were asking for…

[John_Betong]

Try this:

$aWords = [
    ['Just testing to see if it works'], 
    ['It\'s an excellent book'], 
    ['Yet another test to see if it works'],
    ['This is an excellent book by an EXCELLENT author'], 
    ['Final test to see if it works'],
]; 
# while(($rowx = mysqli_fetch_array($resultx,MYSQLI_NUM)))
$pos_prob = 0; 
$text     = 'excellent';
$i2       = 0;
while ( $i2 < count($aWords) )
{
    $rowx  = $aWords[$i2]; 
    $sWords = implode("", $rowx );
    $sWords = strtolower( $sWords );

    # strpos( 'haystack', Needle);
    if( strpos($sWords, $text) !== FALSE) 
    {
      # substr_count( Haystack, Needls )
      $count1    = substr_count($sWords, $text);
      $pos_prob += .2 * $count1;
      echo "<br>pos prob is: ".$pos_prob;
      echo '<br>Found: <b>"' .$text .'"</b> in: "', $sWords .'"';
    }
  $i2++;
}

[quote] **Results:** pos prob is: 0.2 Found: "excellent" in: "it's an excellent book" pos prob is: 0.6 Found: "excellent" in: "this is an excellent book by an excellent author" [/quote]

Notice the Needle and Haystack.

[domino]

Thanks a lot for the help. But even this works:

               $word1='excellent';
	   if(strpos($text, $wordx) !== FALSE) 
        {

            $count1 = substr_count($text, $wordx);
            $pos_prob += .2 * $count1;
            echo "pos prob is".$pos_prob;
        }

[domino]

The problem is that the positive words from the database are not being matched.

[John_Betong]

@domino

if(strpos($text, $wordx) !== FALSE)
{

        $count1 = substr_count($text, $wordx);
        $pos_prob += .2 * $count1;
        echo "pos prob is".$pos_prob;
    }

I am amazed you can find a Haystack in a Needle!!!

Try this:

if(strpos($text, $wordx) !== FALSE) 
{
    $count1 = substr_count($text, $wordx);
    $pos_prob += .2 * $count1;
    echo "pos prob is".$pos_prob;
  
   // DEBUG
   echo '<br>Haystack => $text : ' .$text;
   echo '<br>Needle => $wordx : ' .$wordx;
   die;

}

[domino]

No. $wordx is a needle here. And haystack is $text. I am trying to search needle in the haystack. And I believe this is how it works!

[John_Betong]

@domino

It’s a simple positive word. I even tried echo “strpos($text, $wordx)”; to check the input but there was no problem in that.And I get this output:

strpos(Its an excellent book, excellent)
strpos(Its an excellent book, excellently)

Why the two results?

The first result show excellent but the second result shows excellently which is not in the string"Its an excellent book"

[John_Betong]

@domino

No. $wordx is a needle here. And haystack is $text. I am trying to search needle in the haystack. And I believe this is how it works!

OK, I was getting confused and thought you were trying to find a word in the database results instead of a searching for a string from the database results.

[droopsnoot]

@John_Betong

Why the two results?

Because of the quotes around “strops( xx, xx)” - OP is echoing what strings are being used rather than the result of the strpos() function.