MYSQLI Probleme

Irgendwelche Probleme mit XAMPP für Windows? Dann ist hier genau der richtige Ort um nachzufragen.

MYSQLI Probleme

Postby Daywalker4868 » 11. December 2016 18:43

Hallo zusammen,

ich bekomme folgende Fehlermeldung, wenn ich via MYSQLI die DB aufrufe:

Fatal error: Uncaught Error: Call to undefined function  mysqli_connect() in C:\xampp\htdocs\Psycho\test.php:7 Stack trace: #0 {main} thrown in C:\xampp\htdocs\Psycho\test.php on line 7

mysqli ist in der php.ini aktiviert

Ich habe keine Idee mehr :roll:

Gruss
Thorsten
Daywalker4868
 
Posts: 10
Joined: 11. December 2016 18:38
XAMPP version: 7.0.9
Operating System: Windows 10

Re: MYSQLI Probleme

Postby Altrea » 13. December 2016 00:04

Hallo Thorsten,

phpinfo() Ausgabe wäre hier ganz hilfreich.

mit freundlichen Grüßen,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8883
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MYSQLI Probleme

Postby Daywalker4868 » 13. December 2016 15:35

Hi Altrea,

hier der Auszug aus der PHPINFO. Ich hoffe das reicht so:

PHP Version 7.0.9
System
Windows NT USER-NB 10.0 build 14393 (Windows 10) i586
Build Date
Jul 20 2016 10:44:24
Compiler
MSVC14 (Visual C++ 2015)
Architecture
x86
Configure Command
cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-pdo-oci=c:\php-sdk\oracle\x86\instantclient_12_1\sdk,shared" "--with-oci8-12c=c:\php-sdk\oracle\x86\instantclient_12_1\sdk,shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet=shared" "--with-mcrypt=static" "--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
20151012
PHP Extension
20151012
Zend Extension
320151012
Zend Extension Build
API320151012,TS,VC14
PHP Extension Build
API20151012,TS,VC14
Debug Build
no
Thread Safety
enabled
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, sslv3, tls, tlsv1.0, tlsv1.1, tlsv1.2
Registered Stream Filters
convert.iconv.*, mcrypt.*, mdecrypt.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.*, bzip2.*

Gruss
Thorsten
Daywalker4868
 
Posts: 10
Joined: 11. December 2016 18:38
XAMPP version: 7.0.9
Operating System: Windows 10

Re: MYSQLI Probleme

Postby Nobbie » 13. December 2016 16:23

Daywalker4868 wrote:Ich hoffe das reicht so:


Das reicht ganz sicher NICHT, das ist ja nur ein minimaler Bruchteil von phpinfo().

