цыкл вывода запроса к базе данных работает аж 37 раз причем с каждым новым запуском программы
количество итераций цыкла возрастает на 1. В то время как в таблице базы данных в результате запросов всего 2 строки: цыкл тоже должен бы сработать 2 раза но не тут то было.
PHP Version => 5.6.23
Sqlite3 Version => 3.13.0
Текст программы :
<?php
class MyDB extends SQLite3
{
function __construct()
{
$this->open('mysqlitedb.db');
}
}
$db = new MyDB();
$db->query('CREATE TABLE foo (bar STRING)');
$db->query("INSERT INTO foo (bar) VALUES ('This is a test')");
$db->query("INSERT INTO foo (bar) VALUES ('This is a test_1')");
$res=$db->query('SELECT bar FROM foo');
$i=0;
while($res->fetchArray()){
print_r($res->fetchArray());
$i++;
echo "i=",$i;
}
?>
Вывод программы:
Array
(
[0] => This is a test
[bar] => This is a test
)
i=1Array
(
[0] => This is a test
[bar] => This is a test
)
i=2Array
(
[0] => This is a test
[bar] => This is a test
)
i=3Array
(
[0] => This is a test
[bar] => This is a test
)
i=4Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=5Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=6Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=7Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=8Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=9Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=10Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=11Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=12Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=13Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=14Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=15Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=16Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=17Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=18Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=19Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=20Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=21Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=22Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=23Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=24Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=25Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=26Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=27Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=28Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=29Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=30Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=31Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=32Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=33Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=34Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=35Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=36Array
(
[0] => This is a test_1
[bar] => This is a test_1
)
i=37