desperately need help INCLUDE

[Anon]

I have an include file named "valami.php" where there is a function that is supposed to connect to a MySQL server.

<?
function db_kapcs()
{
$dbhost = HOST ;
$dbuser = USER ;
$dbpass = PASS ;
$db = mysql_connect($dbhost,$dbuser,$dbpass) or die("Hiba a kapcsolódáskor!") ;
return $db ;
}
?>

On the destination page I have:

<?
require("valami.php") ;
...
db_kapcs() ;
...
?>

[Anon]

Your sure $dbhost and other vars are declared within the function db_kapcs, or did you add those for the example only?

Variables you declare within a function only "live" within the functions scope. Therefor, you need to make the vars global which don't get declared within the function.

e.g.

$testvar = "martin";
test();

function test() {
echo $testvar;
}

Would echo an empty string. Since "testvar" is not known to function test.

function test() {
global $testvar;
echo $testvar;
}

Would work however!

[Anon]

Hi Martin,

Almost on each page I need to connect to a MySQL server, and I just want to save some space.

My include file looks like the following (without any change):

<?
session_start() ;
function db_kapcs()
{
$dbhost = MYHOSTNAME ;
$dbuser = MYUSERNAME ;
$dbpass = MYPASSWORD ;
$db = mysql_connect($dbhost,$dbuser,$dbpass) or die("Hiba a kapcsolódáskor!") ;
return $db ;
}
?>

Do you think any of these variables need to be declared globally? I thought the the rest of the program needs only what's in $db and I returned that value.

On the target page:

<?
...
db_kapcs() ;
...
?>

The error message is:

FATAL: Undefined function (why the hell thinks it is undefined?)

Or do you need a global value to make queries afterr calling this function?

Thanks, Akos

[Anon]

There's nothing wrong with this approach. However, make sure to not only say:

<?
...
db_kapcs() ;
...
?>

But also:

<?
require ("yourincludefile");
db_kapcs() ;
...
?>

Undefined function means it cannot find the function db_kapcs() {}.

This can be because:

1. You didn't require the file before calling the function
2. You put the required file in a different path and it can't be included
3. You made a typing mistake, either in calling the function, or in creating the function (or in the required part)

You could make $db global, however I don't really believe this is needed.

Also I take it with:
$dbhost = MYHOSTNAME ;

You mean:
$dbhost = "myhostname";

(just to be sure)

Also, mind the case sensitivity, eg.:

$login = "AKOS";

is different from:

$login = "akos";

Hope this helps...

[Anon]

if you want to work with the database you should not forget to fetch the return value

db_kapcs();
just calls the function ... use
$db_handle = db_kapcs();

cya Rob