Page 1 of 1

mysql not showing up in phpinfo

Posted: Wed Apr 07, 2010 10:03 am
by monte_201
I'm a first time poster, so hopefully this is in the right location; and I'm a week into learning about php, mysql and apache.
My problem is (and I'm near to ripping my hair out in frustration):

I can't get mysql to show up in phpinfo. I get the 'Fatal error: Call to undefined function mysql_connect() on line (whatever number)' when I try to get php to communicate with mysql.

I've read blog posts from literally dozens of people with this issue, and tutorials/guides/etc, over several days - and I'm getting seriously fried. I need any help if possible.

I followed the Kevin Yank 'build your database' guide to the letter. I downloaded mysql 5.1.45 (and it DOES show up in task manager - and it DOES run from the command prompt). I downloaded php 5.2.13 (as Kevin said) as well as apache 2.2.15.

Apache DOES work (as I know it). I can run the today.php script via my localhost and that works too.

In php-ini (which I made as a copy from php.ini-dist) has been modified to make the loadable modules as extension_dir = "C:\php\php-5.2.13-Win32\ext" (as that's where the dll files are) - I enabled extension=php_mysqli.dll (by taking out the ;) - I also set the httd.conf page to have:
<IfModule dir_module>
DirectoryIndex index.html index.php
</IfModule>
LoadModule php5_module

"C:/PHP/php-5.2.13-Win32/php5apache2_2.dll"
AddType application/x-httpd-php .php
PHPIniDir "C:/php/php-5.2.13-Win32/ext"

..but no mysql to php communication...I've uninstalled/rebooted the pc/restarted apache after every sneeze...I need some expert help here guys...

Oh, one thing I should add is that in phpinfo - it says my Configuration File (php.ini) Path is in C:\Windows?? - but I don't have php.ini in there - at all - it's in the C:\php\php-5.2.13-Win32 directory. No matter what I do (copying and pasting php.ini to the windows director, for example) it doesn't change or update phpinfo at all.

Re: mysql not showing up in phpinfo

Posted: Wed Apr 07, 2010 4:41 pm
by Doug G
You can just copy your php.ini into c:\windows, an easier solution than building a new php executable from source.

For your mysql problem, you say you enabled mysqli, and that's different from the older php-mysql. Look for both mysql connection extensions, you can have them both enabled.

Re: mysql not showing up in phpinfo

Posted: Wed Apr 07, 2010 9:47 pm
by mikosiko
be sure that you add C:\php\php-5.2.13-Win32 to your windows PATH (I prefer this instead of copy php.ini under windows)... after that restart and check again to see if phpinfo() show the right php.ini

also if my memory doesn't fail you need include the directive
extension_dir ="C:/php/php-5.2.13-Win32/ext"

otherwise your extensions are not going to work

MIko