help

[osusano]

<?php
$dbservertype   = "mysql";
$dbservername   = "localhost";
$dbusername     = "root";
$dbpassword     = "******";
$dbname         = "testdb";

mysql_connect($dbservername,$dbusername,$dbpassword);      

mysql_select_db($dbname);
?>

execute it in linux like this
[xxx@localhost]$ /usr/bin/php test.php

if will display an error like this

X-Powered-By: PHP/4.2.2
Content-type: text/html

<br />
<b>Fatal error</b>: Call to undefined function: mysql_connect() in <b>/home/webdev/naia/test.php</b> on line <b>9</b><br />

what do u think would be the problem and how can i connect to the database and have some query from the shell?

[osusano]

this do works in win2k with apache and php and mysql i just dont get the reason why i do get an error in linux 🙁

[Moonglobe]

ok, pretty new to linux although i know much, but i still dont have much experience. i believe that there is a pretty easy way to use the /[mysql_dir]/bin/mysqld (is that it?) program, but the only reason i could think of why mysql_connect wouldnt work would be that your PHP has been complied without mysql support. does mysql work from the web?

[osusano]

yes i tried same commands on my browser based script and it do run properly and i can even make some queries. and i dont even know why im having this kind of problem just doing it ni shell

[Moonglobe]

sorry but i havent had command-line linux experience in months since my webhosts SSH went down, so i cant really help u much 🙁

[osusano]

its ok.. thank you for the reply...

maybe somebody here know's how to

coz i really need this kind of script and put it in my cron

[Weedpacket]

If PHP is saying that the mysql_connect() function is undefined, then chances are it is because it was compiled without MySQL support. Use phpinfo() to have a look at the configuration string that was used when it was compiled (near the top of the phpinfo page); if memory serves, --with-mysql should be one of the switches listed there. My guess is that it isn't, in which case PHP would need to be rebuilt as per the usual installation instructions.

On the other hand, there's a function called dl() - may be useful, may be not - I only know what I read in the manual about it.