[ZF3] Zend Framework 3 データベース接続 query()

$config = array(
    'driver' => 'mysqli', // MySQL
    'host' => 'localhost',
    'username' => '{username}',
    'password' => '{password}',
    'database' => '{dbname}',
    'characterset' => 'utf8',
);
$adapter = new \Zend\Db\Adapter\Adapter($config);

$id = 1;

$sql = "select * from user where id = ?";
$params = array($id);
$statement = $adapter->query($sql);
$results = $statement->execute($params);

foreach ($results as $result) {
	//echo $result->id;
	echo $result->name;
}