facing wierd problem in PHP / MYsql connection

amitpadhye

Hello ,

I am running PHP 4.0.4 and Mysql on Linux Server

I create php scripts with mysql connection strings as usual

$conn = mysql_connect("hostname","username","password");
mysql_select_db("dbname", $conn);

My scripts connect to Mysql and work fine when accessed through web or browser...

But same php scripts if try to run from linux console mode giving command
php <filename.php>;

i get the following error :
X-Powered-By: PHP/4.0.4pl1
Content-type: text/html

Fatal error: Call to undefined function: mysql_connect() in greetings.php on line 2

How is that it is giving me PHP error of mysql_connect function undefined when it is working fine from browser..
Mysql.so extension is also loaded properly ;-)

Please help me...

Regards,
Amit

simply___skewed

When you say accessed through a web browser - are you referring to remote connection - and it's not working locally - or... I'm assuming you have apache / PHP /MYSQL installed locally and they all work correctly???

bobthedog

Sounds like the same problem I get on my box, but fortunately I know why (I just can't be bothered to fix it!). The likely problem is that you are running PHP as mod_php under Apache and using the libphp4.so loaded when apache starts.

Whereas, when running in a shell, you are obviously running the php binary.

These are not necessarily the same versions of php (my shell one is 4.2.2, but the module is 4.1.2 inline with my ISP) and the bin executable was probably not configured with the mysql library, while the .so was. To test this, try grabbing the output from php when run on the command line

php -i > info.html

this will dump the results of a phpinfo call into the file info.html

then - run a script through the web server with a phpinfo call in it

compare the results and see what you get.

The solution should be relatively simple - just find the binary that was created (if it was created) when the library was made and replace the current php binary

which php

will tell you where the current php binary is located -its up to you to find the other.

If you have no replacement php binary then you'll need to recompile the source to create one with all the right bits and pieces configure.