Display Selected Value Combobox di PHPDisplay Selected Value Combobox di PHP, mungkin anda pernah menginginkan hasil nilai yang di pilih di combobox padasaat input ketika di edit maka value atau nilai yang di pilih tersebut muncul, jika ya maka selamat anda sudah berada di tempat yang tepat. -- phpMyAdmin SQL Dump -- version 4.8.3 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 05, 2019 at 06:36 AM -- Server version: 10.1.35-MariaDB -- PHP Version: 7.1.21 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */; /*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */; /*!40101 SET @[email protected]@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `hrd` -- -- -------------------------------------------------------- -- -- Table structure for table `karyawan` -- CREATE TABLE `karyawan` ( `nik` varchar(10) NOT NULL, `nama` varchar(100) NOT NULL, `tanggal_masuk` date NOT NULL, `departemen` varchar(50) NOT NULL, `jabatan` varchar(50) NOT NULL, `status` enum('TETAP','PKWT','PKWTT') NOT NULL, `jumlah_cuti` varchar(10) NOT NULL, `username` varchar(50) NOT NULL, `password` text NOT NULL, `level` enum('Admin','Superuser','User') NOT NULL, `gambar` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `karyawan` -- INSERT INTO `karyawan` (`nik`, `nama`, `tanggal_masuk`, `departemen`, `jabatan`, `status`, `jumlah_cuti`, `username`, `password`, `level`, `gambar`) VALUES ('10161', 'Hakko Bio Richard', '2018-04-21', 'IT', 'Supervisor', 'PKWTT', '6', 'hakko', 'fb92eb16a09ed530c91a0e17d9d61a7758754013', 'Admin', 'gambar_admin/5.jpg'), ('10222', 'Dede Rizki', '2017-07-30', 'HRGA', 'Supervisor', 'TETAP', '0', 'test', 'c4033bff94b567a190e33faa551f411caef444f2', 'Admin', 'gambar_admin/4.jpg'), ('12132', 'Dimas', '2018-06-01', 'Accounting', 'Supervisor', 'PKWTT', '9', 'test', 'c4033bff94b567a190e33faa551f411caef444f2', 'Admin', 'gambar_admin/4.jpg'), ('1232434', 'Doni', '2018-10-09', 'IT', 'Supervisor', 'PKWTT', '12', 'testing', '4c0d2b951ffabd6f9a10489dc40fc356ec1d26d5', 'Admin', 'gambar_admin/cuti.jpg'); -- -- Indexes for dumped tables -- -- -- Indexes for table `karyawan` -- ALTER TABLE `karyawan` ADD PRIMARY KEY (`nik`); COMMIT; /*!40101 SET [email protected]_CHARACTER_SET_CLIENT */; /*!40101 SET [email protected]_CHARACTER_SET_RESULTS */; /*!40101 SET [email protected]_COLLATION_CONNECTION */;
Ketika file tersebut dijalankan maka akan muncul combo box dengan selected data yang di ambil dari databse yang sudah di buat, artinya jika anda sudah membuat sebuah halaman view data maka ketika klik button edit selanjutnya di arahkan ke
halaman edit.php yang sudah di buat. $db_host = "localhost"; $db_user = "root"; $db_pass = ""; $db_name = "hrd"; $koneksi = mysqli_connect($db_host, $db_user, $db_pass, $db_name); if(mysqli_connect_errno()){ echo 'Gagal melakukan koneksi ke Database : '.mysqli_connect_error(); }
$sql = mysqli_query($koneksi, "SELECT * FROM karyawan WHERE nik='$kd'"); if(mysqli_num_rows($sql) == 0){ header("Location: karyawan.php"); }else{ $row = mysqli_fetch_assoc($sql); }
<div class="form-group"> <label class="col-sm-2 col-sm-2 control-label">Status</label> <div class="col-sm-4"> <select name="status" id="status" class="form-control" required="required"> <option value="">----- Pilih Status -----</option> <?php $statuskerja = $row['status']; ?> <option <?=($statuskerja=='TETAP')?'selected="selected"':''?>>TETAP</option> <option <?=($statuskerja=='PKWT')?'selected="selected"':''?>>PKWT</option> <option <?=($statuskerja=='PKWTT')?'selected="selected"':''?>>PKWTT</option> </select> </div> </div>
|