<?php

$db = new SQLite3(':memory:');
$db->exec('create table dolgok (vmi TEXT)');

$stmt = $db->prepare('insert into dolgok values (:vmi)';

$stmt->bindParam(':vmi', $vmi, SQLITE3_TEXT);

$vmi = 'Valami';
$stmt->execute();

$vmi = 'Más';
$stmt->execute();

$res = $db->query('select * from dolgok');

while(($row = $res->fetchArray(SQLITE3_ASSOC))) {
    var_dump($row);
}