We help IT Professionals succeed at work.

Error in Script

Can you please help me in that error.
screenshot.JPGscreenshot2.JPGscreenshot3.JPG
<?php

require ("Entities/CoffeeEntity.php");

//Contains database related code for the Coffee page.
class CoffeeModel {

    //Get all coffee types from the database and return them in an array.
    function GetCoffeeTypes() {
        require 'Credentials.php';

        //Open connection and Select database.   
        mysql_connect($host, $user, $passwd) or die(mysql_error());
        mysql_select_db($database);
        $result = mysql_query("SELECT DISTINCT type FROM coffee") or die(mysql_error());
        $types = array();

        //Get data from database.
        while ($row = mysql_fetch_array($result)) {
            array_push($types, $row[0]);
        }

        //Close connection and return result.
        mysql_close();
        return $types;
    }

    //Get coffeeEntity objects from the database and return them in an array.
    function GetCoffeeByType($type) {
        require 'Credentials.php';

        //Open connection and Select database.     
        mysql_connect($host, $user, $passwd) or die(mysql_error);
        mysql_select_db($database);

        $query = "SELECT * FROM coffee WHERE type LIKE '$type'";
        $result = mysql_query($query) or die(mysql_error());
        $coffeeArray = array();

        //Get data from database.
        while ($row = mysql_fetch_array($result)) {
            $name = $row[1];
            $type = $row[2];
            $price = $row[3];
            $roast = $row[4];
            $country = $row[5];
            $image = $row[6];
            $review = $row[7];

            //Create coffee objects and store them in an array.
            $coffee = new CoffeeEntity(-1, $name, $type, $price, $roast, $country, $image, $review);
            array_push($coffeeArray, $coffee);
        }
        //Close connection and return result
        mysql_close();
        return $coffeeArray;
    }

}

?>

Open in new window


<?php
//Login data for the database. In all Models
$host = "localhost";
$user = "root";
$passwd = "";
$database = "coffeedb";

?>

Open in new window

Comment
Watch Question

Most Valuable Expert 2018
Distinguished Expert 2019
Commented:
Hi there,

In your script, you're using the old mysql_* functions. These were deprecated in PHP 5.5 and removed from version 7 altogether. Instead, you should be using either mysqli_* (note the i) or the PDO libary

mysqli_connect(...)
mysqli_select_db(...)

etc.
Most Valuable Expert 2018
Distinguished Expert 2019
Commented:
As well as the deprecated function, you'll also need to make sure you've enabled the mysqli extensions for your PHP installation. Run the following script on your server and search the output for 'mysql'

<?php
phpinfo();

Open in new window

Author

Commented:
I got another error after I replace them with mysqli.
screenshot.JPG
<?php

require ("Entities/CoffeeEntity.php");

//Contains database related code for the Coffee page.
class CoffeeModel {

    //Get all coffee types from the database and return them in an array.
    function GetCoffeeTypes() {
        require 'Credentials.php';

        //Open connection and Select database.   
        mysqli_connect($host, $user, $passwd) or die(mysql_error());
        mysqli_select_db($database);
        $result = mysqli_query("SELECT DISTINCT type FROM coffee") or die(mysql_error());
        $types = array();

        //Get data from database.
        while ($row = mysqli_fetch_array($result)) {
            array_push($types, $row[0]);
        }

        //Close connection and return result.
        mysql_close();
        return $types;
    }

    //Get coffeeEntity objects from the database and return them in an array.
    function GetCoffeeByType($type) {
        require 'Credentials.php';

        //Open connection and Select database.     
        mysqli_connect($host, $user, $passwd) or die(mysql_error);
        mysqli_select_db($database);

        $query = "SELECT * FROM coffee WHERE type LIKE '$type'";
        $result = mysqli_query($query) or die(mysql_error());
        $coffeeArray = array();

        //Get data from database.
        while ($row = mysqli_fetch_array($result)) {
            $name = $row[1];
            $type = $row[2];
            $price = $row[3];
            $roast = $row[4];
            $country = $row[5];
            $image = $row[6];
            $review = $row[7];

            //Create coffee objects and store them in an array.
            $coffee = new CoffeeEntity(-1, $name, $type, $price, $roast, $country, $image, $review);
            array_push($coffeeArray, $coffee);
        }
        //Close connection and return result
        mysqli_close();
        return $coffeeArray;
    }

}

?>

Open in new window

Author

