mysqli_sql_exception #1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-22, 24' at line 11 search►

Source file

File: .../home/www.dexon.cz/www/stranky/stranka_hierarchie.php:390

380:            $sql .= "order by pr_datum_vlozeni \n";
381:        }
382:        if (!IsSet($_GET["seradit"]) || (IsSet($_GET["seradit"]) && $_GET["seradit"] == "")) {
383:            $sql .= "order by pr_poradi is null, pr_poradi, pr_nazev \n";
384:        }
385:        if (IsSet($_GET["seradit"]) && IsSet($_GET["sestupne"])) {
386:            $sql .= "desc \n";
387:        }
388:        $sql .= "limit {$offset}, {$limit} \n";
389:    
390:        $produkty = $conn->query($sql);
391:    
392:    
393:        if ($produkty && $produkty->num_rows > 0) {
394:            $pocty = $conn->query("select found_rows() as pocet")->fetch_array(MYSQLI_ASSOC);

Call stack

.../home/www.dexon.cz/www/stranky/stranka_hierarchie.php:390

mysqli::query (...)

380:            $sql .= "order by pr_datum_vlozeni \n";
381:        }
382:        if (!IsSet($_GET["seradit"]) || (IsSet($_GET["seradit"]) && $_GET["seradit"] == "")) {
383:            $sql .= "order by pr_poradi is null, pr_poradi, pr_nazev \n";
384:        }
385:        if (IsSet($_GET["seradit"]) && IsSet($_GET["sestupne"])) {
386:            $sql .= "desc \n";
387:        }
388:        $sql .= "limit {$offset}, {$limit} \n";
389:    
390:        $produkty = $conn->query($sql);
391:    
392:    
393:        if ($produkty && $produkty->num_rows > 0) {
394:            $pocty = $conn->query("select found_rows() as pocet")->fetch_array(MYSQLI_ASSOC);

$query

/home/www.dexon.cz/www/index.php:213

require_once (...)

203:            $_SESSION["PRESMEROVANI_skolnirozhlas.cz"] = true;
204:            header("Location: /kampane/ozvuceni-skoly.html");
205:        } else if (in_array($aktualni_domena, array("www.skolnizvonky.cz", "skolnizvonky.cz")) && !isset($_SESSION["PRESMEROVANI_skolnizvonky.cz"])) {
206:            $_SESSION["PRESMEROVANI_skolnizvonky.cz"] = true;
207:            header("Location: /kampane/ozvuceni-skoly.html");
208:        }
209:    }
210:    
211:    //...Katalog
212:    if (IsSet($_GET["katalog"])) {
213:        require_once("stranky/stranka_hierarchie.php");
214:    } else if (IsSet($_GET["clanky"])) {
215:        require_once("stranky/stranka_clanky.php");
216:    } else if (IsSet($_GET["diskuzni-forum"])) {
217:        require_once("stranky/stranka_diskuzni-forum.php");

#0	'/home/www.dexon.cz/www/stranky/stranka_hierarchie.php'

Last muted error

Warning: http_response_code(): Cannot set response code - headers already sent (output started at /home/www.dexon.cz/www/system/design/layout/zahlavi.php:95)

Note: the last muted error may have nothing to do with the thrown exception.

.../vendor/tracy/tracy/src/Tracy/Debugger/Debugger.php:317

307:        /**
308:         * Handles an uncaught exception by rendering or logging it.
309:         * @internal
310:         */
311:        public static function exceptionHandler(\Throwable $exception): void
312:        {
313:            $firstTime = (bool) self::$reserved;
314:            self::$reserved = null;
315:            self::$obStatus = ob_get_status(full_status: true);
316:    
317:            @http_response_code(500);
318:            Helpers::improveException($exception);
319:            self::removeOutputBuffers(errorOccurred: true);
320:    
321:            self::getStrategy()->handleException($exception, $firstTime);

Environment

REDIRECT_HTTPS	'on'
REDIRECT_SSL_TLS_SNI	'www.dexon.cz'
REDIRECT_STATUS	'200'
HTTPS	'on'
SSL_TLS_SNI	'www.dexon.cz'
HTTP_ACCEPT	'/'
HTTP_USER_AGENT	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
HTTP_ACCEPT_ENCODING	'gzip, br, zstd, deflate'
HTTP_HOST	'www.dexon.cz'
PATH	'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin'
SERVER_SIGNATURE
SERVER_SOFTWARE	'Apache'
SERVER_NAME	'www.dexon.cz'
SERVER_ADDR	'213.195.215.18'
SERVER_PORT	'443'
REMOTE_ADDR	'216.73.217.74'
DOCUMENT_ROOT	'/home/www.dexon.cz/www'
REQUEST_SCHEME	'https'
CONTEXT_PREFIX	''
CONTEXT_DOCUMENT_ROOT	'/home/www.dexon.cz/www'
SERVER_ADMIN	'kamil.toman@dexon.cz'
SCRIPT_FILENAME	'/home/www.dexon.cz/www/index.php'
REMOTE_PORT	'19606'
REDIRECT_URL	'/katalog/hifi-domaci-kino/filtrovani-polozek.php'
REDIRECT_QUERY_STRING
GATEWAY_INTERFACE	'CGI/1.1'
SERVER_PROTOCOL	'HTTP/1.1'
REQUEST_METHOD	'GET'
QUERY_STRING
REQUEST_URI
SCRIPT_NAME	'/index.php'
PHP_SELF	'/index.php'
REQUEST_TIME_FLOAT	1793299651.546976
REQUEST_TIME	1793299651

CENYDPH	true
CENYMENA	'CZK'
JAZYK	'cz'
KURZ_KC_EUR	'24.335'
DISKUZE	''
NAVSTEVNOST_HIERARCHIE
VIDEO_BANNER	true

CESTA_KOREN	'/home/www.dexon.cz/www/'
CESTA_KATALOG_OBRAZKU	'/home/www.dexon.cz/www/katalog-obrazku/'
CESTA_CLASS	'/home/www.dexon.cz/www/class/'
CESTA_CLASS_FEED	'/home/www.dexon.cz/www/class/feed/'
CESTA_DATA	'/home/www.dexon.cz/www/data/'
CESTA_DATA_OBRAZKY	'/home/www.dexon.cz/www/data/obrazky/'
CESTA_DATA_IMPORT	'/home/www.dexon.cz/www/data/import/'
CESTA_DATA_EXPORT	'/home/www.dexon.cz/www/data/export/'
CESTA_DATA_POPISY	'/home/www.dexon.cz/www/data/popisy/'
CESTA_STRANKY	'/home/www.dexon.cz/www/stranky/'
CESTA_INCLUDE	'/home/www.dexon.cz/www/stranky/inc/'
CESTA_AKCE	'/home/www.dexon.cz/www/stranky/akce/'
CESTA_SYSTEM	'/home/www.dexon.cz/www/system/'
CESTA_LAYOUT	'/home/www.dexon.cz/www/system/design/layout/'
URL_WEB	'https://www.dexon.cz'
URI_WEB
DEFAULT_DOMAIN	'https://www.dexon.cz'
DEXON_CZ	true
DEXON_SK	false
DEXON_EU	false
IS_TEST	false
EMAIL_ODESILATELE	'objednavky@dexon.cz'
EMAIL_PRIJEMCE	'objednavky@dexon.cz'
EMAIL_PRIJEMCE_SKRYTY	null
EMAIL_TECH_PODPORA	'podpora@marf.cz'
EMAIL_OBECNY	'podpora@dexon.cz'
CZ	true
EN	false
CENYDPH	true
CENYMENA	'CZK'
CENYMENASLOVNE	'Kč'
STAV_ERR	'showPOPUP'
STAV_OK	'showPOPUP'
POVINNA_REGISTRACE	true
POSTOVNE_ZDARMA_OD	100000
DPH_PRO_PREPOCET_POSTOVNEHO	21
ADMINISTRATOR	1
OBCHODNIK	2
ZAKAZNIK	3
OBCHODNIK_SENIOR	4
OBCHODNIK_JUNIOR	5
ZAMESTNANEC	6
TYP_OBCHODNIK	5
TYP_DEALER	6
TYP_MJ_PAR	3
MAX_SIRKA_IKONY	110
MAX_SIRKA_NAHLEDU	400
MAX_SIRKA_DETAILU	700
MAX_SIRKA_CLANKY_TITULNI_IKONA	110
MAX_SIRKA_CLANKY_ZOBRAZENI_NAHLED	200
MAX_SIRKA_CLANKY_ZOBRAZENI_DETAIL	700
POCET_OBRAZKU_U_CLANKU	4
KATALOG_POCET_POLOZEK_NA_STRANKU	24
PRIHLASEN	false
UZIVATEL	null
MINULE	null
ID	null
PRAVA	null
OBJEDNAVKA	null
CENOVA_HLADINA	0
TYP_ENTITY	0
PREFIX	'/'
PREFIX_SYSTEM_OBRAZKY	'/system/design/obrazky/'
PREFIX_OBRAZKY	'/data/obrazky/'
PREFIX_OBRAZKY_DETAILY	'/data/obrazky/detaily/'
PREFIX_OBRAZKY_NAHLEDY	'/data/obrazky/nahledy/'
ODKAZ_MENU_1	'/reference.html'
ODKAZ_MENU_2	'/clanky/navody-k-pouziti/'
ODKAZ_MENU_3	'/clanky/recenze-vyrobku/'
ODKAZ_MENU_4	'/konstrukce.html'
ODKAZ_MENU_5	'/clanky/certifikaty/'
ODKAZ_MENU_6	'/dotazy-poradna.html'
ODKAZ_MENU_7	'/skoleni.html'
ODKAZ_MENU_8	'/odkazy.html'
ODKAZ_MENU_9	'/clanky/obchodni-informace/kontaktni-informace.html'
ID_CLANEK_VOP	291
ID_CLANEK_KONFIGURATOR	798
PAYU_URL	'https://secure.payu.com'
PAYU_POS_ID	'131207'
PAYU_POS_AUTH_ID	'KYVEruc'
PAYU_MD5_1	'cedf1efda2e3bcb232724699d1751d24'
PAYU_MD5_2	'ca4d8018b6c3312be9dcdddecd9fb31e'
LPNK	10
LPDO1	7
LPDO2	30
LPNE1	1
LPNE2	3
LPNE3	29
AKTIVNI_TELEMARKETING	false
OBJEMOVA_SLEVA_PROCENTA	2
OBJEMOVA_SLEVA_HRANICE_OD_KC	5000
OBJEMOVA_SLEVA_HRANICE_DO_PROCENT_ZAKAZNIKA	18
KURZ_KC_EUR	'24.335'
VYS_DPH	21
NIZ_DPH	15
PLATBA_DOBIRKA	1
PLATBA_KARTA	2
PLATBA_PREVOD	4
CSS_REFRESH	'?v39'
JS_REFRESH	'?v9'
SEKCE_FORUM	false
GOOGLE_TRANSLATE	false
JE_ZOBRAZENA_KAMPAN	false

apache2handler

Apache Version	Apache
Apache API Version	20120211
Server Administrator	kamil.toman@dexon.cz
Hostname:Port	www.dexon.cz:0
User/Group	www-data(33)/33
Max Requests	Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts	Connection: 300 - Keep-Alive: 5
Virtual Server	Yes
Server Root	/etc/apache2
Loaded Modules	core mod_so mod_watchdog http_core mod_log_config mod_logio mod_version mod_unixd mod_systemd mod_access_compat mod_alias mod_auth_basic mod_authn_core mod_authn_file mod_authz_core mod_authz_host mod_authz_user mod_autoindex mod_deflate mod_dir mod_env mod_expires mod_filter mod_mime mpm_itk prefork mod_negotiation mod_php mod_reqtimeout mod_rewrite mod_setenvif mod_socache_shmcb mod_ssl mod_status

Directive	Local Value	Master Value
engine	On	On
last_modified	Off	Off
xbithack	Off	Off

Apache Environment

Variable	Value
REDIRECT_HTTPS	on
REDIRECT_SSL_TLS_SNI	www.dexon.cz
REDIRECT_STATUS	200
HTTPS	on
SSL_TLS_SNI	www.dexon.cz
HTTP_ACCEPT	/
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_HOST	www.dexon.cz
PATH	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
SERVER_SIGNATURE	<address>Apache Server at www.dexon.cz Port 443</address>
SERVER_SOFTWARE	Apache
SERVER_NAME	www.dexon.cz
SERVER_ADDR	213.195.215.18
SERVER_PORT	443
REMOTE_ADDR	216.73.217.74
DOCUMENT_ROOT	/home/www.dexon.cz/www
REQUEST_SCHEME	https
CONTEXT_PREFIX	no value
CONTEXT_DOCUMENT_ROOT	/home/www.dexon.cz/www
SERVER_ADMIN	kamil.toman@dexon.cz
SCRIPT_FILENAME	/home/www.dexon.cz/www/index.php
REMOTE_PORT	19606
REDIRECT_URL	/katalog/hifi-domaci-kino/filtrovani-polozek.php
REDIRECT_QUERY_STRING	katalog=&hierarchie=hifi-domaci-kino&upravit=filtrovani-polozek&XDEBUG_SESSION_STOP=1&recordStart=-22
GATEWAY_INTERFACE	CGI/1.1
SERVER_PROTOCOL	HTTP/1.1
REQUEST_METHOD	GET
QUERY_STRING	katalog=&hierarchie=hifi-domaci-kino&upravit=filtrovani-polozek&XDEBUG_SESSION_STOP=1&recordStart=-22
REQUEST_URI	/katalog/hifi-domaci-kino/filtrovani-polozek.php?XDEBUG_SESSION_STOP=1&recordStart=-22
SCRIPT_NAME	/index.php

HTTP Headers Information

HTTP Request Headers
HTTP Request	GET /katalog/hifi-domaci-kino/filtrovani-polozek.php?XDEBUG_SESSION_STOP=1&recordStart=-22 HTTP/1.1
accept	/
user-agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
accept-encoding	gzip, br, zstd, deflate
host	www.dexon.cz
HTTP Response Headers
Set-Cookie	PHPSESSID=1f7bb9fa6b03eb70afb86849148c9836; path=/
Expires	Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control	no-store, no-cache, must-revalidate
Pragma	no-cache
Set-Cookie	gdprsouhlasy=%7B%22reklama%22%3A1%2C%22adwords%22%3A1%2C%22sklik%22%3A1%7D; expires=Fri, 29 Jan 2027 18:47:31 GMT; Max-Age=7948800; path=/; domain=www.dexon.cz; HttpOnly
Vary	Accept-Encoding
Content-Encoding	gzip

Core

PHP Version

8.5.4

Directive	Local Value	Master Value
allow_url_fopen	On	Off
allow_url_include	Off	Off
arg_separator.input	&	&
arg_separator.output	&	&
auto_append_file	no value	no value
auto_globals_jit	On	On
auto_prepend_file	no value	no value
browscap	no value	no value
default_charset	UTF-8	UTF-8
default_mimetype	text/html	text/html
disable_functions	pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,exec,system,passthru,popen,shell_exec,proc_open,pcntl_exec,posix_seteuid,posix_setuid,posix_setsid,posix_setgid,posix_setegid	pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,exec,system,passthru,popen,shell_exec,proc_open,pcntl_exec,posix_seteuid,posix_setuid,posix_setsid,posix_setgid,posix_setegid
display_errors	Off	Off
display_startup_errors	Off	Off
doc_root	no value	no value
docref_ext	no value	no value
docref_root	no value	no value
enable_dl	Off	Off
enable_post_data_reading	On	On
error_append_string	no value	no value
error_log	no value	no value
error_log_mode	0644	0644
error_prepend_string	no value	no value
error_reporting	30719	22013
expose_php	Off	Off
extension_dir	/usr/lib/php/20250925	/usr/lib/php/20250925
fatal_error_backtraces	On	On
fiber.stack_size	no value	no value
file_uploads	On	On
hard_timeout	2	2
highlight.comment	#FF8000	#FF8000
highlight.default	#0000BB	#0000BB
highlight.html	#000000	#000000
highlight.keyword	#007700	#007700
highlight.string	#DD0000	#DD0000
html_errors	Off	On
ignore_repeated_errors	Off	Off
ignore_repeated_source	Off	Off
ignore_user_abort	Off	Off
implicit_flush	Off	Off
include_path	.:/usr/share/php	.:/usr/share/php
input_encoding	no value	no value
internal_encoding	no value	no value
log_errors	Off	On
mail.add_x_header	Off	Off
mail.cr_lf_mode	crlf	crlf
mail.force_extra_parameters	no value	no value
mail.log	syslog	syslog
mail.mixed_lf_and_crlf	Off	Off
max_execution_time	30	30
max_file_uploads	20	20
max_input_nesting_level	64	64
max_input_time	60	60
max_input_vars	1000	1000
max_memory_limit	-1	-1
max_multipart_body_parts	-1	-1
memory_hard_limit_percent	no value	no value
memory_limit	128M	128M
open_basedir	/tmp://home/www.dexon.cz	no value
output_buffering	4096	4096
output_encoding	no value	no value
output_handler	no value	no value
post_max_size	22M	22M
precision	14	14
realpath_cache_size	4096K	4096K
realpath_cache_ttl	120	120
register_argc_argv	Off	Off
report_memleaks	On	On
report_zend_debug	Off	Off
request_order	GP	GP
sendmail_from	no value	no value
sendmail_path	/usr/sbin/sendmail -t -i	/usr/sbin/sendmail -t -i
serialize_precision	-1	-1
short_open_tag	Off	Off
SMTP	localhost	localhost
smtp_port	25	25
sys_temp_dir	no value	no value
syslog.facility	LOG_USER	LOG_USER
syslog.filter	no-ctrl	no-ctrl
syslog.ident	php	php
unserialize_callback_func	no value	no value
upload_max_filesize	20M	20M
upload_tmp_dir	no value	no value
user_dir	no value	no value
user_ini.cache_ttl	300	300
user_ini.filename	.user.ini	.user.ini
variables_order	GPCS	GPCS
xmlrpc_error_number	0	0
xmlrpc_errors	Off	Off
zend.assertions	-1	-1
zend.detect_unicode	On	On
zend.enable_gc	On	On
zend.exception_ignore_args	Off	On
zend.exception_string_param_max_len	0	0
zend.max_allowed_stack_size	0	0
zend.multibyte	Off	Off
zend.reserved_stack_size	0	0
zend.script_encoding	no value	no value
zend.signal_check	Off	Off

curl

cURL support	enabled
cURL Information	8.18.0
Age	11
Features
AsynchDNS	Yes
CharConv	No
Debug	No
GSS-Negotiate	No
IDN	Yes
IPv6	Yes
krb4	No
Largefile	Yes
libz	Yes
NTLM	Yes
NTLMWB	No
SPNEGO	Yes
SSL	Yes
SSPI	No
TLS-SRP	Yes
HTTP2	Yes
GSSAPI	Yes
KERBEROS5	Yes
UNIX_SOCKETS	Yes
PSL	Yes
HTTPS_PROXY	Yes
MULTI_SSL	No
BROTLI	Yes
ALTSVC	Yes
HTTP3	No
UNICODE	No
ZSTD	Yes
HSTS	Yes
GSASL	No
Protocols	dict, file, ftp, ftps, gopher, gophers, http, https, imap, imaps, ldap, ldaps, mqtt, pop3, pop3s, rtmp, rtmpe, rtmps, rtmpt, rtmpte, rtmpts, rtsp, scp, sftp, smb, smbs, smtp, smtps, telnet, tftp, ws, wss
Host	x86_64-pc-linux-gnu
SSL Version	OpenSSL/3.5.5
ZLib Version	1.3.1
libSSH Version	libssh2/1.11.1

Directive	Local Value	Master Value
curl.cainfo	no value	no value

date

date/time support	enabled
timelib version	2022.15
"Olson" Timezone Database Version	0.system
Timezone Database	internal
Default timezone	Europe/Prague

Directive	Local Value	Master Value
date.default_latitude	31.7667	31.7667
date.default_longitude	35.2333	35.2333
date.sunrise_zenith	90.833333	90.833333
date.sunset_zenith	90.833333	90.833333
date.timezone	UTC	UTC

dom

DOM/XML	enabled
DOM/XML API Version	20031129
libxml Version	2.15.2
HTML Support	enabled
XPath Support	enabled
XPointer Support	enabled
Schema Support	enabled
RelaxNG Support	enabled

exif

EXIF Support	enabled
Supported EXIF Version	0220
Supported filetypes	JPEG, TIFF
Multibyte decoding support using mbstring	enabled
Extended EXIF tag formats	Canon, Casio, Fujifilm, Nikon, Olympus, Samsung, Panasonic, DJI, Sony, Pentax, Minolta, Sigma, Foveon, Kyocera, Ricoh, AGFA, Epson

Directive	Local Value	Master Value
exif.decode_jis_intel	JIS	JIS
exif.decode_jis_motorola	JIS	JIS
exif.decode_unicode_intel	UCS-2LE	UCS-2LE
exif.decode_unicode_motorola	UCS-2BE	UCS-2BE
exif.encode_jis	no value	no value
exif.encode_unicode	ISO-8859-15	ISO-8859-15

FFI

FFI support

enabled

Directive	Local Value	Master Value
ffi.enable	preload	preload
ffi.preload	no value	no value

fileinfo

fileinfo support	enabled
libmagic	5.46

filter

Input Validation and Filtering

enabled

Directive	Local Value	Master Value
filter.default	unsafe_raw	unsafe_raw
filter.default_flags	no value	no value

ftp

FTP support	enabled
FTPS support	enabled

gd

GD Support	enabled
GD headers Version	2.3.3
GD library Version	2.3.3
FreeType Support	enabled
FreeType Linkage	with freetype
GIF Read Support	enabled
GIF Create Support	enabled
JPEG Support	enabled
PNG Support	enabled
WBMP Support	enabled
XPM Support	enabled
XBM Support	enabled
WebP Support	enabled
BMP Support	enabled
TGA Read Support	enabled

Directive	Local Value	Master Value
gd.jpeg_ignore_warning	On	On

md2 md4 md5 sha1 sha224 sha256 sha384 sha512/224 sha512/256 sha512 sha3-224 sha3-256 sha3-384 sha3-512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b crc32c fnv132 fnv1a32 fnv164 fnv1a64 joaat murmur3a murmur3c murmur3f xxh32 xxh64 xxh3 xxh128 haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

MHASH support	Enabled
MHASH API Version	Emulated Support

iconv

iconv support	enabled
iconv implementation	glibc
iconv library version	2.43

Directive	Local Value	Master Value
iconv.input_encoding	no value	no value
iconv.internal_encoding	no value	no value
iconv.output_encoding	no value	no value

json

json support

enabled

lexbor

Lexbor support	active
Lexbor version	2.5.0

libxml

libXML support	active
libXML Compiled Version	2.15.2
libXML Loaded Version	21502
libXML streams	enabled

mbstring

Multibyte Support	enabled
Multibyte string engine	libmbfl
HTTP input encoding translation	disabled
libmbfl version	1.3.2

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Multibyte (japanese) regex support	enabled
Multibyte regex (oniguruma) version	6.9.10

Directive	Local Value	Master Value
mbstring.detect_order	no value	no value
mbstring.encoding_translation	Off	Off
mbstring.http_input	no value	no value
mbstring.http_output	no value	no value
mbstring.http_output_conv_mimetypes	^(text/\|application/xhtml\+xml)	^(text/\|application/xhtml\+xml)
mbstring.internal_encoding	no value	no value
mbstring.language	neutral	neutral
mbstring.regex_retry_limit	1000000	1000000
mbstring.regex_stack_limit	100000	100000
mbstring.strict_detection	Off	Off
mbstring.substitute_character	no value	no value

mysqli

MysqlI Support	enabled
Client API library version	mysqlnd 8.5.4
Active Persistent Links	0
Inactive Persistent Links	0
Active Links	1

Directive	Local Value	Master Value
mysqli.allow_local_infile	Off	Off
mysqli.allow_persistent	On	On
mysqli.default_host	no value	no value
mysqli.default_port	3306	3306
mysqli.default_pw	no value	no value
mysqli.default_socket	/var/run/mysqld/mysqld.sock	/var/run/mysqld/mysqld.sock
mysqli.default_user	no value	no value
mysqli.local_infile_directory	no value	no value
mysqli.max_links	Unlimited	Unlimited
mysqli.max_persistent	Unlimited	Unlimited
mysqli.rollback_on_cached_plink	Off	Off

mysqlnd

mysqlnd	enabled
Version	mysqlnd 8.5.4
Compression	supported
core SSL	supported
extended SSL	supported
Command buffer size	4096
Read buffer size	32768
Read timeout	86400
Collecting statistics	Yes
Collecting memory statistics	No
Tracing	n/a
Loaded plugins	mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
API Extensions	mysqli,pdo_mysql

openssl

OpenSSL support	enabled
OpenSSL Library Version	OpenSSL 3.5.5 27 Jan 2026
OpenSSL Header Version	OpenSSL 3.5.5 27 Jan 2026
Openssl default config	/usr/lib/ssl/openssl.cnf

Directive	Local Value	Master Value
openssl.cafile	no value	no value
openssl.capath	no value	no value
openssl.libctx	custom	custom

pcre

PCRE (Perl Compatible Regular Expressions) Support	enabled
PCRE Library Version	10.46 2025-08-27
PCRE Unicode Version	16.0.0
PCRE JIT Support	enabled
PCRE JIT Target	x86 64bit (little endian + unaligned)

Directive	Local Value	Master Value
pcre.backtrack_limit	1000000	1000000
pcre.jit	Off	Off
pcre.recursion_limit	100000	100000

PDO

PDO support	enabled
PDO drivers	dblib, mysql, sqlite

pdo_dblib

PDO Driver for FreeTDS/Sybase DB-lib	enabled
Flavour	freetds

pdo_mysql

PDO Driver for MySQL	enabled
Client API version	mysqlnd 8.5.4

Directive	Local Value	Master Value
pdo_mysql.default_socket	/var/run/mysqld/mysqld.sock	/var/run/mysqld/mysqld.sock

pdo_sqlite

PDO Driver for SQLite 3.x	enabled
SQLite Library	3.46.1

Phar

Phar: PHP Archive support	enabled
Phar API version	1.1.1
Phar-based phar archives	enabled
Tar-based phar archives	enabled
ZIP-based phar archives	enabled
gzip compression	enabled
bzip2 compression	disabled (install ext/bz2)
Native OpenSSL support	enabled

Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.

Directive	Local Value	Master Value
phar.cache_list	no value	no value
phar.readonly	On	On
phar.require_hash	On	On

Readline Support	enabled
Readline library	EditLine wrapper

Directive	Local Value	Master Value
cli.pager	no value	no value
cli.prompt	\b \>	\b \>

Reflection

enabled

session

Session Support	enabled
Registered save handlers	files user
Registered serializer handlers	php_serialize php php_binary

Directive	Local Value	Master Value
session.auto_start	Off	Off
session.cache_expire	240	180
session.cache_limiter	nocache	nocache
session.cookie_domain	no value	no value
session.cookie_httponly	Off	Off
session.cookie_lifetime	0	0
session.cookie_partitioned	Off	Off
session.cookie_path	/	/
session.cookie_samesite	no value	no value
session.cookie_secure	Off	Off
session.gc_divisor	1000	1000
session.gc_maxlifetime	7200	1440
session.gc_probability	0	0
session.lazy_write	On	On
session.name	PHPSESSID	PHPSESSID
session.referer_check	no value	no value
session.save_handler	files	files
session.save_path	/var/lib/php/sessions	/var/lib/php/sessions
session.serialize_handler	php	php
session.sid_bits_per_character	4	4
session.sid_length	32	32
session.upload_progress.cleanup	On	On
session.upload_progress.enabled	Off	Off
session.upload_progress.freq	1%	1%
session.upload_progress.min_freq	1	1
session.upload_progress.name	PHP_SESSION_UPLOAD_PROGRESS	PHP_SESSION_UPLOAD_PROGRESS
session.upload_progress.prefix	upload_progress_	upload_progress_
session.use_cookies	On	On
session.use_only_cookies	On	On
session.use_strict_mode	Off	Off
session.use_trans_sid	Off	Off

shmop

shmop support

enabled

SimpleXML

SimpleXML support	enabled
Schema support	enabled

sockets

Sockets Support

enabled

sodium

sodium support	enabled
libsodium headers version	1.0.18
libsodium library version	1.0.18

SPL

SPL support	enabled
Interfaces	OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes	AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

sqlite3

SQLite3 support	enabled
SQLite Library	3.46.1

Directive	Local Value	Master Value
sqlite3.defensive	On	On
sqlite3.extension_dir	no value	no value

standard

Dynamic Library Support	enabled
Path to sendmail	/usr/sbin/sendmail -t -i

Directive	Local Value	Master Value
assert.active	On	On
assert.bail	Off	Off
assert.callback	no value	no value
assert.exception	On	On
assert.warning	On	On
auto_detect_line_endings	Off	Off
default_socket_timeout	60	60
from	no value	no value
session.trans_sid_hosts	no value	no value
session.trans_sid_tags	a=href,area=href,frame=src,form=	a=href,area=href,frame=src,form=
unserialize_max_depth	4096	4096
url_rewriter.hosts	no value	no value
url_rewriter.tags	form=	form=
user_agent	no value	no value

URI support	active
uriparser bundled version	1.0.0

xml

XML Support	active
XML Namespace Support	active
libxml2 Version	2.15.2

XSL	enabled
libxslt Version	1.1.45
libxslt compiled against libxml Version	2.15.1
EXSLT	enabled
libexslt Version	0.8.25

Zend OPcache

Opcode Caching	Up and Running
Optimization	Enabled
SHM Cache	Enabled
File Cache	Disabled
JIT	Disabled
Startup	OK
Shared memory model	mmap
Cache hits	762367
Cache misses	4434
Used memory	58673440
Free memory	75544288
Wasted memory	0
Interned Strings Used memory	8388600
Interned Strings Free memory	8
Cached scripts	1536
Cached keys	1820
Max keys	16229
OOM restarts	0
Hash keys restarts	0
Manual restarts	0
Start time	2026-10-29T14:00:14+0100
Last restart time	none
Last force restart time	none

Directive	Local Value	Master Value
opcache.blacklist_filename	no value	no value
opcache.dups_fix	Off	Off
opcache.enable	On	On
opcache.enable_cli	Off	Off
opcache.enable_file_override	Off	Off
opcache.error_log	no value	no value
opcache.file_cache	no value	no value
opcache.file_cache_consistency_checks	On	On
opcache.file_cache_only	Off	Off
opcache.file_cache_read_only	Off	Off
opcache.file_update_protection	2	2
opcache.force_restart_timeout	180	180
opcache.huge_code_pages	Off	Off
opcache.interned_strings_buffer	8	8
opcache.jit	disable	disable
opcache.jit_bisect_limit	0	0
opcache.jit_blacklist_root_trace	16	16
opcache.jit_blacklist_side_trace	8	8
opcache.jit_buffer_size	64M	64M
opcache.jit_debug	0	0
opcache.jit_hot_func	127	127
opcache.jit_hot_loop	61	61
opcache.jit_hot_return	8	8
opcache.jit_hot_side_exit	8	8
opcache.jit_max_exit_counters	8192	8192
opcache.jit_max_loop_unrolls	8	8
opcache.jit_max_polymorphic_calls	2	2
opcache.jit_max_recursive_calls	2	2
opcache.jit_max_recursive_returns	2	2
opcache.jit_max_root_traces	1024	1024
opcache.jit_max_side_traces	128	128
opcache.jit_max_trace_length	1024	1024
opcache.jit_prof_threshold	0.005	0.005
opcache.lockfile_path	/tmp	/tmp
opcache.log_verbosity_level	1	1
opcache.max_accelerated_files	10000	10000
opcache.max_file_size	0	0
opcache.max_wasted_percentage	5	5
opcache.memory_consumption	128	128
opcache.opt_debug_level	0	0
opcache.optimization_level	0x7FFEBFFF	0x7FFEBFFF
opcache.preferred_memory_model	no value	no value
opcache.preload	no value	no value
opcache.preload_user	no value	no value
opcache.protect_memory	Off	Off
opcache.record_warnings	Off	Off
opcache.restrict_api	no value	no value
opcache.revalidate_freq	2	2
opcache.revalidate_path	Off	Off
opcache.save_comments	On	On
opcache.use_cwd	On	On
opcache.validate_permission	Off	Off
opcache.validate_root	Off	Off
opcache.validate_timestamps	On	On

zip

Zip	enabled
Zip version	1.22.7
Libzip version	1.11.4
BZIP2 compression	Yes
XZ compression	Yes
ZSTD compression	Yes
AES-128 encryption	Yes
AES-192 encryption	Yes
AES-256 encryption	Yes

zlib

ZLib Support	enabled
Stream Wrapper	compress.zlib://
Stream Filter	zlib.inflate, zlib.deflate
Compiled Version	1.3.1
Linked Version	1.3.1

Directive	Local Value	Master Value
zlib.output_compression	Off	Off
zlib.output_compression_level	-1	-1
zlib.output_handler	no value	no value

Additional Modules

Module Name

array (1)
   0 => array (7)
   |  'name' => 'default output handler'
   |  'type' => 0
   |  'flags' => 20592
   |  'level' => 0
   |  'chunk_size' => 4096
   |  'buffer_size' => 8192
   |  'buffer_used' => 2273

HTTP

GET https://www.dexon.cz/katalog/hifi-domaci-kino/filtrovani-polozek.php?XDEBUG_SESSION_STOP=1&recordStart=-22

accept	'/'
user-agent	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
accept-encoding	'gzip, br, zstd, deflate'
host	'www.dexon.cz'

$_GET

katalog	''
hierarchie	'hifi-domaci-kino'
upravit	'filtrovani-polozek'
XDEBUG_SESSION_STOP	'1'
recordStart	'-22'

$_COOKIE

empty

Code: 200

Set-Cookie	'PHPSESSID=1f7bb9fa6b03eb70afb86849148c9836; path=/'
Expires	'Thu, 19 Nov 1981 08:52:00 GMT'
Cache-Control	'no-store, no-cache, must-revalidate'
Pragma	'no-cache'
Set-Cookie	'gdprsouhlasy=%7B%22reklama%22%3A1%2C%22adwords%22%3A1%2C%22sklik%22%3A1%7D; expires=Fri, 29 Jan 2027 18:47:31 GMT; Max-Age=7948800; path=/; domain=www.dexon.cz; HttpOnly'
Content-type	'text/html; charset=UTF-8'

Headers have been sent, output started at .../home/www.dexon.cz/www/system/design/layout/zahlavi.php:95 source

85:            <meta name="description" content="<?php echo $popis_stranky; ?>">
86:            <meta name="robots" content="index,follow">
87:            <meta name="author" content="DEXON CZECH s.r.o.">
88:    
89:            <meta name="viewport" content="width=device-width, initial-scale=1">
90:    
91:            <link rel="apple-touch-icon" sizes="144x144" href="<?php echo PREFIX; ?>system/design/favicon/apple-touch-icon.png">
92:            <link rel="icon" type="image/png" sizes="32x32" href="<?php echo PREFIX; ?>system/design/favicon/favicon-32x32.png">
93:            <link rel="icon" type="image/png" sizes="16x16" href="<?php echo PREFIX; ?>system/design/favicon/favicon-16x16.png">
94:            <link rel="manifest" href="<?php echo PREFIX; ?>system/design/favicon/site.webmanifest">
95:            <link rel="mask-icon" href="<?php echo PREFIX; ?>system/design/favicon/safari-pinned-tab.svg" color="#bd1824">
96:            <meta name="msapplication-TileColor" content="#ffffff">
97:            <meta name="theme-color" content="#ffffff">
98:    
99:            <link rel="alternate" type="application/rss+xml" title="Dexon.cz" href="<?php echo PREFIX; ?>knihovna-vedomosti.xml">

HiFi, domácí kino

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-22, 24' at line 11 search►

Warning: http_response_code(): Cannot set response code - headers already sent (output started at /home/www.dexon.cz/www/system/design/layout/zahlavi.php:95)

Apache Environment

HTTP Headers Information

Additional Modules

GET https://www.dexon.cz/katalog/hifi-domaci-kino/filtrovani-polozek.php?XDEBUG_SESSION_STOP=1&recordStart=-22

$_GET

$_COOKIE

Code: 200