mysql not showing up in phpinfo
Posted: Wed Apr 07, 2010 10:03 am
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.
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
<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.