sending diffrent number of args to a function

[Hawk2005]

Hi,

the problem is, i want to send args to a function (ibase_execute).

function sqlDo($ResultID) {
    for ($i = 0; $i <= func_num_args()-1; $i++)
        args[$i] = func_get_arg ($i);

ibase_execute($ResultID,$args);
}

$sql = "UPDATE users SET text = ? WHERE id = ?";
$sqlConn = ibase_prepare($conn,$sql);
sqlDo($sqlConn,"Harry","1");
sqlDo($sqlConn,"Fred","2");

This doesn't work because $args is an array and ibase_execute doesn't expect an array but a list of args like in sqlDo(). But how can it be done ?

THX

[paulnaj]

You can use the eval() function ...

function sqlDo($ResultID) { 
    for ($i = 0; $i <= func_num_args()-1; $i++) 
        args[$i] = "\"".func_get_arg ($i)."\""; 

eval("ibase_execute(\$ResultID,".join("," $args).");"); 
} 

$sql = "UPDATE users SET text = ? WHERE id = ?"; 
$sqlConn = ibase_prepare($conn,$sql); 
sqlDo($sqlConn,"Harry","1"); 
sqlDo($sqlConn,"Fred","2");

Try the above ... I haven't debugged it, so there might be a glitch, but you get the idea.

[Hawk2005]

Jep seems to work.

Had it like this before but forgot the "\""....

But this is far away from beeing a clean code.

Any other ideas donig this clean ?

[paulnaj]

Not that I know of, I'm afraid.

In the end, if the ibase_execute function can't handle an array, you have to give it separate arguments.

I suppose you could run ibase_execute separately for each argument, maybe!