UserModel::getLike PHP Method

getLike() public method

public getLike ( boolean $Like = false, string $OrderFields = '', string $OrderDirection = 'asc', boolean $Limit = false, boolean $Offset = false ) : Gdn_DataSet
$Like boolean
$OrderFields string
$OrderDirection string
$Limit boolean
$Offset boolean
return Gdn_DataSet
    public function getLike($Like = false, $OrderFields = '', $OrderDirection = 'asc', $Limit = false, $Offset = false)
    {
        $this->userQuery();
        $this->SQL->join('UserRole ur', "u.UserID = ur.UserID", 'left');
        if (is_array($Like)) {
            $this->SQL->beginWhereGroup()->orLike($Like, '', 'right')->endWhereGroup();
        }
        return $this->SQL->where('u.Deleted', 0)->orderBy($OrderFields, $OrderDirection)->limit($Limit, $Offset)->get();
    }

Usage Example

 /**
  * Autocomplete a username.
  *
  * @since 2.0.0
  * @access public
  */
 public function autoComplete()
 {
     $this->deliveryType(DELIVERY_TYPE_NONE);
     $Q = getIncomingValue('q');
     $UserModel = new UserModel();
     $Data = $UserModel->getLike(array('u.Name' => $Q), 'u.Name', 'asc', 10, 0);
     foreach ($Data->result() as $User) {
         echo htmlspecialchars($User->Name) . '|' . Gdn_Format::text($User->UserID) . "\n";
     }
     $this->render();
 }
UserModel