Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [myserver]
- host = myhost
- port = myport
- function getConnection() {
- $dbhost="myserver.database.windows.net";
- $dbuser="user";
- $dbpass="mypass";
- $dbname="myDB";
- $dbh = new PDO("dblib:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
- $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- return $dbh;
- }
- $app = new SlimApp();
- $app->get('/clients', 'getClients');
- $app->run();
- function getClients() {
- $sql = "select * FROM mytable";
- try {
- $db = getConnection();
- $stmt = $db->query($sql);
- $clients = $stmt->fetchAll(PDO::FETCH_OBJ);
- $db = null;
- echo '{"client": ' . json_encode($clients) . '}';
- } catch(PDOException $e) {
- echo '{"error":{"text":'. $e->getMessage() .'}}';
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement