note 108807 deleted from internals2.opcodes.mod by cmb
| From: | cmb@php.net | Date: | Sun, 10 Jan 2021 13:22:41 +0000 |
| Subject: | note 108807 deleted from internals2.opcodes.mod by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-216104@lists.php.net to get a copy of this message | ||
Note Submitter: napora dot adam at gmail dot com
----
Might be helpful:
I had to create and "INSERT INTO" on every 50th row:
<?php
$lineBreak = 50;
$tableName = 'user';
$tableFields = 'id, name, password';
?>
in the loop:
<?php
if ($counter === 0 || $counter % $lineBreak === 0) {
echo "INSERT INTO $tableName ($tableFields) VALUES (";
} else {
echo ' (';
}
// add values comma-delimited
if ($counter === 0 || $counter % $lineBreak === 0) {
$insertStmt .= ');';
} else {
$insertStmt .= '),';
}
?>
(in my case I had to check if $no % $o === 0)