Untitled

<?php
include "db.php";

$srcUserid = "";
$srcName = "";
$srcPassword = "";
$srcLevel = "";
$srcStatus = "";


	if( isset($_POST["btnAdd"])  ){
		$vUserid = $_POST["txtuserid"];
		$vName = $_POST["txtname"];
		$vPassword = $_POST["txtpassword"];
		$vLevel = $_POST["txtlevel"];
		$vStatus = $_POST["txtstatus"];

		$vSQL = " Insert Into usermaster ";
		$vSQL .= " ( userid, username, password, userlevel, status ) ";
		$vSQL .= " values( '$vUserid','$vName','$vPassword','$vLevel','$vStatus' ) ";

		$db = new DB;
		$db->InsertRecord($vSQL);
		$db->CloseDB();

		echo "Record Saved!";
	}

	if( isset($_POST["btnUpdate"])  ){
		$vUserid = $_POST["txtuserid"];
		$vName = $_POST["txtname"];
		$vPassword = $_POST["txtpassword"];
		$vLevel = $_POST["txtlevel"];
		$vStatus = $_POST["txtstatus"];

		$vSQL = " Update usermaster  Set ";
		$vSQL .= " username = '$vName', ";
		$vSQL .= " password = '$vPassword', ";
		$vSQL .= " userlevel = '$vLevel', ";
		$vSQL .= " status = '$vStatus' ";
		$vSQL .= " where userid='$vUserid' ";

		$db = new DB;
		$db->UpdateRecord($vSQL);
		$db->CloseDB();

		echo "Record Updated!";
	}


	if( isset($_POST["btnDelete"])  ){
		$vUserid = $_POST["txtuserid"];

		$vSQL = " Delete From usermaster  ";
		$vSQL .= " where userid='$vUserid' ";

		$db = new DB;
		$db->DeleteRecord($vSQL);
		$db->CloseDB();

		echo "Record Deleted!";
	}


	if( isset($_POST["btnSearch"])  ){

		$vUserid = $_POST["txtuserid"];
		$vSQL = " Select * from usermaster where userid = '$vUserid ' ";
		$db = new DB;
		  $rs = $db->GetResult($vSQL);

		  while( $row = mysql_fetch_array($rs) ){
		  	$srcUserid = $row["userid"];
			$srcName = $row["username"];
			$srcPassword = $row["password"];
			$srcLevel = $row["userlevel"];
			$srcStatus = $row["status"];
		  }
		$db->CloseDB();
	}
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<center>
<style>
div {

    border-width: 1px;
	background-color: lightblue;
}
div#aaa{

    border-width: 5px;
	background-color: lightgreen;
}
</style>
<div>
<table>
<form method="post">
	<tr>
		<td>User ID : </td><td><input required type="text" name="txtuserid" value="<?php echo $srcUserid; ?>" /></td><td>[<input type="submit" name="btnSearch" value="Search" />]</td>
	</tr>
	<tr>
		<td>Name : </td><td><input type="text" name="txtname" value="<?php echo $srcName; ?>" /></td><td></td>
	</tr>
	<tr>
		<td>Password :</td><td><input type="text" name="txtpassword" value="<?php echo $srcPassword; ?>" /></td><td></td>
	</tr>
	<tr>
		<td>Level :</td><td><input type="text" name="txtlevel" value="<?php echo $srcLevel; ?>" /></td><td></td>
	</tr>
	<tr>
		<td>Status :</td><td><input type="text" name="txtstatus" value="<?php echo $srcStatus; ?>" /></td><td></td>
	</tr>
	<tr>
		<td></td>
		<td>
		<input type="submit" name="btnAdd" value="Add" />
		<input type="submit" name="btnUpdate" value="Update" />
		<input type="submit" name="btnDelete" value="Delete" />
		</td>
		<td></td>
	</tr>
</form>
</table>
</div>
<div id=aaa>
<?php  include "usermaster.php"; ?>
</div>
</center>
</body>
</html>