| | {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