Connection error

aphros

I have developed a small application that uses web pages to display data from a mySQL database. The app was developed in Dreamweaver, and I have copied the folder from the development machine onto the machine that is to run it.

I've installed IIS, PHP, mySQL, setup the database and tested that it is working. However, when I try to run the app, I get an error:

Fatal error: Call to undefined function mysql_pconnect() in c:\Inetpub\wwwroot\booksearch\Connection\connBkSearch.php on line 9.

connBkSearch.php is a standard Dreamweaver-generated connection script. The details of username, password, database, etc.are correct.

What's going wrong? OS is XP Pro.

Any guidance appreciated.

Regards,

Brendan

Bunkermaster

why are you using persistant connection?
if you don't know why (could be evil DW going freestyle again sighs) use [MAN]mysql_connect[/MAN]

aphros

Thanks for the feedback, BM. I imagine the persistent connection is the default used by DW. It works fine on my local laptop and also on a site developed using a similar search engine and database. I tried your suggection but I still get the error.

I thought mysql_connect and pconnect were built in functions. Why are they coming up as undefined?

Bunkermaster

mysql_pconnect was introduced in PHP 3 i doubt it was removed in latest releases so you might encounter an OS limitation or a limited build issue (remove some functions support).
You can add a if ( function_exists( mysql_pconnect ) ) in your code but you should really use the vanilla mysql_connect if you dont want your connection persistant.

aphros

Okay, I've tried that and it still doesn't work. I can connect via ODBC using Access, so I know the database is active and functioning. Other PHP pages render correctly, (though these don't require a database connection) so I'm sure that the PHP installation went okay. It's just this 'undefined function' business that's bothering me. Where is this function defined? Am I missing a dll, or have I a problem with path mapping?

This is driving me nuts!

aphros

Okay, problem solved. I had used the Windows installer version of PHP which doesn't include the php_mysql.dll required.

All now working as it should.

Thanks!

Brendan

junbagares

Hi Brendan,

Just want to know where you get php_mysql.dll and where to put such file so that mysql_pconnect() would not be a problem anymore.

Thanks,
Jun

aphros

Jun,

Download the Zip version of PHP from http://www.php.net/downloads.php and you get the full version, along with a folder called 'ext'. This contains php_mysql.dll along with many others.

You have to make sure that this file is somewhere that is accessible through your 'path' statement, either by copying it to Windows/system32 or adding php/ext to your search path. You then need to edit your php.ini file, removing the ';' before the line 'extensions=php_mysql.dll' in the Dynamic Extensions section.

Save php.ini, restart, then all should be okay.

Hope this helps.

Regards,

Brendan

junbagares

Hi,

As you instructed I did the following:

Downloaded the zip version of PHP5
I had copy php_mysql.dll to c:\php\ext
I had modified the environment variable to include ";c:\php\ext" in the "Path" variable
I actually restarted the machine.

And after running the program I still encountered a error message, this time its:

PHP Startup: Unable to load dynamic library 'c:\php\ext\php_mysql.dll" - The specified procedure could not be found.

Hope for your help.

-Jun

junbagares

I also had uncommented 'extensions=php_mysql.dll' by removing the ; preceeding it.

-Jun

aphros

Jun,

The way you have done it works for me. From the error message you are getting, it appears that php can't find the dll in the 'ext' folder. Check that the path statement is working, or copy the dll to \Windows\system32, then reboot.

Also, check the 'Paths and Directories' section of php.ini. You may need to add the path to the 'extension_dir' variable.

If that doesn't work, I'm afraid I'm out of ideas.

Regards,

Brendan

tsinka

Hi,

first of all you need to make sure that you download the zip file that matches the installed PHP version.

Additionally, you need to copy libmysql.dll that comes with the zip file to the system32 directory and you need to change the extension_dir variable in php.ini so that it points to the extension dir.

It shouldn't be neccessary to add the ext directory to any environment variables if php.ini is set up correctly and libmysql.dll exists in system32.

Thomas