php与mysql的连接，怎么回事

郁闷阿，为什么我的php和mysql连接不上啊？
我按照网络上php和mysql连接的文章提示，一步一步做下来，但是测试php和mysql连接的页面一直没反应，不显示error或者ok，我都不知道为什么！

主要步骤是：
1、在PHP.ini文件中引用了mysql的dll，具体如下
;extension=php_bz2.dll
;extension=php_curl.dll
extension=php_dba.dll
extension=php_dbase.dll
extension=php_exif.dll
extension=php_fdf.dll
extension=php_gd2.dll
extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_ifx.dll
extension=php_imap.dll
extension=php_interbase.dll
extension=php_ldap.dll
extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
extension=php_mime_magic.dll
extension=php_ming.dll
extension=php_msql.dll
extension=php_mssql.dll
extension=php_mysql.dll
;extension=php_mysqli.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_pdo.dll
;extension=php_pdo_firebird.dll
;extension=php_pdo_mssql.dll
extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_oci8.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
;extension=php_pspell.dll
extension=php_shmop.dll
extension=php_snmp.dll
;extension=php_soap.dll
extension=php_sockets.dll
;extension=php_sqlite.dll
;extension=php_sybase_ct.dll
extension=php_tidy.dll
extension=php_xmlrpc.dll
extension=php_xsl.dll
;extension=php_zip.dll

另外我写了测试连接的页面
<?php
$link=MySQL_connect('localhost','root','123456');
if(!$link) echo "Error !";
else echo "Ok!";
MySQL_close();
?>

但是打开普通页面正常，就是打开这个测试页面后为一片空白，是不是还需要设置其他我不知道的地方啊！

24 个解决方案

#1

试试这个吧
<?php
$link=mysql_connect('localhost','root','123456');
if(!$link)
{
echo "Error !";
}
else
{
echo "Ok!";
}
?>

#2

还是不行，估计是配置的问题. 我分别测试php和mysql都是没有问题的，就是两者连接不行〉。。。

#3

不应有空白？

用phpinfo();
看配置mysql是否正确加载
第二看一下mysql_connect函数是否可用

#4

phpinfo的信息如下，怎么查看呢，偶是PHP的新手

PHP Version 5.2.3

System  Windows NT ZJU-LYD 5.1 build 2600
Build Date  May 31 2007 09:36:39
Configure Command  cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared"
Server API  Apache 2.0 Handler
Virtual Directory Support  enabled
Configuration File (php.ini) Path  C:\WINDOWS
Loaded Configuration File  E:\PHP\php.ini
PHP API  20041225
PHP Extension  20060613
Zend Extension  220060519
Debug Build  no
Thread Safety  enabled
Zend Memory Manager  enabled
IPv6 Support  enabled
Registered PHP Streams  php, file, data, http, ftp, compress.zlib
Registered Stream Socket Transports  tcp, udp
Registered Stream Filters  convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.*

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies

--------------------------------------------------------------------------------

PHP Credits

--------------------------------------------------------------------------------

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference Off Off
allow_url_fopen On On
allow_url_include Off Off
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors Off Off
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 6143 6143
expose_php On On
extension_dir ./ ./
file_uploads On On
highlight.bg #FFFFFF #FFFFFF
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:\php5\pear .;C:\php5\pear
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 30 30
max_input_nesting_level 64 64
max_input_time 60 60
memory_limit 128M 128M
open_basedir no value no value
output_buffering 4096 4096
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
register_globals Off Off
register_long_arrays Off Off
report_memleaks On On
report_zend_debug On On
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path no value no value
serialize_precision 100 100
short_open_tag Off Off
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir C:\DOCUME~1\李益大\LOCALS~1\Temp\php\upload C:\DOCUME~1\李益大\LOCALS~1\Temp\php\upload
user_dir no value no value
variables_order GPCS GPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off

