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
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.43-cll-lve
[server_version] => 50643
[stat] => Uptime: 19726 Threads: 23 Questions: 6920705 Slow queries: 1 Opens: 151986 Flush tables: 1 Open tables: 5000 Queries per second avg: 350.841
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 102518
[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.43-cll-lve
[server_version] => 50643
[stat] => Uptime: 19726 Threads: 23 Questions: 6920706 Slow queries: 1 Opens: 151986 Flush tables: 1 Open tables: 5000 Queries per second avg: 350.841
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 102518
[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.