PHP database connection error

Question

0.00/5 (No votes)

See more:

Hi all,

I have a quite annoying error with php, mysql. I've configured all the stuff properly and phpinfo() list all the stuff properly. I wrote a simple PHP page and check, works fine.

Then I want to configure MySql. Enable all the extension on the php.ini and try to view the following page.

PHP

<?php
	$con = mysql_connect("localhost", "root", "sa");
	if (!$con) {
		die('Could not connect: ' . mysql_error());
	}
	else {
		echo 'Connected successfully';
	}
?>

But it didn't work. I check the appache error log and found the following.

PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\php\\ext\\php_mysqli.dll' - The specified procedure could not be found.\r\n in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\php\\ext\\php_pdo_firebird.dll' - The specified module could not be found.\r\n in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\php\\ext\\php_pdo_mssql.dll' - The specified module could not be found.\r\n in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\php\\ext\\php_pdo_oci.dll' - The specified module could not be found.\r\n in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\php\\ext\\php_pdo_oci8.dll' - The specified module could not be found.\r\n in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\php\\ext\\php_pdo_pgsql.dll' - The specified module could not be found.\r\n in Unknown on line 0

All the extension are in correct path too. Somehow it didn't work. Is anyone of you have a solution for this...

Posted 21-May-12 20:08pm

CodingLover

Add a Solution

Comments

Mohibur Rashid 22-May-12 2:38am

I am interested about the error that you received on die

CodingLover 22-May-12 3:06am

Nothing printed actually. It simply timed-out.

Mohibur Rashid 22-May-12 5:14am

simply run this statement and see what does it do,

$con = mysql_connect("localhost", "root", "sa") or die("Connection failed");

CodingLover 22-May-12 5:58am

Same thing I have done above. But it is nothing worked, its timed-out. Seems this is something to do with configurations, I am using Win7 64bit

Mohibur Rashid 22-May-12 18:51pm

DID YOU TRY TO CONNECT WITH PHPMYADMIN

CodingLover 23-May-12 0:42am

Yeah, I tried with MyAdmin. On the login page I can see the following error message.

"The mysqli extension is missing. Please check your PHP configuration. "

CodingLover 23-May-12 0:43am

I have already enabled the mysqli dll.

Mohibur Rashid 23-May-12 1:56am

in this case open php.ini and check mysqli setup and also make sure php_mysqli.dll exists. and also make sure extension_dir is set in a proper manner. as example in my development machine it is set like below:
extension_dir = "C:\Program Files\EasyPHP-5.3.9\php\php539x120411100249\ext\"

CodingLover 23-May-12 2:33am

I re-check the ini file.

1. extension_dir specified properly --> extension_dir = C:\php\ext
2. php_mysqli.dll extension also enabled --> extension=php_mysqli.dll
3. mysqli setup is as follows

; Maximum number of persistent links. -1 means no limit.
; http://php.net/mysqli.max-persistent
mysqli.max_persistent = -1

; Allow accessing, from PHP's perspective, local files with LOAD DATA statements
; http://php.net/mysqli.allow_local_infile
;mysqli.allow_local_infile = On

; Allow or prevent persistent links.
; http://php.net/mysqli.allow-persistent
mysqli.allow_persistent = On

; Maximum number of links. -1 means no limit.
mysqli.max_links = -1

; If mysqlnd is used: Number of cache slots for the internal result set cache
; http://php.net/mysqli.cache_size
mysqli.cache_size = 2000

; Default port number for mysqli_connect(). If unset, mysqli_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.
mysqli.default_port = 3306

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysqli.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysqli.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysqli.default_user =

; Default password for mysqli_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("mysqli.default_pw")
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
mysqli.default_pw =

; Allow or prevent reconnect
mysqli.reconnect = Off

Mohibur Rashid 23-May-12 3:53am

I am really really confused. don't know what to say.

CodingLover 23-May-12 4:10am

Same here too mate. I have exactly the same setup on a different machine working fine. Only different is the OS configuration, 32bit and 64bit

Mohibur Rashid 23-May-12 4:35am

is your php 64 bit? I never used a 64 bit machine, so i have no idea if you need a 64 bit php with 64 bit dlls

CodingLover 23-May-12 4:53am

PHP specifically don't have 64bit build. However VC9 solve my problem. I configured VC9 Thread Safe version and works fine. :)

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)