Hi all, I have a script which calls mysql_connect() to connect to a MySQL DB. When I run the script in a browser, it works as expected. However, when I run it from a command line I recieve the error
Call to undefined function mysql_connect()
This seems completely paradoxical. Anyone have any ideas as how I can run it from the command line. Btw, I run it from a bash shell like so:
php /path/to/script.php
While it may be a rudimentary answer, make sure you have the most up to date PHP client, and make sure that it's looking at the same PHP folder that you're working out of through Apache.
If that doesn't work, try playing with mysqli and see if it's globally for the entire MySQL portion of PHP. If mysqli works and mysql_connect() doesn't, well, then, that's as good a time as any to swtich over to the OO side :-)
It maybe using a default PHP configuration. I have found before that it doesn't use the same php.ini or doesn't use one at all. Therefore some of the extensions won't be enabled.
Do this instead:
php -c /etc/php.ini /path/to/script.php
Where /etc/php.ini is the path to your ini file. You can find this by doing a phpinfo();
php-cli.ini might be the file your command line php interpreter is using.
Please make sure this line appears in php.ini
extension=php_mysql.dll
Please note that the php.ini used in command line may be different from the php.ini used by apache.
Check if you php cmd version actually has mysql support:
<? php echo php_info() ?>
If not, then probably it's because it is a different version than the one used by your web server.
Run php using the "-m" parameter in order to list all the compiled modules:
$ php -m
You should see the "mysql" module. If not, then i guess the php cmd version has not been compiled using the --with-mysql or the "configure" script could not included it due some reason.