Exemple #1
0
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!";
    }
}
Exemple #2
0
<!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' )";
Exemple #3
0
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();
    }
}
Exemple #4
0
<?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();