Mercurial > hg > fapweb

comparison msitegen.inc.php @ 1107:acb65ff40ce1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use stDBPrepareSQL_V() to simplify stPrepareSQL() and stDBPrepareSQL().
author Matti Hamalainen <ccr@tnsp.org>
date Thu, 16 May 2019 12:44:17 +0300
parents b3c1c5969a0b
children ac3bd4e94555
comparison
equal deleted inserted replaced
1106:b3c1c5969a0b 1107:acb65ff40ce1
621 } 621 }
622 622
623 623
624 function stDBPrepareSQL($dbh) 624 function stDBPrepareSQL($dbh)
625 { 625 {
626 $argc = func_num_args();
627 $argv = func_get_args(); 626 $argv = func_get_args();
628 627 return stDBPrepareSQL_V($dbh, $argv[1], array_splice($argv, 2));
629 $fmt = $argv[1];
630 $len = strlen($fmt);
631 $sql = "";
632 $argn = 2;
633 for ($pos = 0; $pos < $len; $pos++)
634 {
635 if ($fmt[$pos] == "%")
636 {
637 if ($argn < $argc)
638 $sql .= stDBGetSQLParam($dbh, $fmt[++$pos], $argv[$argn++]);
639 else
640 {
641 stLogError("Invalid SQL statement format string '".$fmt.
642 "', not enough parameters specified (".$argn." of ".$argc.")");
643 return FALSE;
644 }
645 }
646 else
647 $sql .= $fmt[$pos];
648 }
649
650 return $sql;
651 } 628 }
652 629
653 630
654 function stPrepareSQL() 631 function stPrepareSQL()
655 { 632 {
656 global $db; 633 global $db;
657 $argc = func_num_args();
658 $argv = func_get_args(); 634 $argv = func_get_args();
659 635 return stDBPrepareSQL_V($db, $argv[0], array_splice($argv, 1));
660 $fmt = $argv[0];
661 $len = strlen($fmt);
662 $sql = "";
663 $argn = 1;
664 for ($pos = 0; $pos < $len; $pos++)
665 {
666 if ($fmt[$pos] == "%")
667 {
668 if ($argn < $argc)
669 $sql .= stDBGetSQLParam($db, $fmt[++$pos], $argv[$argn++]);
670 else
671 {
672 stLogError("Invalid SQL statement format string '".$fmt.
673 "', not enough parameters specified (".$argn." of ".$argc.")");
674 return FALSE;
675 }
676 }
677 else
678 $sql .= $fmt[$pos];
679 }
680
681 return $sql;
682 } 636 }
683 637
684 638
685 function stDBExecSQLInsert($dbh, $sql) 639 function stDBExecSQLInsert($dbh, $sql)
686 { 640 {