function WriteData() { try { echo "622"; $conn = OpenConnection(); $sql = "INSERT dbo.Dog OUTPUT INSERTED.Name VALUES (Rosco Jenkins,10)"; $stmt = sqlsrv_query($conn, $sql); if (!$stmt) { echo "Error: Doesn't Query"; } sqlsrv_close($conn); } catch (Exception $e) { echo "Error!"; } }
<!DOCTYPE html> <html> <body> <?php echo "<h2>PHP is Fun!</h2>"; echo "Opening Connection to Azure <br>"; $conn = OpenConnection(); echo "Connection Established <br>"; echo "Inserting Data by Executing TSQL Command<br>"; InsertData($conn); echo "Insert complete"; function OpenConnection() { try { $serverName = "tcp:j7luugiwb8.database.windows.net,1433"; $connectionOptions = array("Database" => "Texting_APP", "Uid" => "arufolo@cardinalsolutions.com@j7luugiwb8", "PWD" => "P@ssw0rd1"); $conn = sqlsrv_connect($serverName, $connectionOptions); if ($conn == false) { 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' )";
function deQueueUser($conn, $queue_id) { try { $tsql = "WITH q AS\n (SELECT TOP 1 *\n FROM dbo.Users ORDER BY position ASC) DELETE FROM q"; $conn = OpenConnection(); $results = sqlsrv_query($conn, $tsql); if ($results == FALSE) { die(print_r(sqlsrv_errors(), true)); } sqlsrv_close($conn); return $results; } catch (Exception $e) { echo $e->getMessage(); } }
<?php function OpenConnection() { $servername = "us-cdbr-azure-east-a.cloudapp.net"; $username = "******"; $password = "******"; $dbname = "YHacks"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $d = $_POST('ItemID'); $sql = "DELETE FROM Inventory WHERE ItemID = 300"; //$sql2 = "INSERT INTO Unlocked (Lock_ID) VALUES ($d)"; if ($conn->query($sql) === TRUE) { echo "Record deleted successfully"; } else { echo "Error deleting record: " . $conn->error; } $conn->close(); } $d = $_POST('LockID'); OpenConnection();