Mercurial > hg > fapweb

comparison msitegen.inc.php @ 1105:0b0094db56da

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Improve function stDBPrepareSQLUpdate() by adding new optional last argument to specify values array.
author Matti Hamalainen <ccr@tnsp.org>
date Thu, 16 May 2019 12:42:24 +0300
parents 0a2117349f46
children b3c1c5969a0b
comparison
equal deleted inserted replaced
1104:0a2117349f46 1105:0b0094db56da
577 $db = stConnectSQLDBSpec(stGetSetting("sqlDB")); 577 $db = stConnectSQLDBSpec(stGetSetting("sqlDB"));
578 return ($db !== FALSE); 578 return ($db !== FALSE);
579 } 579 }
580 580
581 581
582 function stDBPrepareSQLUpdate($dbh, $table, $cond, $pairs) 582 function stDBPrepareSQLUpdate($dbh, $table, $cond, $pairs, $values = NULL)
583 { 583 {
584 $sql = array(); 584 $sql = [];
585 foreach ($pairs as $name => $attr) 585 foreach ($pairs as $name => $attr)
586 { 586 {
587 $sql[] = $name."=".stDBGetSQLParam($dbh, $attr, $name); 587 $sql[] = $name."=".stDBGetSQLParam($dbh,
588 $attr, $values !== NULL ? $values[$name] : $name);
588 } 589 }
589 return 590 return
590 "UPDATE ".$table." SET ".implode(",", $sql). 591 "UPDATE ".$table." SET ".implode(",", $sql).
591 ($cond != "" ? " ".$cond : ""); 592 ($cond != "" ? " ".$cond : "");
592 } 593 }