An error occurred in script '/var/www/html/dukesnuz/d/phppercolate_7/ecom-2/includes_2/mysql.inc.php' on line 10:
mysqli_connect(): (HY000/1045): Access denied for user 'ecommercetwo'@'localhost' (using password: YES)
Array

(

    [0] => Array

        (

            [function] => my_error_handler

            [args] => Array

                (

                    [0] => 2

                    [1] => mysqli_connect(): (HY000/1045): Access denied for user 'ecommercetwo'@'localhost' (using password: YES)

                    [2] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/includes_2/mysql.inc.php

                    [3] => 10

                    [4] => Array

                        (

                            [_GET] => Array

                                (

                                )



                            [_POST] => Array

                                (

                                )



                            [_COOKIE] => Array

                                (

                                )



                            [_FILES] => Array

                                (

                                )



                            [page_title] => View All Orders

                            [_SERVER] => Array

                                (

                                    [HTTP_ACCEPT] => */*

                                    [HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

                                    [HTTP_HOST] => dukesnuz.com

                                    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

                                    [SERVER_SIGNATURE] => 
Apache/2.4.18 (Ubuntu) Server at dukesnuz.com Port 80




                                    [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)

                                    [SERVER_NAME] => dukesnuz.com

                                    [SERVER_ADDR] => 165.227.77.107

                                    [SERVER_PORT] => 80

                                    [REMOTE_ADDR] => 3.14.142.115

                                    [DOCUMENT_ROOT] => /var/www/html/dukesnuz

                                    [REQUEST_SCHEME] => http

                                    [CONTEXT_PREFIX] => 

                                    [CONTEXT_DOCUMENT_ROOT] => /var/www/html/dukesnuz

                                    [SERVER_ADMIN] => [no address given]

                                    [SCRIPT_FILENAME] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [REMOTE_PORT] => 25229

                                    [GATEWAY_INTERFACE] => CGI/1.1

                                    [SERVER_PROTOCOL] => HTTP/1.1

                                    [REQUEST_METHOD] => GET

                                    [QUERY_STRING] => 

                                    [REQUEST_URI] => /d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [SCRIPT_NAME] => /d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [PHP_SELF] => /d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [REQUEST_TIME_FLOAT] => 1715230157.767

                                    [REQUEST_TIME] => 1715230157

                                )



                            [_SESSION] => Array

                                (

                                )



                        )



                )



        )



    [1] => Array

        (

            [file] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/includes_2/mysql.inc.php

            [line] => 10

            [function] => mysqli_connect

            [args] => Array

                (

                    [0] => localhost

                    [1] => ecommercetwo

                    [2] => Stacy1964!

                    [3] => ecommercetwo

                )



        )



    [2] => Array

        (

            [file] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

            [line] => 7

            [args] => Array

                (

                    [0] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/includes_2/mysql.inc.php

                )



            [function] => require

        )



)

An error occurred in script '/var/www/html/dukesnuz/d/phppercolate_7/ecom-2/includes_2/mysql.inc.php' on line 13:
mysqli_set_charset() expects parameter 1 to be mysqli, boolean given
Array

(

    [0] => Array

        (

            [function] => my_error_handler

            [args] => Array

                (

                    [0] => 2

                    [1] => mysqli_set_charset() expects parameter 1 to be mysqli, boolean given

                    [2] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/includes_2/mysql.inc.php

                    [3] => 13

                    [4] => Array

                        (

                            [_GET] => Array

                                (

                                )



                            [_POST] => Array

                                (

                                )



                            [_COOKIE] => Array

                                (

                                )



                            [_FILES] => Array

                                (

                                )



                            [page_title] => View All Orders

                            [dbc] => 

                            [_SERVER] => Array

                                (

                                    [HTTP_ACCEPT] => */*

                                    [HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

                                    [HTTP_HOST] => dukesnuz.com

                                    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

                                    [SERVER_SIGNATURE] => 
Apache/2.4.18 (Ubuntu) Server at dukesnuz.com Port 80




                                    [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)

                                    [SERVER_NAME] => dukesnuz.com

                                    [SERVER_ADDR] => 165.227.77.107

                                    [SERVER_PORT] => 80

                                    [REMOTE_ADDR] => 3.14.142.115

                                    [DOCUMENT_ROOT] => /var/www/html/dukesnuz

                                    [REQUEST_SCHEME] => http

                                    [CONTEXT_PREFIX] => 

                                    [CONTEXT_DOCUMENT_ROOT] => /var/www/html/dukesnuz

                                    [SERVER_ADMIN] => [no address given]

                                    [SCRIPT_FILENAME] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [REMOTE_PORT] => 25229

                                    [GATEWAY_INTERFACE] => CGI/1.1

                                    [SERVER_PROTOCOL] => HTTP/1.1

                                    [REQUEST_METHOD] => GET

                                    [QUERY_STRING] => 

                                    [REQUEST_URI] => /d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [SCRIPT_NAME] => /d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [PHP_SELF] => /d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [REQUEST_TIME_FLOAT] => 1715230157.767

                                    [REQUEST_TIME] => 1715230157

                                )



                            [_SESSION] => Array

                                (

                                )



                        )



                )



        )



    [1] => Array

        (

            [file] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/includes_2/mysql.inc.php

            [line] => 13

            [function] => mysqli_set_charset

            [args] => Array

                (

                    [0] => 

                    [1] => utf8

                )



        )



    [2] => Array

        (

            [file] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

            [line] => 7

            [args] => Array

                (

                    [0] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/includes_2/mysql.inc.php

                )



            [function] => require

        )



)

View Orders

An error occurred in script '/var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php' on line 45:
mysqli_query() expects parameter 1 to be mysqli, boolean given
Array

(

    [0] => Array

        (

            [function] => my_error_handler

            [args] => Array

                (

                    [0] => 2

                    [1] => mysqli_query() expects parameter 1 to be mysqli, boolean given

                    [2] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                    [3] => 45

                    [4] => Array

                        (

                            [_GET] => Array

                                (

                                )



                            [_POST] => Array

                                (

                                )



                            [_COOKIE] => Array

                                (

                                )



                            [_FILES] => Array

                                (

                                )



                            [page_title] => View All Orders

                            [q] => SELECT o.id, FORMAT(total/100, 2) AS total, c.customer_id AS cid,

		CONCAT(last_name, ",", first_name) AS name, city, state,zip,

		COUNT(oc.id) AS items FROM orders AS o 

		LEFT OUTER JOIN order_contents AS oc ON 

		(oc.order_id=o.id AND oc.ship_date IS NULL)

		JOIN customers AS c ON (o.customer_id = c.customer_id)

		JOIN transactions AS t ON (t.order_id=o.id AND t.response_code=1)

		GROUP BY o.id DESC

                            [dbc] => 

                            [_SERVER] => Array

                                (

                                    [HTTP_ACCEPT] => */*

                                    [HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

                                    [HTTP_HOST] => dukesnuz.com

                                    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

                                    [SERVER_SIGNATURE] => 
Apache/2.4.18 (Ubuntu) Server at dukesnuz.com Port 80




                                    [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)

                                    [SERVER_NAME] => dukesnuz.com

                                    [SERVER_ADDR] => 165.227.77.107

                                    [SERVER_PORT] => 80

                                    [REMOTE_ADDR] => 3.14.142.115

                                    [DOCUMENT_ROOT] => /var/www/html/dukesnuz

                                    [REQUEST_SCHEME] => http

                                    [CONTEXT_PREFIX] => 

                                    [CONTEXT_DOCUMENT_ROOT] => /var/www/html/dukesnuz

                                    [SERVER_ADMIN] => [no address given]

                                    [SCRIPT_FILENAME] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [REMOTE_PORT] => 25229

                                    [GATEWAY_INTERFACE] => CGI/1.1

                                    [SERVER_PROTOCOL] => HTTP/1.1

                                    [REQUEST_METHOD] => GET

                                    [QUERY_STRING] => 

                                    [REQUEST_URI] => /d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [SCRIPT_NAME] => /d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [PHP_SELF] => /d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [REQUEST_TIME_FLOAT] => 1715230157.767

                                    [REQUEST_TIME] => 1715230157

                                )



                            [_SESSION] => Array

                                (

                                )



                        )



                )



        )



    [1] => Array

        (

            [file] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

            [line] => 45

            [function] => mysqli_query

            [args] => Array

                (

                    [0] => 

                    [1] => SELECT o.id, FORMAT(total/100, 2) AS total, c.customer_id AS cid,

		CONCAT(last_name, ",", first_name) AS name, city, state,zip,

		COUNT(oc.id) AS items FROM orders AS o 

		LEFT OUTER JOIN order_contents AS oc ON 

		(oc.order_id=o.id AND oc.ship_date IS NULL)

		JOIN customers AS c ON (o.customer_id = c.customer_id)

		JOIN transactions AS t ON (t.order_id=o.id AND t.response_code=1)

		GROUP BY o.id DESC

                )



        )



)

An error occurred in script '/var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php' on line 48:
mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given
Array

(

    [0] => Array

        (

            [function] => my_error_handler

            [args] => Array

                (

                    [0] => 2

                    [1] => mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given

                    [2] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                    [3] => 48

                    [4] => Array

                        (

                            [_GET] => Array

                                (

                                )



                            [_POST] => Array

                                (

                                )



                            [_COOKIE] => Array

                                (

                                )



                            [_FILES] => Array

                                (

                                )



                            [page_title] => View All Orders

                            [q] => SELECT o.id, FORMAT(total/100, 2) AS total, c.customer_id AS cid,

		CONCAT(last_name, ",", first_name) AS name, city, state,zip,

		COUNT(oc.id) AS items FROM orders AS o 

		LEFT OUTER JOIN order_contents AS oc ON 

		(oc.order_id=o.id AND oc.ship_date IS NULL)

		JOIN customers AS c ON (o.customer_id = c.customer_id)

		JOIN transactions AS t ON (t.order_id=o.id AND t.response_code=1)

		GROUP BY o.id DESC

                            [r] => 

                            [dbc] => 

                            [_SERVER] => Array

                                (

                                    [HTTP_ACCEPT] => */*

                                    [HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

                                    [HTTP_HOST] => dukesnuz.com

                                    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

                                    [SERVER_SIGNATURE] => 
Apache/2.4.18 (Ubuntu) Server at dukesnuz.com Port 80




                                    [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)

                                    [SERVER_NAME] => dukesnuz.com

                                    [SERVER_ADDR] => 165.227.77.107

                                    [SERVER_PORT] => 80

                                    [REMOTE_ADDR] => 3.14.142.115

                                    [DOCUMENT_ROOT] => /var/www/html/dukesnuz

                                    [REQUEST_SCHEME] => http

                                    [CONTEXT_PREFIX] => 

                                    [CONTEXT_DOCUMENT_ROOT] => /var/www/html/dukesnuz

                                    [SERVER_ADMIN] => [no address given]

                                    [SCRIPT_FILENAME] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [REMOTE_PORT] => 25229

                                    [GATEWAY_INTERFACE] => CGI/1.1

                                    [SERVER_PROTOCOL] => HTTP/1.1

                                    [REQUEST_METHOD] => GET

                                    [QUERY_STRING] => 

                                    [REQUEST_URI] => /d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [SCRIPT_NAME] => /d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [PHP_SELF] => /d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

                                    [REQUEST_TIME_FLOAT] => 1715230157.767

                                    [REQUEST_TIME] => 1715230157

                                )



                            [_SESSION] => Array

                                (

                                )



                        )



                )



        )



    [1] => Array

        (

            [file] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/view_orders.php

            [line] => 48

            [function] => mysqli_fetch_array

            [args] => Array

                (

                    [0] => 

                    [1] => 1

                )



        )



)

Order ID Total Customer Name City State Zip Left to Ship