Search query can search 0

PHP
1

i have this search query i just thought i ran all number test and i found out that if i search for 0 it will return as empty please what am i doing wrong here thank you

if (isset($_SESSION['advs']) && is_array($_SESSION['advs']))
{
    $searching = true;
        
    if (!empty($_SESSION['advs']['team1_score']))
    {
        $wher .= '(';
        if (isset($_SESSION['advs']))
        {
            $asparams[] = array(':liketeam1_score', '' . $system->cleanvars($_SESSION['advs']['team1_score']) . '', 'int');
        }
        $wher .= "(b.team1_score like :liketeam1_score)) AND ";
        $asparams[] = array(':liketeam1_score', '' . $system->cleanvars($_SESSION['advs']['team1_score']) . '', 'int');
        
                $by = 'b.bidwhen ASC';

    }

    
    if (!empty($_SESSION['advs']['team2_score']))
    {
        $wher .= '(';
        if (isset($_SESSION['advs']))
        {
            $asparams[] = array(':liketeam2_score', '' . $system->cleanvars($_SESSION['advs']['team2_score']) . '', 'int');
        }
        $wher .= "(b.team2_score like :liketeam2_score)) AND ";
        $asparams[] = array(':liketeam2_score', '' . $system->cleanvars($_SESSION['advs']['team2_score']) . '', 'int');
        
                $by = 'b.bidwhen ASC';

    }


}
2

edit found the culprit !empty for isset

2 Likes
3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.