Dynamically add placeholders?

[jdaily]

My queries change depending on what php parameters I have, the simplest example I have is:

if ($Number!= NULL && $ID != NULL) {
$Query = "SELECT *
FROM Numbers b
WHERE b.ID =?i AND (b.Active=1 OR b.Active is NULL) AND b.Number=?i;
} else if ($Number == NULL && $ID != NULL) {
$Query = "SELECT *
FROM Numbers b
WHERE 1 AND (b.Active=1 OR b.Active is NULL)";

    if ($Search == false) {
        $Query.=" AND b.ID =?i";
    } else {
        $Query.=" ...."
    }

}

which would give me a final operation of:
$result = $dbobj->getAll($Query, $ID, $Number);
or
$result = $dbobj->getAll($Query, $ID);

The issue I'm facing is that in the final query the number of placeholders will vary. Is there some way I can build the placeholders as I build the query and pass them in as an array? Also not sure if the way I'm building my queries is unorthodox thus causing my issue with prepared statements.

Any Advice?

[colshrapnel]

It is indeed a shame on me. I didn't make it possible for the array with parameters.
I am already aware of the problem and planning for the new version.

At the moment the most simple workaround is to repeat the call right after query definition:

    if ($Search == false) {
        $Query.=" AND b.ID =?i";
        $result = $dbobj->getAll($Query, $ID, $Number);
    } else {
        $Query.=" ...."
        $result = $dbobj->getAll($Query, $ID);
    }

There is also a method involving call_user_func_array() but I doubt it worth the trouble.
Yet I can write the code if you want.

[stephancasas]

When my number of parameters vary, I find it useful to simply include additional parameter chars inside of or after comment chars in the query. Not sure if anyone's still watching this six-year-old thread, but doing this made short work of my similar issue.

[00dev]

I prefer not to add placeholders and avoid to build query with concatenation. When I want add condition (like on above example) I do like below

$additionalCondition = '';
if ($Number !== NULL) {
    $additionalCondition = $dbobj->parse(
        " AND b.Number = ?i",
        $Number
    );
}
$result = $dbobj->getAll(
    "SELECT *
        FROM Numbers b
        WHERE b.ID = ?i AND (b.Active = 1 OR b.Active is NULL) ?p",
    $ID,
    $additionalCondition
);