Re: python like named placeholders sprintf ?

[jeffa]

Ummm ... so what is wrong with Perl's sprintf? Why would you need to name the placeholders? If you need that, then you really need a templating language.

my $hello = sprintf "Hai %s! Time: %s\n" => $name, scalar(localtime);

PHP has sprintf too, you know. To use database placeholders in PHP you need to look to PEAR, but if you don't want that you can always use sprintf to give placeholders to your code:

    $results = array();

    foreach ($tables as $table) {

        $sql = sprintf("
                SELECT id,
                    %s as customer,
                    status,
                    status_error,
                    submit_datetime,
                FROM stats.%s
                WHERE direction = %s
            ",
            $config['customer_field'],
            $table,
            $config['direction'],
        );

        $results[$table] = $dbh->exec( $sql );
    }

    return $results;

[saberworks]

I know this isn't a PHP board but what you're suggesting is very dangerous. Using simple sprintf & %s in php like that does not get you all the benefits of ? placeholders in DBI. Later versions of PHP have PDO which is similar to DBI (but not as nice).