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.223.196.211

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

                                    [REMOTE_PORT] => 63055

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

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

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

                                    [REQUEST_TIME_FLOAT] => 1715279186.832

                                    [REQUEST_TIME] => 1715279186

                                )



                            [page_title] => Add Inventory

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

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

                                    [REMOTE_PORT] => 63055

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

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

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

                                    [REQUEST_TIME_FLOAT] => 1715279186.832

                                    [REQUEST_TIME] => 1715279186

                                )



                            [page_title] => Add Inventory

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

            [line] => 7

            [args] => Array

                (

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

                )



            [function] => require

        )



)

Add Inventory

Indicate how many addistional quantity of each product should be added to the inventory.
An error occurred in script '/var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/admin_2/add_inventory.php' on line 83:
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/add_inventory.php

                    [3] => 83

                    [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.223.196.211

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

                                    [REMOTE_PORT] => 63055

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

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

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

                                    [REQUEST_TIME_FLOAT] => 1715279186.832

                                    [REQUEST_TIME] => 1715279186

                                )



                            [page_title] => Add Inventory

                            [dbc] => 

                            [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

				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 ORDER By

				sc.general_coffee_id, sc.size, sc.caf_decaf, sc.ground_whole)

                            [_SESSION] => Array

                                (

                                )



                        )



                )



        )



    [1] => Array

        (

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

            [line] => 83

            [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

				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 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/add_inventory.php' on line 86:
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/add_inventory.php

                    [3] => 86

                    [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.223.196.211

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

                                    [REMOTE_PORT] => 63055

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

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

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

                                    [REQUEST_TIME_FLOAT] => 1715279186.832

                                    [REQUEST_TIME] => 1715279186

                                )



                            [page_title] => Add Inventory

                            [dbc] => 

                            [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

				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 ORDER By

				sc.general_coffee_id, sc.size, sc.caf_decaf, sc.ground_whole)

                            [r] => 

                            [_SESSION] => Array

                                (

                                )



                        )



                )



        )



    [1] => Array

        (

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

            [line] => 86

            [function] => mysqli_fetch_array

            [args] => Array

                (

                    [0] => 

                    [1] => 1

                )



        )



)

Item Normal Price Quantity in Stock Add