fwolf /
fwlib
| @@ 580-602 (lines=23) @@ | ||
| 577 | * Array($k=>$v) means '($k) VALUES ($v)' in sql, |
|
| 578 | * @return string |
|
| 579 | */ |
|
| 580 | protected function GenSqlArrayValues($param) |
|
| 581 | { |
|
| 582 | $sql = ' ( '; |
|
| 583 | if (is_array($param) && !empty($param)) |
|
| 584 | { |
|
| 585 | $sql1 = ''; |
|
| 586 | $sql2 = ''; |
|
| 587 | foreach ($param as $k=>$v) |
|
| 588 | { |
|
| 589 | $sql1 .= ', ' . $k; |
|
| 590 | $sql2 .= ', ' . $this->GenSqlQuote($this->sInsert, $k, $v); |
|
| 591 | } |
|
| 592 | $sql1 = substr($sql1, 2); |
|
| 593 | $sql2 = substr($sql2, 2); |
|
| 594 | $sql .= $sql1 . ' ) VALUES ( ' . $sql2 . ' ) '; |
|
| 595 | } |
|
| 596 | else |
|
| 597 | { |
|
| 598 | $sql = $param; |
|
| 599 | } |
|
| 600 | ||
| 601 | return $sql; |
|
| 602 | } // end of func GenSqlArrayValues |
|
| 603 | ||
| 604 | ||
| 605 | /** |
|
| @@ 318-337 (lines=20) @@ | ||
| 315 | * Array($k=>$v) means '($k) VALUES ($v)' in sql. |
|
| 316 | * @return string |
|
| 317 | */ |
|
| 318 | protected function genSqlArrayValues($param) |
|
| 319 | { |
|
| 320 | $sql = ''; |
|
| 321 | if (!empty($param) && is_array($param)) { |
|
| 322 | $sql1 = ''; |
|
| 323 | $sql2 = ''; |
|
| 324 | foreach ($param as $k => $v) { |
|
| 325 | $sql1 .= ', ' . $k; |
|
| 326 | $sql2 .= ', ' |
|
| 327 | . $this->genSqlQuote($this->paramPart['INSERT'], $k, $v); |
|
| 328 | } |
|
| 329 | $sql1 = substr($sql1, 2); |
|
| 330 | $sql2 = substr($sql2, 2); |
|
| 331 | $sql .= '(' . $sql1 . ') VALUES (' . $sql2 . ')'; |
|
| 332 | } else { |
|
| 333 | $sql = $param; |
|
| 334 | } |
|
| 335 | ||
| 336 | return $sql; |
|
| 337 | } |
|
| 338 | ||
| 339 | ||
| 340 | /** |
|
