Azure/index.php at master · ryzwar65/Azure · GitHub

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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta http-equiv="X-UA-Compatible" content="ie=edge">
	<title>Document</title>
</head>
<body>
<form action="index.php" method="post" enctype="multipart/form-data">
<label for="">Nama : </label>
	<input type="text" name="nama" id=""><br>
	<label for="">kelas</label>
	<input type="text" name="kelas" id=""><br>
	<label for="">Jurusan :</label>
	<input type="text" name="jurusan" id="">
	<button type="submit" name="kirim">Submit</button>
	<button type="submit" name="load">Load Data</button>
	</form>
</body>
</html>
<?php
	$host ="riyanwar.database.windows.net";
	$user = "riyanwar";
	$pass = "Nurlaela0902";
	$db = "myDB";

	try {
		$conn = new PDO("sqlsrv:server = tcp:riyanwar.database.windows.net,1433; Database = myDB", "riyanwar", "{Nurlaela0902}");
		$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	}
	catch (PDOException $e) {
		print("Error connecting to SQL Server.");
		die(print_r($e));
	}

	if(isset($_POST['kirim'])){
		try {
			$nama = $_POST['nama'];
			$kelas = $_POST['kelas'];
			$jurusan = $_POST['jurusan'];
			$date = date("Y-m-d");

			$sql = "INSERT INTO Mahasiswa(nama,kelas,jurusan,date) VALUES(?,?,?,?)";
			$stmt = $conn->prepare($sql);
			$stmt->bindValue(1, $nama);
			$stmt->bindValue(2, $kelas);
			$stmt->bindValue(3, $jurusan);
			$stmt->bindValue(4, $date);

		} catch (Exception $e) {
			echo "Failed:",$e;
		}
		echo "<<br>Berhasil Terdaftar";
	}else if (isset($_POST['load'])) {
		try {
			$ambil = "SELECT * FROM Mahasiswa";
			$stmt = $conn->query($ambil);
			$tampil = $stmt->fetchAll();
			if (count($tampil)>0) {
				echo "<table>";
				echo "<tr>";
				echo "<td>Nama</td>";
				echo "<td>Kelas</td>";
				echo "<td>Jurusan</td>";
				echo "<td>Tanggal</td>";
				echo "</tr>";
				foreach ($tampil as $t) {

				echo "<tr>";
				echo "<td>".$t['nama']."</td>";
				echo "<td>".$t['kelas']."</td>";
				echo "<td>".$t['jurusan']."</td>";
				echo "<td>".$t['date']."</td>";
				echo "</tr>";
				}
				echo "</table>";
			}else {
				echo "Data Unknown";
			}
		} catch (Exception $e) {
			echo "Failed: ".$e;
		}
	}

?>