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] => Coffee - Would'nt you Love a Cup Right Now?

                            [_SERVER] => Array

                                (

                                    [HTTP_ACCEPT] => */*

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

                                    [HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate

                                    [HTTP_HOST] => dukesnuz.com

                                    [HTTP_VIA] => 1.1 squid-proxy-5b5d847c96-g2n9f (squid/6.10)

                                    [HTTP_X_FORWARDED_FOR] => 10.1.231.130

                                    [HTTP_CACHE_CONTROL] => max-age=259200

                                    [HTTP_CONNECTION] => keep-alive

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

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

                                    [REMOTE_PORT] => 52653

                                    [GATEWAY_INTERFACE] => CGI/1.1

                                    [SERVER_PROTOCOL] => HTTP/1.1

                                    [REQUEST_METHOD] => GET

                                    [QUERY_STRING] => 

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

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

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

                                    [REQUEST_TIME_FLOAT] => 1751775438.673

                                    [REQUEST_TIME] => 1751775438

                                )



                        )



                )



        )



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

            [line] => 11

            [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] => Coffee - Would'nt you Love a Cup Right Now?

                            [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_ACCEPT_ENCODING] => gzip, br, zstd, deflate

                                    [HTTP_HOST] => dukesnuz.com

                                    [HTTP_VIA] => 1.1 squid-proxy-5b5d847c96-g2n9f (squid/6.10)

                                    [HTTP_X_FORWARDED_FOR] => 10.1.231.130

                                    [HTTP_CACHE_CONTROL] => max-age=259200

                                    [HTTP_CONNECTION] => keep-alive

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

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

                                    [REMOTE_PORT] => 52653

                                    [GATEWAY_INTERFACE] => CGI/1.1

                                    [SERVER_PROTOCOL] => HTTP/1.1

                                    [REQUEST_METHOD] => GET

                                    [QUERY_STRING] => 

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

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

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

                                    [REQUEST_TIME_FLOAT] => 1751775438.673

                                    [REQUEST_TIME] => 1751775438

                                )



                        )



                )



        )



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

            [line] => 11

            [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/ch_11/index.php' on line 15:
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/index.php

                    [3] => 15

                    [4] => Array

                        (

                            [_GET] => Array

                                (

                                )



                            [_POST] => Array

                                (

                                )



                            [_COOKIE] => Array

                                (

                                )



                            [_FILES] => Array

                                (

                                )



                            [page_title] => Coffee - Would'nt you Love a Cup Right Now?

                            [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_ACCEPT_ENCODING] => gzip, br, zstd, deflate

                                    [HTTP_HOST] => dukesnuz.com

                                    [HTTP_VIA] => 1.1 squid-proxy-5b5d847c96-g2n9f (squid/6.10)

                                    [HTTP_X_FORWARDED_FOR] => 10.1.231.130

                                    [HTTP_CACHE_CONTROL] => max-age=259200

                                    [HTTP_CONNECTION] => keep-alive

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

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

                                    [REMOTE_PORT] => 52653

                                    [GATEWAY_INTERFACE] => CGI/1.1

                                    [SERVER_PROTOCOL] => HTTP/1.1

                                    [REQUEST_METHOD] => GET

                                    [QUERY_STRING] => 

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

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

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

                                    [REQUEST_TIME_FLOAT] => 1751775438.673

                                    [REQUEST_TIME] => 1751775438

                                )



                        )



                )



        )



    [1] => Array

        (

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

            [line] => 15

            [function] => mysqli_query

            [args] => Array

                (

                    [0] => 

                    [1] => CALL select_sale_items(false)

                )



        )



)

An error occurred in script '/var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/views/home.html' on line 10:
mysqli_num_rows() expects parameter 1 to be mysqli_result, null given
Array

(

    [0] => Array

        (

            [function] => my_error_handler

            [args] => Array

                (

                    [0] => 2

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

                    [2] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/views/home.html

                    [3] => 10

                    [4] => Array

                        (

                            [_GET] => Array

                                (

                                )



                            [_POST] => Array

                                (

                                )



                            [_COOKIE] => Array

                                (

                                )



                            [_FILES] => Array

                                (

                                )



                            [page_title] => Coffee - Would'nt you Love a Cup Right Now?

                            [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_ACCEPT_ENCODING] => gzip, br, zstd, deflate

                                    [HTTP_HOST] => dukesnuz.com

                                    [HTTP_VIA] => 1.1 squid-proxy-5b5d847c96-g2n9f (squid/6.10)

                                    [HTTP_X_FORWARDED_FOR] => 10.1.231.130

                                    [HTTP_CACHE_CONTROL] => max-age=259200

                                    [HTTP_CONNECTION] => keep-alive

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

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

                                    [REMOTE_PORT] => 52653

                                    [GATEWAY_INTERFACE] => CGI/1.1

                                    [SERVER_PROTOCOL] => HTTP/1.1

                                    [REQUEST_METHOD] => GET

                                    [QUERY_STRING] => 

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

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

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

                                    [REQUEST_TIME_FLOAT] => 1751775438.673

                                    [REQUEST_TIME] => 1751775438

                                )



                        )



                )



        )



    [1] => Array

        (

            [file] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/views/home.html

            [line] => 10

            [function] => mysqli_num_rows

            [args] => Array

                (

                    [0] => 

                )



        )



    [2] => Array

        (

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

            [line] => 17

            [args] => Array

                (

                    [0] => /var/www/html/dukesnuz/d/phppercolate_7/ecom-2/ch_11/views/home.html

                )



            [function] => include

        )



)

Chapter 11 Exercises

  • Site Administration
  • This chapter is set up to accept an example sale.
  • If all goes well, which it will, purchase some cool stuff here.
  • Use the demo payment numbers. Then view the sale in the admin site.
  • GO ahead. Try it out!

About Clever Coffee, Inc.

Clever Coffee, Inc. has been selling coffee online since 1923. For years, Clever Coffee, Inc failed to make a profit, due to the lack of computers and the Interent. Yadda, yadda, yadda

It 's safe to shop here, promise!