The MySQL module isn't running or you would see it in your phpinfo. 
Make sure: extension=php_mysql.dll 
doesn't have a semicolon in front of it. Make sure you restart your webserver 
if you make any changes. 
Also in your php.ini file:
include_path .;C:\php5\pear .;C:\php5\pear 
you dont need this twice, I would just put the c:\php5; and thats it.
The MySQL table in the phpinfo would look something like this:
mysql
MySQL Support   enabled 
Active Persistent Links         0       
Active Links    0       
Client API version      4.1.7   

Directive       Local Value     Master Value    
mysql.allow_persistent  On      On      
mysql.connect_timeout   60      60      
mysql.default_host      localhost       localhost       
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     



Hi, 
I have a php_mysql.dll file in my PHP directory at D:\PHP5\ext. I've tried 
copying this to C:\Windows\SYSTEM but this make no difference. There is no 
reference to SQL when running phpinfo() - the output is pasted below. 
As per the documentation, I took php.ini-recommend and copied it into the 
C:\Window directory. I've attached it. My understanding is that mysql is 
already built in and that there's no need to declare mysql as an extension. 
Any ideas?. 
Regards, 
Dave 
PHP Version 5.0.2 
System Windows 9x VENUS 4.90 
Build Date Sep 24 2004 01:24:24 
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\php.ini 
PHP API 20031224 
PHP Extension 20040412 
Zend Extension 220040412 
Debug Build no 
Thread Safety enabled 
IPv6 Support enabled 
Registered PHP Streams php, file, http, ftp, compress.zlib 
Registered Stream Socket Transports tcp, udp 
This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.0.2, Copyright (c) 1998-2004 Zend Technologies

--------------------------------------------------------------------------------
 
PHP Credits 
--------------------------------------------------------------------------------
 
Configuration
PHP Core
Directive Local Value Master Value 
allow_call_time_pass_reference Off Off 
allow_url_fopen On On 
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 d:\Program Files\Apache Group\Apache2\htdocs d:\Program Files\Apache 
Group\Apache2\htdocs 
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 2047 2047 
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_time 60 60 
open_basedir no value no value 
output_buffering 4096 4096 
output_handler no value no value 
post_max_size 8M 8M 
precision 14 14 
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 On On 
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 no value no value 
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.0.52 (Win32) PHP/5.0.2 
Apache API Version 20020903 
Server Administrator [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 
Hostname:Port localdomain:80 
Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100 
Timeouts Connection: 300 - Keep-Alive: 0 
Virtual Server No 
Server Root D:/Program Files/Apache Group/Apache2 
Loaded Modules core mod_win32 mpm_winnt http_core mod_so mod_access mod_actions 
mod_alias mod_asis mod_auth mod_autoindex mod_cgi mod_dir mod_env mod_imap 
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 image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, 
application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, 
application/x-shockwave-flash, */* 
HTTP_ACCEPT_LANGUAGE en-gb 
HTTP_ACCEPT_ENCODING gzip, deflate 
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Win 9x 4.90; 
3330) 
HTTP_HOST localhost 
HTTP_CONNECTION Keep-Alive 
HTTP_COOKIE dtpref_rows="20"; dtpref_cols="100%" 
PATH C:\WINDOWS;C:\WINDOWS\COMMAND 
COMSPEC C:\WINDOWS\COMMAND.COM 
WINDIR C:\WINDOWS 
SERVER_SIGNATURE <address>Apache/2.0.52 (Win32) PHP/5.0.2 Server at localhost 
Port 80</address> 
SERVER_SOFTWARE Apache/2.0.52 (Win32) PHP/5.0.2 
SERVER_NAME localhost 
SERVER_ADDR 127.0.0.1 
SERVER_PORT 80 
REMOTE_ADDR 127.0.0.1 
DOCUMENT_ROOT D:/Program Files/Apache Group/Apache2/htdocs 
SERVER_ADMIN [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 
SCRIPT_FILENAME D:/Program Files/Apache Group/Apache2/htdocs/phpinfo.php 
REMOTE_PORT 1196 
GATEWAY_INTERFACE CGI/1.1 
SERVER_PROTOCOL HTTP/1.1 
REQUEST_METHOD GET 
QUERY_STRING no value 
REQUEST_URI /phpinfo.php 
SCRIPT_NAME /phpinfo.php 

HTTP Headers Information
HTTP Request Headers 
HTTP Request GET /phpinfo.php HTTP/1.1 
Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, 
application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, 
application/x-shockwave-flash, */* 
Accept-Language en-gb 
Accept-Encoding gzip, deflate 
User-Agent Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Win 9x 4.90; 3330) 
Host localhost 
Connection Keep-Alive 
Cookie dtpref_rows="20"; dtpref_cols="100%" 
HTTP Response Headers 
X-Powered-By PHP/5.0.2 
Keep-Alive timeout=15, max=99 
Connection Keep-Alive 
Transfer-Encoding chunked 
Content-Type text/html; charset=ISO-8859-1 

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 

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

ftp
FTP support enabled 

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 

libxml
libXML support active 
libXML Version 2.6.11 
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 4.5 01-December-2003 

session
Session Support enabled 
Registered save handlers files user sqlite 
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_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 no value no value 
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.139.2.4 $ 
Schema support enabled 

SPL
SPL support enabled 
Interfaces RecursiveIterator, SeekableIterator 
Classes ArrayObject, ArrayIterator, CachingIterator, CachingRecursiveIterator, 
DirectoryIterator, FilterIterator, LimitIterator, ParentIterator, 
RecursiveDirectoryIterator, RecursiveIteratorIterator, SimpleXMLIterator 

