1. Halo Guest, pastikan Anda selalu menaati peraturan forum sebelum mengirimkan post atau thread baru.

Izin Konsultasi tentang Form CRUD dalam PHP

Discussion in 'Pemrograman Web' started by biakmanini, Dec 13, 2022.

  1. biakmanini

    biakmanini Newbie

    Joined:
    Feb 15, 2019
    Messages:
    5
    Likes Received:
    0
    Mohon izin minta bantuan terkait aplikasi CRUD php untuk pendataan pegawai dengan CRUD ( source codenya dapat dari youtube); tapi ketemu permasalahan dimana saat tambah pegawai ternyata dari script nya wajib upload foto (kalo foto tdk dipilih; datanya otomatis tdk akan terekam. Ini gimana ya edit di script nya biar dihapus bagian wajib upload foto nya

    Ini screnshoot saat tambah pegawai
    Code:
    prnt.sc/huE5XNCS_u9C
    Ini script dalam php nya
    Code:
    <div class="card card-primary">
        <div class="card-header">
            <h3 class="card-title">
                <i class="fa fa-edit"></i> Tambah Data</h3>
        </div>
        <form action="" method="post" enctype="multipart/form-data">
            <div class="card-body">
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">NIP</label>
                    <div class="col-sm-5">
                        <input type="text" class="form-control" id="nip" name="nip" placeholder="NIP" required>
                    </div>
                </div>
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">Nama Pegawai</label>
                    <div class="col-sm-5">
                        <input type="text" class="form-control" id="nama" name="nama" placeholder="Nama Pegawai" required>
                    </div>
                </div>
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">Alamat</label>
                    <div class="col-sm-10">
                        <input type="text" class="form-control" id="alamat" name="alamat" placeholder="Alamat" required>
                    </div>
                </div>
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">No HP</label>
                    <div class="col-sm-5">
                        <input type="text" class="form-control" id="no_hp" name="no_hp" placeholder="No HP" required>
                    </div>
                </div>
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">Status</label>
                    <div class="col-sm-5">
                        <select name="status" id="status" class="form-control">
                            <option>- Pilih -</option>
                            <option>Pegawai</option>
                            <option>Honorer</option>
                        </select>
                    </div>
                </div>
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">Jabatan</label>
                    <div class="col-sm-5">
                        <input type="text" class="form-control" id="jabatan" name="jabatan" placeholder="No HP" required>
                    </div>
                </div>
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">Foto Pegawai</label>
                    <div class="col-sm-6">
                        <input type="file" id="foto" name="foto">
                        <p class="help-block">
                            <font color="red">"Format file Jpg/Png"</font>
                        </p>
                    </div>
                </div>
    
            </div>
            <div class="card-footer">
                <input type="submit" name="Simpan" value="Simpan" class="btn btn-info">
                <a href="?page=data-pegawai" title="Kembali" class="btn btn-secondary">Batal</a>
            </div>
        </form>
    </div>
    
    <?php
        $sumber = @$_FILES['foto']['tmp_name'];
        $target = 'foto/';
        $nama_file = @$_FILES['foto']['name'];
        $pindah = move_uploaded_file($sumber, $target.$nama_file);
    
        if (isset ($_POST['Simpan'])){
    
            if(!empty($sumber)){
            $sql_simpan = "INSERT INTO tb_pegawai (nip, nama, alamat, no_hp, status, jabatan, foto) VALUES (
                '".$_POST['nip']."',
                '".$_POST['nama']."',
                '".$_POST['alamat']."',
                '".$_POST['no_hp']."',
                '".$_POST['status']."',
                '".$_POST['jabatan']."',
                '".$nama_file."')";
            $query_simpan = mysqli_query($koneksi, $sql_simpan);
            mysqli_close($koneksi);
    
        if ($query_simpan) {
          echo "<script>
          Swal.fire({title: 'Tambah Data Berhasil',text: '',icon: 'success',confirmButtonText: 'OK'
          }).then((result) => {if (result.value){
              window.location = 'index.php?page=data-pegawai';
              }
          })</script>";
          }else{
          echo "<script>
          Swal.fire({title: 'Tambah Data Gagal',text: '',icon: 'error',confirmButtonText: 'OK'
          }).then((result) => {if (result.value){
              window.location = 'index.php?page=add-pegawai';
              }
          })</script>";
        }
        }elseif(empty($sumber1)){
            echo "<script>
            Swal.fire({title: 'Gagal, Foto Wajib Diisi',text: '',icon: 'error',confirmButtonText: 'OK'
            }).then((result) => {
                if (result.value) {
                    window.location = 'index.php?page=add-pegawai';
                }
            })</script>";
        }
        }
         //selesai proses simpan data
    
    
    Mohon bantuannya. Terima kasih banyak
     
  2. JAMBAL

    JAMBAL Ads.id Pro

    Joined:
    Aug 13, 2014
    Messages:
    261
    Likes Received:
    24
    Mungkin seperti ini yang dimaksud
    Code:
    <div class="card card-primary">
        <div class="card-header">
            <h3 class="card-title">
                <i class="fa fa-edit"></i> Tambah Data
            </h3>
        </div>
        <form action="" method="post" enctype="multipart/form-data">
            <div class="card-body">
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">NIP</label>
                    <div class="col-sm-5">
                        <input type="text" class="form-control" id="nip" name="nip" placeholder="NIP" required>
                    </div>
                </div>
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">Nama Pegawai</label>
                    <div class="col-sm-5">
                        <input type="text" class="form-control" id="nama" name="nama" placeholder="Nama Pegawai" required>
                    </div>
                </div>
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">Alamat</label>
                    <div class="col-sm-10">
                        <input type="text" class="form-control" id="alamat" name="alamat" placeholder="Alamat" required>
                    </div>
                </div>
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">No HP</label>
                    <div class="col-sm-5">
                        <input type="text" class="form-control" id="no_hp" name="no_hp" placeholder="No HP" required>
                    </div>
                </div>
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">Status</label>
                    <div class="col-sm-5">
                        <select name="status" id="status" class="form-control">
                            <option>- Pilih -</option>
                            <option>Pegawai</option>
                            <option>Honorer</option>
                        </select>
                    </div>
                </div>
    
                <div class="form-group row">
                    <label class="col-sm-2 col-form-label">Jabatan</label>
                    <div class="col-sm-5">
                        <input type="text" class="form-control" id="jabatan" name="jabatan" placeholder="No HP" required>
                    </div>
                </div>
    
            </div>
            <div class="card-footer">
                <input type="submit" name="Simpan" value="Simpan" class="btn btn-info">
                <a href="?page=data-pegawai" title="Kembali" class="btn btn-secondary">Batal</a>
            </div>
        </form>
    </div>
    
    <?php
    if (isset($_POST['Simpan'])) {
        $sql_simpan = "INSERT INTO tb_pegawai (nip, nama, alamat, no_hp, status, jabatan) VALUES (
                '" . $_POST['nip'] . "',
                '" . $_POST['nama'] . "',
                '" . $_POST['alamat'] . "',
                '" . $_POST['no_hp'] . "',
                '" . $_POST['status'] . "',
                '" . $_POST['jabatan'] . "')";
        $query_simpan = mysqli_query($koneksi, $sql_simpan);
        mysqli_close($koneksi);
    
        if ($query_simpan) {
            echo "<script>
          Swal.fire({title: 'Tambah Data Berhasil',text: '',icon: 'success',confirmButtonText: 'OK'
          }).then((result) => {if (result.value){
              window.location = 'index.php?page=data-pegawai';
              }
          })</script>";
        } else {
            echo "<script>
          Swal.fire({title: 'Tambah Data Gagal',text: '',icon: 'error',confirmButtonText: 'OK'
          }).then((result) => {if (result.value){
              window.location = 'index.php?page=add-pegawai';
              }
          })</script>";
        }
    }
         //selesai proses simpan data
    
     
    Last edited: Dec 13, 2022
    biakmanini likes this.
  3. biakmanini

    biakmanini Newbie

    Joined:
    Feb 15, 2019
    Messages:
    5
    Likes Received:
    0
    Alhamdulillah. Sempurna sesuai keinginan . Terima kasih banyak
     
  4. biakmanini

    biakmanini Newbie

    Joined:
    Feb 15, 2019
    Messages:
    5
    Likes Received:
    0
    Izin konsultasi gan. Secara default pada aplikasi CRUD nya (data_pegawai.php) ; otomatis akan tampilkan semua data yang sudah pernah di entry (tiap halaman ada 10 baris ); tampilan nya seperti ini
    Code:
    prnt.sc/a6MGmqSHpxih
    . Ada gak ya cara supaya ketika diakses data_pegawai.php yang tampil tanpa data ; tapi ketika kita search hasilnya akan tetap tampil ?

    Ini script data pegawai nya
    Code:
    <div class="card card-info">
        <div class="card-header">
            <h3 class="card-title">
                <i class="fa fa-table"></i> Data Pegawai</h3>
        </div>
        <!-- /.card-header -->
        <div class="card-body">
            <div class="table-responsive">
                <div>
                    <a href="?page=add-pegawai" class="btn btn-primary">
                        <i class="fa fa-edit"></i> Tambah Data</a>
                </div>
                <br>
                <table id="example1" class="table table-bordered table-striped">
                    <thead>
                        <tr>
                            <th>No</th>
                           
                            <th>NIP</th>
                            <th>Nama</th>
                            <th>Jabatan</th>
                            <th>Aksi</th>
                        </tr>
                    </thead>
                    <tbody>
    
                        <?php
                  $no = 1;
                  $sql = $koneksi->query("SELECT * from tb_pegawai");
                  while ($data= $sql->fetch_assoc()) {
                ?>
    
                        <tr>
                            <td>
                                <?php echo $no++; ?>
                            </td>
                           
                            <td>
                                <?php echo $data['nip']; ?>
                            </td>
                            <td>
                                <?php echo $data['nama']; ?>
                            </td>
                            <td>
                                <?php echo $data['jabatan']; ?>
                            </td>
    
                            <td>
                                <a href="?page=view-pegawai&kode=<?php echo $data['nip']; ?>" title="Detail"
                                class="btn btn-info btn-sm">
                                    <i class="fa fa-eye"></i>
                                </a>
                                </a>
                                <a href="?page=edit-pegawai&kode=<?php echo $data['nip']; ?>" title="Ubah" class="btn btn-success btn-sm">
                                    <i class="fa fa-edit"></i>
                                </a>
                               
                            </td>
                        </tr>
    
                        <?php
                  }
                ?>
                    </tbody>
                    </tfoot>
                </table>
            </div>
        </div>
        <!-- /.card-body -->
    
    Mohon bantuan nya lagi
     
  5. JAMBAL

    JAMBAL Ads.id Pro

    Joined:
    Aug 13, 2014
    Messages:
    261
    Likes Received:
    24
    Kalo mau ngilangin datanya, hapus aja table nya
     
    biakmanini likes this.
  6. biakmanini

    biakmanini Newbie

    Joined:
    Feb 15, 2019
    Messages:
    5
    Likes Received:
    0
    Kalo table nya hilang; kolom search juga hilang. Pengen nya data table tidak tampil saat diakses pertama kali (tapi kolom search tetap ada). Ketika kita serach ; data table nya akan muncul sesuai dengan keyword nya. Atau Ada yg punya skript pencarian sederhana ( dlm bentuk php) + hasilnya dalam bentuk tabel gak ya
     

Share This Page