sngrl\SphinxSearch\SphinxSearch::getSnippetsQL PHP Method

getSnippetsQL() public method

public getSnippetsQL ( $docs, $index_name, $query, $extra = [] ) : array
$docs
$index_name
$query
return array
    public function getSnippetsQL($docs, $index_name, $query, $extra = [])
    {
        // $extra = [];
        if (is_array($docs) === FALSE) {
            $docs = [$docs];
        }
        foreach ($docs as &$doc) {
            $doc = "'" . mysqli_real_escape_string($this->_raw_mysql_connection, strip_tags($doc)) . "'";
        }
        $extra_ql = '';
        if ($extra) {
            foreach ($extra as $key => $value) {
                $extra_ql[] = $value . ' AS ' . $key;
            }
            $extra_ql = implode(',', $extra_ql);
            if ($extra_ql) {
                $extra_ql = ',' . $extra_ql;
            }
        }
        $query = "CALL SNIPPETS((" . implode(',', $docs) . "),'" . $index_name . "','" . mysqli_real_escape_string($this->_raw_mysql_connection, $query) . "' " . $extra_ql . ")";
        // die($query);
        $result = mysqli_query($this->_raw_mysql_connection, $query);
        // ddd($result);
        $reply = array();
        if ($result) {
            while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
                $reply[] = $row['snippet'];
            }
        }
        return $reply;
    }