Prior to MySQL 8.0.4, MySQL used the Henry Spencer regular expression library to support regular expression operations, rather than International Components for Unicode (ICU).
...
The Spencer library supports word-beginning and word-end boundary markers ([[:<:]] and [[:>:]] notation). ICU does not. For ICU, you can use \b to match word boundaries; double the backslash because MySQL interprets it as the escape character within strings.
\\b111,222,333\\b
#!/usr/bin/php
) и запускает интерпретатор, передавая ему путь к скрипту.$x = '-- \' --';
print $x . "\n"; // -- ' --
$y = '-- \\\' --';
print $y . "\n"; // -- \' --
To specify a literal single quote, escape it with a backslash (\). To specify a literal backslash, double it (\\).https://www.php.net/manual/en/language.types.strin...
<?php
$xml = new SimpleXmlElement(<<<XML
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE yml_catalog SYSTEM "shops.dtd">
<yml_catalog>
</yml_catalog>
XML
);
$xml->addAttribute('date', (new DateTimeImmutable())->format('Y-m-d H:i'));
print $xml->asXML();
// <?xml version="1.0" encoding="utf-8"?>
// <!DOCTYPE yml_catalog SYSTEM "shops.dtd">
// <yml_catalog date="2024-01-24 16:42">
// </yml_catalog>
- $result = $connect->query($sql);
- $rows = $result->fetch();
- if($rows != 0)
- {
- for ($i = 0;$i < $rows;$i ++)
- {
- $result->data_seek($i);
- $map = $result->fetch_assoc();
+ foreach ($connect->query($sql) as $map) {
- }
- $result->close();
- if($x > 0) $left = (3000 + abs($x))/5.3;
- else $left = (3000 - abs($x))/5.3;
+ $left = (3000 + $x)/5.3;
- if($y > 0) $top = (3000 - abs($y))/5.3;
- else $top = (3000 + abs($y))/5.3;
+ $top = (3000 - $y)/5.3;
- $newwidth = $height * $rate;
+ $newwidth = round($height * $rate);
- $newheight = $width / $rate;
+ $newheight = round($width / $rate);
$needleRight = constant("{$rightsManager}::TASK_{$rightType}");
https://www.php.net/manual/en/function.constant