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