Commented:
PHP logo
PHP Version 7.4.1
System 	Windows NT LENOVO-PC 6.1 build 7601 (Windows 7 Professional Edition Service Pack 1) AMD64
Build Date 	Dec 17 2019 19:17:41
Compiler 	Visual C++ 2017
Architecture 	x64
Configure Command 	cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-pdo-oci=c:\php-snap-build\deps_aux\oracle\x64\instantclient_12_1\sdk,shared" "--with-oci8-12c=c:\php-snap-build\deps_aux\oracle\x64\instantclient_12_1\sdk,shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet=shared" "--without-analyzer" "--with-pgo"
Server API 	Apache 2.0 Handler
Virtual Directory Support 	enabled
Configuration File (php.ini) Path 	C:\Windows
Loaded Configuration File 	C:\xampp\php\php.ini
Scan this dir for additional .ini files 	(none)
Additional .ini files parsed 	(none)
PHP API 	20190902
PHP Extension 	20190902
Zend Extension 	320190902
Zend Extension Build 	API320190902,TS,VC15
PHP Extension Build 	API20190902,TS,VC15
Debug Build 	no
Thread Safety 	enabled
Thread API 	Windows Threads
Zend Signal Handling 	disabled
Zend Memory Manager 	enabled
Zend Multibyte Support 	provided by mbstring
IPv6 Support 	enabled
DTrace Support 	disabled
Registered PHP Streams	php, file, glob, data, http, ftp, zip, compress.zlib, compress.bzip2, https, ftps, phar
Registered Stream Socket Transports	tcp, udp, ssl, tls, tlsv1.0, tlsv1.1, tlsv1.2, tlsv1.3
Registered Stream Filters	convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.*, bzip2.*
Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v3.4.0, Copyright (c) Zend Technologies
Configuration
apache2handler
Apache Version 	Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.4.1
Apache API Version 	20120211
Server Administrator 	postmaster@localhost
Hostname:Port 	localhost:80
Max Requests 	Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts 	Connection: 300 - Keep-Alive: 5
Virtual Server 	No
Server Root 	C:/xampp/apache
Loaded Modules 	core mod_win32 mpm_winnt http_core mod_so mod_access_compat mod_actions mod_alias mod_allowmethods mod_asis mod_auth_basic mod_authn_core mod_authn_file mod_authz_core mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dav_lock mod_dir mod_env mod_headers mod_include mod_info mod_isapi mod_log_config mod_cache_disk mod_mime mod_negotiation mod_proxy mod_proxy_ajp mod_rewrite mod_setenvif mod_socache_shmcb mod_ssl mod_status mod_version mod_php7
Directive	Local Value	Master Value
engine	1	1
last_modified	0	0
xbithack	0	0
Apache Environment
Variable	Value
MIBDIRS 	C:/xampp/php/extras/mibs
MYSQL_HOME 	\xampp\mysql\bin
OPENSSL_CONF 	C:/xampp/apache/bin/openssl.cnf
PHP_PEAR_SYSCONF_DIR 	\xampp\php
PHPRC 	\xampp\php
TMP 	\xampp\tmp
HTTP_HOST 	localhost:8090
HTTP_USER_AGENT 	Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0
HTTP_ACCEPT 	text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_ACCEPT_LANGUAGE 	en-US,en;q=0.5
HTTP_ACCEPT_ENCODING 	gzip, deflate
HTTP_CONNECTION 	keep-alive
HTTP_UPGRADE_INSECURE_REQUESTS 	1
PATH 	C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ProgramData\Oracle\Java\javapath;C:\Perl\site\bin;C:\Perl\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Lenovo\Access Connections\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files (x86)\Windows Kits\8.1\Windows Performance Toolkit\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SDKs\TypeScript\1.0\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Pages\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\perl\bin;C:\Program Files\Microsoft DNX\Dnvm\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files (x86)\Rand McNally\RNDDock\GtkSharp\2.12\Bin
SystemRoot 	C:\Windows
COMSPEC 	C:\Windows\system32\cmd.exe
PATHEXT 	.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
WINDIR 	C:\Windows
SERVER_SIGNATURE 	<address>Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.4.1 Server at localhost Port 8090</address>
SERVER_SOFTWARE 	Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.4.1
SERVER_NAME 	localhost
SERVER_ADDR 	::1
SERVER_PORT 	8090
REMOTE_ADDR 	::1
DOCUMENT_ROOT 	C:/xampp/htdocs
REQUEST_SCHEME 	http
CONTEXT_PREFIX 	no value
CONTEXT_DOCUMENT_ROOT 	C:/xampp/htdocs
SERVER_ADMIN 	postmaster@localhost
SCRIPT_FILENAME 	C:/xampp/htdocs/CoffeeWebsite/test.php
REMOTE_PORT 	58817
GATEWAY_INTERFACE 	CGI/1.1
SERVER_PROTOCOL 	HTTP/1.1
REQUEST_METHOD 	GET
QUERY_STRING 	no value
REQUEST_URI 	/CoffeeWebsite/test.php
SCRIPT_NAME 	/CoffeeWebsite/test.php
HTTP Headers Information
HTTP Request Headers
HTTP Request 	GET /CoffeeWebsite/test.php HTTP/1.1
Host 	localhost:8090
User-Agent 	Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0
Accept 	text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
Accept-Language 	en-US,en;q=0.5
Accept-Encoding 	gzip, deflate
Connection 	keep-alive
Upgrade-Insecure-Requests 	1
HTTP Response Headers
X-Powered-By 	PHP/7.4.1
bcmath
BCMath support 	enabled
Directive	Local Value	Master Value
bcmath.scale	0	0
bz2
BZip2 Support 	Enabled
Stream Wrapper support 	compress.bzip2://
Stream Filter support 	bzip2.decompress, bzip2.compress
BZip2 Version 	1.0.8, 13-Jul-2019
calendar
Calendar support 	enabled
Core
PHP Version 	7.4.1
Directive	Local Value	Master Value
allow_url_fopen	On	On
allow_url_include	Off	Off
arg_separator.input	&	&
arg_separator.output	&	&
auto_append_file	no value	no value
auto_globals_jit	On	On
auto_prepend_file	no value	no value
browscap	C:\xampp\php\extras\browscap.ini	C:\xampp\php\extras\browscap.ini
default_charset	UTF-8	UTF-8
default_mimetype	text/html	text/html
disable_classes	no value	no value
disable_functions	no value	no value
display_errors	On	On
display_startup_errors	On	On
doc_root	no value	no value
docref_ext	no value	no value
docref_root	no value	no value
enable_dl	Off	Off
enable_post_data_reading	On	On
error_append_string	no value	no value
error_log	C:\xampp\php\logs\php_error_log	C:\xampp\php\logs\php_error_log
error_prepend_string	no value	no value
error_reporting	22527	22527
expose_php	On	On
extension_dir	C:\xampp\php\ext	C:\xampp\php\ext
file_uploads	On	On
hard_timeout	2	2
highlight.comment	#FF8000	#FF8000
highlight.default	#0000BB	#0000BB
highlight.html	#000000	#000000
highlight.keyword	#007700	#007700
highlight.string	#DD0000	#DD0000
html_errors	On	On
ignore_repeated_errors	Off	Off
ignore_repeated_source	Off	Off
ignore_user_abort	Off	Off
implicit_flush	Off	Off
include_path	C:\xampp\php\PEAR	C:\xampp\php\PEAR
input_encoding	no value	no value
internal_encoding	no value	no value
log_errors	On	On
log_errors_max_len	1024	1024
mail.add_x_header	Off	Off
mail.force_extra_parameters	no value	no value
mail.log	no value	no value
max_execution_time	120	120
max_file_uploads	20	20
max_input_nesting_level	64	64
max_input_time	60	60
max_input_vars	1000	1000
memory_limit	512M	512M
open_basedir	no value	no value
output_buffering	4096	4096
output_encoding	no value	no value
output_handler	no value	no value
post_max_size	40M	40M
precision	14	14
realpath_cache_size	4096K	4096K
realpath_cache_ttl	120	120
register_argc_argv	Off	Off
report_memleaks	On	On
report_zend_debug	On	On
request_order	GP	GP
sendmail_from	no value	no value
sendmail_path	no value	no value
serialize_precision	-1	-1
short_open_tag	Off	Off
SMTP	localhost	localhost
smtp_port	25	25
sys_temp_dir	no value	no value
syslog.facility	LOG_USER	LOG_USER
syslog.filter	no-ctrl	no-ctrl
syslog.ident	php	php
track_errors	Off	Off
unserialize_callback_func	no value	no value
upload_max_filesize	40M	40M
upload_tmp_dir	C:\xampp\tmp	C:\xampp\tmp
user_dir	no value	no value
user_ini.cache_ttl	300	300
user_ini.filename	.user.ini	.user.ini
variables_order	GPCS	GPCS
windows.show_crt_warning	Off	Off
xmlrpc_error_number	0	0
xmlrpc_errors	Off	Off
zend.assertions	1	1
zend.detect_unicode	On	On
zend.enable_gc	On	On
zend.exception_ignore_args	Off	Off
zend.multibyte	Off	Off
zend.script_encoding	no value	no value
ctype
ctype functions 	enabled
curl
cURL support 	enabled
cURL Information 	7.67.0
Age 	5
Features
AsynchDNS 	Yes
CharConv 	No
Debug 	No
GSS-Negotiate 	No
IDN 	Yes
IPv6 	Yes
krb4 	No
Largefile 	Yes
libz 	Yes
NTLM 	Yes
NTLMWB 	No
SPNEGO 	Yes
SSL 	Yes
SSPI 	Yes
TLS-SRP 	No
HTTP2 	Yes
GSSAPI 	No
KERBEROS5 	Yes
UNIX_SOCKETS 	Yes
PSL 	No
HTTPS_PROXY 	Yes
MULTI_SSL 	No
BROTLI 	No
Protocols 	dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtsp, scp, sftp, smb, smbs, smtp, smtps, telnet, tftp
Host 	x86_64-pc-win32
SSL Version 	OpenSSL/1.1.1c
ZLib Version 	1.2.11
libSSH Version 	libssh2/1.8.2
Directive	Local Value	Master Value
curl.cainfo	C:\xampp\apache\bin\curl-ca-bundle.crt	C:\xampp\apache\bin\curl-ca-bundle.crt
date
date/time support 	enabled
timelib version 	2018.03
"Olson" Timezone Database Version 	2019.3
Timezone Database 	internal
Default timezone 	Europe/Berlin
Directive	Local Value	Master Value
date.default_latitude	31.7667	31.7667
date.default_longitude	35.2333	35.2333
date.sunrise_zenith	90.583333	90.583333
date.sunset_zenith	90.583333	90.583333
date.timezone	Europe/Berlin	Europe/Berlin
dom
DOM/XML 	enabled
DOM/XML API Version 	20031129
libxml Version 	2.9.10
HTML Support 	enabled
XPath Support 	enabled
XPointer Support 	enabled
Schema Support 	enabled
RelaxNG Support 	enabled
exif
EXIF Support 	enabled
Supported EXIF Version 	0220
Supported filetypes 	JPEG, TIFF
Multibyte decoding support using mbstring 	enabled
Extended EXIF tag formats 	Canon, Casio, Fujifilm, Nikon, Olympus, Samsung, Panasonic, DJI, Sony, Pentax, Minolta, Sigma, Foveon, Kyocera, Ricoh, AGFA, Epson
Directive	Local Value	Master Value
exif.decode_jis_intel	JIS	JIS
exif.decode_jis_motorola	JIS	JIS
exif.decode_unicode_intel	UCS-2LE	UCS-2LE
exif.decode_unicode_motorola	UCS-2BE	UCS-2BE
exif.encode_jis	no value	no value
exif.encode_unicode	ISO-8859-15	ISO-8859-15
fileinfo
fileinfo support 	enabled
libmagic 	537
filter
Input Validation and Filtering 	enabled
Directive	Local Value	Master Value
filter.default	unsafe_raw	unsafe_raw
filter.default_flags	no value	no value
ftp
FTP support 	enabled
FTPS support 	enabled
gd
GD Support 	enabled
GD Version 	bundled (2.1.0 compatible)
FreeType Support 	enabled
FreeType Linkage 	with freetype
FreeType Version 	2.9.1
GIF Read Support 	enabled
GIF Create Support 	enabled
JPEG Support 	enabled
libJPEG Version 	9 compatible
PNG Support 	enabled
libPNG Version 	1.6.34
WBMP Support 	enabled
XPM Support 	enabled
libXpm Version 	30512
XBM Support 	enabled
WebP Support 	enabled
BMP Support 	enabled
TGA Read Support 	enabled
Directive	Local Value	Master Value
gd.jpeg_ignore_warning	1	1
gettext
GetText Support 	enabled
hash
hash support 	enabled
Hashing Engines 	md2 md4 md5 sha1 sha224 sha256 sha384 sha512/224 sha512/256 sha512 sha3-224 sha3-256 sha3-384 sha3-512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b crc32c fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5
MHASH support 	Enabled
MHASH API Version 	Emulated Support
iconv
iconv support 	enabled
iconv implementation 	"libiconv"
iconv library version 	1.16
Directive	Local Value	Master Value
iconv.input_encoding	no value	no value
iconv.internal_encoding	no value	no value
iconv.output_encoding	no value	no value
json
json support 	enabled
libxml
libXML support 	active
libXML Compiled Version 	2.9.10
libXML Loaded Version 	20910
libXML streams 	enabled
mbstring
Multibyte Support 	enabled
Multibyte string engine 	libmbfl
HTTP input encoding translation 	disabled
libmbfl version 	1.3.2
mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.
Multibyte (japanese) regex support 	enabled
Multibyte regex (oniguruma) version 	6.9.4
Directive	Local Value	Master Value
mbstring.detect_order	no value	no value
mbstring.encoding_translation	Off	Off
mbstring.func_overload	0	0
mbstring.http_input	no value	no value
mbstring.http_output	no value	no value
mbstring.http_output_conv_mimetypes	^(text/|application/xhtml\+xml)	^(text/|application/xhtml\+xml)
mbstring.internal_encoding	no value	no value
mbstring.language	neutral	neutral
mbstring.regex_retry_limit	1000000	1000000
mbstring.regex_stack_limit	100000	100000
mbstring.strict_detection	Off	Off
mbstring.substitute_character	no value	no value
mysqli
MysqlI Support	enabled
Client API library version 	mysqlnd 7.4.1
Active Persistent Links 	0
Inactive Persistent Links 	0
Active Links 	0
Directive	Local Value	Master Value
mysqli.allow_local_infile	Off	Off
mysqli.allow_persistent	On	On
mysqli.default_host	no value	no value
mysqli.default_port	3306	3306
mysqli.default_pw	no value	no value
mysqli.default_socket	no value	no value
mysqli.default_user	no value	no value
mysqli.max_links	Unlimited	Unlimited
mysqli.max_persistent	Unlimited	Unlimited
mysqli.reconnect	Off	Off
mysqli.rollback_on_cached_plink	Off	Off
mysqlnd
mysqlnd	enabled
Version 	mysqlnd 7.4.1
Compression 	supported
core SSL 	supported
extended SSL 	not supported
Command buffer size 	4096
Read buffer size 	32768
Read timeout 	86400
Collecting statistics 	Yes
Collecting memory statistics 	Yes
Tracing 	n/a
Loaded plugins 	mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password
API Extensions 	mysqli,pdo_mysql
openssl
OpenSSL support 	enabled
OpenSSL Library Version 	OpenSSL 1.1.1c 28 May 2019
OpenSSL Header Version 	OpenSSL 1.1.1d 10 Sep 2019
Openssl default config 	C:\Program Files\Common Files\SSL/openssl.cnf
Directive	Local Value	Master Value
openssl.cafile	C:\xampp\apache\bin\curl-ca-bundle.crt	C:\xampp\apache\bin\curl-ca-bundle.crt
openssl.capath	no value	no value
pcre
PCRE (Perl Compatible Regular Expressions) Support 	enabled
PCRE Library Version 	10.33 2019-04-16
PCRE Unicode Version 	11.0.0
PCRE JIT Support 	enabled
PCRE JIT Target 	x86 64bit (little endian + unaligned)
Directive	Local Value	Master Value
pcre.backtrack_limit	1000000	1000000
pcre.jit	1	1
pcre.recursion_limit	100000	100000
PDO
PDO support	enabled
PDO drivers 	mysql
pdo_mysql
PDO Driver for MySQL	enabled
Client API version 	mysqlnd 7.4.1
Phar
Phar: PHP Archive support	enabled
Phar API version 	1.1.1
Phar-based phar archives 	enabled
Tar-based phar archives 	enabled
ZIP-based phar archives 	enabled
gzip compression 	enabled
bzip2 compression 	enabled
OpenSSL support 	enabled
Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
Directive	Local Value	Master Value
phar.cache_list	no value	no value
phar.readonly	On	On
phar.require_hash	On	On
readline
Readline Support	enabled
Readline library 	WinEditLine
Directive	Local Value	Master Value
cli.pager	no value	no value
cli.prompt	\b \> 	\b \> 
Reflection
Reflection 	enabled
session
Session Support 	enabled
Registered save handlers 	files user
Registered serializer handlers 	php_serialize php php_binary
Directive	Local Value	Master Value
session.auto_start	Off	Off
session.cache_expire	180	180
session.cache_limiter	nocache	nocache
session.cookie_domain	no value	no value
session.cookie_httponly	no value	no value
session.cookie_lifetime	0	0
session.cookie_path	/	/
session.cookie_samesite	no value	no value
session.cookie_secure	0	0
session.gc_divisor	1000	1000
session.gc_maxlifetime	1440	1440
session.gc_probability	1	1
session.lazy_write	On	On
session.name	PHPSESSID	PHPSESSID
session.referer_check	no value	no value
session.save_handler	files	files
session.save_path	C:\xampp\tmp	C:\xampp\tmp
session.serialize_handler	php	php
session.sid_bits_per_character	5	5
session.sid_length	26	26
session.upload_progress.cleanup	On	On
session.upload_progress.enabled	On	On
session.upload_progress.freq	1%	1%
session.upload_progress.min_freq	1	1
session.upload_progress.name	PHP_SESSION_UPLOAD_PROGRESS	PHP_SESSION_UPLOAD_PROGRESS
session.upload_progress.prefix	upload_progress_	upload_progress_
session.use_cookies	1	1
session.use_only_cookies	1	1
session.use_strict_mode	0	0
session.use_trans_sid	0	0
SimpleXML
SimpleXML support 	enabled
Schema support 	enabled
SPL
SPL support	enabled
Interfaces 	OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes 	AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException
standard
Dynamic Library Support 	enabled
Internal Sendmail Support for Windows 	enabled
Directive	Local Value	Master Value
assert.active	1	1
assert.bail	0	0
assert.callback	no value	no value
assert.exception	0	0
assert.quiet_eval	0	0
assert.warning	1	1
auto_detect_line_endings	0	0
default_socket_timeout	60	60
from	no value	no value
session.trans_sid_hosts	no value	no value
session.trans_sid_tags	a=href,area=href,frame=src,form=	a=href,area=href,frame=src,form=
unserialize_max_depth	4096	4096
url_rewriter.hosts	no value	no value
url_rewriter.tags	form=	form=
user_agent	no value	no value
tokenizer
Tokenizer Support 	enabled
xml
XML Support 	active
XML Namespace Support 	active
libxml2 Version 	2.9.10
xmlreader
XMLReader 	enabled
xmlwriter
XMLWriter 	enabled
zip
Zip 	enabled
Zip version 	1.15.5
Libzip version 	1.4.0
zlib
ZLib Support	enabled
Stream Wrapper 	compress.zlib://
Stream Filter 	zlib.inflate, zlib.deflate
Compiled Version 	1.2.11
Linked Version 	1.2.11
Directive	Local Value	Master Value
zlib.output_compression	Off	Off
zlib.output_compression_level	-1	-1
zlib.output_handler	no value	no value
Additional Modules
Module Name
Environment
Variable	Value
no value 	::=::\
ACPath 	C:\Program Files (x86)\Lenovo\Access Connections\
ALLUSERSPROFILE 	C:\ProgramData
APPDATA 	C:\Users\Lenovo\AppData\Roaming
CommonProgramFiles 	C:\Program Files\Common Files
CommonProgramFiles(x86) 	C:\Program Files (x86)\Common Files
CommonProgramW6432 	C:\Program Files\Common Files
COMPUTERNAME 	LENOVO-PC
ComSpec 	C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK 	NO
HOMEDRIVE 	C:
HOMEPATH 	\Users\Lenovo
LOCALAPPDATA 	C:\Users\Lenovo\AppData\Local
LOGONSERVER 	\\LENOVO-PC
NUMBER_OF_PROCESSORS 	4
OS 	Windows_NT
Path 	C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ProgramData\Oracle\Java\javapath;C:\Perl\site\bin;C:\Perl\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Lenovo\Access Connections\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files (x86)\Windows Kits\8.1\Windows Performance Toolkit\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SDKs\TypeScript\1.0\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Pages\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\perl\bin;C:\Program Files\Microsoft DNX\Dnvm\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files (x86)\Rand McNally\RNDDock\GtkSharp\2.12\Bin
PATHEXT 	.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE 	AMD64
PROCESSOR_IDENTIFIER 	Intel64 Family 6 Model 42 Stepping 7, GenuineIntel
PROCESSOR_LEVEL 	6
PROCESSOR_REVISION 	2a07
ProgramData 	C:\ProgramData
ProgramFiles 	C:\Program Files
ProgramFiles(x86) 	C:\Program Files (x86)
ProgramW6432 	C:\Program Files
PSModulePath 	C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\PowerShell\Modules\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\PowerShell\Modules\
PUBLIC 	C:\Users\Public
SESSIONNAME 	Console
SystemDrive 	C:
SystemRoot 	C:\Windows
TEMP 	C:\Users\Lenovo\AppData\Local\Temp
TMP 	C:\Users\Lenovo\AppData\Local\Temp
USERDOMAIN 	Lenovo-PC
USERNAME 	Lenovo
USERPROFILE 	C:\Users\Lenovo
VS100COMNTOOLS 	C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\Tools\
VS110COMNTOOLS 	C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\Tools\
VS120COMNTOOLS 	C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\Tools\
VS140COMNTOOLS 	C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\Tools\
windir 	C:\Windows
windows_tracing_flags 	3
windows_tracing_logfile 	C:\BVTBin\Tests\installpackage\csilogfile.log
AP_PARENT_PID 	11584
PHP Variables
Variable	Value
$_SERVER['MIBDIRS']	C:/xampp/php/extras/mibs
$_SERVER['MYSQL_HOME']	\xampp\mysql\bin
$_SERVER['OPENSSL_CONF']	C:/xampp/apache/bin/openssl.cnf
$_SERVER['PHP_PEAR_SYSCONF_DIR']	\xampp\php
$_SERVER['PHPRC']	\xampp\php
$_SERVER['TMP']	\xampp\tmp
$_SERVER['HTTP_HOST']	localhost:8090
$_SERVER['HTTP_USER_AGENT']	Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0
$_SERVER['HTTP_ACCEPT']	text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
$_SERVER['HTTP_ACCEPT_LANGUAGE']	en-US,en;q=0.5
$_SERVER['HTTP_ACCEPT_ENCODING']	gzip, deflate
$_SERVER['HTTP_CONNECTION']	keep-alive
$_SERVER['HTTP_UPGRADE_INSECURE_REQUESTS']	1
$_SERVER['PATH']	C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ProgramData\Oracle\Java\javapath;C:\Perl\site\bin;C:\Perl\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Lenovo\Access Connections\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files (x86)\Windows Kits\8.1\Windows Performance Toolkit\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SDKs\TypeScript\1.0\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Pages\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\perl\bin;C:\Program Files\Microsoft DNX\Dnvm\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files (x86)\Rand McNally\RNDDock\GtkSharp\2.12\Bin
$_SERVER['SystemRoot']	C:\Windows
$_SERVER['COMSPEC']	C:\Windows\system32\cmd.exe
$_SERVER['PATHEXT']	.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
$_SERVER['WINDIR']	C:\Windows
$_SERVER['SERVER_SIGNATURE']	<address>Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.4.1 Server at localhost Port 8090</address>
$_SERVER['SERVER_SOFTWARE']	Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.4.1
$_SERVER['SERVER_NAME']	localhost
$_SERVER['SERVER_ADDR']	::1
$_SERVER['SERVER_PORT']	8090
$_SERVER['REMOTE_ADDR']	::1
$_SERVER['DOCUMENT_ROOT']	C:/xampp/htdocs
$_SERVER['REQUEST_SCHEME']	http
$_SERVER['CONTEXT_PREFIX']	no value
$_SERVER['CONTEXT_DOCUMENT_ROOT']	C:/xampp/htdocs
$_SERVER['SERVER_ADMIN']	postmaster@localhost
$_SERVER['SCRIPT_FILENAME']	C:/xampp/htdocs/CoffeeWebsite/test.php
$_SERVER['REMOTE_PORT']	58817
$_SERVER['GATEWAY_INTERFACE']	CGI/1.1
$_SERVER['SERVER_PROTOCOL']	HTTP/1.1
$_SERVER['REQUEST_METHOD']	GET
$_SERVER['QUERY_STRING']	no value
$_SERVER['REQUEST_URI']	/CoffeeWebsite/test.php
$_SERVER['SCRIPT_NAME']	/CoffeeWebsite/test.php
$_SERVER['PHP_SELF']	/CoffeeWebsite/test.php
$_SERVER['REQUEST_TIME_FLOAT']	1579650967.26
$_SERVER['REQUEST_TIME']	1579650967
PHP Credits
PHP Group
Thies C. Arntzen, Stig Bakken, Shane Caraveo, Andi Gutmans, Rasmus Lerdorf, Sam Ruby, Sascha Schumann, Zeev Suraski, Jim Winstead, Andrei Zmievski
Language Design & Concept
Andi Gutmans, Rasmus Lerdorf, Zeev Suraski, Marcus Boerger
PHP Authors
Contribution	Authors
Zend Scripting Language Engine 	Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Marcus Boerger, Dmitry Stogov, Xinchen Hui, Nikita Popov
Extension Module API 	Andi Gutmans, Zeev Suraski, Andrei Zmievski
UNIX Build and Modularization 	Stig Bakken, Sascha Schumann, Jani Taskinen, Peter Kokot
Windows Support 	Shane Caraveo, Zeev Suraski, Wez Furlong, Pierre-Alain Joye, Anatol Belski, Kalle Sommer Nielsen
Server API (SAPI) Abstraction Layer 	Andi Gutmans, Shane Caraveo, Zeev Suraski
Streams Abstraction Layer 	Wez Furlong, Sara Golemon
PHP Data Objects Layer 	Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
Output Handler 	Zeev Suraski, Thies C. Arntzen, Marcus Boerger, Michael Wallner
Consistent 64 bit support 	Anthony Ferrara, Anatol Belski
SAPI Modules
Contribution	Authors
Apache 2.0 Handler 	Ian Holsman, Justin Erenkrantz (based on Apache 2.0 Filter code)
CGI / FastCGI 	Rasmus Lerdorf, Stig Bakken, Shane Caraveo, Dmitry Stogov
CLI 	Edin Kadribasic, Marcus Boerger, Johannes Schlueter, Moriyoshi Koizumi, Xinchen Hui
Embed 	Edin Kadribasic
FastCGI Process Manager 	Andrei Nigmatulin, dreamcat4, Antony Dovgal, Jerome Loyet
litespeed 	George Wang
phpdbg 	Felipe Pena, Joe Watkins, Bob Weinand
Module Authors
Module	Authors
BC Math 	Andi Gutmans
Bzip2 	Sterling Hughes
Calendar 	Shane Caraveo, Colin Viebrock, Hartmut Holzgraefe, Wez Furlong
COM and .Net 	Wez Furlong
ctype 	Hartmut Holzgraefe
cURL 	Sterling Hughes
Date/Time Support 	Derick Rethans
DB-LIB (MS SQL, Sybase) 	Wez Furlong, Frank M. Kromann, Adam Baratz
DBA 	Sascha Schumann, Marcus Boerger
DOM 	Christian Stocker, Rob Richards, Marcus Boerger
enchant 	Pierre-Alain Joye, Ilia Alshanetsky
EXIF 	Rasmus Lerdorf, Marcus Boerger
FFI 	Dmitry Stogov
fileinfo 	Ilia Alshanetsky, Pierre Alain Joye, Scott MacVicar, Derick Rethans, Anatol Belski
Firebird driver for PDO 	Ard Biesheuvel
FTP 	Stefan Esser, Andrew Skalski
GD imaging 	Rasmus Lerdorf, Stig Bakken, Jim Winstead, Jouni Ahto, Ilia Alshanetsky, Pierre-Alain Joye, Marcus Boerger
GetText 	Alex Plotnick
GNU GMP support 	Stanislav Malyshev
Iconv 	Rui Hirokawa, Stig Bakken, Moriyoshi Koizumi
IMAP 	Rex Logan, Mark Musone, Brian Wang, Kaj-Michael Lang, Antoni Pamies Olive, Rasmus Lerdorf, Andrew Skalski, Chuck Hagenbuch, Daniel R Kalowsky
Input Filter 	Rasmus Lerdorf, Derick Rethans, Pierre-Alain Joye, Ilia Alshanetsky
Internationalization 	Ed Batutis, Vladimir Iordanov, Dmitry Lakhtyuk, Stanislav Malyshev, Vadim Savchuk, Kirti Velankar
JSON 	Jakub Zelenka, Omar Kilani, Scott MacVicar
LDAP 	Amitay Isaacs, Eric Warnke, Rasmus Lerdorf, Gerrit Thomson, Stig Venaas
LIBXML 	Christian Stocker, Rob Richards, Marcus Boerger, Wez Furlong, Shane Caraveo
Multibyte String Functions 	Tsukada Takuya, Rui Hirokawa
MySQL driver for PDO 	George Schlossnagle, Wez Furlong, Ilia Alshanetsky, Johannes Schlueter
MySQLi 	Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel
MySQLnd 	Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter
OCI8 	Stig Bakken, Thies C. Arntzen, Andy Sautins, David Benson, Maxim Maletsky, Harald Radi, Antony Dovgal, Andi Gutmans, Wez Furlong, Christopher Jones, Oracle Corporation
ODBC driver for PDO 	Wez Furlong
ODBC 	Stig Bakken, Andreas Karajannis, Frank M. Kromann, Daniel R. Kalowsky
Opcache 	Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Dmitry Stogov, Xinchen Hui
OpenSSL 	Stig Venaas, Wez Furlong, Sascha Kettler, Scott MacVicar
Oracle (OCI) driver for PDO 	Wez Furlong
pcntl 	Jason Greene, Arnaud Le Blanc
Perl Compatible Regexps 	Andrei Zmievski
PHP Archive 	Gregory Beaver, Marcus Boerger
PHP Data Objects 	Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
PHP hash 	Sara Golemon, Rasmus Lerdorf, Stefan Esser, Michael Wallner, Scott MacVicar
Posix 	Kristian Koehntopp
PostgreSQL driver for PDO 	Edin Kadribasic, Ilia Alshanetsky
PostgreSQL 	Jouni Ahto, Zeev Suraski, Yasuo Ohgaki, Chris Kings-Lynne
Pspell 	Vlad Krupin
Readline 	Thies C. Arntzen
Reflection 	Marcus Boerger, Timm Friebe, George Schlossnagle, Andrei Zmievski, Johannes Schlueter
Sessions 	Sascha Schumann, Andrei Zmievski
Shared Memory Operations 	Slava Poliakov, Ilia Alshanetsky
SimpleXML 	Sterling Hughes, Marcus Boerger, Rob Richards
SNMP 	Rasmus Lerdorf, Harrie Hazewinkel, Mike Jackson, Steven Lawrance, Johann Hanne, Boris Lytochkin
SOAP 	Brad Lafountain, Shane Caraveo, Dmitry Stogov
Sockets 	Chris Vandomelen, Sterling Hughes, Daniel Beulshausen, Jason Greene
Sodium 	Frank Denis
SPL 	Marcus Boerger, Etienne Kneuss
SQLite 3.x driver for PDO 	Wez Furlong
SQLite3 	Scott MacVicar, Ilia Alshanetsky, Brad Dewar
System V Message based IPC 	Wez Furlong
System V Semaphores 	Tom May
System V Shared Memory 	Christian Cartus
tidy 	John Coggeshall, Ilia Alshanetsky
tokenizer 	Andrei Zmievski, Johannes Schlueter
XML 	Stig Bakken, Thies C. Arntzen, Sterling Hughes
XMLReader 	Rob Richards
xmlrpc 	Dan Libby
XMLWriter 	Rob Richards, Pierre-Alain Joye
XSL 	Christian Stocker, Rob Richards
Zip 	Pierre-Alain Joye, Remi Collet
Zlib 	Rasmus Lerdorf, Stefan Roehrich, Zeev Suraski, Jade Nicoletti, Michael Wallner
PHP Documentation
Authors 	Mehdi Achour, Friedhelm Betz, Antony Dovgal, Nuno Lopes, Hannes Magnusson, Philip Olson, Georg Richter, Damien Seguy, Jakub Vrana, Adam Harvey
Editor 	Peter Cowburn
User Note Maintainers 	Daniel P. Brown, Thiago Henrique Pojda
Other Contributors 	Previously active authors, editors and other contributors are listed in the manual.
PHP Quality Assurance Team
Ilia Alshanetsky, Joerg Behrens, Antony Dovgal, Stefan Esser, Moriyoshi Koizumi, Magnus Maatta, Sebastian Nohn, Derick Rethans, Melvyn Sopacua, Pierre-Alain Joye, Dmitry Stogov, Felipe Pena, David Soria Parra, Stanislav Malyshev, Julien Pauli, Stephen Zarkos, Anatol Belski, Remi Collet, Ferenc Kovacs
Websites and Infrastructure team
PHP Websites Team 	Rasmus Lerdorf, Hannes Magnusson, Philip Olson, Lukas Kahwe Smith, Pierre-Alain Joye, Kalle Sommer Nielsen, Peter Cowburn, Adam Harvey, Ferenc Kovacs, Levi Morrison
Event Maintainers 	Damien Seguy, Daniel P. Brown
Network Infrastructure 	Daniel P. Brown
Windows Infrastructure 	Alex Schoenmaker
PHP License

