CRUD ADMIN PHP
Marvels Code
Mei 31, 2023
0
Komentar
<?php
$pro = "simpan";
$nama_admin = "";
$telepon = "";
$email = "";
$username = "";
$password = "";
$status = "Aktif";
$keterangan = "";
?>
<script type="text/javascript">
	function PRINT() {
		win = window.open('admin/admin_print.php', 'win', 'width=1000, height=400, menubar=0, scrollbars=1, resizable=0, location=0, toolbar=0, status=0');
	}
</script>
<?php
$sql = "select `id_admin` from `$tbadmin` order by `id_admin` desc";
$jum = getJum($conn, $sql);
$kd = "ADM";
if ($jum > 0) {
	$d = getField($conn, $sql);
	$idmax = $d['id_admin'];
	$urut = substr($idmax, 3, 2) + 1; //01
	if ($urut < 10) {
		$idmax = "$kd" . "0" . $urut;
	} else {
		$idmax = "$kd" . $urut;
	}
} else {
	$idmax = "$kd" . "01";
}
$id_admin = $idmax;
?>
<?php
$lbl = "Tambah Data Admin";
if (isset($_GET["pro"]) && $_GET["pro"] == "ubah") {
	$id_admin = $_GET["kode"];
	$sql = "select * from `$tbadmin` where `id_admin`='$id_admin'";
	$d = getField($conn, $sql);
	$id_admin = $d["id_admin"];
	$id_admin0 = $d["id_admin"];
	$nama_admin = $d["nama_admin"];
	$username = $d["username"];
	$password = $d["password"];
	$telepon = $d["telepon"];
	$email = $d["email"];
	$status = $d["status"];
	$keterangan = $d["keterangan"];
	$pro = "ubah";
	$lbl = "Ubah Data Admin";
}
if (isset($_GET["pro"]) && ($_GET["pro"] == "ubah" || $_GET["pro"] == "add")) {
?>
	
<h3><?php echo $lbl ?></h3>
	<form action="" method="post" enctype="multipart/form-data">
		<table class="table">
			<tr>
				<th width="15%"><label for="id_admin">ID Admin</label>
				<th width="9">:
				<th colspan="2"><b><?php echo $id_admin; ?></b>
			</tr>
			<tr>
				<td><label for="nama_admin">Nama Admin</label>
				<td>:
				<td width="683"><input style="width: 350px" required name="nama_admin" class="form-control" type="text" id="nama_admin" value="<?php echo $nama_admin; ?>" size="25" /></td>
			</tr>
			<tr>
				<td height="24"><label for="telepon">Telepon</label>
				<td>:
				<td><input required style="width: 170px" name="telepon" class="form-control" type="number" id="telepon" value="<?php echo $telepon; ?>" size="25" /></td>
			</tr>
			<tr>
				<td height="24"><label for="email">Email</label>
				<td>:
				<td><input required style="width: 550px" name="email" class="form-control" type="email" id="email" value="<?php echo $email; ?>" size="25" /></td>
			</tr>
			<tr>
				<td height="24"><label for="username">Username</label>
				<td>:
				<td><input required style="width: 250px" name="username" class="form-control" type="text" id="username" value="<?php echo $username; ?>" size="25" /></td>
			</tr>
			<tr>
				<td height="24"><label for="password">Password</label>
				<td>:
				<td><input required style="width: 250px" name="password" class="form-control" type="password" id="password" value="<?php echo $password; ?>" size="25" /></td>
			</tr>
			<?php
			if (isset($_GET["pro"]) && $_GET["pro"] == "ubah") {
			?>
				<tr>
					<td><label for="status">Status</label>
					<td>:
					<td colspan="2">
						<input type="radio" name="status" id="status" checked="checked" value="Aktif" <?php if ($status == "Aktif") {
																											echo "checked";
																										} ?> />Aktif
						<input type="radio" name="status" id="status" value="Tidak Aktif" <?php if ($status == "Tidak Aktif") {
																								echo "checked";
																							} ?> />Tidak Aktif
					</td>
				</tr>
				<tr>
					<td height="24"><label for="keterangan">Keterangan</label>
					<td>:
					<td>
						<textarea name="keterangan" class="form-control" cols="55" rows="2"><?php echo $keterangan; ?></textarea>
					</td>
				</tr>
			<?php
			}
			?>
			<tr>
				<td>
				<td>
				<td colspan="2">
					<input name="Simpan" class="btn btn-success" type="submit" id="Simpan" value="Simpan" />
					<input name="pro" type="hidden" id="pro" value="<?php echo $pro; ?>" />
					<input name="id_admin" type="hidden" id="id_admin" value="<?php echo $id_admin; ?>" />
					<input name="id_admin0" type="hidden" id="id_admin0" value="<?php echo $id_admin0; ?>" />
					<a href="?mnu=admin"><input class="btn btn-secondary" name="Batal" type="button" id="Batal" value="Batal" /></a>
				</td>
			</tr>
		</table>
	</form>
<?php
}
?>
<h3>Laporan Data Admin:</h3>
Data Admin
| <img src='ypathicon/print.png' title='Cetak Print/Pdf' OnClick="PRINT()">
| <a href='?mnu=admin&pro=add'><img src='ypathicon/adds.png' title='Tambah Data'></a> |
<hr>
<script src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js"></script>
<script>
	$(document).ready(function() {
		$('#examplec').DataTable();
	});
