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

                                (

                                )



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

                                    [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/create_sales.php

                                    [REMOTE_PORT] => 4416

                                    [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/create_sales.php

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

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

                                    [REQUEST_TIME_FLOAT] => 1715228867.461

                                    [REQUEST_TIME] => 1715228867

                                )



                            [page_title] => Create Sales

                            [_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/create_sales.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

                                (

                                )



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

                                    [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/create_sales.php

                                    [REMOTE_PORT] => 4416

                                    [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/create_sales.php

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

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

                                    [REQUEST_TIME_FLOAT] => 1715228867.461

                                    [REQUEST_TIME] => 1715228867

                                )



                            [page_title] => Create Sales

                            [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/create_sales.php

            [line] => 7

            [args] => Array

                (

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

                )



            [function] => require

        )



)

Create Sales

To mark an item as being on sale, indicate the sale price, the date the sales starts, and the date the sale ends. All dates must be in the format YYY-MM-DD. You may leave the end date blank, thereby creating an open-ended sale. Only the currently stocked products are listed below!

An error occurred in script '/var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/create_sales.php' on line 96:
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/create_sales.php

                    [3] => 96

                    [4] => Array

                        (

                            [_GET] => Array

                                (

                                )



                            [_POST] => Array

                                (

                                )



                            [_COOKIE] => Array

                                (

                                )



                            [_FILES] => Array

                                (

                                )



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

                                    [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/create_sales.php

                                    [REMOTE_PORT] => 4416

                                    [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/create_sales.php

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

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

                                    [REQUEST_TIME_FLOAT] => 1715228867.461

                                    [REQUEST_TIME] => 1715228867

                                )



                            [page_title] => Create Sales

                            [q] => (SELECT CONCAT("G", ncp.id) AS sku, ncc.category, ncp.name, FORMAT(ncp.price/100, 2) AS price, ncp.stock

		FROM non_coffee_products AS ncp

		INNER JOIN non_coffee_categories AS ncc ON ncc.id=ncp.non_coffee_category_id

		WHERE ncp.stock >0 ORDER BY category, name)

		UNION(SELECT CONCAT("C", sc.id), gc.category, CONCAT_WS(" - ", s.size, sc.caf_decaf, sc.ground_whole),

		FORMAT(sc.price/100,2), sc.stock

		FROM specific_coffees AS sc		

		INNER JOIN sizes AS s ON s.id=sc.size_id

		INNER JOIN general_coffees AS gc ON gc.id=sc.general_coffee_id

		WHERE sc.stock > 0 ORDER BY sc.general_coffee_id, sc.size, sc.caf_decaf, sc.ground_whole)

                            [dbc] => 

                            [_SESSION] => Array

                                (

                                )



                        )



                )



        )



    [1] => Array

        (

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

            [line] => 96

            [function] => mysqli_query

            [args] => Array

                (

                    [0] => 

                    [1] => (SELECT CONCAT("G", ncp.id) AS sku, ncc.category, ncp.name, FORMAT(ncp.price/100, 2) AS price, ncp.stock

		FROM non_coffee_products AS ncp

		INNER JOIN non_coffee_categories AS ncc ON ncc.id=ncp.non_coffee_category_id

		WHERE ncp.stock >0 ORDER BY category, name)

		UNION(SELECT CONCAT("C", sc.id), gc.category, CONCAT_WS(" - ", s.size, sc.caf_decaf, sc.ground_whole),

		FORMAT(sc.price/100,2), sc.stock

		FROM specific_coffees AS sc		

		INNER JOIN sizes AS s ON s.id=sc.size_id

		INNER JOIN general_coffees AS gc ON gc.id=sc.general_coffee_id

		WHERE sc.stock > 0 ORDER BY sc.general_coffee_id, sc.size, sc.caf_decaf, sc.ground_whole)

                )



        )



)

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

(

    [0] => Array

        (

            [function] => my_error_handler

            [args] => Array

                (

                    [0] => 2

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

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

                    [3] => 97

                    [4] => Array

                        (

                            [_GET] => Array

                                (

                                )



                            [_POST] => Array

                                (

                                )



                            [_COOKIE] => Array

                                (

                                )



                            [_FILES] => Array

                                (

                                )



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

                                    [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/create_sales.php

                                    [REMOTE_PORT] => 4416

                                    [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/create_sales.php

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

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

                                    [REQUEST_TIME_FLOAT] => 1715228867.461

                                    [REQUEST_TIME] => 1715228867

                                )



                            [page_title] => Create Sales

                            [q] => (SELECT CONCAT("G", ncp.id) AS sku, ncc.category, ncp.name, FORMAT(ncp.price/100, 2) AS price, ncp.stock

		FROM non_coffee_products AS ncp

		INNER JOIN non_coffee_categories AS ncc ON ncc.id=ncp.non_coffee_category_id

		WHERE ncp.stock >0 ORDER BY category, name)

		UNION(SELECT CONCAT("C", sc.id), gc.category, CONCAT_WS(" - ", s.size, sc.caf_decaf, sc.ground_whole),

		FORMAT(sc.price/100,2), sc.stock

		FROM specific_coffees AS sc		

		INNER JOIN sizes AS s ON s.id=sc.size_id

		INNER JOIN general_coffees AS gc ON gc.id=sc.general_coffee_id

		WHERE sc.stock > 0 ORDER BY sc.general_coffee_id, sc.size, sc.caf_decaf, sc.ground_whole)

                            [dbc] => 

                            [r] => 

                            [_SESSION] => Array

                                (

                                )



                        )



                )



        )



    [1] => Array

        (

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

            [line] => 97

            [function] => mysqli_error

            [args] => Array

                (

                    [0] => 

                )



        )



)

An error occurred in script '/var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/create_sales.php' on line 99:
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/create_sales.php

                    [3] => 99

                    [4] => Array

                        (

                            [_GET] => Array

                                (

                                )



                            [_POST] => Array

                                (

                                )



                            [_COOKIE] => Array

                                (

                                )



                            [_FILES] => Array

                                (

                                )



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

                                    [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/create_sales.php

                                    [REMOTE_PORT] => 4416

                                    [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/create_sales.php

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

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

                                    [REQUEST_TIME_FLOAT] => 1715228867.461

                                    [REQUEST_TIME] => 1715228867

                                )



                            [page_title] => Create Sales

                            [q] => (SELECT CONCAT("G", ncp.id) AS sku, ncc.category, ncp.name, FORMAT(ncp.price/100, 2) AS price, ncp.stock

		FROM non_coffee_products AS ncp

		INNER JOIN non_coffee_categories AS ncc ON ncc.id=ncp.non_coffee_category_id

		WHERE ncp.stock >0 ORDER BY category, name)

		UNION(SELECT CONCAT("C", sc.id), gc.category, CONCAT_WS(" - ", s.size, sc.caf_decaf, sc.ground_whole),

		FORMAT(sc.price/100,2), sc.stock

		FROM specific_coffees AS sc		

		INNER JOIN sizes AS s ON s.id=sc.size_id

		INNER JOIN general_coffees AS gc ON gc.id=sc.general_coffee_id

		WHERE sc.stock > 0 ORDER BY sc.general_coffee_id, sc.size, sc.caf_decaf, sc.ground_whole)

                            [dbc] => 

                            [r] => 

                            [_SESSION] => Array

                                (

                                )



                        )



                )



        )



    [1] => Array

        (

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

            [line] => 99

            [function] => mysqli_fetch_array

            [args] => Array

                (

                    [0] => 

                    [1] => 1

                )



        )



)

Item Normal Price Quantity in Stock Sale Price Start Date End Date