An error occurred in script '/home/fredtbx1/public_html/phpperc7/ex2/html/sales.php' on line 20:
mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given
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] => /home/fredtbx1/public_html/phpperc7/ex2/html/sales.php
[3] => 20
[4] => Array
(
[_GET] => Array
(
)
[_POST] => Array
(
)
[_COOKIE] => Array
(
)
[_FILES] => Array
(
)
[page_title] => Sale Items
[dbc] => mysqli Object
(
[affected_rows] => -1
[client_info] => 5.6.42
[client_version] => 50642
[connect_errno] => 0
[connect_error] =>
[errno] => 1305
[error] => PROCEDURE ecommerce2php.select_sale_items does not exist
[error_list] => Array
(
[0] => Array
(
[errno] => 1305
[sqlstate] => 42000
[error] => PROCEDURE ecommerce2php.select_sale_items does not exist
)
)
[field_count] => 0
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.6.44-cll-lve
[server_version] => 50644
[stat] => Uptime: 272601 Threads: 10 Questions: 120523409 Slow queries: 12 Opens: 2460048 Flush tables: 1 Open tables: 5000 Queries per second avg: 442.123
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 1577624
[warning_count] => 0
)
[r] =>
)
)
)
[1] => Array
(
[file] => /home/fredtbx1/public_html/phpperc7/ex2/html/sales.php
[line] => 20
[function] => mysqli_num_rows
[args] => Array
(
[0] =>
)
)
)
An error occurred in script '/home/fredtbx1/public_html/phpperc7/ex2/html/views/noproducts.html' on line 2:
Undefined variable: category
Array
(
[0] => Array
(
[file] => /home/fredtbx1/public_html/phpperc7/ex2/html/views/noproducts.html
[line] => 2
[function] => my_error_handler
[args] => Array
(
[0] => 8
[1] => Undefined variable: category
[2] => /home/fredtbx1/public_html/phpperc7/ex2/html/views/noproducts.html
[3] => 2
[4] => Array
(
[_GET] => Array
(
)
[_POST] => Array
(
)
[_COOKIE] => Array
(
)
[_FILES] => Array
(
)
[page_title] => Sale Items
[dbc] => mysqli Object
(
[affected_rows] => -1
[client_info] => 5.6.42
[client_version] => 50642
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 0
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.6.44-cll-lve
[server_version] => 50644
[stat] => Uptime: 272601 Threads: 10 Questions: 120523412 Slow queries: 12 Opens: 2460048 Flush tables: 1 Open tables: 5000 Queries per second avg: 442.123
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 1577624
[warning_count] => 0
)
[r] =>
)
)
)
[1] => Array
(
[file] => /home/fredtbx1/public_html/phpperc7/ex2/html/sales.php
[line] => 23
[args] => Array
(
[0] => /home/fredtbx1/public_html/phpperc7/ex2/html/views/noproducts.html
)
[function] => include
)
)
Undefined variable: category
Array
(
[0] => Array
(
[file] => /home/fredtbx1/public_html/phpperc7/ex2/html/views/noproducts.html
[line] => 2
[function] => my_error_handler
[args] => Array
(
[0] => 8
[1] => Undefined variable: category
[2] => /home/fredtbx1/public_html/phpperc7/ex2/html/views/noproducts.html
[3] => 2
[4] => Array
(
[_GET] => Array
(
)
[_POST] => Array
(
)
[_COOKIE] => Array
(
)
[_FILES] => Array
(
)
[page_title] => Sale Items
[dbc] => mysqli Object
(
[affected_rows] => -1
[client_info] => 5.6.42
[client_version] => 50642
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 0
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.6.44-cll-lve
[server_version] => 50644
[stat] => Uptime: 272601 Threads: 10 Questions: 120523412 Slow queries: 12 Opens: 2460048 Flush tables: 1 Open tables: 5000 Queries per second avg: 442.123
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 1577624
[warning_count] => 0
)
[r] =>
)
)
)
[1] => Array
(
[file] => /home/fredtbx1/public_html/phpperc7/ex2/html/sales.php
[line] => 23
[args] => Array
(
[0] => /home/fredtbx1/public_html/phpperc7/ex2/html/views/noproducts.html
)
[function] => include
)
)
Unfortunately there are no products to list in this category. Please use the links at the top of the page to continue shopping. We apologize for the inconvenience.