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

                            [_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] => 

                            [_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] => 

                            [_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] => 

                            [_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