alokp99 Posted June 29, 2008 Share Posted June 29, 2008 Hi, I am using php5.2.3 with iis and mysql5.0 on win xp.I downloaded installed php,mysql and uncommented php_mysql.dll in the php.ini file which is in windows folder.when i try to run the testmysql connection it just throws up a blank page. does not give me any errors.i cant think of anything.i have used php and mysql before and never faced such a problem.Do you think it has something to do with the norton firewall.I can seem to understand. Thanks, Alok. Quote Link to comment https://forums.phpfreaks.com/topic/112416-php-mysql-connection-problem/ Share on other sites More sharing options...
wildteen88 Posted June 29, 2008 Share Posted June 29, 2008 It has nothing to do with your firewall, but with how PHP loads the mysql extensions. In order for the mysql extension to function correctly PHP needs to be able to find an external library called libmysql.dll. This file should be located in the root of the PHP Installation folder. Make sure you have done the following. - Added PHP to the PATH Environment Variable. - Ensured PHP is reading the php.ini you're editing - Setup extension_dir to point to PHP's extension folder Quote Link to comment https://forums.phpfreaks.com/topic/112416-php-mysql-connection-problem/#findComment-577152 Share on other sites More sharing options...
alokp99 Posted June 29, 2008 Author Share Posted June 29, 2008 i added c:\php; to the PATH variable and also edited php.ini to point to the C:\php\ext folder.I copied libmysql.dll to system folder.But still the same result.A blank page.do you think there is some problem with the libmysql.dll file?Should I get another copy of it and try? Quote Link to comment https://forums.phpfreaks.com/topic/112416-php-mysql-connection-problem/#findComment-577572 Share on other sites More sharing options...
alokp99 Posted June 30, 2008 Author Share Posted June 30, 2008 phpinfo output PHP Version 5.2.3 System Windows NT ABC-YZLHGGBXXC1 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 ISAPI Virtual Directory Support enabled Configuration File (php.ini) Path C:\WINDOWS Loaded Configuration File C:\WINDOWS\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 c:\php\ext c:\php\ext 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:\php\pear .;C:\php\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 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 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 Australia/Melbourne 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 ISAPI Server Variable Value CONTENT_LENGTH 0 PATH_TRANSLATED c:\inetpub\wwwroot\phpinfo.php REMOTE_ADDR 127.0.0.1 REMOTE_HOST 127.0.0.1 REQUEST_METHOD GET SERVER_NAME 127.0.0.1 SERVER_PORT 80 SERVER_PROTOCOL HTTP/1.1 SERVER_SOFTWARE Microsoft-IIS/5.1 APPL_MD_PATH /LM/W3SVC/1/ROOT APPL_PHYSICAL_PATH c:\inetpub\wwwroot\ INSTANCE_ID 1 INSTANCE_META_PATH /LM/W3SVC/1 URL /phpinfo.php ALL_HTTP HTTP_ACCEPT:*/* HTTP_ACCEPT_LANGUAGE:en-us HTTP_CONNECTION:Keep-Alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) HTTP_ACCEPT_ENCODING:gzip, deflate HTTPS off SCRIPT_NAME /phpinfo.php SERVER_PORT_SECURE 0 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 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.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 Environment Variable Value ALLUSERSPROFILE C:\Documents and Settings\All Users.WINDOWS CommonProgramFiles C:\Program Files\Common Files COMPUTERNAME ABC-YZLHGGBXXC1 ComSpec C:\WINDOWS\system32\cmd.exe NUMBER_OF_PROCESSORS 1 OS Windows_NT Path C:\php;C:\MySQL\MySQL Server 5.0\bin;c:\ruby\bin;C:\php\pear;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem; PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.RB;.RBW PROCESSOR_ARCHITECTURE x86 PROCESSOR_IDENTIFIER x86 Family 15 Model 2 Stepping 7, GenuineIntel PROCESSOR_LEVEL 15 PROCESSOR_REVISION 0207 ProgramFiles C:\Program Files RUBYOPT -rubygems SystemDrive C: SystemRoot C:\WINDOWS TEMP C:\WINDOWS\TEMP TMP C:\WINDOWS\TEMP USERPROFILE C:\Documents and Settings\Default User.WINDOWS windir C:\WINDOWS PHP Variables Variable Value _SERVER["ALL_HTTP"] HTTP_ACCEPT:*/* HTTP_ACCEPT_LANGUAGE:en-us HTTP_CONNECTION:Keep-Alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) HTTP_ACCEPT_ENCODING:gzip, deflate _SERVER["HTTPS"] off _SERVER["SCRIPT_NAME"] /phpinfo.php _SERVER["HTTP_COOKIE"] no value _SERVER["AUTH_PASSWORD"] no value _SERVER["AUTH_TYPE"] no value _SERVER["AUTH_USER"] no value _SERVER["CONTENT_LENGTH"] 0 _SERVER["CONTENT_TYPE"] no value _SERVER["PATH_TRANSLATED"] c:\inetpub\wwwroot _SERVER["QUERY_STRING"] no value _SERVER["REMOTE_ADDR"] 127.0.0.1 _SERVER["REMOTE_HOST"] 127.0.0.1 _SERVER["REMOTE_USER"] no value _SERVER["REQUEST_METHOD"] GET _SERVER["SERVER_NAME"] 127.0.0.1 _SERVER["SERVER_PORT"] 80 _SERVER["SERVER_PROTOCOL"] HTTP/1.1 _SERVER["SERVER_SOFTWARE"] Microsoft-IIS/5.1 _SERVER["APPL_MD_PATH"] /LM/W3SVC/1/ROOT _SERVER["APPL_PHYSICAL_PATH"] c:\inetpub\wwwroot\ _SERVER["INSTANCE_ID"] 1 _SERVER["INSTANCE_META_PATH"] /LM/W3SVC/1 _SERVER["LOGON_USER"] no value _SERVER["REQUEST_URI"] /phpinfo.php _SERVER["URL"] /phpinfo.php _SERVER["SCRIPT_FILENAME"] c:\inetpub\wwwroot\phpinfo.php _SERVER["ORIG_PATH_INFO"] /phpinfo.php _SERVER["PATH_INFO"] no value _SERVER["ORIG_PATH_TRANSLATED"] c:\inetpub\wwwroot\phpinfo.php _SERVER["DOCUMENT_ROOT"] c:\inetpub\wwwroot _SERVER["PHP_SELF"] /phpinfo.php _SERVER["HTTP_ACCEPT"] */* _SERVER["HTTP_ACCEPT_LANGUAGE"] en-us _SERVER["HTTP_CONNECTION"] Keep-Alive _SERVER["HTTP_HOST"] 127.0.0.1 _SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) _SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate _SERVER["REQUEST_TIME"] 1214810551 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. Quote Link to comment https://forums.phpfreaks.com/topic/112416-php-mysql-connection-problem/#findComment-577915 Share on other sites More sharing options...
PFMaBiSmAd Posted June 30, 2008 Share Posted June 30, 2008 Set display_errors = On in your php.ini and stop and start the web server to get any changes made to php.ini to take effect. When learning php, developing php code, or debugging php code, you need this on anyway. This will both tell you if the php.ini is actually getting loaded (the phpinfo() output states that the one being loaded is where you stated you put yours) and it will hopefully tell you why the code is not working. The blank page is either because of an undefined mysql function call or there could be something like a syntax error in the code. Posting the code you are trying would help also. Quote Link to comment https://forums.phpfreaks.com/topic/112416-php-mysql-connection-problem/#findComment-578173 Share on other sites More sharing options...
alokp99 Posted July 1, 2008 Author Share Posted July 1, 2008 Hi, php is really freaking me out.I did set display_errors=on and it threw an fatal error mysql function not found error.So I checked my php.ini file and found that the php_mysql.dll,php_mysqli.dll were not uncommented.so i removed the ; and then it worked.But when I tried it after a hour or so I am back to square one with no errors being thrown. Why is this happening? Quote Link to comment https://forums.phpfreaks.com/topic/112416-php-mysql-connection-problem/#findComment-578792 Share on other sites More sharing options...
alokp99 Posted July 1, 2008 Author Share Posted July 1, 2008 <?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'hack'; $dbname = 'mystore'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); mysql_select_db($dbname); $query='select * from users'; ?> This the code I am using to connect. Quote Link to comment https://forums.phpfreaks.com/topic/112416-php-mysql-connection-problem/#findComment-578806 Share on other sites More sharing options...
PFMaBiSmAd Posted July 1, 2008 Share Posted July 1, 2008 If that is your whole code, it does not output anything. It connects to the database server, selects a database, makes an assignment to the variable $query, and ends. Quote Link to comment https://forums.phpfreaks.com/topic/112416-php-mysql-connection-problem/#findComment-578819 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.