ci-bonfire /
Sprint
| @@ 593-604 (lines=12) @@ | ||
| 590 | * @param array $values INSERT values |
|
| 591 | * @return string |
|
| 592 | */ |
|
| 593 | protected function _insert_batch($table, $keys, $values) |
|
| 594 | { |
|
| 595 | $keys = implode(', ', $keys); |
|
| 596 | $sql = "INSERT ALL\n"; |
|
| 597 | ||
| 598 | for ($i = 0, $c = count($values); $i < $c; $i++) |
|
| 599 | { |
|
| 600 | $sql .= ' INTO '.$table.' ('.$keys.') VALUES '.$values[$i]."\n"; |
|
| 601 | } |
|
| 602 | ||
| 603 | return $sql.'SELECT * FROM dual'; |
|
| 604 | } |
|
| 605 | ||
| 606 | // -------------------------------------------------------------------- |
|
| 607 | ||
| @@ 268-279 (lines=12) @@ | ||
| 265 | * @param array $values INSERT values |
|
| 266 | * @return string |
|
| 267 | */ |
|
| 268 | protected function _insert_batch($table, $keys, $values) |
|
| 269 | { |
|
| 270 | $keys = implode(', ', $keys); |
|
| 271 | $sql = "INSERT ALL\n"; |
|
| 272 | ||
| 273 | for ($i = 0, $c = count($values); $i < $c; $i++) |
|
| 274 | { |
|
| 275 | $sql .= ' INTO '.$table.' ('.$keys.') VALUES '.$values[$i]."\n"; |
|
| 276 | } |
|
| 277 | ||
| 278 | return $sql.'SELECT * FROM dual'; |
|
| 279 | } |
|
| 280 | ||
| 281 | // -------------------------------------------------------------------- |
|
| 282 | ||
