function InsertData($from, $body, $to, $caseStudy, $conn) { try { $tsql = "INSERT INTO TextQueue (PhoneNumber, TextContent, TextTo, CaseStudy) VALUES ('" . $from . "', '" . $body . "', '" . $to . "', '" . $caseStudy . "')"; $insertReview = sqlsrv_query($conn, $tsql); if ($insertReview == FALSE) { die(FormatErrors(sqlsrv_errors())); } while ($row = sqlsrv_fetch_array($insertReview, SQLSRV_FETCH_ASSOC)) { echo $row['ID']; } } catch (Exception $e) { echo "Error!"; } }
function OpenConnection() { try { echo "1"; $serverName = "tcp:pawsitivedogs.database.windows.net,1433"; $connectionOptions = array("Database" => "PawsitiveDogs", "Uid" => "*****@*****.**", "PWD" => "HackTX1!"); $conn = sqlsrv_connect($serverName, $connectionOptions); echo "6"; if ($conn == false) { echo "No connection"; die(FormatErrors(sqlsrv_errors())); } return $conn; } catch (Exception $e) { echo "Error!"; } }
function InsertData($conn) { echo "Inside The Insert Function <br>"; try { $tsql = "INSERT INTO TextQueue (PhoneNumber, TextContent) VALUES ('+17047856193', 'This is a test insert' )"; echo "TSQL Query: " . $tsql . "<br>"; $insertReview = sqlsrv_query($conn, $tsql); echo "Insert Review: " . $insertReview . "<br>"; if ($insertReview == FALSE) { echo "Dying <br>"; die(FormatErrors(sqlsrv_errors())); } while ($row = sqlsrv_fetch_array($insertReview, SQLSRV_FETCH_ASSOC)) { echo $row['ID']; } sqlsrv_close($conn); } catch (Exception $e) { echo "Error!"; } }
function OpenConnection() { $error = ""; $dbhost = HOST; $dbuser = USER; $dbport = PORT; $dbpass = PASSWORD; $dbname = DATABASE; $serverName = "tcp:{$dbhost},{$dbport}"; try { $connectionOptions = array("Database" => "{$dbname}", "Uid" => "{$dbuser}", "PWD" => "{$dbpass}"); $conn = sqlsrv_connect($serverName, $connectionOptions); if ($conn == false) { echo "Connection failed"; die(FormatErrors(sqlsrv_errors())); } else { return $conn; } } catch (Exception $e) { echo " Connection Open Error!"; $error = $e->getMessage(); } }
<?php try { $connectionInfo = array("UID" => "sbannister@w8bvrrkcp9", "pwd" => "T@maz0n13", "Database" => "AmiAdvantageDb", "LoginTimeout" => 30, "Encrypt" => 1); $serverName = "tcp:w8bvrrkcp9.database.windows.net,1433"; $conn = sqlsrv_connect($serverName, $connectionInfo); if ($conn == false) { die(FormatErrors(sqlsrv_errors())); } } catch (Exception $e) { echo "Error!"; } try { $tsql = "SELECT TOP 100 * FROM events WHERE event_severity = 'Emergency'"; $getProducts = sqlsrv_query($conn, $tsql); if ($getProducts == FALSE) { die(FormatErrors(sqlsrv_errors())); } $productCount = 0; $i = 0; while ($row = sqlsrv_fetch_array($getProducts, SQLSRV_FETCH_ASSOC)) { print "<row open='A' id='{$i}'><cell close='B'>"; echo $row['event_time']; print "</cell><cell>"; echo $row['src_mac']; print "</cell><cell>"; echo $row['event_text']; print "</cell><cell>"; echo $row['event_id']; print "</cell></row>"; $i++; }
<?php try { $serverName = "tcp:qhkdzwx2fn.database.windows.net,1433"; $connectionOptions = array("Database" => "dbTest", "Uid" => "farfd4323fs", "PWD" => "@zuR3s3rvER"); $conn = sqlsrv_connect($serverName, $connectionOptions); if ($conn == false) { echo 'test' . FormatErrors(sqlsrv_errors()); } } catch (Exception $e) { echo "Error!"; }
<?php header("Access-Control-Allow-Origin: *"); // header("Content-Type: application/json; charset=UTF-8"); include '../partials/dbconfig.php'; $tsql = "SELECT FROM dbo.tblstudents"; $result = sqlsrv_query($conn, $tsql); if ($result == FALSE) { die('' . FormatErrors(sqlsrv_errors())); } $ctr = 0; while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { $arr[$ctr] = array('name' => $row['name'], 'city' => $row['city'], 'country' => $row['country']); $ctr++; } sqlsrv_free_stmt($result); sqlsrv_close($conn); $json_response = json_encode($arr); echo $json_response;