[RESOLVED] Multiple queries in different functions?

[Brutal]

Hi all,

I have trouble in getting my queries from own made functions to work. IF i just write the code in one function it all work, but when I start to divide it in logical functions, the queries just won't work anymore.

<?php

$global_handle = mysql_connect("host", "user", "pass");
mysql_select_db("test", $global_handle);

function first_func() {
        $qryStr = "SELECT * FROM table";
        $result_id = mysql_query($qryStr, $global_handle); //WORKS FINE!

    call_second_func();
}

function call_second_func() {
        $qryStr = "SELECT * FROM table";
        $result_id = mysql_query($qryStr, $global_handle); //DOESNT work
}
?>

IF i just add the second function in the end of the first, it works just fine? Am I'm loosing the global handle or something?

Please help!:o

[laserlight]

PHP is unusual in that global variables have to be declared global in the given scope. As such, you would write:

<?php

$global_handle = mysql_connect("host", "user", "pass");
mysql_select_db("test", $global_handle);
first_func(); // You need to actually call a function.

function first_func() {
    global $global_handle;

$qryStr = "SELECT * FROM table";
$result_id = mysql_query($qryStr, $global_handle);

call_second_func();
}

function call_second_func() {
    global $global_handle;

$qryStr = "SELECT * FROM table";
$result_id = mysql_query($qryStr, $global_handle);
}
?>

I would suggest passing handles by reference as opposed to using a global handle. After all, the whole point of specifying the handle is so that you can use different handles.

<?php

$db_handle = mysql_connect("host", "user", "pass");
mysql_select_db("test", $db_handle);
first_func($db_handle);

function first_func(&$db_handle) {
    $qryStr = "SELECT * FROM table";
    $result_id = mysql_query($qryStr, $db_handle);

call_second_func($db_handle);
}

function call_second_func(&$db_handle) {
    $qryStr = "SELECT * FROM table";
    $result_id = mysql_query($qryStr, $db_handle);
}
?>

[Brutal]

Thanks a lot for a very quick answer! Now it is working. I tried your approach from the beginning and didnt get it to work, but now when u said it really should work, I just went through all my code again, and now it is working.

Only difference that I noticed was the ampersand (&) before the function argument. What does that really mean?

Thanks alot!

[laserlight]

Only difference that I noticed was the ampersand (&) before the function argument. What does that really mean?

That is for passing by reference. You might want to read the PHP manual on references.

[Brutal]

ty for your input, I really appreciate it.

I'll head over to the reference section and readup

[laserlight]

You are welcome. Remember to mark this thread resolved using the thread tools (if it is resolved).

[Brutal]

Heh, were fiddling around with this resolved thing, and u answered that question too for me, thnx 🙂