<?php require __DIR__ . '/../vendor/autoload.php'; $config = ['server' => 'localhost', 'username' => 'rootuser', 'password' => 'rootuser', 'database' => 'beatguide_devel_service']; $dbh = new \Simplon\Mysql\Mysql($config['server'], $config['username'], $config['password'], $config['database']); // ############################################ $query = 'SELECT * FROM events WHERE venue_id = :venueId LIMIT 10'; $conds = array('venueId' => 23); // ############################################ echo '<h3>fetchValue</h3>'; $results = $dbh->fetchColumn($query, $conds); var_dump($results); // ############################################ echo '<h3>fetchValueMany</h3>'; $results = $dbh->fetchColumnMany($query, $conds); echo '<h4>total rows: ' . $dbh->getRowCount() . '</h4>'; var_dump($results); // ############################################ echo '<h3>fetchValueManyCursor</h3>'; $counter = 0; foreach ($dbh->fetchColumnManyCursor($query, $conds) as $result) { echo '<h4>#' . ++$counter . ' cursor</h4>'; var_dump($result); } // ############################################ echo '<h3>fetch</h3>'; $results = $dbh->fetchRow($query, $conds); var_dump($results); // ############################################ echo '<h3>fetchMany</h3>'; $results = $dbh->fetchRowMany($query, $conds);