[RESOLVED] Call to undefined function, can't conect to DB (mySQL) white screen...

hedgehead

Hi, I've been trying to configure Apache with MySQL and PHP. The specs are:
Apache 2.2.4 (win32)
PHP 5.2.2-dev

When testing if PHP is working using phpinfo(); it seems to be working.

I've copied libmysql.dll to my Windows folder, System folder and System32 folder.

Initially I would simply get a white screen when testing any php code.

When I turned on the error display from my php.ini, I got the error: call to undefined function mysql connect().

I've commented out the ; in my php.ini for extension=php_mysql.dll

I am new to most of this, especially the set-up of these programs.

Any help or suggestions you could give me would be greatly appreciated. Thanks!

stolzyboy

are you restarting apache after making config changes?

bradgrafelman

Copying files to system folders has been deprecated for some time now and should never be done.
In Apache's httpd.conf file, have you added a PHPIniDir directive to set the location of your php.ini file?
In your php.ini file, have you properly set the location of the "extension_dir" to the 'extensions' directory (e.g. mine is c:\php\extensions).
If you visit the extensions directory mentioned above, do you see php_mysql.dll in there?
In the directory you installed PHP (e.g. c:\php) do you have a 'dlls' folder? Part of the instructions in the manual ([man]install.windows.manual[/man]) say to copy all of those DLL files to the root of the PHP installation folder (e.g. files from c:\php\dlls\ go to c:\php).
If you've done step 5, have you added the PHP directory to your system's PATH environment variable? If not, instructions for doing so can be found here.

hedgehead

Hey, thanks for your help. I don't actually have a dll folder in my c:/php folder.

I actually followed the instructions from here:
http://www.ricocheting.com/server/php.html
for apache, php and finally mysql except for the part suggesting to move dlls to the windows / system folders, as you suggested otherwise.

phpinfo function works well, would it help at all if i posted my apache httpd config or php.ini file?

My extensions dir is set also, in the php.ini as
extensions_dir="C:\php\ext"

After each change I have restarted the apache server, but still no luck...

So far, I havent moved any dlls from their original places since the initial extraction of php to c:\php and installation of apache.

I have enabled mysql, but not mysqli, could this be the problem?
extension=php_mysql.dll
;extension=php_mysqli.dll

Additionally ni my php.ini I have

extensions_dir="C:\php\ext"

Thanks again

bradgrafelman

Woops, nevermind about the dlls folder - forgot you were installing PHP5.

Did you add the C:\php\ to your system's PATH variable as described in point #6 of my post above?

Also, have you enabled "display_startup_errors" to see if any errors pop up?

Houdini

Most likely you are not editing the active php.ini PHP 5.0 disables MySQL and instead uses MySQLi. I also believe that with PHP 5 there is both an ext and an extensions folder (at least with my PHP 5 there is).

Always restart Apache after editing the php.ini so PHP can see the changes then do a php.info but if nothing changes after you have edited what you believe is the active php.ini then you are editing the wrong file or telling PHP to look for it in the wrong place.

hedgehead

Hey thanks for all your replies. I had done the system variables procedure you mentioned, but left out the ; before the location of my php directory.
Though, still the same problem, however when I turned on display_startup_errors, I get an error

PHP Startup: Unable to load dynamic library 'C:\php\ext\php_mysql.dll' - the specified module could not be found.

I found the quite confusing considering I went to that directory and the file is indeed there. All files names / folders are matching.

Additionally, I checked and my php ini is the correct one being read, when I do phpinfo() I get
Configuration File (php.ini) Path C:\php\php.ini

So basically I'm unsure why it cannot find a file that is really there.

Thanks again for your helpful replies.

After browsing the net for this problem, I came across a forum suggesting a fix, this goes against what is stated in this forum, so I thought I might check what your opinion was. It states:

"Ok, sorted @ last. Turned out I needed to use an older version of libmysql.dll (the one that bundles with php) and not the one that came with mysql.

For those who need to know... php_mysql.dll -> c:\WINDOWS, libmysql.dll -> c:\WINDOWS\system32, libmysql should be the one that came in the php zip/installer."

Sorry to add to this and make things more complicated, but I just wanted to give all the details. Some people say to list your extensions directory, others say to list your extension directory.

I initially had
extension_dir = "C:\php\ext"

though I tried changing it to

extensions_dir = "C:\php\ext"

This then gave me a interesting error that may be the clue in how to solve this. When attempting to restard apache I get "C:\php5\php_mysql.dll" - the specified module could not be found.

Strangely enough I havent listed my php folder to be php5 anywhere or in any config files.

Hope this helps a bit....?

Houdini

Great then I suppose that your problem is now resolved...so look at my signature to see how to mark it resolved.

hedgehead

Umm, still no luck though, I edited the post above

Houdini

Well alrighty then just click the last link in my signature and then download and install XAMPP for Windows then check your php.ini which by default will be installed into C:\Program Files\xampp\apache\bin. This is an no fail install then all you need to do is tweak php.ini in the above noted location to suit your fancy.

I believe that XAMPP comes with MySQL and MySQLi both enabled, but I can not remember.

hedgehead

Thanks very much for your help, the problem lay in the Environmental Variables section of Advanced (My Computer)!!

Much appreciated🙂 🙂 🙂 🙂