class.ilLikeUserSearch.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
class ilLikeUserSearch extends ilUserSearch
{
    public function __createWhereCondition(): string
    {
        $fields = $this->getFields();
        $field = $fields[0] . ' ';
 
        $and = "  WHERE ( ";
 
        $counter = 0;
        foreach ($this->query_parser->getQuotedWords() as $word) {
            if ($counter++) {
                $and .= " OR ";
            }
 
            if (strpos($word, '^') === 0) {
                $and .= $this->db->like($field, 'text', substr($word, 1) . '%');
            } else {
                $and .= $this->db->like($field, 'text', '%' . $word . '%');
            }
        }
        return $and . ") ";
    }
}