Tolong pilih kategori sesuai, jenis posting (pertanyaan atau bukan) dan sertakan tag/topik yang sesuai misal komputer, php, mysql, dll.
Promosi atau posting tidak pada tempatnya akan kami hapus.
HELP..buat form edit profil / user..????
Mohon bantuannya master..
tampilkan data user/user login udah bisa, tinggal edit datanya, saya bingung.....
ni contoh script tampil profil...
session_start();
if($_SESSION['ok'] != 'OK'){
header ("location:home.php");
} // memastikan user sudah login
include "con.php";
?>
<table align="center" width="600">
<?php
$sql='select * from juser where user="'.$_SESSION['user_id'].'" LIMIT 1';
$query=mysql_query($sql);
while($rows=mysql_fetch_array($query)){
echo '
<tr><td bgcolor="#ffffff" width="200"><b>
<font color="#666666" face="Arial Narrow" size="3"> Nama :
</font></b> </td><td bgcolor="#ffFFFF" width="228"><b>
<font color="#666666" face="Arial Narrow" size="3"> '.$rows['nama'].'</font></b></td></tr>
<tr><td bgcolor="#ffFFFF" width="167"><b>
<font color="#666666" face="Arial Narrow" size="3"> Email :
</font></b> </td><td bgcolor="#ffFFFF" width="228"><b>
<font color="#666666" face="Arial Narrow" size="3"> '.$rows['email'].'</font></b></td></tr>
<tr><td bgcolor="#ffFFFF" width="167"><b>
<font color="#666666" face="Arial Narrow" size="3"> Alamat / Kota :
</font></b> </td><td bgcolor="#ffFFFF" width="228"><b>
<font color="#666666" face="Arial Narrow" size="3"> '.$rows['alamat'].'</font></b></td></tr>
<tr><td bgcolor="#ffFFFF" width="167"><b>
<font color="#666666" face="Arial Narrow" size="3"> No. Telp / Hp :
</font></b> </td><td bgcolor="#ffFFFF" width="228"><b>
<font color="#666666" face="Arial Narrow" size="3"> '.$rows['hp'].'</font></b></td></tr>
<tr><td bgcolor="#ffFFFF" width="167"><b>
<font color="#666666" face="Arial Narrow" size="3"> Username :
</font></b> </td><td bgcolor="#ffFFFF" width="228"><b>
<font color="#666666" face="Arial Narrow" size="3"> '.$rows['user'].'</font></b></td></tr>
<tr><td bgcolor="#ffFFFF" width="167"><b>
<font color="#666666" face="Arial Narrow" size="3"> Password :
</font></b> </td><td bgcolor="#ffFFFF" width="228"><b>
<font color="#666666" face="Arial Narrow" size="3"> '.$rows['password'].'</font></b></td></tr>
<tr><td bgcolor="#ffFFFF" width="167"><b>
<font color="#666666" face="Arial Narrow" size="3"> Kode ID Klien :
</font></b> </td><td bgcolor="#ffFFFF" width="228"><b>
<font color="#666666" face="Arial Narrow" size="3"> '.$rows['id'].'</font></b></td></tr>
';}
?>
</table>
Mohon Bantuannya Master....???
Comments
yg diatas kan cuma 1 user
Tolong contoh scriptnya...
ini alur umum, ntah situ modelnya gimana,
kalo beda ... paparin yg jelas
- registrasi, bisa oleh user bersangkutan atau di registrasi admin via halaman admin
- aktifasi oleh user (kalo ada)
ada 2 jalur
[A]
- user login
- masuk panel user
- ada link utk edit data nya sendiri
[B]
- admin login
- masuk panel admin
- ada panel manajemen user
- admin bisa edit user yg mana pun
yg dimau yg mana ?
[A]
- user login
- masuk panel user
- ada link utk edit data nya sendiri...[yang ini gimana Master]
masa cuma bikin link / button nya kagak bisa ?
itu pan cuma html
$result = mysql_query($query);
echo "<table border='1' cellpadding='1' cellspacing='1'>";
echo "<tr bgcolor='#aaaaaa' align='center'>
<td> <b> No </b> </td>
<td> <b> Nama</b> </td>
<td> <b> Email </b> </td>
<td> <b> Alamat / Kota </b> </td>
<td> <b> No.Hp / Telp </b> </td>
<td> <b> User Name </b> </td>
<td> <b> Password </b> </td>
<td> <b> Update Data </b> </td>
</tr>";
while ($data = mysql_fetch_array($result))
{
echo "<tr align='center'>
<td>".$data['no']."</td>
<td>".$data['nama']."</td>
<td>".$data['email']."</td>
<td>".$data['alamat']."</td>
<td>".$data['hp']."</td>
<td>".$data['user']."</td>
<td>".$data['password']."</td>
<td> <i> <a href='edit.php?no=".$data['no']."'> - EDIT - </a> </i></td>
</tr>";
}
echo "</table>";
?>
begini ya Master....Mohon koreksinya..??
form edit nya biar gampang, bikin aja sama persis kaya form input
ndak usah mikir value nya dolo, posting kemari form yg dibuat
include 'con.php';
$no = $_GET['no'];
$query = "SELECT * FROM user WHERE no = $no";
$hasil = mysql_query($query);
$data = mysql_fetch_array($hasil);
?>
<form method="post" action="edit-save.php">
<table width="500" border="1" cellpadding="1" cellspacing="1">
<tr bgcolor="#aaaaaa">
<td height="21" colspan="3">
<strong> Edit Data Member</strong>
</td>
<tr>
<td width="23%"> No </td>
<td width="1%">:</td>
<td width="60%"> <input type="text" name="no" disabled='disable' value="<?php echo $data['no']; ?>"> </td>
</tr>
<tr>
<td>Nama</td>
<td>:</td>
<td> <input type="text" name="nama" value="<?php echo $data['nama']; ?>"> </td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td> <textarea name="email"><?php echo $data['email']; ?></textarea></td>
</tr>
<tr>
<tr>
<td>Alamat / Kota</td>
<td>:</td>
<td> <textarea name="alamat"><?php echo $data['alamat']; ?></textarea></td>
</tr>
<tr>
<tr>
<td>No. Hp / Telp</td>
<td>:</td>
<td> <textarea name="hp"><?php echo $data['hp']; ?></textarea></td>
</tr>
<tr>
<tr>
<td>User Name</td>
<td>:</td>
<td> <textarea name="user"><?php echo $data['user']; ?></textarea></td>
</tr>
<tr>
<tr>
<td>Password</td>
<td>:</td>
<td> <textarea name="password"><?php echo $data['password']; ?></textarea></td>
</tr>
<tr>
<tr>
<td></td> <td></td> <td> <input type="hidden" name="no" value="<?php echo $data['no']; ?>">
<input type="SUBMIT" name="SUBMIT" value="Update"></td>
</tr>
</table>
</form>
[B]
- admin login
- masuk panel admin
- ada panel manajemen user
- admin bisa edit user yg mana pun......(yang ini hasilnya master)
maunya saya yang ini master
[A]
- user login
- masuk panel user
- ada link utk edit data nya sendiri..(yang edit USER bukan ADMIN)
Mohon koreksinya...???
mas, bilang dong kalo itu beda file ...
ini query yg di profil user :
$sql='select * from juser where user="'.$_SESSION['user_id'].'" LIMIT 1';
yg ini yg ada link edit nya ( ini punya admin ? ) :
$query = "SELECT * FROM user";
...
...
<td> <i> <a href='edit.php?no=".$data['no']."'> - EDIT - </a> </i></td>
ya semestinya bisa dilihat sendiri to mas ada beda di situ ...
kalo butuhnya link edit di profil ... ya bikin link edit nya di tampilan profil dong ...
gak beda dengan yg di admin
tinggal copy paste, modif nama variabel nya kalo emang diperlukan
dan form edit nya sama aja, copy aja punya admin,
cuma mungkin query nya diubah ditambah where sesuai session nya user yg bersangkutan
$query = "SELECT * FROM user WHERE no = $no";
jadi
$query = "SELECT * FROM user WHERE no = $no AND user='.$_SESSION['user_id'].'";
include 'con.php';
$sql='select * from user where user="'.$_SESSION['user_id'].'" LIMIT 1';
$result = mysql_query($sql);
============
Form edit tdk d rubah....
ok MASTER BOO suda jalan scriptnya..terima kasih.....moga Sukses selalu