Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $myServer = "replaced";
- $connectionInfo = array('Database' => 'replaced', 'UID' => 'replaced', 'PWD' => 'replaced');
- //connection to the database
- $conn = sqlsrv_connect($myServer, $connectionInfo)
- or die("Couldn't connect to SQL Server on $myServer");
- ?>
- <?php
- //Defining my queries
- $getNotes = "SELECT NoteID, NoteName, Note FROM Notes";
- $getTemplateNotes = "SELECT TemplateNoteID, TemplateNoteName, TemplateNote FROM TemplateNotes";
- $getReplaceVariables = "SELECT ReplaceVariableID, ReplaceVariableName, ReplaceVariableNote FROM ReplaceVariables";
- $resultNotes = sqlsrv_query( $conn, $getNotes );
- $resultTemplate = sqlsrv_query($conn, $getTemplateNotes);
- $resultVariables = sqlsrv_query($conn, $getReplaceVariables);
- if( $resultNotes === false)
- {
- die( print_r( sqlsrv_errors(), true) );
- }
- if( $resultTemplate === false)
- {
- die( print_r( sqlsrv_errors(), true) );
- }
- if( $resultVariables === false)
- {
- die( print_r( sqlsrv_errors(), true) );
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement