|
-
May 21st, 2005, 05:41 PM
#1
Thread Starter
Addicted Member
 MySQL, Changing a value of a field[RESOLVED]
I am writing a web program and I need to have a way for the admin to change either the admin password or the standard password (user name view)
I need to know what I have to do with my code to get it working properly.
Or, maybe someone has code already where I just have to change the names of the fields? Im sure it is simple code, it just has to determine which submit button was clicked and then use the proper query to update the password field.
Please help
VB Code:
<?php
include("cn.php");
include("common.php");
checklogin();
$msg = "";
$password = "";
$_POST['Submit']
{
$password = $_POST['password'];
$result = mysql_query("Update admin set password='$password');
$msg="Admin Password Changed"
}
?>
<html>
<head>
<title>Administration</title>
</head>
<body bgcolor="#BCCDCC">
<table width="76%" border="1" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td width="3%" bgcolor="#CCCCCC"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
<td width="97%" bgcolor="#CCCCCC"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Records</strong></font></td>
</tr>
<tr>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
</tr>
<tr>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="newrecord.php">Addnew
Record </a></font></td>
</tr>
<tr>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="listrecord.php">Edit/View
Records</a></font></td>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
</tr>
</table>
<form name="form1" method="post" action="">
<table width="48%" border="1" align="center" cellpadding="1" cellspacing="1" bordercolor="#000000">
<tr><td colspan="2">Change Admin Password</td></tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">New Password</font></td>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="password" type="password" id="password">
</font></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
<p> </p></form>
<form name="form1" method="post" action="">
<table width="48%" border="1" align="center" cellpadding="1" cellspacing="1" bordercolor="#000000">
<tr><td colspan="2">Change View Password</td></tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">New Password</font></td>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="password" type="password" id="password">
</font></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
<p> </p></form>
</body>
</html>
Last edited by espylacopa; May 21st, 2005 at 07:34 PM.
Things fall apart which the center cannot hold...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote