Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: python like named placeholders sprintf ?

by jeffa (Bishop)
on Jan 15, 2009 at 18:20 UTC ( #736630=note: print w/replies, xml ) Need Help??


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).

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://736630]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (8)
As of 2021-04-16 15:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?