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();