Was passiert, wenn Du phpmyadmin startest (entweder via http://localhost auf den Link oben rechts klicken oder hier auf http://localhost/phpmyadmin klicken)? Läuft das?
Nobbie
 
Posts: 9617
Joined: 09. March 2008 13:04

Re: MYSQLI Probleme

Postby Daywalker4868 » 13. December 2016 17:32

Hi,
my PHPADMIN kann ich ohne Schwierigkeiten aufrufen. Da gibt rs kin Problem.

Anbei der Rest der PHPINFO:

Configuration
apache2handler
Apache Version
Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/7.0.9
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_ACCEPT
text/html, application/xhtml+xml, image/jxr, */*
HTTP_ACCEPT_LANGUAGE
de-DE,de;q=0.8,en-US;q=0.5,en;q=0.3
HTTP_USER_AGENT
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.79 Safari/537.36 Edge/14.14393
HTTP_ACCEPT_ENCODING
gzip, deflate
HTTP_HOST
localhost
HTTP_CONNECTION
Keep-Alive
PATH
C:\ProgramData\Oracle\Java\javapath;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Samsung\AllShare Framework DMS\1.3.23\;C:\Program Files\Samsung\AllShare Framework DMS\1.3.23\64bit\;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Users\User\AppData\Local\Microsoft\WindowsApps;C:\Users\User\AppData\Local\atom\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.23 (Win32) OpenSSL/1.0.2h PHP/7.0.9 Server at localhost Port 80</address>
SERVER_SOFTWARE
Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/7.0.9
SERVER_NAME
localhost
SERVER_ADDR
::1
SERVER_PORT
80
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/dashboard/phpinfo.php
REMOTE_PORT
50110
GATEWAY_INTERFACE
CGI/1.1
SERVER_PROTOCOL
HTTP/1.1
REQUEST_METHOD
GET
QUERY_STRING
no value
REQUEST_URI
/dashboard/phpinfo.php
SCRIPT_NAME
/dashboard/phpinfo.php
HTTP Headers Information
HTTP Request Headers
HTTP Request
GET /dashboard/phpinfo.php HTTP/1.1
Accept
text/html, application/xhtml+xml, image/jxr, */*
Accept-Language
de-DE,de;q=0.8,en-US;q=0.5,en;q=0.3
User-Agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.79 Safari/537.36 Edge/14.14393
Accept-Encoding
gzip, deflate
Host
localhost
Connection
Keep-Alive
HTTP Response Headers
X-Powered-By
PHP/7.0.9
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.6, 6-Sept-2010
calendar
Calendar support
enabled
Core
PHP Version
7.0.9
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
exit_on_timeout
Off
Off
expose_php
On
On
extension_dir
C:\xampp\php\ext
C:\xampp\php\ext
file_uploads
On
On
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
On
On
mail.force_extra_parameters
no value
no value
mail.log
no value
no value
max_execution_time
30
30
max_file_uploads
20
20
max_input_nesting_level
64
64
max_input_time
60
60
max_input_vars
1000
1000
memory_limit
128M
128M
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
8M
8M
precision
14
14
realpath_cache_size
16K
16K
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
17
17
short_open_tag
Off
Off
SMTP
localhost
localhost
smtp_port
25
25
sql.safe_mode
Off
Off
sys_temp_dir
no value
no value
track_errors
Off
Off
unserialize_callback_func
no value
no value
upload_max_filesize
2M
2M
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.multibyte
Off
Off
zend.script_encoding
no value
no value
ctype
ctype functions
enabled
curl
cURL support
enabled
cURL Information
7.49.1
Age
3
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
No
GSSAPI
No
KERBEROS5
Yes
UNIX_SOCKETS
No
PSL
No
Protocols
dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, pop3, pop3s, rtsp, scp, sftp, smtp, smtps, telnet, tftp
Host
i386-pc-win32
SSL Version
OpenSSL/1.0.2h
ZLib Version
1.2.8
libSSH Version
libssh2/1.7.0
date
date/time support
enabled
"Olson" Timezone Database Version
2016.5
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.4
HTML Support
enabled
XPath Support
enabled
XPointer Support
enabled
Schema Support
enabled
RelaxNG Support
enabled
exif
EXIF Support
enabled
EXIF Version
1.4 $Id: 8bdc0c8f27c2c9dd1f7551f1f9fe3ab57a06a4b1 $
Supported EXIF Version
0220
Supported filetypes
JPEG,TIFF
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
version
1.0.5
libmagic
522
filter
Input Validation and Filtering
enabled
Revision
$Id: 2c8dde9d49ae877877eccaf496c8f5a733b4f1c2 $
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.6.2
GIF Read Support
enabled
GIF Create Support
enabled
JPEG Support
enabled
libJPEG Version
9 compatible
PNG Support
enabled
libPNG Version
1.6.21
WBMP Support
enabled
XPM Support
enabled
libXpm Version
30411
XBM Support
enabled
WebP Support
enabled
Directive
Local Value
Master Value
gd.jpeg_ignore_warning
0
0
gettext
GetText Support
enabled
hash
hash support
enabled
Hashing Engines
md2 md4 md5 sha1 sha224 sha256 sha384 sha512 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 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.14
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
json version
1.4.0
libxml
libXML support
active
libXML Compiled Version
2.9.4
libXML Loaded Version
20904
libXML streams
enabled
mbstring
Multibyte Support
enabled
Multibyte string engine
libmbfl
HTTP input encoding translation
disabled
libmbfl version
1.3.2
oniguruma version
5.9.6
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
5.9.6
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.strict_detection
Off
Off
mbstring.substitute_character
no value
no value
mcrypt
mcrypt support
enabled
mcrypt_filter support
enabled
Version
2.5.8
Api No
20021217
Supported ciphers
cast-128 gost rijndael-128 twofish cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes arcfour
Supported modes
cbc cfb ctr ecb ncfb nofb ofb stream
Directive
Local Value
Master Value
mcrypt.algorithms_dir
no value
no value
mcrypt.modes_dir
no value
no value
mysqli
MysqlI Support
enabled
Client API library version
mysqlnd 5.0.12-dev - 20150407 - $Id: 241ae00989d1995ffcbbf63d579943635faf9972 $
Active Persistent Links
0
Inactive Persistent Links
0
Active Links
0
Directive
Local Value
Master Value
mysqli.allow_local_infile
On
On
mysqli.allow_persistent
On
On
mysqli.default_host
no value
no value
mysqli.default_port
no value
no value
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 5.0.12-dev - 20150407 - $Id: 241ae00989d1995ffcbbf63d579943635faf9972 $
Compression
supported
core SSL
supported
extended SSL
not supported
Command buffer size
4096
Read buffer size
32768
Read timeout
31536000
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
mysqlnd statistics

bytes_sent
0
bytes_received
0
packets_sent
0
packets_received
0
protocol_overhead_in
0
protocol_overhead_out
0
bytes_received_ok_packet
0
bytes_received_eof_packet
0
bytes_received_rset_header_packet
0
bytes_received_rset_field_meta_packet
0
bytes_received_rset_row_packet
0
bytes_received_prepare_response_packet
0
bytes_received_change_user_packet
0
packets_sent_command
0
packets_received_ok
0
packets_received_eof
0
packets_received_rset_header
0
packets_received_rset_field_meta
0
packets_received_rset_row
0
packets_received_prepare_response
0
packets_received_change_user
0
result_set_queries
0
non_result_set_queries
0
no_index_used
0
bad_index_used
0
slow_queries
0
buffered_sets
0
unbuffered_sets
0
ps_buffered_sets
0
ps_unbuffered_sets
0
flushed_normal_sets
0
flushed_ps_sets
0
ps_prepared_never_executed
0
ps_prepared_once_executed
0
rows_fetched_from_server_normal
0
rows_fetched_from_server_ps
0
rows_buffered_from_client_normal
0
rows_buffered_from_client_ps
0
rows_fetched_from_client_normal_buffered
0
rows_fetched_from_client_normal_unbuffered
0
rows_fetched_from_client_ps_buffered
0
rows_fetched_from_client_ps_unbuffered
0
rows_fetched_from_client_ps_cursor
0
rows_affected_normal
0
rows_affected_ps
0
rows_skipped_normal
0
rows_skipped_ps
0
copy_on_write_saved
0
copy_on_write_performed
0
command_buffer_too_small
0
connect_success
0
connect_failure
0
connection_reused
0
reconnect
0
pconnect_success
0
active_connections
0
active_persistent_connections
0
explicit_close
0
implicit_close
0
disconnect_close
0
in_middle_of_command_close
0
explicit_free_result
0
implicit_free_result
0
explicit_stmt_close
0
implicit_stmt_close
0
mem_emalloc_count
0
mem_emalloc_amount
0
mem_ecalloc_count
0
mem_ecalloc_amount
0
mem_erealloc_count
0
mem_erealloc_amount
0
mem_efree_count
0
mem_efree_amount
0
mem_malloc_count
0
mem_malloc_amount
0
mem_calloc_count
0
mem_calloc_amount
0
mem_realloc_count
0
mem_realloc_amount
0
mem_free_count
0
mem_free_amount
0
mem_estrndup_count
0
mem_strndup_count
0
mem_estndup_count
0
mem_strdup_count
0
proto_text_fetched_null
0
proto_text_fetched_bit
0
proto_text_fetched_tinyint
0
proto_text_fetched_short
0
proto_text_fetched_int24
0
proto_text_fetched_int
0
proto_text_fetched_bigint
0
proto_text_fetched_decimal
0
proto_text_fetched_float
0
proto_text_fetched_double
0
proto_text_fetched_date
0
proto_text_fetched_year
0
proto_text_fetched_time
0
proto_text_fetched_datetime
0
proto_text_fetched_timestamp
0
proto_text_fetched_string
0
proto_text_fetched_blob
0
proto_text_fetched_enum
0
proto_text_fetched_set
0
proto_text_fetched_geometry
0
proto_text_fetched_other
0
proto_binary_fetched_null
0
proto_binary_fetched_bit
0
proto_binary_fetched_tinyint
0
proto_binary_fetched_short
0
proto_binary_fetched_int24
0
proto_binary_fetched_int
0
proto_binary_fetched_bigint
0
proto_binary_fetched_decimal
0
proto_binary_fetched_float
0
proto_binary_fetched_double
0
proto_binary_fetched_date
0
proto_binary_fetched_year
0
proto_binary_fetched_time
0
proto_binary_fetched_datetime
0
proto_binary_fetched_timestamp
0
proto_binary_fetched_string
0
proto_binary_fetched_json
0
proto_binary_fetched_blob
0
proto_binary_fetched_enum
0
proto_binary_fetched_set
0
proto_binary_fetched_geometry
0
proto_binary_fetched_other
0
init_command_executed_count
0
init_command_failed_count
0
com_quit
0
com_init_db
0
com_query
0
com_field_list
0
com_create_db
0
com_drop_db
0
com_refresh
0
com_shutdown
0
com_statistics
0
com_process_info
0
com_connect
0
com_process_kill
0
com_debug
0
com_ping
0
com_time
0
com_delayed_insert
0
com_change_user
0
com_binlog_dump
0
com_table_dump
0
com_connect_out
0
com_register_slave
0
com_stmt_prepare
0
com_stmt_execute
0
com_stmt_send_long_data
0
com_stmt_close
0
com_stmt_reset
0
com_stmt_set_option
0
com_stmt_fetch
0
com_deamon
0
bytes_received_real_data_normal
0
bytes_received_real_data_ps
0
openssl
OpenSSL support
enabled
OpenSSL Library Version
OpenSSL 1.0.2h 3 May 2016
OpenSSL Header Version
OpenSSL 1.0.2h 3 May 2016
Openssl default config
c:/openssl-1.0.2h-win32/ssl/openssl.cnf
Directive
Local Value
Master Value
openssl.cafile
no value
no value
openssl.capath
no value
no value
pcre
PCRE (Perl Compatible Regular Expressions) Support
enabled
PCRE Library Version
8.38 2015-11-23
PCRE JIT Support
enabled
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, sqlite
pdo_mysql
PDO Driver for MySQL
enabled
Client API version
mysqlnd 5.0.12-dev - 20150407 - $Id: 241ae00989d1995ffcbbf63d579943635faf9972 $
pdo_sqlite
PDO Driver for SQLite 3.x
enabled
SQLite Library
3.8.10.2
Phar
Phar: PHP Archive support
enabled
Phar EXT version
2.0.2
Phar API version
1.1.1
SVN revision
$Id: 860f5132d446a7b24c2bbf050ce6949381ea8db5 $
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
Reflection
Reflection
enabled
Version
$Id: 4c3f6240f4111de768fd771f35e2291d27631432 $
session
Session Support
enabled
Registered save handlers
files user
Registered serializer handlers
php_serialize php php_binary wddx
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
Off
Off
session.cookie_lifetime
0
0
session.cookie_path
/
/
session.cookie_secure
Off
Off
session.entropy_file
no value
no value
session.entropy_length
0
0
session.gc_divisor
1000
1000
session.gc_maxlifetime
1440
1440
session.gc_probability
1
1
session.hash_bits_per_character
5
5
session.hash_function
0
0
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.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
On
On
session.use_only_cookies
On
On
session.use_strict_mode
Off
Off
session.use_trans_sid
0
0
SimpleXML
Simplexml support
enabled
Revision
$Id: 8a1ef4915f2024925ab80334b809c691c2cc0196 $
Schema support
enabled
SPL
SPL support
enabled
Interfaces
Countable, 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
url_rewriter.tags
a=href,area=href,frame=src,input=src,form=fakeentry
a=href,area=href,frame=src,input=src,form=fakeentry
user_agent
no value
no value
tokenizer
Tokenizer Support
enabled
wddx
WDDX Support
enabled
WDDX Session Serializer
enabled
xml
XML Support
active
XML Namespace Support
active
libxml2 Version
2.9.4
xmlreader
XMLReader
enabled
xmlwriter
XMLWriter
enabled
zip
Zip
enabled
Zip version
1.13.3
Libzip version
1.1.2
zlib
ZLib Support
enabled
Stream Wrapper
compress.zlib://
Stream Filter
zlib.inflate, zlib.deflate
Compiled Version
1.2.8
Linked Version
1.2.8
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
ALLUSERSPROFILE
C:\ProgramData
APPDATA
C:\Users\User\AppData\Roaming
CommonProgramFiles
C:\Program Files (x86)\Common Files
CommonProgramFiles(x86)
C:\Program Files (x86)\Common Files
CommonProgramW6432
C:\Program Files\Common Files
COMPUTERNAME
USER-NB
ComSpec
C:\WINDOWS\system32\cmd.exe
FPS_BROWSER_APP_PROFILE_STRING
Internet Explorer
FPS_BROWSER_USER_PROFILE_STRING
Default
FP_NO_HOST_CHECK
NO
HOMEDRIVE
C:
HOMEPATH
\Users\User
LOCALAPPDATA
C:\Users\User\AppData\Local
LOGONSERVER
\\USER-NB
NUMBER_OF_PROCESSORS
4
OS
Windows_NT
Path
C:\ProgramData\Oracle\Java\javapath;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Samsung\AllShare Framework DMS\1.3.23\;C:\Program Files\Samsung\AllShare Framework DMS\1.3.23\64bit\;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Users\User\AppData\Local\Microsoft\WindowsApps;C:\Users\User\AppData\Local\atom\bin
PATHEXT
.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE
x86
PROCESSOR_ARCHITEW6432
AMD64
PROCESSOR_IDENTIFIER
Intel64 Family 6 Model 55 Stepping 8, GenuineIntel
PROCESSOR_LEVEL
6
PROCESSOR_REVISION
3708
ProgramData
C:\ProgramData
ProgramFiles
C:\Program Files (x86)
ProgramFiles(x86)
C:\Program Files (x86)
ProgramW6432
C:\Program Files
PSModulePath
C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\
PUBLIC
C:\Users\Public
SESSIONNAME
Console
SystemDrive
C:
SystemRoot
C:\WINDOWS
TEMP
C:\Users\User\AppData\Local\Temp
TMP
C:\Users\User\AppData\Local\Temp
USERDOMAIN
User-NB
USERDOMAIN_ROAMINGPROFILE
User-NB
USERNAME
User
USERPROFILE
C:\Users\User
windir
C:\WINDOWS
windows_tracing_flags
3
windows_tracing_logfile
C:\BVTBin\Tests\installpackage\csilogfile.log
AP_PARENT_PID
9772
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_ACCEPT']
text/html, application/xhtml+xml, image/jxr, */*
$_SERVER['HTTP_ACCEPT_LANGUAGE']
de-DE,de;q=0.8,en-US;q=0.5,en;q=0.3
$_SERVER['HTTP_USER_AGENT']
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.79 Safari/537.36 Edge/14.14393
$_SERVER['HTTP_ACCEPT_ENCODING']
gzip, deflate
$_SERVER['HTTP_HOST']
localhost
$_SERVER['HTTP_CONNECTION']
Keep-Alive
$_SERVER['PATH']
C:\ProgramData\Oracle\Java\javapath;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Samsung\AllShare Framework DMS\1.3.23\;C:\Program Files\Samsung\AllShare Framework DMS\1.3.23\64bit\;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Users\User\AppData\Local\Microsoft\WindowsApps;C:\Users\User\AppData\Local\atom\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.23 (Win32) OpenSSL/1.0.2h PHP/7.0.9 Server at localhost Port 80</address>
$_SERVER['SERVER_SOFTWARE']
Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/7.0.9
$_SERVER['SERVER_NAME']
localhost
$_SERVER['SERVER_ADDR']
::1
$_SERVER['SERVER_PORT']
80
$_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/dashboard/phpinfo.php
$_SERVER['REMOTE_PORT']
50110
$_SERVER['GATEWAY_INTERFACE']
CGI/1.1
$_SERVER['SERVER_PROTOCOL']
HTTP/1.1
$_SERVER['REQUEST_METHOD']
GET
$_SERVER['QUERY_STRING']
no value
$_SERVER['REQUEST_URI']
/dashboard/phpinfo.php
$_SERVER['SCRIPT_NAME']
/dashboard/phpinfo.php
$_SERVER['PHP_SELF']
/dashboard/phpinfo.php
$_SERVER['REQUEST_TIME_FLOAT']
1481639785.379
$_SERVER['REQUEST_TIME']
1481639785

Gruss
Thorsten
Daywalker4868
 
Posts: 10
Joined: 11. December 2016 18:38
XAMPP version: 7.0.9
Operating System: Windows 10

Re: MYSQLI Probleme

Postby Nobbie » 13. December 2016 17:48

phpmyadmin läuft auf Basis von mysqli.

Was ist denn dieses "Psycho/test.php" für ein Script? Füge das doch mal hier ein (komplett).
Nobbie
 
Posts: 9617
Joined: 09. March 2008 13:04

Re: MYSQLI Probleme

Postby Daywalker4868 » 13. December 2016 18:00

Hi,

hier mein Script:

$hosti = "localhost";
$nutzi = "root";
$passwi = "";
$dbi = "blabla";

if ($db = mysqli_connect("$hosti", "$nutzi", "$passwi", "$dbi") or die("cannot select DB. Please contact us"))
{
$sqli = "SELECT LMAIL from login";
if ($ergebnis = mysqli_query($dbi, $sqli))
{
echo "<ul>";
while ($zeile = mysqli_fetch_assoc($ergebnis))
{
echo "<li>" . htmlspecialchars($zeile["LMAIL"]) . "</li>";
}
echo "</ul>";
mysqli_close($dbi);
}

echo "Vielen Dank. Sie erhalten in Kürze eine Email.<br>";
echo "$MAIL";//<br>$_POST['PWORD1']<br>$_POST['PWORD2']";
}
}
Daywalker4868
 
Posts: 10
Joined: 11. December 2016 18:38
XAMPP version: 7.0.9
Operating System: Windows 10

Re: MYSQLI Probleme

Postby Nobbie » 13. December 2016 19:57

Das kann nicht sein, da fehlt am Anfang der PHP Tag (<?php), am Ende auch, es sind jede Menge ungeschlossener Klammern offen - so läuft das Script nie im Leben.

Dann muss ich es noch einmal ganz explizit sagen, das scheint Dir neu zu sein: wenn Du wirklich effektive Hilfe haben möchtest, gibt es nicht kontraproduktiveres als verstümmelte Fragmente. Da fange ich genau überhaupt nichts mit an. Also bitte stelle uns das Script VOLLSTÄNDIG hier ein und insbesondere rahme es auch in CODE Tags ein, das sieht dann beispielsweise so aus:

Code: Select all
<?php

$hosti = "localhost";
$nutzi = "root";
$passwi = "";
$dbi = "blabla";

if ($db = mysqli_connect("$hosti", "$nutzi", "$passwi", "$dbi") or die("cannot select DB. Please contact us"))
{
$sqli = "SELECT LMAIL from login";
if ($ergebnis = mysqli_query($dbi, $sqli))
{
echo "<ul>";
while ($zeile = mysqli_fetch_assoc($ergebnis))
{
echo "<li>" . htmlspecialchars($zeile["LMAIL"]) . "</li>";
}
echo "</ul>";
mysqli_close($dbi);
}

echo "Vielen Dank. Sie erhalten in Kürze eine Email.<br>";
echo "$MAIL";//<br>$_POST['PWORD1']<br>$_POST['PWORD2']";


Nur mit diesen Stümmelfragmenten kann ich nichts anfangen. Dir muss doch eines klar sein: es liegt NICHT daran, dass bei Dir grundsätzlich mysqli nicht freigeschaltet ist, php.ini und phpinfo() berichten das Gegenteil und auch phpmyadmin läuft. Also müssen wir woanders nach der Ursache suchen, aber in Stümmelfragmenten kann man nicht suchen. Das ist schlicht Müll und insbesondere gehst Du von der total falschen Voraussetzung aus, dass einfach mysqli nicht läuft. Irgendetwas anderes muss es sein, keine Ahnung, ob wir es finden, aber auf diese Weise finde ich zumindest die Ursache ganz sicher NICHT.
Nobbie
 
Posts: 9617
Joined: 09. March 2008 13:04

Re: MYSQLI Probleme

Postby Daywalker4868 » 13. December 2016 22:35

Hi,

sry. Hast natürlich Recht. Habe zu wenig geschlafen die letzten beiden Tage :D

Code: Select all
<?php

$hosti = "localhost";
$nutzi = "root";
$passwi = "";
$dbi = "blabla";

if ($db = mysql_connect("$hosti", "$nutzi", "$passwi") or die("cannot select DB. Please contact us"))
{
  $sqli = "SELECT LMAIL from login";
  if ($ergebnis = mysql_query($sqli, $db))
    {
    echo "<ul>";
    while ($zeile = mysql_fetch_assoc($ergebnis))
      {
      echo "<li>" . htmlspecialchars($zeile["LMAIL"])  . "</li>";
      }
    echo "</ul>";
    mysql_close($db);
    }
  }

?>


Danke und Gruss

Thorsten
Daywalker4868
 
Posts: 10
Joined: 11. December 2016 18:38
XAMPP version: 7.0.9
Operating System: Windows 10

Re: MYSQLI Probleme

Postby Altrea » 14. December 2016 06:51

Also verwendest du garnicht die mysqli_ Funktionen, sondern die veralteten und inzwischen entfernten mysql_ Funktionen!?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8883
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MYSQLI Probleme

Postby Nobbie » 14. December 2016 11:41

Genau das habe ich mir gedacht.... wie kommt man eigentlich auf die Idee, auch noch die Fehlermeldung zu verfälschen und mit gefälschter Fehlermeldung hier im Forum zu fragen? Das ist wirklich unfassbar.

Der Hammer ist auch noch, selbst wenn man die gefälschte Fehlermeldung in Google eingibt, schlägt Google die RICHTIGE(!) Fehlermeldung vor (nämlich mysql_connect() and Stelle von mysqli_connect()) und verlinkt anschließend jede Menge Treffer, wo die Ursache auch gleich geklärt wird. Das ist echt unglaublich, was Du da für einen vorsätzlichen(!) Megamist baust. Warum????
Nobbie
 
Posts: 9617
Joined: 09. March 2008 13:04

Re: MYSQLI Probleme

Postby Daywalker4868 » 14. December 2016 12:29

Hi,
kein Grund so patzig zu werden. Das liegt daran, dass ich den Code verändert hatte um zu schauen, ob es mit der alten Version geht.
Die Fehlermeldung kommt von diesem Code:

Code: Select all
<?php

$hosti = "localhost";
$nutzi = "root";
$passwi = "";
$dbi = "blabla";

if ($db = mysqli_connect("$hosti", "$nutzi", "$passwi") or die("cannot select DB. Please contact us"))
{
  $sqli = "SELECT LMAIL from login";
  if ($ergebnis = mysqli_query($db, $sqli))
    {
    echo "<ul>";
    while ($zeile = mysqli_fetch_assoc($ergebnis))
      {
      echo "<li>" . htmlspecialchars($zeile["LMAIL"])  . "</li>";
      }
    echo "</ul>";
    mysqli_close($db);
    }
  }

?>
Daywalker4868
 
Posts: 10
Joined: 11. December 2016 18:38
XAMPP version: 7.0.9
Operating System: Windows 10

Re: MYSQLI Probleme

Postby Nobbie » 14. December 2016 13:41

Glaube ich kein Wort. Du hast irgendwo den Überblick verloren (wollen wir mal gütlich annehmen) und dann gibt es auch noch tatsächlich die Version, wo mysql_connect() aufgerufen wird. Ich wüßte nicht, wie man den Fehler produzieren kann mit mysqli, denn das ist installiert und das wird von phpmyadmin benutzt. Und es ist bekannt, dass in PHP7 die mysql_xxxx Funktionen entfernt wurden. In Google findet man keinen einzigen Treffer, wenn man nach mysqli_connect() sucht. Es fällt außerdem auf, dass die Fehlermeldung nicht per copy&paste hier eingefügt wurde, sondern sie wurde editiert:

Code: Select all
Fatal error: Uncaught Error: Call to undefined function  mysqli_connect() in C:\xampp\htdocs\Psycho\test.php:7 Stack trace: #0 {main} thrown in C:\xampp\htdocs\Psycho\test.php on line 7


Zwischen "funcion" und "mysqli_connect()" befinden sich zwei Leerstellen anstelle nur einer Leerstelle, das macht PHP nicht, das ist händisch gemacht worden. Für mich ist das Thema erledigt.

P.S.: Ich habe mir noch die Mühe gemacht und auf beiden installierten Xampp Versionen bei mir das Script installiert - mit mysqli_connect() läuft es durch (allerdings bekomme ich natürlich einen anderen Fehler, dass "blabla" nicht bekannt ist, aber das ist logisch). Und mit mysql_connect() bekomme ich die erwartete Fehlermeldung, dass die Funktion nicht existiert.

P.P.S.: Bei der Gelegenheit fällt mir auf, dass Du uns jetzt schon die 3.(!!) verschiedene Version des Scripts zeigst, im ersten Anlauf steht nämlich:

Code: Select all
if ($db = mysqli_connect("$hosti", "$nutzi", "$passwi", "$dbi") or die("cannot select DB. Please contact us"))


und um letzten Anlauf steht:

Code: Select all
if ($db = mysqli_connect("$hosti", "$nutzi", "$passwi") or die("cannot select DB. Please contact us"))


Und zwischendurch steht auch mal so etwas dort:

Code: Select all
if ($db = mysql_connect("$hosti", "$nutzi", "$passwi") or die("cannot select DB. Please contact us"))


Wenn das kein Grund ist, "patzig" zu werden, dann weiß ich es nicht. Veräppeln kann ich mich jedenfalls auch selbst.
Nobbie
 
Posts: 9617
Joined: 09. March 2008 13:04

Re: MYSQLI Probleme

Postby Daywalker4868 » 14. December 2016 13:57

SAg mal Nobbie,
hast du schlecht geschlafen oder so?
Warum sollte ich nach einen Fehler suchen lassen, den es nicht gibt? Ich bin schon seit 2 Wochen auf der Suche nach der Lösung und habe schon in anderen Foren gepostet. Bis jetzt konnte mir niemand helfen.
Ich muss mich aber von dir nicht blöde anmachen lassen. An der Fehlermeldung wurde nichts verändert. Das es beim Posten von dem Code einen Fehler gegeben hat, war klar meine Schuld, da ich verschiedene Dinge ausprobiert habe. Passiert denke ich.
Ich bin völlig übernächtigt, da wir 8 Welpen bekommen haben und ich auf die Mutter und die Kleinen aufgepasst habe. Leider kann ich hier den Screenshot vom IE10 nicht einfach hochladen, sondern müsste ihn erst auf den Webserver legen.

Die Fehlermeldung ist echt und wurde nicht verändert. Ich habe das Web durchsucht und leider keine Lösung gefunden. Daher dachte ich mir, dass ihr mir helfen könnt. Scheint aber nicht der Fall zu sein.

Trotzdem danke an die, die versucht haben mir zu helfen.

Gruss
Thorsten
Daywalker4868
 
Posts: 10
Joined: 11. December 2016 18:38
XAMPP version: 7.0.9
Operating System: Windows 10

Re: MYSQLI Probleme

Postby Daywalker4868 » 14. December 2016 14:32

Auch nach der Neuinstallation von XAMPP besteht das Problem weiterhin :cry: :cry: :cry:
Daywalker4868
 
Posts: 10
Joined: 11. December 2016 18:38
XAMPP version: 7.0.9
Operating System: Windows 10

Next

Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 17 guests