</script>
<link rel="stylesheet" href="https://cdn.datatables.net/1.11.3/css/jquery.dataTables.min.css">
<table id="examplec" class="display" style="width:100%">
	<thead>
		<tr>
			<th width="3%">
				<center>No
			</th>
			<th width="7%">ID Admin</th>
			<th width="20%">Nama Admin</th>
			<th width="10%">
				<center>Telepon
			</th>
			<th width="5%">
				<center>Status
			</th>
			<th width="15%">Keterangan</th>
			<th width="5%">
				<center>Menu
			</th>
		</tr>
	</thead>
	<tbody>
		<?php
		$sql = "select * from `$tbadmin` order by `id_admin` asc";
		$jum = getJum($conn, $sql);
		if ($jum > 0) {
			$no = 1;
			$arr = getData($conn, $sql);
			foreach ($arr as $d) {
				$id_admin = $d["id_admin"];
				$nama_admin = ucwords($d["nama_admin"]);
				$username = $d["username"];
				$password = $d["password"];
				$telepon = $d["telepon"];
				$email = $d["email"];
				$status = $d["status"];
				$keterangan = $d["keterangan"];
				$color = "#fff";
				if ($no % 2 == 0) {
					$color = "#eeeeee";
				}
				echo "<tr bgcolor='$color'>
				<td align='center'>$no</td>
				<td>$id_admin</td>
				<td>$nama_admin</td>
				<td align='center'>$telepon</td>	
				<td align='center'>$status</td>	
				<td align='center'>$keterangan</td>
				<td><div align='center'>
<a href='?mnu=admin&pro=ubah&kode=$id_admin&nama_admin=$nama_admin'><img src='ypathicon/ub.png' title='ubah'></a>
<a href='?mnu=admin&pro=hapus&kode=$id_admin&nama_admin=$nama_admin'><img src='ypathicon/ha.png' title='hapus' 
onClick='return confirm(\"Apakah Anda benar-benar akan menghapus $nama_admin pada data admin ?..\")'></a></div></td>
				</tr>";
				$no++;
			} //for dalam
		} //if
		else {
			echo "<tr><td colspan='6'><blink>Maaf, Data admin belum tersedia...</blink></td></tr>";
		}
		?>
	</tbody>
</table>
<?php
if (isset($_POST["Simpan"])) {
        $pro = strip_tags($_POST["pro"]);
	$id_admin = strip_tags($_POST["id_admin"]);
	$username = strip_tags($_POST["username"]);
	$nama_admin = strip_tags($_POST["nama_admin"]);
	$password = strip_tags($_POST["password"]);
	$telepon = strip_tags($_POST["telepon"]);
	$email = strip_tags($_POST["email"]);
	if ($pro == "simpan") {
		$sql = " INSERT INTO `$tbadmin` (
					`id_admin` ,
					`nama_admin` ,
					`username` ,
					`password` ,
					`telepon` ,
					`email` ,
					`status` ,
					`keterangan`
					) VALUES (
					'$id_admin', 
					'$nama_admin',
					'$username',
					'$password', 
					'$telepon',
					'$email',
					'Aktif',
					''
					)";
		$simpan = process($conn, $sql);
		if ($simpan) {
			echo "<script>Message1('$header','index.php?mnu=admin',' Data \'$nama_admin\'... Sukses Tersimpan...');</script>";
		} else {
			echo "<script>Message2('$header','index.php?mnu=admin',' Data \'$nama_admin\'... Gagal disimpan...');</script>";
		}
	} else {
		$id_admin0 = strip_tags($_POST["id_admin0"]);
		$status = strip_tags($_POST["status"]);
		$keterangan = strip_tags($_POST["keterangan"]);
		$sql = "update `$tbadmin` set 
		`nama_admin`='$nama_admin',
		`email`='$email',
		`telepon`='$telepon',
		`username`='$username',
		`password`='$password',
		`status`='$status',
		`keterangan`='$keterangan' 
		where `id_admin`='$id_admin0'";
		$ubah = process($conn, $sql);
		if ($ubah) {
			echo "<script>Message1('$header','index.php?mnu=admin',' Data \'$nama_admin\'... Sukses diubah...');</script>";
		} else {
			echo "<script>Message2('$header','index.php?mnu=admin',' Data \'$nama_admin\'... Gagal diubah...');</script>";
		}
	} //else simpan
}
?>
<?php
if (isset($_GET["pro"]) && $_GET["pro"] == "hapus") {
	$id_admin = $_GET["kode"];
	$nama_admin = $_GET["nama_admin"];
	$sql = "delete from `$tbadmin` where `id_admin`='$id_admin'";
	$hapus = process($conn, $sql);
	if ($hapus) {
		echo "<script>Message1('$header','index.php?mnu=admin',' Data \'$nama_admin\'... Sukses dihapus...');</script>";
	} else {
		echo "<script>Message2('$header','index.php?mnu=admin',' Data \'$nama_admin\'... Gagal dihapus...');</script>";
	}
}
?>
 
 
0 Komentar