This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.

Open in new window

Most Valuable Expert 2018
Distinguished Expert 2019
Commented:
Have a read of the errors and it tells you exactly what's wrong:

mysqli_select_db expects 2 parameters. 1 given:

You have this:

mysqli_select_db($database)

If you look at the docs for that function, you'll see it expects a link to your connection AND a database name, so you need to so this:

mysqli_select_db($conn, $database);

In order for that to work, first you need to assign your connection to a variable called $conn, so you create your connection like this:

$conn = mysqli_connect($host, $user, $passwd);

The same applies for your mysqli_query() call. It should be this:

$result = mysqli_query($conn, $query) or die(mysqli_error($conn));

Notive we've also change the call to mysql_error to mysqli error.
Most Valuable Expert 2018
Distinguished Expert 2019
Commented:
I would make a suggestion here. When you're dealing with the mysqli library you have 2 different ways of using it - either in a procedural way (the way you're currently doing it) or in an Object Oriented way. Because you're using a class in your code, you are already taking an Object Oriented approach to your code, so I would suggest you switch out the procedural methods and go with the Object approach instead.

And if you're going to go with the Object approach, you might want to look into PDO instead of mysqli. In my opinion, it's a much cleaner way of coding. With PDO, your code will be a lot cleaner:

$result = $db->query("SELECT DISTINCT type FROM coffee");
return $result->fetchAll();

