ReVeR Posted December 21, 2006 Share Posted December 21, 2006 Hello.I just updated all of my soft due to a reformat, and i installaed apache, then php which configured itself. That ran fine. I started to installa mysql, worked fine up until i try to use mysql_connect(). At which point there is no error, but the page refuses to load at all. If i comment out that line it works fine once more. I installed MySQL and it runs fine on the side. I uncommented the extensions dir in php, and uncomment the mysql extensions. I configured the right port in php.ini . I copied the library from MySQl to windows folder and PHP folder. Any ideas what i am missing?php.ini[code]extension_dir = "C:\Program Files\PHP\ext\"extension=php_mysql.dll[MySQL]; Allow or prevent persistent links.mysql.allow_persistent = On; Maximum number of persistent links. -1 means no limit.mysql.max_persistent = -1; Maximum number of links (persistent + non-persistent). -1 means no limit.mysql.max_links = -1; Default port number for mysql_connect(). If unset, mysql_connect() will use; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the; compile-time value defined MYSQL_PORT (in that order). Win32 will only look; at MYSQL_PORT.mysql.default_port = 3306; Default socket name for local MySQL connects. If empty, uses the built-in; MySQL defaults.mysql.default_socket =; Default host for mysql_connect() (doesn't apply in safe mode).mysql.default_host = localhost; Default user for mysql_connect() (doesn't apply in safe mode).mysql.default_user = ; Default password for mysql_connect() (doesn't apply in safe mode).; Note that this is generally a *bad* idea to store passwords in this file.; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password"); and reveal this password! And of course, any users with read access to this; file will be able to reveal the password as well.mysql.default_password =; Maximum time (in secondes) for connect timeout. -1 means no limitmysql.connect_timeout = 60; Trace mode. When trace_mode is active (=On), warnings for table/index scans and; SQL-Errors will be displayed.mysql.trace_mode = Off[/code][EDIT[Note here is a piece of simplified code that i tried:[code]<?phpinclude 'conf/conf.php';echo 'test';$link = mysql_connect('localhost:3306', 'root', 'passhere');if(!$link){ die("Couldn't connect: ".mysql_error());}?>[/code]I get the test output adn after that nothing even thoug i have a page to display afterwardsThanks in advance. Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted December 22, 2006 Share Posted December 22, 2006 If you used the installer then download the zip binaries instead and extract the contents of the zip to your PHP installation folder overwriting all existing files/folders. The installer doesnt include all files. Whereas the zip binaries do.Also do not copy the mysql library from the MySQL folder, but libmysql.dll from the php folder.Also make sure you restart the server too when you move the files/changes. Quote Link to comment 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.