mirror of
https://github.com/FreshRSS/FreshRSS.git
synced 2026-01-16 09:17:58 -05:00
7573fee4f0
The string syntax of `strtr()` cannot handle mutibytes characters, so need to be rewritten using an array map approach. Extend the fallback replacements to include the Windows/ISO charsets of the latin languages for which we have a translation
551 lines
18 KiB
PHP
551 lines
18 KiB
PHP
<?php
|
||
declare(strict_types=1);
|
||
|
||
/**
|
||
* This class is used to test database is well-constructed.
|
||
*/
|
||
class FreshRSS_DatabaseDAO extends Minz_ModelPdo {
|
||
|
||
//MySQL error codes
|
||
public const ER_BAD_FIELD_ERROR = '42S22';
|
||
public const ER_BAD_TABLE_ERROR = '42S02';
|
||
public const ER_DATA_TOO_LONG = '1406';
|
||
|
||
/**
|
||
* Based on SQLite SQLITE_MAX_VARIABLE_NUMBER
|
||
*/
|
||
public const MAX_VARIABLE_NUMBER = 998;
|
||
|
||
//MySQL InnoDB maximum index length for UTF8MB4
|
||
//https://dev.mysql.com/doc/refman/8.0/en/innodb-restrictions.html
|
||
public const LENGTH_INDEX_UNICODE = 191;
|
||
|
||
public function create(): string {
|
||
require_once APP_PATH . '/SQL/install.sql.' . $this->pdo->dbType() . '.php';
|
||
$db = FreshRSS_Context::systemConf()->db;
|
||
|
||
try {
|
||
$sql = $GLOBALS['SQL_CREATE_DB'];
|
||
if (!is_string($sql)) {
|
||
throw new Exception('SQL_CREATE_DB is not a string!');
|
||
}
|
||
$sql = sprintf($sql, empty($db['base']) ? '' : $db['base']);
|
||
return $this->pdo->exec($sql) === false ? 'Error during CREATE DATABASE' : '';
|
||
} catch (Exception $e) {
|
||
syslog(LOG_DEBUG, __METHOD__ . ' notice: ' . $e->getMessage());
|
||
return $e->getMessage();
|
||
}
|
||
}
|
||
|
||
public function testConnection(): string {
|
||
try {
|
||
$sql = 'SELECT 1';
|
||
$stm = $this->pdo->query($sql);
|
||
if ($stm === false) {
|
||
return 'Error during SQL connection test!';
|
||
}
|
||
$res = $stm->fetchAll(PDO::FETCH_COLUMN, 0);
|
||
return $res == false ? 'Error during SQL connection fetch test!' : '';
|
||
} catch (Exception $e) {
|
||
syslog(LOG_DEBUG, __METHOD__ . ' warning: ' . $e->getMessage());
|
||
return $e->getMessage();
|
||
}
|
||
}
|
||
|
||
public function exits(): bool {
|
||
$sql = 'SELECT * FROM `_entry` LIMIT 1';
|
||
$stm = $this->pdo->query($sql);
|
||
if ($stm !== false) {
|
||
$res = $stm->fetchAll(PDO::FETCH_COLUMN, 0);
|
||
if ($res !== false) {
|
||
return true;
|
||
}
|
||
}
|
||
return false;
|
||
}
|
||
|
||
public function tablesAreCorrect(): bool {
|
||
$res = $this->fetchAssoc('SHOW TABLES');
|
||
if ($res == null) {
|
||
return false;
|
||
}
|
||
|
||
$tables = [
|
||
$this->pdo->prefix() . 'category' => false,
|
||
$this->pdo->prefix() . 'feed' => false,
|
||
$this->pdo->prefix() . 'entry' => false,
|
||
$this->pdo->prefix() . 'entrytmp' => false,
|
||
$this->pdo->prefix() . 'tag' => false,
|
||
$this->pdo->prefix() . 'entrytag' => false,
|
||
];
|
||
foreach ($res as $value) {
|
||
$tables[array_pop($value)] = true;
|
||
}
|
||
|
||
return count(array_keys($tables, true, true)) === count($tables);
|
||
}
|
||
|
||
/** @return list<array{name:string,type:string,notnull:bool,default:mixed}> */
|
||
public function getSchema(string $table): array {
|
||
$res = $this->fetchAssoc('DESC `_' . $table . '`');
|
||
return $res == null ? [] : $this->listDaoToSchema($res);
|
||
}
|
||
|
||
/** @param array<string> $schema */
|
||
public function checkTable(string $table, array $schema): bool {
|
||
$columns = $this->getSchema($table);
|
||
if (count($columns) === 0 || count($schema) === 0) {
|
||
return false;
|
||
}
|
||
|
||
$ok = count($columns) === count($schema);
|
||
foreach ($columns as $c) {
|
||
$ok &= in_array($c['name'], $schema, true);
|
||
}
|
||
|
||
return (bool)$ok;
|
||
}
|
||
|
||
public function categoryIsCorrect(): bool {
|
||
return $this->checkTable('category', ['id', 'name']);
|
||
}
|
||
|
||
public function feedIsCorrect(): bool {
|
||
return $this->checkTable('feed', [
|
||
'id',
|
||
'url',
|
||
'category',
|
||
'name',
|
||
'website',
|
||
'description',
|
||
'lastUpdate',
|
||
'priority',
|
||
'pathEntries',
|
||
'httpAuth',
|
||
'error',
|
||
'ttl',
|
||
'attributes',
|
||
'cache_nbEntries',
|
||
'cache_nbUnreads',
|
||
]);
|
||
}
|
||
|
||
public function entryIsCorrect(): bool {
|
||
return $this->checkTable('entry', [
|
||
'id',
|
||
'guid',
|
||
'title',
|
||
'author',
|
||
'content_bin',
|
||
'link',
|
||
'date',
|
||
'lastSeen',
|
||
'hash',
|
||
'is_read',
|
||
'is_favorite',
|
||
'id_feed',
|
||
'tags',
|
||
]);
|
||
}
|
||
|
||
public function entrytmpIsCorrect(): bool {
|
||
return $this->checkTable('entrytmp', [
|
||
'id', 'guid', 'title', 'author', 'content_bin', 'link', 'date', 'lastSeen', 'hash', 'is_read', 'is_favorite', 'id_feed', 'tags'
|
||
]);
|
||
}
|
||
|
||
public function tagIsCorrect(): bool {
|
||
return $this->checkTable('tag', ['id', 'name', 'attributes']);
|
||
}
|
||
|
||
public function entrytagIsCorrect(): bool {
|
||
return $this->checkTable('entrytag', ['id_tag', 'id_entry']);
|
||
}
|
||
|
||
/**
|
||
* @param array<string,string|int|bool|null> $dao
|
||
* @return array{name:string,type:string,notnull:bool,default:mixed}
|
||
*/
|
||
public function daoToSchema(array $dao): array {
|
||
return [
|
||
'name' => is_string($dao['Field'] ?? null) ? $dao['Field'] : '',
|
||
'type' => is_string($dao['Type'] ?? null) ? strtolower($dao['Type']) : '',
|
||
'notnull' => empty($dao['Null']),
|
||
'default' => is_scalar($dao['Default'] ?? null) ? $dao['Default'] : null,
|
||
];
|
||
}
|
||
|
||
/**
|
||
* @param array<array<string,string|int|bool|null>> $listDAO
|
||
* @return list<array{name:string,type:string,notnull:bool,default:mixed}>
|
||
*/
|
||
public function listDaoToSchema(array $listDAO): array {
|
||
$list = [];
|
||
|
||
foreach ($listDAO as $dao) {
|
||
$list[] = $this->daoToSchema($dao);
|
||
}
|
||
|
||
return $list;
|
||
}
|
||
|
||
private static ?string $staticVersion = null;
|
||
/**
|
||
* To override the database version. Useful for testing.
|
||
*/
|
||
public static function setStaticVersion(?string $version): void {
|
||
self::$staticVersion = $version;
|
||
}
|
||
|
||
protected function selectVersion(): string {
|
||
return $this->fetchValue('SELECT version()') ?? '';
|
||
}
|
||
|
||
public function version(): string {
|
||
if (self::$staticVersion !== null) {
|
||
return self::$staticVersion;
|
||
}
|
||
static $version = null;
|
||
if (!is_string($version)) {
|
||
$version = $this->selectVersion();
|
||
}
|
||
return $version;
|
||
}
|
||
|
||
public function pdoClientVersion(): string {
|
||
$version = $this->pdo->getAttribute(PDO::ATTR_CLIENT_VERSION);
|
||
return is_string($version) ? $version : '';
|
||
}
|
||
|
||
final public function isMariaDB(): bool {
|
||
// MariaDB includes its name in version, but not MySQL
|
||
return str_contains($this->version(), 'MariaDB');
|
||
}
|
||
|
||
/**
|
||
* @return bool true if the database PDO driver returns typed integer values as it should, false otherwise.
|
||
*/
|
||
final public function testTyping(): bool {
|
||
$sql = 'SELECT 2 + 3';
|
||
if (($stm = $this->pdo->query($sql)) !== false) {
|
||
$res = $stm->fetchAll(PDO::FETCH_COLUMN, 0);
|
||
return ($res[0] ?? null) === 5;
|
||
}
|
||
return false;
|
||
}
|
||
|
||
public function size(bool $all = false): int {
|
||
$db = FreshRSS_Context::systemConf()->db;
|
||
|
||
// MariaDB does not refresh size information automatically
|
||
$sql = <<<'SQL'
|
||
ANALYZE TABLE `_category`, `_feed`, `_entry`, `_entrytmp`, `_tag`, `_entrytag`
|
||
SQL;
|
||
$stm = $this->pdo->query($sql);
|
||
if ($stm !== false) {
|
||
$stm->fetchAll();
|
||
}
|
||
|
||
//MySQL:
|
||
$sql = <<<'SQL'
|
||
SELECT SUM(DATA_LENGTH + INDEX_LENGTH + DATA_FREE)
|
||
FROM information_schema.TABLES WHERE TABLE_SCHEMA=:table_schema
|
||
SQL;
|
||
$values = [':table_schema' => $db['base']];
|
||
if (!$all) {
|
||
$sql .= ' AND table_name LIKE :table_name';
|
||
$values[':table_name'] = addcslashes($this->pdo->prefix(), '\\%_') . '%';
|
||
}
|
||
$res = $this->fetchColumn($sql, 0, $values);
|
||
return isset($res[0]) ? (int)($res[0]) : -1;
|
||
}
|
||
|
||
public function optimize(): bool {
|
||
$ok = true;
|
||
$tables = ['category', 'feed', 'entry', 'entrytmp', 'tag', 'entrytag'];
|
||
|
||
foreach ($tables as $table) {
|
||
$sql = 'OPTIMIZE TABLE `_' . $table . '`'; //MySQL
|
||
$stm = $this->pdo->query($sql);
|
||
if ($stm === false || $stm->fetchAll(PDO::FETCH_ASSOC) == false) {
|
||
$ok = false;
|
||
$info = $stm === false ? $this->pdo->errorInfo() : $stm->errorInfo();
|
||
Minz_Log::warning(__METHOD__ . ' error: ' . $sql . ' : ' . json_encode($info));
|
||
}
|
||
}
|
||
return $ok;
|
||
}
|
||
|
||
public function minorDbMaintenance(): void {
|
||
$catDAO = FreshRSS_Factory::createCategoryDao();
|
||
$catDAO->resetDefaultCategoryName();
|
||
|
||
include_once APP_PATH . '/SQL/install.sql.' . $this->pdo->dbType() . '.php';
|
||
if (!empty($GLOBALS['SQL_UPDATE_MINOR']) && is_string($GLOBALS['SQL_UPDATE_MINOR'])) {
|
||
$sql = $GLOBALS['SQL_UPDATE_MINOR'];
|
||
$isMariaDB = false;
|
||
|
||
if ($this->pdo->dbType() === 'mysql') {
|
||
$isMariaDB = $this->isMariaDB();
|
||
if (!$isMariaDB) {
|
||
// MySQL does not support `DROP INDEX IF EXISTS` yet https://dev.mysql.com/doc/refman/8.3/en/drop-index.html
|
||
// but MariaDB does https://mariadb.com/kb/en/drop-index/
|
||
$sql = str_replace('DROP INDEX IF EXISTS', 'DROP INDEX', $sql);
|
||
}
|
||
}
|
||
|
||
if ($this->pdo->exec($sql) === false) {
|
||
$info = $this->pdo->errorInfo();
|
||
if ($this->pdo->dbType() === 'mysql' &&
|
||
!$isMariaDB && is_string($info[2] ?? null) && (stripos($info[2], "Can't DROP ") !== false)) {
|
||
// Too bad for MySQL, but ignore error
|
||
return;
|
||
}
|
||
Minz_Log::error('SQL error ' . __METHOD__ . json_encode($this->pdo->errorInfo()));
|
||
}
|
||
}
|
||
}
|
||
|
||
private static function stdError(string $error): bool {
|
||
if (defined('STDERR')) {
|
||
fwrite(STDERR, $error . "\n");
|
||
}
|
||
Minz_Log::error($error);
|
||
return false;
|
||
}
|
||
|
||
public const SQLITE_EXPORT = 1;
|
||
public const SQLITE_IMPORT = 2;
|
||
|
||
public function dbCopy(string $filename, int $mode, bool $clearFirst = false, bool $verbose = true): bool {
|
||
if (!extension_loaded('pdo_sqlite')) {
|
||
return self::stdError('PHP extension pdo_sqlite is missing!');
|
||
}
|
||
$error = '';
|
||
|
||
$databaseDAO = FreshRSS_Factory::createDatabaseDAO();
|
||
$userDAO = FreshRSS_Factory::createUserDao();
|
||
$catDAO = FreshRSS_Factory::createCategoryDao();
|
||
$feedDAO = FreshRSS_Factory::createFeedDao();
|
||
$entryDAO = FreshRSS_Factory::createEntryDao();
|
||
$tagDAO = FreshRSS_Factory::createTagDao();
|
||
|
||
switch ($mode) {
|
||
case self::SQLITE_EXPORT:
|
||
if (@filesize($filename) > 0) {
|
||
$error = 'Error: SQLite export file already exists: ' . $filename;
|
||
}
|
||
break;
|
||
case self::SQLITE_IMPORT:
|
||
if (!is_readable($filename)) {
|
||
$error = 'Error: SQLite import file is not readable: ' . $filename;
|
||
} elseif ($clearFirst) {
|
||
$userDAO->deleteUser();
|
||
$userDAO = FreshRSS_Factory::createUserDao();
|
||
if ($this->pdo->dbType() === 'sqlite') {
|
||
//We cannot just delete the .sqlite file otherwise PDO gets buggy.
|
||
//SQLite is the only one with database-level optimization, instead of at table level.
|
||
$this->optimize();
|
||
}
|
||
} elseif ($databaseDAO->exits() && $entryDAO->count() > 0) {
|
||
$error = 'Error: Destination database already contains some entries!';
|
||
}
|
||
break;
|
||
default:
|
||
$error = 'Invalid copy mode!';
|
||
break;
|
||
}
|
||
if ($error != '') {
|
||
return self::stdError($error);
|
||
}
|
||
|
||
$sqlite = null;
|
||
|
||
try {
|
||
$sqlite = new Minz_PdoSqlite('sqlite:' . $filename);
|
||
$sqlite->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
|
||
} catch (Exception $e) {
|
||
$error = 'Error while initialising SQLite copy: ' . $e->getMessage();
|
||
return self::stdError($error);
|
||
}
|
||
|
||
Minz_ModelPdo::clean();
|
||
$userDAOSQLite = new FreshRSS_UserDAO('', $sqlite);
|
||
$categoryDAOSQLite = new FreshRSS_CategoryDAOSQLite('', $sqlite);
|
||
$feedDAOSQLite = new FreshRSS_FeedDAOSQLite('', $sqlite);
|
||
$entryDAOSQLite = new FreshRSS_EntryDAOSQLite('', $sqlite);
|
||
$tagDAOSQLite = new FreshRSS_TagDAOSQLite('', $sqlite);
|
||
|
||
switch ($mode) {
|
||
case self::SQLITE_EXPORT:
|
||
$userFrom = $userDAO; $userTo = $userDAOSQLite;
|
||
$catFrom = $catDAO; $catTo = $categoryDAOSQLite;
|
||
$feedFrom = $feedDAO; $feedTo = $feedDAOSQLite;
|
||
$entryFrom = $entryDAO; $entryTo = $entryDAOSQLite;
|
||
$tagFrom = $tagDAO; $tagTo = $tagDAOSQLite;
|
||
break;
|
||
case self::SQLITE_IMPORT:
|
||
$userFrom = $userDAOSQLite; $userTo = $userDAO;
|
||
$catFrom = $categoryDAOSQLite; $catTo = $catDAO;
|
||
$feedFrom = $feedDAOSQLite; $feedTo = $feedDAO;
|
||
$entryFrom = $entryDAOSQLite; $entryTo = $entryDAO;
|
||
$tagFrom = $tagDAOSQLite; $tagTo = $tagDAO;
|
||
break;
|
||
default:
|
||
return false;
|
||
}
|
||
|
||
$idMaps = [];
|
||
|
||
if (defined('STDERR') && $verbose) {
|
||
fwrite(STDERR, "Start SQL copy…\n");
|
||
}
|
||
|
||
$userTo->createUser();
|
||
|
||
$catTo->beginTransaction();
|
||
$catTo->deleteCategory(FreshRSS_CategoryDAO::DEFAULTCATEGORYID);
|
||
$catTo->sqlResetSequence();
|
||
foreach ($catFrom->selectAll() as $category) {
|
||
$catId = $catTo->addCategory($category);
|
||
if ($catId === false) {
|
||
$error = 'Error during SQLite copy of categories!';
|
||
return self::stdError($error);
|
||
}
|
||
$idMaps['c' . $category['id']] = $catId;
|
||
}
|
||
$catTo->sqlResetSequence();
|
||
foreach ($feedFrom->selectAll() as $feed) {
|
||
$feed['category'] = empty($idMaps['c' . $feed['category']]) ? FreshRSS_CategoryDAO::DEFAULTCATEGORYID : $idMaps['c' . $feed['category']];
|
||
$feedId = $feedTo->addFeed($feed);
|
||
if ($feedId == false) {
|
||
$error = 'Error during SQLite copy of feeds!';
|
||
return self::stdError($error);
|
||
}
|
||
$idMaps['f' . $feed['id']] = $feedId;
|
||
}
|
||
$feedTo->sqlResetSequence();
|
||
$catTo->commit();
|
||
|
||
$nbEntries = $entryFrom->count();
|
||
$n = 0;
|
||
$brokenEntries = 0;
|
||
$entryTo->beginTransaction();
|
||
while ($n < $nbEntries) {
|
||
foreach ($entryFrom->selectAll(offset: $n) as $entry) {
|
||
$n++;
|
||
if (!empty($idMaps['f' . $entry['id_feed']])) {
|
||
$entry['id_feed'] = $idMaps['f' . $entry['id_feed']];
|
||
if (!$entryTo->addEntry($entry, false)) {
|
||
$error = 'Error during SQLite copy of entries!';
|
||
return self::stdError($error);
|
||
}
|
||
}
|
||
if ($n % 100 === 1 && defined('STDERR') && $verbose) { //Display progression
|
||
fwrite(STDERR, "\033[0G" . $n . '/' . $nbEntries . ($brokenEntries > 0 ? " ($brokenEntries broken)" : ''));
|
||
}
|
||
}
|
||
if ($n < $nbEntries) {
|
||
$brokenEntries++;
|
||
// Attempt to skip broken records in the case of corrupted database
|
||
$n++;
|
||
}
|
||
if (defined('STDERR') && $verbose) {
|
||
fwrite(STDERR, "\033[0G" . $n . '/' . $nbEntries . ($brokenEntries > 0 ? " ($brokenEntries broken)" : '') . PHP_EOL);
|
||
}
|
||
}
|
||
$entryTo->commit();
|
||
$feedTo->updateCachedValues();
|
||
|
||
$idMaps = [];
|
||
|
||
$tagTo->beginTransaction();
|
||
foreach ($tagFrom->selectAll() as $tag) {
|
||
$tagId = $tagTo->addTag($tag);
|
||
if ($tagId == false) {
|
||
$error = 'Error during SQLite copy of tags!';
|
||
return self::stdError($error);
|
||
}
|
||
$idMaps['t' . $tag['id']] = $tagId;
|
||
}
|
||
foreach ($tagFrom->selectEntryTag() as $entryTag) {
|
||
if (!empty($idMaps['t' . $entryTag['id_tag']])) {
|
||
$entryTag['id_tag'] = $idMaps['t' . $entryTag['id_tag']];
|
||
if (!$tagTo->tagEntry($entryTag['id_tag'], (string)$entryTag['id_entry'])) {
|
||
$error = 'Error during SQLite copy of entry-tags!';
|
||
return self::stdError($error);
|
||
}
|
||
}
|
||
}
|
||
$tagTo->sqlResetSequence();
|
||
$tagTo->commit();
|
||
|
||
return true;
|
||
}
|
||
|
||
/**
|
||
* Remove accents from characters and lowercase. Relevant for emulating MySQL utf8mb4_unicode_ci collation.
|
||
* Example: `Café` becomes `cafe`.
|
||
*/
|
||
private static function removeAccentsLower(string $str): string {
|
||
if (function_exists('transliterator_transliterate')) {
|
||
// https://unicode-org.github.io/icu/userguide/transforms/general/#overview
|
||
$transliterated = transliterator_transliterate('NFD; [:Nonspacing Mark:] Remove; NFC; Lower', $str);
|
||
if ($transliterated !== false) {
|
||
return $transliterated;
|
||
}
|
||
}
|
||
// Fallback covering only Latin: Windows-1252 / ISO-8859-15 / ISO-8859-1, Windows-1250 / ISO-8859-2, Windows-1257 / ISO-8859-13, Windows-1254 / ISO-8859-9
|
||
// phpcs:disable PSR12.Operators.OperatorSpacing.NoSpaceBefore, PSR12.Operators.OperatorSpacing.NoSpaceAfter, Squiz.WhiteSpace.OperatorSpacing.NoSpaceBefore, Squiz.WhiteSpace.OperatorSpacing.NoSpaceAfter
|
||
$replacements = [
|
||
'A' => 'a', 'À'=>'a', 'Á'=>'a', 'Â'=>'a', 'Ä'=>'a', 'Ã'=>'a', 'Å'=>'a', 'Ă'=>'a', 'Ą'=>'a', 'Ā'=>'a',
|
||
'à'=>'a', 'á'=>'a', 'â'=>'a', 'ä'=>'a', 'ã'=>'a', 'å'=>'a', 'ă'=>'a', 'ą'=>'a', 'ā'=>'a',
|
||
'B' => 'b',
|
||
'C' => 'c', 'Ç'=>'c', 'Ć'=>'c', 'Č'=>'c', 'ç'=>'c', 'ć'=>'c', 'č'=>'c',
|
||
'D' => 'd', 'Ď'=>'d', 'Đ'=>'d', 'ď'=>'d', 'đ'=>'d',
|
||
'E' => 'e', 'È'=>'e', 'É'=>'e', 'Ê'=>'e', 'Ë'=>'e', 'Ę'=>'e', 'Ě'=>'e', 'Ē'=>'e', 'Ė'=>'e',
|
||
'è'=>'e', 'é'=>'e', 'ê'=>'e', 'ë'=>'e', 'ę'=>'e', 'ě'=>'e', 'ē'=>'e', 'ė'=>'e',
|
||
'F' => 'f',
|
||
'G' => 'g', 'Ğ'=>'g', 'Ģ'=>'g', 'ğ'=>'g', 'ģ'=>'g',
|
||
'H' => 'h',
|
||
'I' => 'i', 'Ì'=>'i', 'Í'=>'i', 'Î'=>'i', 'Ï'=>'i', 'İ'=>'i', 'Ī'=>'i', 'Į'=>'i',
|
||
'ì'=>'i', 'í'=>'i', 'î'=>'i', 'ï'=>'i', 'ı'=>'i', 'ī'=>'i', 'į'=>'i',
|
||
'J' => 'j',
|
||
'K' => 'k', 'Ķ'=>'k', 'ķ'=>'k',
|
||
'L' => 'l', 'Ĺ'=>'l', 'Ľ'=>'l', 'Ł'=>'l', 'Ļ'=>'l', 'ĺ'=>'l', 'ľ'=>'l', 'ł'=>'l', 'ļ'=>'l',
|
||
'M' => 'm',
|
||
'N' => 'n', 'Ñ'=>'n', 'Ń'=>'n', 'Ň'=>'n', 'Ņ'=>'n', 'ñ'=>'n', 'ń'=>'n', 'ň'=>'n', 'ņ'=>'n',
|
||
'O' => 'o', 'Ò'=>'o', 'Ó'=>'o', 'Ô'=>'o', 'Ö'=>'o', 'Õ'=>'o', 'Ø'=>'o', 'Ő'=>'o', 'ò'=>'o', 'ó'=>'o', 'ô'=>'o', 'ö'=>'o', 'õ'=>'o', 'ø'=>'o', 'ő'=>'o',
|
||
'P' => 'p',
|
||
'Q' => 'q',
|
||
'R' => 'r', 'Ŕ'=>'r', 'Ř'=>'r', 'ŕ'=>'r', 'ř'=>'r',
|
||
'S' => 's', 'Ś'=>'s', 'Š'=>'s', 'Ş'=>'s', 'ß'=>'ss', 'ś'=>'s', 'š'=>'s', 'ş'=>'s',
|
||
'T' => 't', 'Ť'=>'t', 'Ţ'=>'t', 'ť'=>'t', 'ţ'=>'t',
|
||
'U' => 'u', 'Ù'=>'u', 'Ú'=>'u', 'Û'=>'u', 'Ü'=>'u', 'Ů'=>'u', 'Ű'=>'u', 'Ū'=>'u', 'Ų'=>'u',
|
||
'ù'=>'u', 'ú'=>'u', 'û'=>'u', 'ü'=>'u', 'ů'=>'u', 'ű'=>'u', 'ū'=>'u', 'ų'=>'u',
|
||
'V' => 'v',
|
||
'W' => 'w',
|
||
'X' => 'x',
|
||
'Y' => 'y', 'Ý'=>'y', 'Ÿ'=>'y', 'ý'=>'y', 'ÿ'=>'y',
|
||
'Z' => 'z', 'Ź'=>'z', 'Ż'=>'z', 'Ž'=>'z', 'ź'=>'z', 'ż'=>'z', 'ž'=>'z',
|
||
'Æ'=>'ae', 'æ'=>'ae',
|
||
'Œ'=>'oe', 'œ'=>'oe',
|
||
];
|
||
// phpcs:enable PSR12.Operators.OperatorSpacing.NoSpaceBefore, PSR12.Operators.OperatorSpacing.NoSpaceAfter, Squiz.WhiteSpace.OperatorSpacing.NoSpaceBefore, Squiz.WhiteSpace.OperatorSpacing.NoSpaceAfter
|
||
return strtr($str, $replacements);
|
||
}
|
||
|
||
/**
|
||
* PHP emulation of the SQL ILIKE operation of the selected database.
|
||
* Note that it depends on the database collation settings and Unicode extensions.
|
||
* @param bool $contains If true, checks whether $haystack contains $needle (`'Testing' ILIKE '%Test%'`),
|
||
* otherwise checks whether they are alike (`'Testing' ILIKE 'Test'`).
|
||
*/
|
||
public static function strilike(string $haystack, string $needle, bool $contains = false): bool {
|
||
// Implementation approximating MySQL/MariaDB `LIKE` with `utf8mb4_unicode_ci` collation.
|
||
$haystack = self::removeAccentsLower($haystack);
|
||
$needle = self::removeAccentsLower($needle);
|
||
return $contains ? str_contains($haystack, $needle) : ($haystack === $needle);
|
||
}
|
||
}
|