include/search.inc.php ➔ member_search()

Complexity

Conditions	5
Paths	4

Size

Total Lines

27

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function member_search($queryarray, $andor, $limit, $offset, $userid)   

The parameter $userid is not used and could be removed.

{   
    $sql = "SELECT * FROM " . $GLOBALS['xoopsDB']->prefix("users") ."";  
    // because count() returns 1 even if a supplied variable  
    // is not an array, we must check if $querryarray is really an array  
    if ( is_array($queryarray) && $count = count($queryarray) ) {  
        $sql .= " WHERE ((uname LIKE '%{$queryarray[0]}%' OR name LIKE '%{$queryarray[0]}%')";
        for ( $i=1; $i<$count; $i++ ) {  
            $sql .= " $andor ";  
            $sql .= "(uname LIKE '%{$queryarray[$i]}%' OR name LIKE '%{$queryarray[$i]}%')";
        }  
        $sql .= ") ";  
    }
    $sql .= " ORDER BY uname,name ASC";  

    $result = $GLOBALS['xoopsDB']->query($sql, intval($limit), intval($offset));  
    $ret = array();  
    $i = 0;  
     while($myrow = $GLOBALS['xoopsDB']->fetchArray($result)){  
        $ret[$i]['link'] = "".XOOPS_URL."\userinfo.php?uid=".$myrow['uid']."";   
        $ret[$i]['title'] = "".htmlspecialchars($myrow['uname'])." / ".htmlspecialchars($myrow['name'])."";
		$ret[$i]['time'] = "".$myrow['user_regdate']."";
		$ret[$i]['uid']   = "".$myrow['uid']."";
		$i++;   
    }   
    return $ret;   
}

?>

It is not recommended to use PHP's closing tag ?> in files other than templates.