| {nanya} para mastah bikin form ubah pasword gimana ya script;nya biar konek sama database? |
|
| tampilanya kaya gini? |
|
| databasenya kaya gini---(untuk koneksi ke database gimana nih? |
|
| bantu scriptnya dong mastah |
|
| gini bro : 1. lu tambahin 1 inputbox untuk user id 2. habis itu kau update password=password_baru dimana userid=userid dan password=password_lama |
|
| ini nanya koneksi ke database apa cara update data ya ??
kalo koneksi ke database coba liat ini dulu http://www.phpro.org/tutorials/Introduction-to-PHP-PDO.html |
|
| cara update gan...script ane salah dimananya? |
|
| script kau mana ?? :D |
|
| untuk koneksi user<?php session_start(); mysql_connect("localhost","root","") or die("Nggak bisa koneksi"); mysql_select_db("test");//sesuaikan dengan nama database anda
$userid = $_POST['userid']; $psw = $_POST['psw']; $txtPassBaru = $_POST['txtPassBaru']; $txtPassBaru2 = $_POST['txtPassBaru2']; $op = $_GET['op'];
if(trim($psw) =="") { echo "<b>Password Lama</b> belum diisi, tolong diisi"; include "adminEdit.php"; } else if (strlen(trim($txtPassBaru)) <=5) { echo "<b>Password Baru</b> minimal 6 digit, tolong diperbaiki"; } else if (trim($txtPassBaru) != trim($txtPassBaru2)) { echo "<b>Password Baru</b> dan <b> Ketik Ulang </b> harus sama"; include "adminEdit.php"; } else { $sqlPeriksa = "SELECT * FROM admin WHERE userID='$userid' AND passID=PASSWORD ('$psw')"; $qryPeriksa = mysql_query($sqlPeriksa, $koneksi); $hslPeriksa = mysql_num_rows($qryPeriksa); if ($hslPeriksa >=1 ) { $sqlUbah = "UPDATE admin SET passID = PASSWORD('$txtPassBaru') WHERE userID ='admin'"; mysql_query($sqlUbah, $koneksi) or die ("Gagal Perintah SQL". mysql_error()); # Jika sukses echo "MENGUBAH PASSWORD DENGAN YANG BARU BERHASIL"; } else { # Jika gagal echo "<b>PASSWORD LAMA</b> TIDAK SESUAI DENGAN DATABASE"; include "adminEdit.php"; } } ?> |
|
| utk tampilan form ....: <form action="adminEditSim.php" method="get"></form><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>adminEdit.php</title> <style type="text/css"> #form1 table tr td #simpan { text-align: center; } </style> </head>
<body> <form action="adminEditSim.php" method="post" name="form1" target="_self" id="form1"> <table width="400" border="0" cellspacing="1" cellpadding="2"> <tr> <td width="166">Ubah Password</td> <td width="223"> </td> </tr> <tr> <td>Password Lama</td> <td>: <input name="psw" type="password" size="30" maxlength="30" /></td> </tr> <tr> <td>Password Baru</td> <td>: <input name="txtPassBaru" type="password" id="txtPassBaru" size="30" maxlength="30"/></td> </tr> <tr> <td>Ulang PassBaru</td> <td>: <input name="txtPassBaru2" type="password" id="txtPassBaru2" size="30" maxlength="30"/></td> </tr> <tr> <td> </td> <td><input type="submit" name="simpan" id="simpan" value="Submit" /></td> </tr> </table> <p> </p> </form> </body> </html> |
|
| $sqlPeriksa = "SELECT * FROM admin WHERE userID='$userid' AND passID=PASSWORD ('$psw')";
dan
$sqlUbah = "UPDATE admin SET passID = PASSWORD('$txtPassBaru') WHERE userID ='admin'";
Rancu banget bro, 'PASSWORD' itu untuk ap y? lalu kenapa ada 'passID' padahal d tabel namanya 'password' ? |
|
| ntuh hasil olahan script login gan...kalo buat login dah ok... |
|
| harusnya gimana bro?bagi scriptnya buat update pasword dong bro.. |
|
| coba lu ganti passID jadi password |
|
| iya bro nih dah ane coba...dan ga mau mengupdate bro |
|
| $userid = $_POST['userid']; d form'a g ad textbox user id. jadi sintak sql'a g akan terpenuhi |
|
| nih juga ane tambahin user |
|
| name'a udah jadi 'userid' ?? |
|
| udah bro..kesalhan dimana ya?nih belum bisa update tablnya |
|
| coba yg PASSWORD'a itu kau hapus |
|
| dihapus saja?ato diganti? |
|
| $sqlUbah = "UPDATE admin SET password = '$txtPassBaru' WHERE userid ='$userid' and password='$psw'";
nama field yg lu pake harus sama kyk yg d tabel |
|
| kalau g bisa coba $sqlUbah = "UPDATE admin SET password = '$txtPassBaru' WHERE userid ='$userid'"; |
|
| $koneksi=$mysql_connect("localhost","root",""); mysql_select_db("test",$koneksi); |
|
| koneksinya kalo ane rubah ga mau konek ama php;nya |
|
| kalo masbro punya script yg lain utk update password boleh dong dibagi |
Tidak ada komentar:
Posting Komentar