Open in new window

Author

Commented:
screenshot.JPGscreenshot2.JPG
<?php

require ("Entities/CoffeeEntity.php");

//Contains database related code for the Coffee page.
class CoffeeModel {

    //Get all coffee types from the database and return them in an array.
    function GetCoffeeTypes() {
        require 'Credentials.php';

        //Open connection and Select database.   
        $conn = mysqli_connect($host, $user, $passwd);                
        mysqli_connect($host, $user, $passwd) or die(mysql_error());
        mysqli_select_db($conn, $database);        
        $result = mysqli_query($conn, "SELECT DISTINCT type FROM coffee") or die(mysql_error());
        $types = array();

        //Get data from database.
        while ($row = mysqli_fetch_array($result)) {
            array_push($types, $row[0]);
        }

        //Close connection and return result.
        mysql_close();
        return $types;
    }

    //Get coffeeEntity objects from the database and return them in an array.
    function GetCoffeeByType($type) {
        require 'Credentials.php';

        //Open connection and Select database.     
        mysqli_connect($host, $user, $passwd) or die(mysql_error);
        mysqli_select_db($database);

        $query = "SELECT * FROM coffee WHERE type LIKE '$type'";
        $result = mysqli_query($query) or die(mysql_error());
        $coffeeArray = array();

        //Get data from database.
        while ($row = mysqli_fetch_array($result)) {
            $name = $row[1];
            $type = $row[2];
            $price = $row[3];
            $roast = $row[4];
            $country = $row[5];
            $image = $row[6];
            $review = $row[7];

            //Create coffee objects and store them in an array.
            $coffee = new CoffeeEntity(-1, $name, $type, $price, $roast, $country, $image, $review);
            array_push($coffeeArray, $coffee);
        }
        //Close connection and return result
        mysqli_close();
        return $coffeeArray;
    }

}

?>

Open in new window

Author

Commented:
Can you please change my page with the PDO style.
screenshot.JPG
<?php

require ("Entities/CoffeeEntity.php");

//Contains database related code for the Coffee page.
class CoffeeModel {

    //Get all coffee types from the database and return them in an array.
    function GetCoffeeTypes() {
        require 'Credentials.php';

        //Open connection and Select database.   
        $conn = mysqli_connect($host, $user, $passwd);                
        mysqli_connect($host, $user, $passwd) or die(mysql_error());
        mysqli_select_db($conn, $database);        
        $result = mysqli_query($conn, "SELECT DISTINCT type FROM coffee") or die(mysql_error());
        $types = array();

        //Get data from database.
        while ($row = mysqli_fetch_array($result)) {
            array_push($types, $row[0]);
        }

        //Close connection and return result.
        mysql_close();
        return $types;
    }

    //Get coffeeEntity objects from the database and return them in an array.
    function GetCoffeeByType($type) {
        require 'Credentials.php';

        //Open connection and Select database.     
        mysqli_connect($host, $user, $passwd) or die(mysql_error);
        mysqli_select_db($database);

        $query = "SELECT * FROM coffee WHERE type LIKE '$type'";
        //$result = mysqli_query($query) or die(mysql_error());
        //$coffeeArray = array();

        $result = $db->query("SELECT DISTINCT type FROM coffee");
        return $result->fetchAll();
        //Get data from database.
        while ($row = mysqli_fetch_array($result)) {
            $name = $row[1];
            $type = $row[2];
            $price = $row[3];
            $roast = $row[4];
            $country = $row[5];
            $image = $row[6];
            $review = $row[7];

            //Create coffee objects and store them in an array.
            $coffee = new CoffeeEntity(-1, $name, $type, $price, $roast, $country, $image, $review);
            array_push($coffeeArray, $coffee);
        }
        //Close connection and return result
        mysqli_close();
        return $coffeeArray;
    }

}

?>

Open in new window

Most Valuable Expert 2018
Distinguished Expert 2019
Commented:
Sure. Something like this is how I would code your Model with PDO:

class CoffeeModel {

    private $db;

    public function __construct(\PDO $db) {
        $this->db = $db;
    }

    public function GetCoffeeTypes() {
        $stmt = $this->db->query("SELECT DISTINCT type FROM coffee");
		
        return $stmt->fetchAll();
    }

    public function GetCoffeeByType($type) {
        $stmt = $this->db->prepare("SELECT name, type, price, roast, country, image, review FROM coffee WHERE type LIKE ?");
        $stmt->execute(['%' . $type . '%']);
		
        return $stmt->fetchAll(PDO::FETCH_CLASS, 'CoffeeEntity');
    }

}

Open in new window

You'll notice that instead of connecting to the DB inside the class, we're passing a connection into the class constructor. This is called dependency injection, and is generally the way you should do this. Now to use it, you need to create a connection to your DB outside of the class, and inject it in. Create your credentials.php file like this:

$user = "root";
$passwd = "";
$dsn      = 'mysql:host=localhost;dbname=coffeedb;charset=utf8mb4'; 
$options  = [
    PDO::ATTR_EMULATE_PREPARES   => false,
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,
];

$db = new \PDO($dsn, $username, $passwd, $options);

Open in new window

And the include that so that you can inject it:

require 'credentials.php';
$coffee = new CoffeeModel($db);

var_dump( $coffee->GetCoffeeTypes() );
var_dump( $coffee->GetCoffeeByType('sometype') );

Open in new window

Author

Commented:
Thank You.
Most Valuable Expert 2018
Distinguished Expert 2019

Commented:

You're welcome