An error occurred in script 'C:\xampp\htdocs\distancelearning\categories.php' on line
166:
mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given
Array
(
[0] => Array
(
[function] => my_error_handler
[args] => Array
(
[0] => 2
[1] => mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given
[2] => C:\xampp\htdocs\distancelearning\categories.php
[3] => 166
[4] => Array
(
[_GET] => Array
(
[department_name] => seasonal
[department_id] => 6
[category_name] => valentine
[category_id] => 8
)
[_POST] => Array
(
)
[_COOKIE] => Array
(
)
[_FILES] => Array
(
)
[_SERVER] => Array
(
[REDIRECT_MIBDIRS] => C:/xampp/php/extras/mibs
[REDIRECT_MYSQL_HOME] => \xampp\mysql\bin
[REDIRECT_OPENSSL_CONF] => C:/xampp/apache/bin/openssl.cnf
[REDIRECT_PHP_PEAR_SYSCONF_DIR] => \xampp\php
[REDIRECT_PHPRC] => \xampp\php
[REDIRECT_TMP] => \xampp\tmp
[REDIRECT_STATUS] => 200
[MIBDIRS] => C:/xampp/php/extras/mibs
[MYSQL_HOME] => \xampp\mysql\bin
[OPENSSL_CONF] => C:/xampp/apache/bin/openssl.cnf
[PHP_PEAR_SYSCONF_DIR] => \xampp\php
[PHPRC] => \xampp\php
[TMP] => \xampp\tmp
[HTTP_ACCEPT] => */*
[HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[HTTP_HOST] => www.elegancetrading.org.uk
[PATH] => C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\WINDOWS\System32\OpenSSH\;C:\Users\elegancetrading\AppData\Local\Microsoft\WindowsApps;
[SystemRoot] => C:\WINDOWS
[COMSPEC] => C:\WINDOWS\system32\cmd.exe
[PATHEXT] => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
[WINDIR] => C:\WINDOWS
[SERVER_SIGNATURE] => Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/7.0.20 Server at www.elegancetrading.org.uk Port 80
[SERVER_SOFTWARE] => Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/7.0.20
[SERVER_NAME] => www.elegancetrading.org.uk
[SERVER_ADDR] => 81.137.69.97
[SERVER_PORT] => 80
[REMOTE_ADDR] => 52.14.126.74
[DOCUMENT_ROOT] => C:/xampp/htdocs/distancelearning
[REQUEST_SCHEME] => http
[CONTEXT_PREFIX] =>
[CONTEXT_DOCUMENT_ROOT] => C:/xampp/htdocs/distancelearning
[SERVER_ADMIN] => postmaster@localhost
[SCRIPT_FILENAME] => C:/xampp/htdocs/distancelearning/categories.php
[REMOTE_PORT] => 23064
[REDIRECT_URL] => /category/seasonal-d6/valentine-c8/
[REDIRECT_QUERY_STRING] => department_name=seasonal&department_id=6&category_name=valentine&category_id=8
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => department_name=seasonal&department_id=6&category_name=valentine&category_id=8
[REQUEST_URI] => /category/seasonal-d6/valentine-c8/
[SCRIPT_NAME] => /categories.php
[PHP_SELF] => /categories.php
[REQUEST_TIME_FLOAT] => 1713495343.744
[REQUEST_TIME] => 1713495343
)
[category_name] => Valentine
[category_id] => 8
[department_name] => kimtolksosks
[department_id] => 6
[page_title] => seasonal-6::valentine-8
[sql] => SELECT products.product_id, products.name, products.description,
products.price, products.discounted_price, products.stock, products.image
FROM product_category
INNER JOIN products
ON products.product_id = product_category.product_id
WHERE product_category.category_id = 8
ORDER BY products.name
LIMIT -4, 4
[res] =>
[dbc] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $
[client_version] => 50012
[connect_errno] => 0
[connect_error] =>
[errno] => 1064
[error] => 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 '-4, 4' at line 8
[error_list] => Array
(
[0] => Array
(
[errno] => 1064
[sqlstate] => 42000
[error] => 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 '-4, 4' at line 8
)
)
[field_count] => 1
[host_info] => localhost via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.1.24-MariaDB
[server_version] => 50505
[stat] => Uptime: 34184397 Threads: 1 Questions: 772882 Slow queries: 0 Opens: 211 Flush tables: 1 Open tables: 203 Queries per second avg: 0.022
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 130558
[warning_count] => 0
)
[row] => Array
(
[0] => 0
)
[selected_department_id] => 6
[selected_department_name] => Seasonal
[category_description] => For the more timid, all you have to do is wear your heartfelt message to get it across. Buy one for you and your sweetie(s) today!
[selected_category_id] => 8
[selected_cat_name] => Valentine
[selected_cat_description] => For the more timid, all you have to do is wear your heartfelt message to get it across. Buy one for you and your sweetie(s) today!
[product_count_sql] => SELECT COUNT(products.product_id)
FROM product_category
INNER JOIN products
ON products.product_id = product_category.product_id
WHERE product_category.category_id = 8
[product_count_res] => mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] => Array
(
[0] => 1
)
[num_rows] => 1
[type] => 0
)
[rec_count] => 0
[limit] => 4
[pages] => 0
[page] => 0
[offset] => -4
[_SESSION] => Array
(
[continue_shopping_last_page] => /category/seasonal-d6/valentine-c8/
)
)
)
)
[1] => Array
(
[file] => C:\xampp\htdocs\distancelearning\categories.php
[line] => 166
[function] => mysqli_num_rows
[args] => Array
(
[0] =>
)
)
)