Advertisement
Guest User

Untitled

a guest
May 24th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. [myserver]
  2. host = myhost
  3. port = myport
  4.  
  5. function getConnection() {
  6. $dbhost="myserver.database.windows.net";
  7. $dbuser="user";
  8. $dbpass="mypass";
  9. $dbname="myDB";
  10. $dbh = new PDO("dblib:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
  11. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  12. return $dbh;
  13. }
  14.  
  15. $app = new SlimApp();
  16.  
  17. $app->get('/clients', 'getClients');
  18.  
  19. $app->run();
  20.  
  21. function getClients() {
  22. $sql = "select * FROM mytable";
  23.  
  24. try {
  25. $db = getConnection();
  26. $stmt = $db->query($sql);
  27. $clients = $stmt->fetchAll(PDO::FETCH_OBJ);
  28. $db = null;
  29. echo '{"client": ' . json_encode($clients) . '}';
  30. } catch(PDOException $e) {
  31. echo '{"error":{"text":'. $e->getMessage() .'}}';
  32. }
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement