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;
