/*	инициализация	*/

$result_1 = NULL;
$result_2 = NULL;
$result_3 = NULL;
$result_4 = NULL;


/*	запросы, которые будут выполняться последовательно	*/

$query_1 = "
	CREATE TABLE IF NOT EXISTS test (id INTEGER NOT NULL PRIMARY KEY ON CONFLICT ABORT AUTOINCREMENT, test TEXT);
	INSERT INTO test (test)
	SELECT 'tttt';
	SELECT last_insert_rowid() AS id;
";

$query_2 = "SELECT * FROM test;";

$query_3 = "
	INSERT INTO test (test)
	SELECT 'tttt';
";

$query_4 = "SELECT * FROM test;";

$dbh_1 = new PDO('sqlite:C:\test.sqlite3');
$dbh_2 = new PDO('sqlite:C:\test.sqlite3');
$dbh_3 = new PDO('sqlite:C:\test.sqlite3');
$dbh_4 = new PDO('sqlite:C:\test.sqlite3');

$sth_1 = $dbh_1->prepare($query_1);
$sth_2 = $dbh_2->prepare($query_2);
$sth_3 = $dbh_3->prepare($query_3);
$sth_4 = $dbh_4->prepare($query_4);

if ( $sth_1->execute() )
	$result_1 = $sth_1->fetchAll(PDO::FETCH_BOTH);

if ( $sth_2->execute() )
	$result_2 = $sth_2->fetchAll(PDO::FETCH_BOTH);

if ( $sth_3->execute() )
	$result_3 = $sth_3->fetchAll(PDO::FETCH_BOTH);

if ( $sth_4->execute() )
	$result_4 = $sth_4->fetchAll(PDO::FETCH_BOTH);


echo('<br>$result_1 = ');
var_export($result_1);

echo('<br>$result_2 = ');
var_export($result_2);

echo('<br>$result_3 = ');
var_export($result_3);

echo('<br>$result_4 = ');
var_export($result_4);

$result_1 = array ( )
$result_2 = array ( )
$result_3 = array ( )
$result_4 = array ( 0 => array ( 'id' => '1', 0 => '1', 'test' => 'tttt', 1 => 'tttt', ), )