Postingan lainnya
Cara edit data user yang sudah login
Tolong dong ane udh pasrah, ini knp data nya gak mau dibuka pas mau ngeklik edit profile slalu ngeblank tolong bantuan nya,
PROFILE.PHP
<?php
session_start();
include('admin.session.php');
include("header.php"); // memanggil file header.php
include("menu.php"); // memanggil file header.php
?>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Admin</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<link rel="shortcut icon" href="../img/favicon.png"/>
<link href="../css/bootstrap.min.css" rel="stylesheet" media="screen">
<style>
body{
background-image: url(../img/body.jpg);
background-repeat: repeat;
background-attachment: fixed;
}
</style>
</head>
<body>
<div class="container">
<div class="content">
<h2>Profile</h2>
<hr />
<?php
$username = $_SESSION['username']; // mengambil username dari session yang login
$sql = $conn->query("SELECT * FROM admin WHERE username='$username'"); // query memilih entri username pada database
if(mysqli_num_rows($sql) == 0){
}else{
$row = mysqli_fetch_assoc($sql);
}
?>
<!-- bagian ini digunakan untuk menampilkan data profile -->
<table class="table table-striped table-condensed">
<tr>
<th>Username</th>
<td><?php echo $row['username']; ?></td>
</tr>
<tr>
<th>Password</th>
<td><?php echo $row['password']; ?></td>
</tr>
<tr>
<th width="20%">Nama</th>
<td><?php echo $row['nama']; ?></td>
</tr>
<tr>
<th>Email</th>
<td><?php echo $row['email']; ?></td>
</tr>
<tr>
<th>Level</th>
<td><?php echo $row['level']; ?></td>
</tr>
</table>
<a href="admin.update.php?id=<?php echo $id;?>" class="btn btn-sm btn-success"><span class="glyphicon glyphicon-edit" aria-hidden="true"></span> Edit Profile</a>
</div> <!-- /.content -->
</div> <!-- /.container -->
ADMIN.UPDATE.PHP
<?php
session_start();
include_once('admin.session.php');
$id = $_GET['id'];
$sql = $conn->query("select * from admin where id_user='$id'");
$data = mysqli_fetch_array($sql);
if(mysqli_num_rows($sql) > 0){
$username = $data['username'];
$password = $data['password'];
$nama = $data['nama'];
$email = $data['email'];
$level = $data['level'];
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Edit Admin</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<link rel="shortcut icon" href="../img/favicon.png"/>
<link href="../css/bootstrap.min.css" rel="stylesheet" media="screen">
<style>
body{
background-image: url(../img/body.jpg);
background-repeat: repeat;
background-attachment: fixed;
}
</style>
</head>
<body>
<?php
include_once('menu.php');
?>
<div class="container">
<div class="navbar-inner" style="border:1px solid #bbb; border-radius:10px; padding:10px 20px 10px 20px; margin-top:50px; margin-left:auto; margin-right:auto;">
<div class="modal-header">
<h3>Edit Admin</h3>
</div>
<div style="margin-top:10px;">
<form class="form-horizontal" name="form1" method="post" action="" enctype="multipart/form-data">
<div class="control-group">
<label class="control-label" for="username">Username</label>
<div class="controls">
<input name="username" type="text" id="username" class="input-large" value='<?php echo "$username";?>'>
</div>
</div>
<div class="control-group">
<label class="control-label" for="password">Password</label>
<div class="controls">
<input name="password" type="password" id="password" class="input-large" value='<?php echo "$password";?>'>
</div>
</div>
<div class="control-group">
<label class="control-label" for="nama">Nama</label>
<div class="controls">
<input name="nama" type="text" id="nama" class="input-large" value='<?php echo "$nama";?>'>
</div>
</div>
<div class="control-group">
<label class="control-label" for="phone">Email</label>
<div class="controls">
<input name="email" type="text" id="email" class="input-large" value='<?php echo "$email";?>'>
</div>
</div>
<div class="control-group">
<label class="control-label" for="level">Level</label>
<div class="controls">
<select class="form-control" name="level">
<option value="Manager">Manager</option>
<option value="Production">Production</option>
<option value="Warehouse">Warehouse</option>
</select>
</div>
</div>
<div class="control-group">
<label class="control-label" for="update"></label>
<div class="controls">
<input name="update" type="submit" id="update" value="Update" class="btn btn-success">
<input name="batal" type="submit" id="batal" value="Batal" class="btn btn-warning">
</div>
</div>
<?php }
if(isset($_POST['update'])){
$conn->query("update admin set
username = '$_POST[username]',
password = '$_POST[password]',
nama = '$_POST[nama]',
email = '$_POST[email]',
level = '$_POST[level]'
where id_user = '$id'") or die(mysqli_error);
echo "<script language=javascript>
window.alert('Edit Berhasil');
window.location='admin.php?hal=1';
</script>";
exit;
}
if(isset($_POST['batal'])){
echo "<script language=javascript>
window.location='admin.php?hal=1';
</script>";
exit;
}
?>
</form>
</div>
</div>
</div>
<br><br><br><br>
<script src="../js/jquery-1.8.3.min.js"></script>
<script src="../js/bootstrap.min.js"></script>
</body>
</html>
2 Jawaban:
Hai @ardharafano coba dibagian profile.php kamu ubah <pre> <a href="admin.update.php?id=<?php echo $id;?>" class="btn btn-sm btn-success"><span class="glyphicon glyphicon-edit" aria-hidden="true"></span> Edit Profile</a>
// ubah jadi <a href="admin.update.php?id=<?php echo $row['id'];?>" class="btn btn-sm btn-success"><span class="glyphicon glyphicon-edit" aria-hidden="true"></span> Edit Profile</a> </pre> semoga membantu
sama aja gan, dia nya gak ngehasilin id nya http://localhost:8083/ayam/prod/admin.update.php?id=
ane sih curiga di coadingan nya admin.update.php gan ada yg salah mungkin
<img src='https://i.ibb.co/k32Y0xr/3.png'>
Tanggapan
Coba die dump querynya. die(var_dump($row)). Pastikan nama kolom idnya
thx gan, masalahnya di id nya ternyata. problem solved
ini dimana ya tambah var dumbnya?