Untitled

<html>
 <head>
 <Title>Registration Form</Title>
 <style type="text/css">
    body { background-color: #fff; border-top: solid 10px #226b80;
        color: #226b80; font-size: .85em; margin: 20; padding: 20;
        font-family: "Segoe UI", Verdana, Helvetica, Sans-Serif;
    }
    h1, h2, h3,{ color: #000; margin-bottom: 0; padding-bottom: 0; }
    h1 { font-size: 2em; }
    h2 { font-size: 1.75em; }
    h3 { font-size: 1.2em; }
    table { margin-top: 0.75em; }
    th { font-size: 1.2em; text-align: left; border: none; padding-left: 0; }
    td { padding: 0.25em 2em 0.25em 0em; border: 0 none; }
 </style>
 </head>
 <body>
 <h1>Tambahkan Data</h1>
 <p>Masukkan Email dan Password dan Pekerjaan </p>
 <form method="post" action="index.php" enctype="multipart/form-data" >
       Nama  <input type="text" name="nama" id="name"/></br></br>
       Email <input type="text" name="email" id="email"/></br></br>
       Pekerjaan <input type="text" name="job" id="job"/></br></br>
       <input type="submit" name="simpan" value="Simpan" />
       <input type="submit" name="tampil" value="Tampilkan" />
 </form>

<?php
$user = "aksan08";
$pass = "aksan123";
$host = "tcp:aksan08.database.windows.net,1433";
 $db = "azura_aksan";
    try {
        $conn = new PDO("$host; Database = $db", "$user", "$pass");
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    } catch(Exception $e) {
        echo "Failed: " . $e;
    }
    if (isset($_POST['simpan'])) {
        try {
            $nama = $_POST['nama'];
            $email = $_POST['email'];
            $pekerjan = $_POST['pekerjaan'];
            $tanggal = date("Y-m-d");
            // Simpan data
            $sql_insert = "INSERT INTO Registrasi (nama, email, pekerjaan, date)
                        VALUES (?,?,?,?)";
            $stmt = $conn->prepare($sql_insert);
            $stmt->bindValue(1, $nama);
            $stmt->bindValue(2, $email);
            $stmt->bindValue(3, $pekerjaan);
            $stmt->bindValue(4, $date);
            $stmt->execute();
        } catch(Exception $e) {
            echo "Failed: " . $e;
        }
        echo "<h3>Your're registered!</h3>";
    } else if (isset($_POST['tampil'])) {
        try {
            $sql_select = "SELECT * FROM Registrasi";
            $stmt = $conn->query($sql_select);
            $registrants = $stmt->fetchAll();
            if(count($registrants) > 0) {
                echo "<h2>Registrasi:</h2>";
                echo "<table>";
                echo "<tr><th>Nama</th>";
                echo "<th>Email</th>";
                echo "<th>Pekerjaan</th>";
                echo "<th>Tanggal</th></tr>";
                foreach($registrants as $registrant) {
                    echo "<tr><td>".$registrant['name']."</td>";
                    echo "<td>".$registrant['email']."</td>";
                    echo "<td>".$registrant['pekerjaan']."</td>";
                    echo "<td>".$registrant['tanggal']."</td></tr>";
                }
                echo "</table>";
            } else {
                echo "<h3>No one is currently registered.</h3>";
            }
        } catch(Exception $e) {
            echo "Failed: " . $e;
        }
    }
 ?>
 </body>
 </html>