SQLite
SQLite support enabled 
PECL Module version 2.0-dev $Id: sqlite.c,v 1.146.2.2 2004/08/02 22:43:42 iliaa 
Exp $ 
SQLite Library 2.8.14 
SQLite Encoding iso8859 
Directive Local Value Master Value 
sqlite.assoc_case 0 0 

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 
date.default_latitude 31.7667 31.7667 
date.default_longitude 35.2333 35.2333 
date.sunrise_zenith 90.83 90.83 
date.sunset_zenith 90.83 90.83 
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.11 

zlib
ZLib Support enabled 
Compiled Version 1.1.4 
Linked Version 1.1.4 
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 
COMSPEC C:\WINDOWS\COMMAND.COM 
PATH C:\WINDOWS;C:\WINDOWS\COMMAND 
PROMPT $p$g 
TEMP C:\WINDOWS\TEMP 
TMP C:\WINDOWS\TEMP 
MIDI SYNTH:1 MAP:E MODE:0 
SOUND D:\PROGRA~1\CREATIVE\CTSND 
BLASTER A220 I5 D1 H5 P330 T6 
TVDUMPFLAGS 10 
winbootdir C:\WINDOWS 
windir C:\WINDOWS 
AP_PARENT_PID -3189745 

PHP Variables
Variable Value 
_REQUEST["dtpref_rows"] "20" 
_REQUEST["dtpref_cols"] "100%" 
_COOKIE["dtpref_rows"] "20" 
_COOKIE["dtpref_cols"] "100%" 
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, 
application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, 
application/x-shockwave-flash, */* 
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-gb 
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate 
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Win 
9x 4.90; 3330) 
_SERVER["HTTP_HOST"] localhost 
_SERVER["HTTP_CONNECTION"] Keep-Alive 
_SERVER["HTTP_COOKIE"] dtpref_rows="20"; dtpref_cols="100%" 
_SERVER["PATH"] C:\WINDOWS;C:\WINDOWS\COMMAND 
_SERVER["COMSPEC"] C:\WINDOWS\COMMAND.COM 
_SERVER["WINDIR"] C:\WINDOWS 
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.52 (Win32) PHP/5.0.2 Server at 
localhost Port 80</address> 
_SERVER["SERVER_SOFTWARE"] Apache/2.0.52 (Win32) PHP/5.0.2 
_SERVER["SERVER_NAME"] localhost 
_SERVER["SERVER_ADDR"] 127.0.0.1 
_SERVER["SERVER_PORT"] 80 
_SERVER["REMOTE_ADDR"] 127.0.0.1 
_SERVER["DOCUMENT_ROOT"] D:/Program Files/Apache Group/Apache2/htdocs 
_SERVER["SERVER_ADMIN"] [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 
_SERVER["SCRIPT_FILENAME"] D:/Program Files/Apache 
Group/Apache2/htdocs/phpinfo.php 
_SERVER["REMOTE_PORT"] 1196 
_SERVER["GATEWAY_INTERFACE"] CGI/1.1 
_SERVER["SERVER_PROTOCOL"] HTTP/1.1 
_SERVER["REQUEST_METHOD"] GET 
_SERVER["QUERY_STRING"] no value 
_SERVER["REQUEST_URI"] /phpinfo.php 
_SERVER["SCRIPT_NAME"] /phpinfo.php 
_SERVER["PHP_SELF"] /phpinfo.php 
_ENV["COMSPEC"] C:\WINDOWS\COMMAND.COM 
_ENV["PATH"] C:\WINDOWS;C:\WINDOWS\COMMAND 
_ENV["PROMPT"] $p$g 
_ENV["TEMP"] C:\WINDOWS\TEMP 
_ENV["TMP"] C:\WINDOWS\TEMP 
_ENV["MIDI"] SYNTH:1 MAP:E MODE:0 
_ENV["SOUND"] D:\PROGRA~1\CREATIVE\CTSND 
_ENV["BLASTER"] A220 I5 D1 H5 P330 T6 
_ENV["TVDUMPFLAGS"] 10 
_ENV["winbootdir"] C:\WINDOWS 
_ENV["windir"] C:\WINDOWS 
_ENV["AP_PARENT_PID"] -3189745 

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 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>. 

nohello after 
"David Bo Jensen" <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote in 
message <news:[EMAIL PROTECTED]>...> Where do you have the php_mysql.dll.
> Please send us a copy of the php.ini file.
> How many php.ini files do you have and whats the location of these?
> 
> -- 
> David Bo Jensen
> "List Php Config" <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote in 
> message
> <news:[EMAIL PROTECTED]>...
> Does your phpinfo() show the mysql information? You might not have the mysql
> modules loaded for PHP.
> John
> 
> Hi All,
> I really need some help interfacing PHP5 with a MySQL database. I'm running
> MySQL 4.0.21, Apache 2.0.52 and PHP 5.0.2 on a desktop PC running Windows
> ME. I've followed all the appropriate installation instructions and can get
> the server up and running and executing php files fine. Also, the I can use
> mysql to manipulate the SQL database. My problem is that none of the php
> mysql functions appear to be accessible from my php scripts. For example:
> <?php
> 
> if (function_exists("mysql_connect"))
> echo "yes";
> else
> echo "no";
> ?>
> fails every time. It's like the sql access functions don't exist. I've
> copied libmysql.dll and php5ts.dll into the windows/system directory, made
> various changes to php.ini etc... but nothing.
> What am I doing wrong?.
> Ta,
> Dave
> 
> 
> 
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.9.17 - Release Date: 19/04/2005
> 
> 

Reply via email to