http://qs321.pair.com?node_id=736630


in reply to python like named placeholders sprintf ?

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;

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

Replies are listed 'Best First'.
Re^2: python like named placeholders sprintf ?
by saberworks (Curate) on Jan 16, 2009 at 03:25 UTC
    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).