apache2handler
Apache Version  Apache/2.2.4 (Win32) PHP/5.2.3
Apache API Version  20051115
Server Administrator  hellbird0923@163.com
Hostname:Port  www.hellbird.com:8080
Max Requests  Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts  Connection: 300 - Keep-Alive: 5
Virtual Server  No
Server Root  E:/Apache2.2
Loaded Modules  core mod_win32 mpm_winnt http_core mod_so mod_actions mod_alias mod_asis mod_auth_basic mod_authn_default mod_authn_file mod_authz_default mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dir mod_env mod_imagemap mod_include mod_isapi mod_log_config mod_mime mod_negotiation mod_setenvif mod_userdir mod_php5

Directive Local Value Master Value
engine 1 1
last_modified 0 0
xbithack 0 0

Apache Environment
Variable Value
HTTP_ACCEPT  */*
HTTP_ACCEPT_LANGUAGE  zh-cn
HTTP_ACCEPT_ENCODING  gzip, deflate
HTTP_USER_AGENT  Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)
HTTP_HOST  127.0.0.1:8080
HTTP_CONNECTION  Keep-Alive
PATH  E:\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;E:\MySQL\MySQL Server 5.0\bin
SystemRoot  C:\WINDOWS
COMSPEC  C:\WINDOWS\system32\cmd.exe
PATHEXT  .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
WINDIR  C:\WINDOWS
SERVER_SIGNATURE  no value
SERVER_SOFTWARE  Apache/2.2.4 (Win32) PHP/5.2.3
SERVER_NAME  127.0.0.1
SERVER_ADDR  127.0.0.1
SERVER_PORT  8080
REMOTE_ADDR  127.0.0.1
DOCUMENT_ROOT  E:/Apache2.2/htdocs
SERVER_ADMIN  hellbird0923@163.com
SCRIPT_FILENAME  E:/Apache2.2/htdocs/testdb.php
REMOTE_PORT  1669
GATEWAY_INTERFACE  CGI/1.1
SERVER_PROTOCOL  HTTP/1.1
REQUEST_METHOD  GET
QUERY_STRING  no value
REQUEST_URI  /testdb.php
SCRIPT_NAME  /testdb.php

HTTP Headers Information
HTTP Request Headers
HTTP Request  GET /testdb.php HTTP/1.1
Accept  */*
Accept-Language  zh-cn
Accept-Encoding  gzip, deflate
User-Agent  Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)
Host  127.0.0.1:8080
Connection  Keep-Alive
HTTP Response Headers
X-Powered-By  PHP/5.2.3
Keep-Alive  timeout=5, max=100
Connection  Keep-Alive
Transfer-Encoding  chunked
Content-Type  text/html

#5

接上：

bcmath
BCMath support  enabled

calendar
Calendar support  enabled

com_dotnet
COM support enabled
DCOM support disabled
.Net support enabled

Directive Local Value Master Value
com.allow_dcom 0 0
com.autoregister_casesensitive 1 1
com.autoregister_typelib 0 0
com.autoregister_verbose 0 0
com.code_page no value no value
com.typelib_file no value no value

ctype
ctype functions  enabled

date
date/time support  enabled
"Olson" Timezone Database Version  2007.5
Timezone Database  internal
Default timezone  UTC

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 no value no value

dom
DOM/XML  enabled
DOM/XML API Version  20031129
libxml Version  2.6.26
HTML Support  enabled
XPath Support  enabled
XPointer Support  enabled
Schema Support  enabled
RelaxNG Support  enabled

filter
Input Validation and Filtering  enabled
Revision  $Revision: 1.52.2.39 $

Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value

ftp
FTP support  enabled

hash
hash support  enabled
Hashing Engines  md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b 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

iconv
iconv support  enabled
iconv implementation  "libiconv"
iconv library version  1.9

Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1

json
json support  enabled
json version  1.2.1

libxml
libXML support  active
libXML Version  2.6.26
libXML streams  enabled

odbc
ODBC Support enabled
Active Persistent Links  0
Active Links  0
ODBC library  Win32

Directive Local Value Master Value
odbc.allow_persistent On On
odbc.check_persistent On On
odbc.default_db no value no value
odbc.default_pw no value no value
odbc.default_user no value no value
odbc.defaultbinmode return as is return as is
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes
odbc.max_links Unlimited Unlimited
odbc.max_persistent Unlimited Unlimited

pcre
PCRE (Perl Compatible Regular Expressions) Support  enabled
PCRE Library Version  7.0 18-Dec-2006

Reflection
Reflection enabled
Version  $Id: php_reflection.c,v 1.164.2.33.2.39 2007/05/29 08:44:05 helly Exp $

session
Session Support  enabled
Registered save handlers  files user
Registered serializer handlers  php php_binary wddx

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 Off Off
session.bug_compat_warn On On
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.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path C:\DOCUME~1\李益大\LOCALS~1\Temp\php\session C:\DOCUME~1\李益大\LOCALS~1\Temp\php\session
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0

SimpleXML
Simplexml support enabled
Revision  $Revision: 1.151.2.22.2.26 $
Schema support  enabled

SPL
SPL support enabled
Interfaces  Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes  AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException

standard
Regex Library  Bundled library enabled
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.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 60 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
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.6.26

xmlreader
XMLReader  enabled

xmlwriter
XMLWriter  enabled

zlib
ZLib Support  enabled
Stream Wrapper support  compress.zlib://
Stream Filter support  zlib.inflate, zlib.deflate
Compiled Version  1.2.3
Linked Version  1.2.3

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

#6

接上：

Environment
Variable Value
ALLUSERSPROFILE  C:\Documents and Settings\All Users
CommonProgramFiles  C:\Program Files\Common Files
COMPUTERNAME  ZJU-LYD
ComSpec  C:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK  NO
NUMBER_OF_PROCESSORS  2
OS  Windows_NT
Path  E:\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;E:\MySQL\MySQL Server 5.0\bin
PATHEXT  .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PHPRC  E:\PHP\
PROCESSOR_ARCHITECTURE  x86
PROCESSOR_IDENTIFIER  x86 Family 15 Model 4 Stepping 7, GenuineIntel
PROCESSOR_LEVEL  15
PROCESSOR_REVISION  0407
ProgramFiles  C:\Program Files
SystemDrive  C:
SystemRoot  C:\WINDOWS
TEMP  C:\WINDOWS\TEMP
TMP  C:\WINDOWS\TEMP
USERPROFILE  C:\Documents and Settings\LocalService
VS80COMNTOOLS  e:\Microsoft Visual Studio 8\Common7\Tools\
windir  C:\WINDOWS
AP_PARENT_PID  1896

