kok fungsi update saya gagal terus yah...

 
<?php
    //Koneksi Database
    $server = "localhost";
    $user = "root";
    $pass = "";
    $database = "aplikasipanjar";

    $koneksi = mysqli_connect($server, $user, $pass, $database)or die(mysqli_error($koneksi));

    
//jika tombol simpan diklik

if(isset($_POST['bsimpan']))
    
{
    //Pengujian Apakah data akan diedit atau disimpan baru
    if($_GET['hal'] == "edit")
    {
        //Data akan di edit
        $edit = mysqli_query($koneksi, "UPDATE biayagugatan SET
                                             id_rad = '$_POST[trad]',
                                             radius = '$_POST[tradius]',
                                             
                                         WHERE id_no = '$_GET[id]'
                                       ");
        if($edit) //jika edit sukses
        {

            echo "<script>
                    alert('Edit data suksess!');
                    document.location='index.php';
                 </script>";
        }
        else
        {
            echo "<script>
                    alert('Edit data GAGAL!!');
                    document.location='index.php';
                 </script>";
        }
    }
    else
    {
        //Data akan disimpan Baru
        $simpan = mysqli_query($koneksi, "INSERT INTO biayagugatan (id_rad, radius)
                                      VALUES ('$_POST[trad]',  
                                               '$_POST[tradius]')
                                     ");
        if($simpan) //jika simpan sukses
        {
            echo "<script>
                    alert('Simpan data suksess!');
                    document.location='index.php';
                 </script>";
        }
        else
        {
            echo "<script>
                    alert('Simpan data GAGAL!!');
                    document.location='index.php';
                 </script>";
        }
    }


    
}

    //Pengujian jika tombol Edit / Hapus di klik
    if(isset($_GET['hal']))
    {
        //Pengujian jika edit Data
        if($_GET['hal'] == "edit")
        {
            //Tampilkan Data yang akan diedit
            $tampil = mysqli_query($koneksi, "SELECT * FROM biayagugatan WHERE id_no = '$_GET[id]' ");
            $data = mysqli_fetch_array($tampil);
            if($data)
            {
                //Jika data ditemukan, maka data ditampung ke dalam variabel
                $vrad = $data['id_rad'];
                $vradius = $data['radius'];
            }
        }
        else if ($_GET['hal'] == "hapus")
        {
            //Persiapan hapus data
            $hapus = mysqli_query($koneksi, "DELETE FROM biayagugatan WHERE id_no = '$_GET[id]' ");
            if($hapus){
                echo "<script>
                        alert('Hapus Data Suksess!!');
                        document.location='index.php';
                     </script>";
            }
        }
    }

?>

<!DOCTYPE html>
<html>
<head>
    <title>CRUD 2020 PHP & MySQL + Bootstrap 4</title>
    <link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
</head>
<body>
<div class="container">

    <h1 class="text-center">Halaman Radius</h1>
    <h2 class="text-center">Test</h2>

    <!-- Awal Card Form -->
    <div class="card mt-3">
      <div class="card-header bg-primary text-white">
        Form Input
      </div>
      <div class="card-body">
        <form method="post" action="">
            <div class="form-group">
                <label>Radius</label>
                <input type="text" name="trad" value="<?=@$vrad?>" class="form-control" placeholder="Input disini!" required>
            </div>
            <div class="form-group">
                <label>Biaya Radius</label>
                <input type="text" name="tradius" value="<?=@$vradius?>" class="form-control" placeholder="Input disini!" required>
            </div>
            <button type="submit" class="btn btn-success" name="bsimpan">Simpan</button>
            <button type="reset" class="btn btn-danger" name="breset">Kosongkan</button>
        </form>
      </div>
    </div>
    <!-- Akhir Card Form -->

    <!-- Awal Card Tabel -->
    <div class="card mt-3">
      <div class="card-header bg-success text-white">
        Daftar Mahasiswa
      </div>
      <div class="card-body">
        
        <table class="table table-bordered table-striped">
            <tr>
                <th>No.</th>
                <th>Radius</th>
                <th>Biaya Radius</th>
                <th>Aksi</th>
            </tr>
            <?php
                $no = 1;
                $tampil = mysqli_query($koneksi, "SELECT * from biayagugatan order by id_no desc");
                while($data = mysqli_fetch_array($tampil)) :

            ?>
            <tr>
                <td><?=$no++;?></td>
                <td><?=$data['id_rad']?></td>
                <td><?=$data['radius']?></td>
                <td>
                    <a href="index.php?hal=edit&id=<?=$data['id_no']?>" class="btn btn-warning"> Edit </a>
                    <a href="index.php?hal=hapus&id=<?=$data['id_no']?>" 
                       onclick="return confirm('Apakah yakin ingin menghapus data ini?')" class="btn btn-danger"> Hapus </a>
                </td>
            </tr>
        <?php endwhile; //penutup perulangan while ?>
        </table>

      </div>
    </div>
    <!-- Akhir Card Tabel -->

</div>

<script type="text/javascript" src="js/bootstrap.min.js"></script>
</body>
</html> 
avatar ganemchannel

@ganemchannel

1 Kontribusi 0 Poin

  • Baca aturan main di forum ini ya. Biasakan bikin judul yang relevan. contoh "kode update PHP gagal". 2. Tuliskan penjelasan di pertanyaan kamu, jangan hanya copy paste kodenya - @hilmanski


Jawaban

Ubah bagian :
$edit = mysqli_query($koneksi, "UPDATE biayagugatan SET
                                             id_rad = '$_POST[trad]',
                                             radius = '$_POST[tradius]',
                                             
                                         WHERE id_no = '$_GET[id]'
                                       ");
Menjadi :
$edit = mysqli_query($koneksi, "UPDATE biayagugatan SET
                                             id_rad = '$_POST[trad]',
                                             radius = '$_POST[tradius]'
                                             
                                         WHERE id_no = '$_GET[id]'
                                       ");

Note : Kelebihan koma itu, lain kali teliti ya 😁

Semoga membantu
avatar syahid246

@syahid246

66 Kontribusi 155 Poin


Login untuk gabung berdiskusi
premium logo tube

Hey, sedang ada diskon premium untuk akses semua kelas. Lihat di sini