Mercurial > hg > fapweb

comparison msitegen.inc.php @ 1109:ac3bd4e94555

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merge.
author Matti Hamalainen <ccr@tnsp.org>
date Thu, 16 May 2019 21:59:44 +0300
parents c7093ad17858 acb65ff40ce1
children a5f52e54c9da
comparison
equal deleted inserted replaced
1108:c7093ad17858 1109:ac3bd4e94555
590 "UPDATE ".$table." SET ".implode(",", $sql). 590 "UPDATE ".$table." SET ".implode(",", $sql).
591 ($cond != "" ? " ".$cond : ""); 591 ($cond != "" ? " ".$cond : "");
592 } 592 }
593 593
594 594
595 function stDBPrepareSQL($dbh) 595 function stDBPrepareSQL_V($dbh, $fmt, $argv)
596 { 596 {
597 $argc = func_num_args();
598 $argv = func_get_args();
599
600 $fmt = $argv[1];
601 $len = strlen($fmt); 597 $len = strlen($fmt);
602 $sql = ""; 598 $sql = "";
603 $argn = 2; 599 $argn = 0;
600 $argc = count($argv);
601
604 for ($pos = 0; $pos < $len; $pos++) 602 for ($pos = 0; $pos < $len; $pos++)
605 { 603 {
606 if ($fmt[$pos] == "%") 604 if ($fmt[$pos] == "%")
607 { 605 {
608 if ($argn < $argc) 606 if ($argn < $argc)
620 618
621 return $sql; 619 return $sql;
622 } 620 }
623 621
624 622
623 function stDBPrepareSQL($dbh)
624 {
625 $argv = func_get_args();
626 return stDBPrepareSQL_V($dbh, $argv[1], array_splice($argv, 2));
627 }
628
629
625 function stPrepareSQL() 630 function stPrepareSQL()
626 { 631 {
627 global $db; 632 global $db;
628 $argc = func_num_args();
629 $argv = func_get_args(); 633 $argv = func_get_args();
630 634 return stDBPrepareSQL_V($db, $argv[0], array_splice($argv, 1));
631 $fmt = $argv[0];
632 $len = strlen($fmt);
633 $sql = "";
634 $argn = 1;
635 for ($pos = 0; $pos < $len; $pos++)
636 {
637 if ($fmt[$pos] == "%")
638 {
639 if ($argn < $argc)
640 $sql .= stDBGetSQLParam($db, $fmt[++$pos], $argv[$argn++]);
641 else
642 {
643 stLogError("Invalid SQL statement format string '".$fmt.
644 "', not enough parameters specified (".$argn." of ".$argc.")");
645 return FALSE;
646 }
647 }
648 else
649 $sql .= $fmt[$pos];
650 }
651
652 return $sql;
653 } 635 }
654 636
655 637
656 function stDBExecSQLInsert($dbh, $sql) 638 function stDBExecSQLInsert($dbh, $sql)
657 { 639 {