PHP Variables
Variable Value
_SERVER["HTTP_ACCEPT"] */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] zh-cn
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)
_SERVER["HTTP_HOST"] 127.0.0.1:8080
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["PATH"] E:\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;E:\MySQL\MySQL Server 5.0\bin
_SERVER["SystemRoot"] C:\WINDOWS
_SERVER["COMSPEC"] C:\WINDOWS\system32\cmd.exe
_SERVER["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
_SERVER["WINDIR"] C:\WINDOWS
_SERVER["SERVER_SIGNATURE"] no value
_SERVER["SERVER_SOFTWARE"] Apache/2.2.4 (Win32) PHP/5.2.3
_SERVER["SERVER_NAME"] 127.0.0.1
_SERVER["SERVER_ADDR"] 127.0.0.1
_SERVER["SERVER_PORT"] 8080
_SERVER["REMOTE_ADDR"] 127.0.0.1
_SERVER["DOCUMENT_ROOT"] E:/Apache2.2/htdocs
_SERVER["SERVER_ADMIN"] hellbird0923@163.com
_SERVER["SCRIPT_FILENAME"] E:/Apache2.2/htdocs/testdb.php
_SERVER["REMOTE_PORT"] 1669
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /testdb.php
_SERVER["SCRIPT_NAME"] /testdb.php
_SERVER["PHP_SELF"] /testdb.php
_SERVER["REQUEST_TIME"] 1180847008

#7

是服务器配置有问题，在php.ini中修改，并且不要忘记拷贝相应的文件到系统目录下

#8

是服务器配置有问题，在php.ini中修改，并且不要忘记拷贝相应的文件到系统目录下

按理说我去掉；的那些项的dll文件都是在path中设定好了
;extension=php_bz2.dll
;extension=php_curl.dll
extension=php_dba.dll
extension=php_dbase.dll
extension=php_exif.dll
extension=php_fdf.dll
extension=php_gd2.dll
extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_ifx.dll
extension=php_imap.dll
extension=php_interbase.dll
extension=php_ldap.dll
extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
extension=php_mime_magic.dll
extension=php_ming.dll
extension=php_msql.dll
extension=php_mssql.dll
extension=php_mysql.dll
;extension=php_mysqli.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_pdo.dll
;extension=php_pdo_firebird.dll
;extension=php_pdo_mssql.dll
extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_oci8.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
;extension=php_pspell.dll
extension=php_shmop.dll
extension=php_snmp.dll
;extension=php_soap.dll
extension=php_sockets.dll
;extension=php_sqlite.dll
;extension=php_sybase_ct.dll
extension=php_tidy.dll
extension=php_xmlrpc.dll
extension=php_xsl.dll
;extension=php_zip.dll

不知道还需要copy什么dll文件到系统目录下，能详细一点吗？

#9

mysql_connect($host,$user,$pwd) or die("CONNECT-ERROR:".mysql_error());

看看错误提示是什么

#10

最前面加一句
error_reporting(2039);

#11

你的phpinfo里有没如下字样:
mysql
MySQL Support enabled
Active Persistent Links  0
Active Links  0
Client API version  5.0.27

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

如果没的话说明你的php不认mysql

另:extension=php_mysql.dll不是去了";"号就可以了
你检查一下php5的ext目录下有没有php_mysql.dll文件.

都有了后重新启动一下电脑

#12

建议你安装appserv打包好的程序

#13

估计是因为找不到
php_mysql.dll

察看extension目录下有没有对应文件

#14

先把 display_error 改为 on
然后再看出错信息

#15

另外函数名大小写要注意，MySQL_connect
现在可以用，将来就有问题了

#16

在安装的时候有一步选择需要安装的内容，在那一步选择对mysql的支持就可以了，不用自己配置。

#17

关键是没有报错,问题比较麻烦!
php 目录下有个 libmysql.dll 要复制到system32目录下的!
LZ做了没有?
LZ看看以上方法行不行

#18

楼上的老兄,php的函数和c不一样.函数名不区分大小写.ABS()和abs()是一样的

#19

没有加载MYSQL库，怎么连接？

#20

汗，。。。。。我第一次听说php的函数名区分大小写。。。。

#21

extension_dir ./ ./

在你的php.ini中找到extension_dir，将它的地址设置成你php路径下的ext文件夹，如：extension_dir = c":/php/ext"，然后重新启动apache

#22

建议，弄个按安装包，什么都有，自动配置好。

#23

ok了，主要是在安装的时候没选择php_mysql.dll。谢谢各位了

#24

如果还有问题，请查看一下php.ini里面的
disable_functions =
是不是把某些应该有的函数给禁用了。
我当初就是在搭建discuz的时候根据说明书来的，加了下面一行
disable_functions = phpinfo,passthru,exec,system,chroot,scandir,chgrp,chown,shell_exec,proc_open,proc_get_status,ini_alter,ini_alter,ini_restore,dl,pfsockopen,openlog,syslog,readlink,symlink,popepassthru,stream_socket_server
结果其它配置完全正确，却出现了相同的问题。当然是屏蔽哪个函数产生的问题我就没有具体去尝试了。

#1