Mercurial > hg > fapweb
changeset 1106:b3c1c5969a0b
Add new helper function stDBPrepareSQL_V().
author | Matti Hamalainen <ccr@tnsp.org> |
---|---|
date | Thu, 16 May 2019 12:43:48 +0300 |
parents | 0b0094db56da |
children | acb65ff40ce1 |
files | msitegen.inc.php |
diffstat | 1 files changed, 28 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/msitegen.inc.php Thu May 16 12:42:24 2019 +0300 +++ b/msitegen.inc.php Thu May 16 12:43:48 2019 +0300 @@ -593,6 +593,34 @@ } +function stDBPrepareSQL_V($dbh, $fmt, $argv) +{ + $len = strlen($fmt); + $sql = ""; + $argn = 0; + $argc = count($argv); + + for ($pos = 0; $pos < $len; $pos++) + { + if ($fmt[$pos] == "%") + { + if ($argn < $argc) + $sql .= stDBGetSQLParam($dbh, $fmt[++$pos], $argv[$argn++]); + else + { + stLogError("Invalid SQL statement format string '".$fmt. + "', not enough parameters specified (".$argn." of ".$argc.")"); + return FALSE; + } + } + else + $sql .= $fmt[$pos]; + } + + return $sql; +} + + function stDBPrepareSQL($dbh) { $argc = func_num_args();