관리-도구

편집 파일: memberEdit.php

<?php
include("../connect.php");

if ($_POST['Submit'])
{
	$sql = "update ftp_usermaster set ";
	$sql .= "firstname='" . $_POST['txtfirstname'] . "', ";
	$sql .= "lastname='" . $_POST['txtlastname'] . "', ";
	$sql .= "emailaddress='" . $_POST['txtemailaddress'] . "', ";
	$sql .= "username='" . $_POST['txtusername'] . "', ";
	$sql .= "password='" . $_POST['txtpassword'] . "', ";
	$sql .= "status='" . $_POST['cmbstatus'] . "' ";
	$sql .= " where id='" . $_POST['memberID'] . "'";
	$res = mysql_query($sql);
	
	header("location:membersList.php?actionname=editSuccess");
}

if ($_GET['baseTask'] == 'EditMember')
{
	$sql = "select * from ftp_usermaster where id='".$_GET['memberID']."'";
	$res = mysql_query($sql);
	$row = mysql_fetch_row($res);
}
if ($_GET['baseTask'] == 'DeleteMember')
{
	$sql = "delete from ftp_usermaster where id='".$_GET['memberID']."'";
	$res = mysql_query($sql);
	header("location:membersList.php?actionname=deleteSuccess");
}
?>

<!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=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">

</style>
<script language="javascript">
function validateForm()
{
	if (document.getElementById('txtfirstname').value == '')
	{
		alert("First Name can not be left blank.");
		document.getElementById('txtfirstname').focus();
		return false;
	}
	if (document.getElementById('txtlastname').value == '')
	{
		alert("Last Name can not be left blank.");
		document.getElementById('txtlastname').focus();
		return false;
	}
	if (document.getElementById('txtusername').value == '')
	{
		alert("User Name can not be left blank.");
		document.getElementById('txtusername').focus();
		return false;
	}
	if (document.getElementById('txtpassword').value == '')
	{
		alert("Password can not be left blank.");
		document.getElementById('txtpassword').focus();
		return false;
	}
	if (document.getElementById('txtemailaddress').value == '')
	{
		alert("Email Address can not be left blank.");
		document.getElementById('txtemailaddress').focus();
		return false;
	}
	if (echeck(document.getElementById('txtemailaddress').value)==false)
	{
		document.getElementById('txtemailaddress').focus()
		return false;
	}	
}

function echeck(str) 
{
	var at="@"
	var dot="."
	var lat=str.indexOf(at)
	var lstr=str.length
	var ldot=str.indexOf(dot)
	if (str.indexOf(at)==-1)
	{
		alert("Invalid E-mail ID")
		return false
	}
	if (str.indexOf(at)==-1 || str.indexOf(at)==0 || str.indexOf(at)==lstr)
	{
		alert("Invalid E-mail ID")
		return false
	}
	if (str.indexOf(dot)==-1 || str.indexOf(dot)==0 || str.indexOf(dot)==lstr)
	{
		alert("Invalid E-mail ID")
		return false
	}
	if (str.indexOf(at,(lat+1))!=-1)
	{
		alert("Invalid E-mail ID")
		return false
	}
	if (str.substring(lat-1,lat)==dot || str.substring(lat+1,lat+2)==dot)
	{
		alert("Invalid E-mail ID")
		return false
	}
	if (str.indexOf(dot,(lat+2))==-1)
	{
		alert("Invalid E-mail ID")
		return false
	}
	if (str.indexOf(" ")!=-1)
	{
		alert("Invalid E-mail ID")
		return false
	}
	return true					
}
</script>
</head>
<body>
<form id="frmSignUp" name="frmSignUp" method="post" action="memberEdit.php" onsubmit="return validateForm()">
  <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#999999">
    <tr>
      <td><table width="100%" border="0" cellspacing="1" cellpadding="4">
          <tr>
            <td height="48" colspan="2" align="center" valign="middle" bgcolor="#F0F0F0" class="style3">Edit Member Details  
			<input name="memberID" type="hidden" id="memberID" size="25" value="<?php echo $_GET['memberID']; ?>" />
			</td>
          </tr>
          <tr>
            <td width="40%" align="right" valign="top" bgcolor="#F9F9F9"><span class="style1">First Name : </span></td>
            <td width="60%" align="left" valign="top" bgcolor="#FFFFFF"><input name="txtfirstname" type="text" id="txtfirstname" size="25" value="<?php echo $row[3]; ?>" /></td>
          </tr>
          <tr>
            <td align="right" valign="top" bgcolor="#F9F9F9" class="style1">Last Name : </td>
            <td align="left" valign="top" bgcolor="#FFFFFF"><input name="txtlastname" type="text" id="txtlastname" size="25" value="<?php echo $row[4]; ?>" /></td>
          </tr>
          <tr>
            <td align="right" valign="top" bgcolor="#F9F9F9" class="style1">User Name  : </td>
            <td align="left" valign="top" bgcolor="#FFFFFF"><input name="txtusername" type="text" id="txtusername" size="25" value="<?php echo $row[1]; ?>" /></td>
          </tr>
          <tr>
            <td align="right" valign="top" bgcolor="#F9F9F9" class="style1">Password : </td>
            <td align="left" valign="top" bgcolor="#FFFFFF"><input name="txtpassword" type="text" id="txtpassword" size="25" value="<?php echo $row[2]; ?>" /></td>
          </tr>
          <tr>
            <td align="right" valign="top" bgcolor="#F9F9F9" class="style1">Email Address  : </td>
            <td align="left" valign="top" bgcolor="#FFFFFF"><input name="txtemailaddress" type="text" id="txtemailaddress" size="25" value="<?php echo $row[5]; ?>" /></td>
          </tr>
          <tr>
            <td align="right" valign="top" bgcolor="#F9F9F9" class="style1">User Status : </td>
            <td align="left" valign="top" bgcolor="#FFFFFF"><label>
              <select name="cmbstatus" class="style1" id="cmbstatus">
                <option value="Active" selected="selected">Active</option>
                <option value="Inactive">Inactive</option>
              </select>
            </label></td>
          </tr>
          <tr>
            <td height="41" colspan="2" align="center" valign="middle" bgcolor="#F0F0F0"><input type="submit" name="Submit" value="Update Member Data" /></td>
          </tr>
      </table></td>
    </tr>
  </table>
</form>
</body>
</html>