Kamis, 22 Agustus 2013

PHP Indonesia - Facebook: {nanya} para mastah bikin form ubah pasword gimana...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
Learning HTML & CSS shouldn't be difficult.

Master Trainer, Mark Lassoff, will teach you everything you need to know to create a creative and professional web site in 4 hours.
From our sponsors
{nanya} para mastah bikin form ubah pasword gimana...
Aug 22nd 2013, 07:45, by Orang Indonesia Banget

Orang Indonesia Banget 7:45am Aug 22
{nanya}
para mastah bikin form ubah pasword gimana ya script;nya biar konek sama database?

Orang Indonesia Banget 8:06am Aug 22
tampilanya kaya gini?

Orang Indonesia Banget 8:06am Aug 22
databasenya kaya gini---(untuk koneksi ke database gimana nih?

Orang Indonesia Banget 8:10am Aug 22
bantu scriptnya dong mastah

Adhie Purwa Sasmita 8:11am Aug 22
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

La Jayuhni Yarsyah 8:12am Aug 22
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

Orang Indonesia Banget 8:13am Aug 22
cara update gan...script ane salah dimananya?

Adhie Purwa Sasmita 8:13am Aug 22
script kau mana ?? :D

Orang Indonesia Banget 8:16am Aug 22
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";
}
}
?>

Orang Indonesia Banget 8:18am Aug 22
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">&nbsp;</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>&nbsp;</td>
<td><input type="submit" name="simpan" id="simpan" value="Submit" /></td>
</tr>
</table>
<p>&nbsp;</p>
</form>
</body>
</html>

Adhie Purwa Sasmita 8:24am Aug 22
$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' ?

Orang Indonesia Banget 8:26am Aug 22
ntuh hasil olahan script login gan...kalo buat login dah ok...

Orang Indonesia Banget 8:27am Aug 22
harusnya gimana bro?bagi scriptnya buat update pasword dong bro..

Adhie Purwa Sasmita 8:30am Aug 22
coba lu ganti passID jadi password

Orang Indonesia Banget 8:30am Aug 22
iya bro nih dah ane coba...dan ga mau mengupdate bro

Adhie Purwa Sasmita 8:31am Aug 22
$userid = $_POST['userid']; d form'a g ad textbox user id.
jadi sintak sql'a g akan terpenuhi

Orang Indonesia Banget 8:32am Aug 22
nih juga ane tambahin user

Adhie Purwa Sasmita 8:32am Aug 22
name'a udah jadi 'userid' ??

Orang Indonesia Banget 8:34am Aug 22
udah bro..kesalhan dimana ya?nih belum bisa update tablnya

Adhie Purwa Sasmita 8:36am Aug 22
coba yg PASSWORD'a itu kau hapus

Orang Indonesia Banget 8:38am Aug 22
dihapus saja?ato diganti?

Adhie Purwa Sasmita 8:40am Aug 22
$sqlUbah = "UPDATE admin SET
password = '$txtPassBaru'
WHERE userid ='$userid' and password='$psw'";

nama field yg lu pake harus sama kyk yg d tabel

Adhie Purwa Sasmita 8:41am Aug 22
kalau g bisa coba
$sqlUbah = "UPDATE admin SET
password = '$txtPassBaru'
WHERE userid ='$userid'";

Adhie Purwa Sasmita 8:44am Aug 22
$koneksi=$mysql_connect("localhost","root","");
mysql_select_db("test",$koneksi);

Orang Indonesia Banget 8:46am Aug 22
koneksinya kalo ane rubah ga mau konek ama php;nya

Orang Indonesia Banget 8:54am Aug 22
kalo masbro punya script yg lain utk update password boleh dong dibagi

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar