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;
}