forked from The-inevitables/AzureHackathon
-
Notifications
You must be signed in to change notification settings - Fork 0
/
connection.php
47 lines (37 loc) · 1.39 KB
/
connection.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
<?php
try {
$conn = new PDO("sqlsrv:server = tcp:lifelineserver.database.windows.net,1433; Database = lifelinesqldb", "akhil", "Inevitables@123");
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e) {
print("Error connecting to SQL Server.");
die(print_r($e));
}
// SQL Server Extension Sample Code:
$connectionInfo = array("UID" => "akhil", "pwd" => "Inevitables@123", "Database" => "lifelinesqldb", "LoginTimeout" => 30, "Encrypt" => 1, "TrustServerCertificate" => 0);
$serverName = "tcp:lifelineserver.database.windows.net,1433";
$conn = sqlsrv_connect($serverName, $connectionInfo);
$name = $_POST['name'];
$phone = $_POST['phone'];
$day = $_POST['day'];
$hospital = $_POST['hospital'];
$params = array($name,$phone,$day,$hospital);
$sql="INSERT INTO register (name, phone, day, hospital)
VALUES ( ?,?,?,?)";
$stmt = sqlsrv_query($conn, $sql, $params);
if ($stmt === false) {
echo "Row insertion failed.\n";
die(print_r(sqlsrv_errors(), true));
} else {
$params = array($name,$phone,$day,$hospital);
$sql="INSERT INTO reserve (name, phone, day, hospital)
VALUES ( ?,?,?,?)";
$stmt = sqlsrv_query($conn, $sql, $params);
if ($stmt === false) {
echo "Row insertion failed.\n";
die(print_r(sqlsrv_errors(), true));
} else {
header('location: booking.php');
}
}
?>