So now that I have that sorted out fine...here is my code for the project that I am putting together:
This is basically a form that will change a user's password my updating the mysql database and will validate fields
<?php
require_once('auth.php');
// Get global variable values if there are any
if (isset($_POST['submit']))
{
$usrname = ($_SESSION['SESS_MEMBER_USERNAME']);
$passwd = ($_SESSION['SESS_MEMBER_PASSWORD']);
$oldpasswd = $_POST['oldpasswd'];
$newpasswd = $_POST['newpasswd'];
$cfmpasswd = $_POST['cfmpasswd'];
}
if ($submit)
{
// Check if Old password is the correct
if ($oldpasswd != $passwd)
{ echo "Old password is wrong!"; exit; }
// Check if New password if blank
if (trim($newpasswd) == "")
{ echo "New password cannot be blank!"; exit; }
// Check if New password is confirmed
if ($newpasswd != $cfmpasswd)
{ print "New password was not confirmed!"; exit; }
}
// If everything is ok, use auth class to modify the record
$query = "UPDATE smw_members ".
"SET usrname = '$usrname', newpasswd = '".md5($_POST['newpasswd'])."' ".
"WHERE member_id = '$member_id'";
mysql_query($query) or die('Error : ' . mysql_error());
?>
<meta http-equiv="REFRESH" content="0;url=http://www.google.ca">
<html>
<head>
<title>Scotty Media Content Management System</title>
<?php include("scripts.php"); ?>
</head>
<body>
<table border="1" width="1000" align="center" cellpadding="0" cellspacing="0">
<tr valign="top">
<?php include("itop_bar.php"); ?>
</tr>
<tr valign="top">
<td width="213" bgcolor="#404040">
<?php include("iside_bar.php"); ?>
</td>
<td width="787">
<table border="0" width="100%">
<tr>
<?php include("iquick_bar.php"); ?>
</tr>
<tr>
<td valign="top" colspan="2">
<hr align="left" width="770" align="center">
</td>
</tr>
<tr>
<td valign="top" class="txt_main" colspan="2">
<form method="POST" action="chgpwd.php">
<table>
<tr>
<td width="30%">Old Password:</td>
<td width="70%"><input type="password" name="oldpasswd"></td>
</tr>
<tr>
<td width="30%">New Password:</td>
<td width="70%"><input type="password" name="newpasswd" size="25"></td>
</tr>
<tr>
<td width="34%">Confirm:</td>
<td width="66%"><input type="password" name="cfmpasswd" size="25"></td>
</tr>
<tr>
<td width="100%" colspan="2" align="center"><input type="submit" value="Change Password" name="submit"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<?php include("ibottom_bar.php"); ?>
</tr>
</table>
</body>
</html>
When I run the code the password is not changed in the database...what is wrong!
| 