/
index.php
51 lines (50 loc) · 1.05 KB
/
index.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
<!DOCTYPE html>
<html lang = "en-US">
<?php
function OpenConnection()
{
try
{
echo "1";
$serverName = "tcp:pawsitivedogs.database.windows.net,1433";
$connectionOptions = array("Database"=>"PawsitiveDogs",
"Uid"=>"andymedina11@pawsitivedogs.database.windows.net", "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 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!");
}
}
echo "6";
WriteData();
echo "7";
?>
</body>
</html>