Edit Group Member
The edit-group-member.php script lets administrators change any user's first name to any other name of 1 to 12 characters containing only letters, numbers and underline. Adding group members or deleting group members are done in other scripts.
In editing a group member name in the administrator's psb table, the configure.php is included to establish server and database connections. Next, we get the username, oldfname and newfname variables POSTed to our PHP script, with the username being POSTed from the page that sent us here and the other variables getting POSTed from this member editing page to itself. Note that if the Administrator is not logged in and therefore his username (stored in $U) is unset, he is sent to the login page. If the $A variable is not set, he has not yet entered data into the form.
Once the $A and $Z variables are set (the old and new first names, respectively), the PHP script updates the specified first name in the Administrator's psb table where first names, IDs, statuses and comments are stored. If the table gets updated successfully, you get a message to that effect. Success is detected by a special MySQL function, mysql_affected_rows(). Once the edit is done, there's a button to let the administrator return to the Administrators Page. Note that JSON is used to pass the user name from PHP to JavaScript and then it gets POSTed back to PHP by the form in this script as well as to the Administrator page. This keeps the user logged in so he need not login constantly as he uses various editing scripts.
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<TITLE>Edit Group Member</TITLE>
<meta name="description" content="Edit Group Member">
<meta name="keywords" content="Edit Group Member,php,javascript, dhtml, DHTML">
<style type="text/css">
BODY {margin-left:0; margin-right:0; margin-top:0;text-align:left}
p, li {font:13px Verdana; color:black;text-align:left}
h1 {font:bold 28px Verdana; color:black;text-align:center}
h2 {font:bold 24px Verdana;text-align:center}
h3 {font:bold 15px Verdana;}
</style>
</head><body>
<div style='position:absolute;top:450px;left:370px;border:1px solid black;background-color:#eee;'>
<?php
include_once"configure.php";
$U=$_POST['username'];
$A=$_POST['oldfname'];
$Z=$_POST['newfname'];
if (!isset($U)) {
echo '<script language="javascript">alert("Please login.");
window.location="login.php"; </script>';
}
$B=$U."_psb";
$result = mysql_query("SELECT * FROM $B") or die(mysql_error());
echo "<table border='1' width='162'>";
echo "<tr><th>ID</th><th>First Name</th></tr>";
while($row = mysql_fetch_array($result)) {
echo "<tr><td>";
echo $row['ID'];
echo "</td><td>";
echo $row['Firstname'];
echo "</td></tr>";
}
echo "</table>";
if (isset($A)) {
mysql_query("UPDATE $B SET Firstname = '$Z' WHERE Firstname='$A'");
$rc = mysql_affected_rows();
if ($rc>0){unset($A);
echo '<script language="javascript">alert("The change was successfully accomplished.");</script>';}
else{echo '<script language="javascript">alert("The change was unsuccessful.");</script>';}
?>
<div style='position:absolute;top:0px;left:0px;border:1px solid black;background-color:#eee;'>
<?php
$B=$U."_psb";
$result = mysql_query("SELECT * FROM $B") or die(mysql_error());
echo "<table border='1' width='162'>";
echo "<tr><th>ID</th><th>First Name</th></tr>";
while($row = mysql_fetch_array($result)) {
echo "<tr><td>";
echo $row['ID'];
echo "</td><td>";
echo $row['Firstname'];
echo "</td></tr>";
}
echo "</table>";
?>
</div>
<?php
}
mysql_close();
?>
</div>
<h1>Edit Group Member</h1>
<div id='pw' style='position:absolute;top:150px;left:370px;width:262px'><table style="background-color:#8aa;border-color:#00f" border='6' cellspacing=0 cellpadding=6><tr><td>
<form id='formpw' name="formpw" method="post" action="edit-group-member.php" onsubmit="return validatefname()">
<label for="Old First Name"><b>Old First Name: </b><input type="text" name="oldfname" size="12" maxlength="12" value=""></label>
<label for="New First Name"><b>New First Name: </b><input type="text" name="newfname" size="12" maxlength="12" value=""></label><br><br>
<input type="hidden" name="username" value=" ">
<input type="submit" value="Edit Group Member"><br><br>
<input type="reset" value="Reset"></form></td></tr></table>
<br><br>
<form style='margin-left:0px' name="MyForm" method="POST" action="administrator-page.php">
<input type="button" value="Return to Administrator Page" onclick="goback()">
<input type="hidden" name="username" value=" ">
</form>
</div>
<script language="javascript">
function goback(){
var u = <?php echo json_encode($U); ?>;
document.MyForm.username.value=u;
document.MyForm.submit();}
function validatefname(){
var u = <?php echo json_encode($U); ?>;
document.formpw.username.value=u;
var ck_username = /^[A-Za-z0-9_]{1,12}$/;
if (document.formpw.oldfname.value.search(ck_username)==-1)
{alert("Please only enter letters, numbers and underline for user first names, and enter 1 to 12 characters.");return false}
var ck_username = /^[A-Za-z0-9_]{1,12}$/;
if (document.formpw.newfname.value.search(ck_username)==-1)
{alert("Please only enter letters, numbers and underline for user first names, and enter 1 to 12 characters.");return false}
return true;}
</script>
</body></html>