Advertisement
Guest User

Untitled

a guest
Dec 1st, 2016
185
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. <?php
  2. $myServer = "replaced";
  3. $connectionInfo = array('Database' => 'replaced', 'UID' => 'replaced', 'PWD' => 'replaced');
  4.  
  5. //connection to the database
  6. $conn = sqlsrv_connect($myServer, $connectionInfo)
  7. or die("Couldn't connect to SQL Server on $myServer");
  8. ?>
  9.  
  10. <?php
  11.  
  12. //Defining my queries
  13. $getNotes = "SELECT NoteID, NoteName, Note FROM Notes";
  14. $getTemplateNotes = "SELECT TemplateNoteID, TemplateNoteName, TemplateNote FROM TemplateNotes";
  15. $getReplaceVariables = "SELECT ReplaceVariableID, ReplaceVariableName, ReplaceVariableNote FROM ReplaceVariables";
  16.  
  17. $resultNotes = sqlsrv_query( $conn, $getNotes );
  18. $resultTemplate = sqlsrv_query($conn, $getTemplateNotes);
  19. $resultVariables = sqlsrv_query($conn, $getReplaceVariables);
  20.  
  21.  
  22. if( $resultNotes === false)
  23. {
  24. die( print_r( sqlsrv_errors(), true) );
  25. }
  26. if( $resultTemplate === false)
  27. {
  28. die( print_r( sqlsrv_errors(), true) );
  29. }
  30.  
  31. if( $resultVariables === false)
  32. {
  33. die( print_r( sqlsrv_errors(), true) );
  34. }
  35.  
  36. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement