Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title>Web Praktikum</title>
- <link href="../style.css" rel="stylesheet" type="text/css"><meta name="viewport" content="width=device-width, initial-scale=1">
- <link href="https://fonts.googleapis.com/css?family=Noto+Sans+JP|Open+Sans|Montserrat|Tomorrow&display=swap" rel="stylesheet">
- <link href="https://fonts.googleapis.com/css?family=Montserrat|Tomorrow&display=swap" rel="stylesheet">
- <style>
- .container{
- font-weight:bold;
- text-align:center;
- position:relative;
- left:-10px;
- margin-top:20px;
- }
- img{
- margin-top: 20px;
- position:relative;
- left:35%;
- width:200px;
- height:200px;
- border-radius:100%
- }
- .nama{
- font-family: "Open Sans", sans-serif;
- font-weight:bold;
- line-height:20px;
- }
- .nama span{
- font-family: "Open Sans", sans-serif;
- background-color:cyan;
- border-radius:20%;
- color:white;
- padding: 2px;
- font-size:12px;
- }
- .ttl{
- font-family: 'Noto Sans JP', sans-serif;
- font-style: italic;
- }
- .ttl span{
- font-family: "Open Sans", sans-serif;
- font-size:11px;
- color:gray;
- }
- .jenis {
- font-family: "Open Sans", sans-serif;
- }
- .email{
- font-family: 'Noto Sans JP', sans-serif;
- font-style:italic;
- color:gray;
- font-weight:normal;
- }
- .no{
- font-family: 'Noto Sans JP', sans-serif;
- color:gray;
- font-style:italic;
- }
- .alamat {
- font-family: 'Noto Sans JP', sans-serif;
- }
- .btn{
- background:#1CF3AC;
- width:80px;
- height:40px;
- position:absolute;
- left:53%;
- margin-top:10px;
- border:2px solid white;
- border-radius:10%;
- }
- .btn a{
- text-decoration:none;
- color:white;
- font-family: 'Tomorrow', sans-serif;
- font-size:17px;
- }
- .overlay{
- width: 0;
- height: 0;
- overflow: hidden;
- position: fixed;
- top:0;
- left: 0;
- background: rgba(0,0,0,0);
- z-index:9999;
- text-align: center;
- }
- .overlay:target{
- width: auto;
- height: auto;
- bottom: 0;
- right: 0;
- background: rgba(0,0,0,.6);
- color: black;
- transition-duration:1s;
- display: block;
- }
- .close {
- position: absolute;
- top: 15px;
- left: 97%;
- color: white;
- text-decoration: none;
- font-size: 30px;
- line-height: 14px;
- }
- .box{
- border: 2px solid black;
- background-color: #4C494D;
- opacity:0.8;
- border-radius:10%;
- width:500px;
- height:550px;
- position:absolute;
- top:50%;
- left:50%;
- transform:translate(-50%,-50%);
- color:#f4f4f4;
- }
- .box h1{
- text-transform:uppercase;
- font-weight:bold;
- margin-top:20px;
- font-family: 'Montserrat', sans-serif;
- }
- .text-box{
- width:200px;
- color:#959395;
- overflow:hidden;
- padding:5px 0;
- margin:5px 0;
- position:relative;
- top:50%;
- left:30%;
- margin-top:8px;
- }
- .text-box input{
- width:500px;
- backgroune:none;
- color:black;
- font-size:15px;
- margin:0 70px 0 0;
- font-family: 'Tomorrow', sans-serif;
- }
- .text-box label{
- font-family: 'Tomorrow', sans-serif;
- color:white;
- margin-left:2px;
- float:left;
- text-align:center;
- font-size:16px;
- }
- #submit{
- width:100px;
- background:#A1A0A0;
- border:2px solid white;
- color:black;
- padding: 5px;
- font-size:18px;
- cursor:pointer;
- margin:12px 0;
- font-family: 'Tomorrow', sans-serif;
- }
- </style>
- </head>
- <body>
- <header>
- <h1>Web Praktikum</h1>
- <p>Kumpulan Tugas Tugas Praktikum</p>
- </header>
- <nav>
- <ul class="navbar">
- <li><a href="../../Home/index.html">Home</a></li>
- <li><a href="prak.html"class="active">Praktikum</a></li>
- <li><a href="saran.html">Saran</a></li>
- </ul>
- <div>
- <ul class="sidebar">
- <li><a href="../Praktikum 1/prak1.html">Praktikum 1</a></li>
- <li><a href="../Praktikum 2/prak2.html">Praktikum 2</a></li>
- <li><a href="prak.html">Praktikum 3</a></li>
- <li><a href="../Praktikum 4/prak4.html">Praktikum 4</a></li>
- <li><a href="prak.html">Praktikum 5</a></li>
- <li><a href="../Praktikum 6/prak6.html">Praktikum 6</a></li>
- <li><a href="../Praktikum 6/index.php">Praktikum 7</a></li>
- <li><a href="../Praktikum 8/prak8.php">Praktikum 8</a></li>
- <li><a href="../Praktikum 9/prak9.php">Praktikum 9</a></li>
- <li><a href="prak.html"class="active">Praktikum 10</a></li>
- </ul>
- </div>
- </nav>
- <content>
- <div class="judul">
- <h2>Biodata</h2>
- </div>
- <hr>
- <?php
- //memanggil database
- include "koneksi.php";
- $sql = "SELECT * FROM datadiri";
- $result = $koneksi->query($sql);
- // mengubah query di database menjadi variabel
- foreach($result as $res){
- $id = $res["id"];
- $nama = $res["nama"];
- $gambar = $res["gambar"];
- $jenis = $res["jenis_kelamin"];
- $ttl = $res["ttl"];
- $alamat = $res["alamat"];
- $no = $res["no_hp"];
- $angkat = $res["angkat"];
- $email = $res["email"];
- // output untuk php
- echo "<img src='$gambar'>";
- echo "<div class='container'><div class='nama'>$nama, <span>$angkat</span></div>";
- echo "<div class='email'>$email</div>";
- echo "<div class='ttl'>$ttl <span>$jenis</span></div>";
- echo "<div class='alamat'>$alamat</div>";
- echo "<div class='no'>$no</div></div>";
- }
- ?>
- <button class="btn"><a href=#btn>Edit</a></button>
- <div class="overlay" id="btn">
- <?php
- include 'koneksi.php';
- var_dump($_POST);
- if (isset($_POST['submit'])){
- $id = $_POST["id"];
- $nama = $_POST["nama"];
- $gambar = $_POST["gambar"];
- $jenis = $_POST["jenis_kelamin"];
- $ttl = $_POST["ttl"];
- $alamat = $_POST["alamat"];
- $no = $_POST["no_hp"];
- $angkat = $_POST["angkat"];
- $email = $_POST["email"];
- $sql = "UPDATE datadiri SET nama ='$nama', gambar ='$gambar',
- jenis_kelamin ='$jenis', alamat ='$alamat', no_hp ='$no',
- angkat ='$angkat',email ='$email' WHERE id = '$id'";
- if($koneksi->query($sql) == TRUE){
- echo "<script>
- alert('Succes')
- </script>";
- }
- else {
- echo "<script>
- alert('Data gagal dirubah')
- </script>";
- }
- }
- ?>
- <a href="#" class="close">X</a>
- <div class="box">
- <h1>Edit Profile</h1>
- <form method="post" action="<?= $_SERVER['PHP_SELF'];?>">
- <div class="text-box">
- <input type="text" name="id" value="<?= $id;?>">
- </div>
- <div class="text-box">
- <label for="nama">Nama</label>
- <input type="text" name="nama" value="<?= $nama;?>">
- </div>
- <div class="text-box">
- <label for="jenis_kelamin">Jenis Kelamin</label>
- <input type="text" name="jenis_kelamin"id="jenis_kelamin" value="<?= $jenis;?>">
- </div>
- <div class="text-box">
- <label for="ttl">Tempat Tanggal Lahir</label>
- <input type="text" name="ttl"id="ttl" value="<?= $ttl;?>" aria-describedy="namaUser">
- </div>
- <div class="text-box">
- <label for="alamat">Alamat</label>
- <input type="text" name="alamat"id="alamat" value="<?= $alamat;?>" aria-describedy="namaUser">
- </div>
- <div class="text-box">
- <label for="no_hp">No HP</label>
- <input type="text" name="no_hp"id="no_hp" value="<?= $no;?>" aria-describedy="namaUser">
- </div>
- <div class="text-box">
- <label for="angkat">Angkatan</label>
- <input type="text" name="angkat"id="angkat" value="<?= $angkat;?>" aria-describedy="namaUser">
- </div>
- <div class="text-box">
- <label for="email">Email</label>
- <input type="text" name="email"id="email" value="<?= $email;?>" aria-describedy="namaUser">
- </div>
- <input type="submit" name="submit" id="submit">
- </form>
- </div>
- </div>
- </content>
- <footer>
- <div>Copyright @ 2019 Created by Gusti Muhammad Aulia Nur Sulthan </div>
- </footer>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement