$db=new PDO('sqlite:data/test2.db');

//最初だけ実行
//$sql='create table test (id varchar(30), name varchar(50))';
//$stmt= $db->prepare($sql);
//echo $stmt->execute();

$sql="INSERT INTO test (id, name) VALUES (?,?)";
$stmt=$db->prepare($sql);
$ret=$stmt->execute(array('test2','テスト二郎'));
echo $ret;

$stmt=$db->prepare('SELECT * FROM test');
$stmt->execute();
$rst=$stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($rst);