note 82176 added to function.sprintf
| From: | ranema at ubuntu dot polarhome dot com | Date: | Sun, 30 Mar 2008 15:40:49 +0000 |
| Subject: | note 82176 added to function.sprintf | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-137759@lists.php.net to get a copy of this message | ||
It's very comfortible for long Sql queries:
<?php
$_gQuery = "UPDATE
x SET a = %i AND b = '%s'
WHERE my = '%s';"; // ........
mysql_query( sprintf( $_gQuery, 10, 'a', 'rrrr' ) );
?>
But if you have a short query, then it would be much faster to append your data by using
..
<?php
$_gQuery = 'SELECT COUNT(*) FROM ' . $_gName . ';';
?>
----
Server IP: 193.219.81.76
Probable Submitter: 78.62.123.120
----
Manual Page -- http://www.php.net/manual/en/function.sprintf.php
Edit -- https://master.php.net/note/edit/82176
Del: integrated -- https://master.php.net/note/delete/82176/integrated
Del: useless -- https://master.php.net/note/delete/82176/useless
Del: bad code -- https://master.php.net/note/delete/82176/bad+code
Del: spam -- https://master.php.net/note/delete/82176/spam
Del: non-english -- https://master.php.net/note/delete/82176/non-english
Del: in docs -- https://master.php.net/note/delete/82176/in+docs
Del: other reasons-- https://master.php.net/note/delete/82176
Reject -- https://master.php.net/note/reject/82176
Search -- https://master.php.net/manage/user-notes.php