Advertisement
Guest User

Untitled

a guest
Sep 24th, 2018
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.79 KB | None | 0 0
  1. <?php
  2.     if (isset($_POST['submit'])) {
  3.         require_once("koneksi.php");
  4.         $sql = $conn->prepare("INSERT INTO pertemuan1 (Nama,Username,Email,Password) VALUES (?, ?, ?, ?)");  
  5.         $Nama = $_POST['Nama'];
  6.         $Username= $_POST['Username'];
  7.         $Email= $_POST['Email'];
  8.         $Password= $_POST['Password'];
  9.         $sql->bind_param("ssss", $Nama, $Username, $Email, $Password);
  10.         if(!preg_match("/^[a-zA-Z ]+$/",$Nama)){
  11.  
  12.             $success_message = "<div class='alert alert-danger'>Kolom Nama Hanya Huruf Yang Dibolehkan, Dan Boleh Spasi.</div><br>";
  13.         }
  14.         else if($sql->execute()) {
  15.             $success_message = "<div class='alert alert-warning'>Input Data Berhasil</div>";
  16.         } else {
  17.             $error_message = "<div class='alert alert-danger'>Ada masalah dengan Penginputan</div>";
  18.         }
  19.         $sql->close();  
  20.         $conn->close();
  21.     }  
  22.  
  23. ?>
  24. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
  25. <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js" integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy" crossorigin="anonymous"></script>
  26.  
  27.  
  28. <html>
  29. <head>
  30. <link href="style.css" rel="stylesheet" type="text/css" />
  31.    
  32. <style>
  33. .tbl-qa{border-spacing:0px;border-radius:4px;border:#6ab5b9 1px solid;}
  34. </style>
  35.   <title>Input Data Mahasiswa</title>  
  36. </head>
  37. <body>
  38. <?php if(!empty($success_message)) { ?>
  39. <div class="success message"><?php echo $success_message; ?></div>
  40. <?php } if(!empty($error_message)) { ?>
  41. <div class="error message"><?php echo $error_message; ?></div>
  42. <?php } ?>
  43. <form id="frmUser" method="post" action="">
  44. <div class="container">
  45.     <br>
  46.     <br>
  47. <a href="index.php" class="btn btn-outline-warning">Daftar Data Mahasiswa</a>
  48. <table border="0" cellpadding="10" cellspacing="0" width="500" align="center" class="tbl-qa">
  49.     <thead>
  50.         <tr>
  51.             <th colspan="2" class="table-header">Tambah Data Mahasiswa</th>
  52.         </tr>
  53.     </thead>
  54.     <tbody>
  55.         <tr class="table-row">
  56.             <td><label>NAMA</label></td>
  57.             <td><input type="text" name="Nama" class="form-control"></td>
  58.         </tr>
  59.         <tr class="table-row">
  60.             <td><label>USERNAME</label></td>
  61.             <td><input type="text" name="Username" class="form-control"></td>
  62.         </tr>
  63.         <tr class="table-row">
  64.             <td><label>EMAIL</label></td>
  65.             <td><input type="text" name="Email" class="form-control"></td>
  66.         </tr>
  67.         <tr class="table-row">
  68.             <td><label>PASSWORD</label></td>
  69.             <td><input id="password" type="password" name="Password" class="form-control"></td>
  70.         </tr>
  71.         <br>
  72.         <tr class="table-row">
  73.             <td colspan="2"><input  type="submit" name="submit" value="Submit" class="btn btn-outline-primary"></td>
  74.         </tr>
  75.         <br>
  76.     </tbody>
  77. </table>
  78. </div>
  79. </form>
  80. </body>
  81. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement