Untitled

<html >
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script src="../angularscript/angular.min.js"></script>
 <link href="../bs/bootstrap-combined.min.css" rel="stylesheet">

</head>

<body  ng-app="myApp">
<center>
<br>
	<div class="well well-sm" ng-controller="mycontroller">

		<form >
		<table>
		<tr><td>User id:</td><td><input type="text" ng-model="userid"/></td><td align="center"><input class="btn btn-warning" type="submit" value="Show" ng-click="showdata()"/></td></tr>
		<tr><td>Name :</td><td><input type="text" ng-model="username"/></td></tr>
		<tr><td>Password :</td><td><input type="text" ng-model="pass"/></td></tr>
		<tr><td>Level :</td><td><input type="text" ng-model="level"/></td></tr>
		<tr><td>Status:</td><td><input type="text" ng-model="status"/></td></tr>
		<tr>
			<td align="center"><input class="btn btn-success" type="submit" value="Add" ng-click="insertdata()"/></td>
			<td align="center"><input class="btn btn-primary" type="submit" value="Update" ng-click="updatedata()"/></td>
			<td align="center"><input class="btn btn-danger" type="submit" value="Delete" ng-click="deletedata()"/></td>
		</tr>
		</table>
		</form>


		<table class="table table-hover" border="1" width="50%">
		  <tr>
			<th>User ID</th>
			<th>Name</th>
			<th>Password</th>
			<th>Level</th>
			<th>Status</th>
		  </tr>
		  <tr ng-repeat="data in myData">
			<td ng-mouseover="showdataclick(data.userid)" ng-click="showdataclick(data.userid)">{{data.userid}}</td>
			<td>{{data.username}}</td>
			<td>{{data.password}}</td>
			<td>{{data.userlevel}}</td>
			<td>{{data.status}}</td>
		  </tr>
		</table>
	</div>

</center>
</body>
</html>
<script>
	var app = angular.module('myApp', []);

	app.controller('mycontroller', function($scope, $http, myService) {

		  $scope.filename="usermaster.php";

		  $http.get($scope.filename)
		  .then(function(response) {
			  $scope.myData = response.data;

		  });

		$scope.insertdata=function(){
			//alert($scope:name);
			$scope.successvalue= "";
			$http.post("insertdata.php", {'userid':$scope.userid, 'username':$scope.username, 'pass':$scope.pass, 'level':$scope.level, 'status':$scope.status    }).
				success(function(data, status, header, config){
				 $scope.successvalue = data;
				});

				$scope.refreshtable();
				$scope.clearscreen();
			}// Close insertdata function


		$scope.updatedata=function(){
			//alert($scope:name);
			$scope.successvalue= "";
			$http.post("updatedata.php", {'userid':$scope.userid, 'username':$scope.username, 'pass':$scope.pass, 'level':$scope.level, 'status':$scope.status    }).
				success(function(data, status, header, config){
				 $scope.successvalue = data;
				});
				$scope.refreshtable();
				$scope.clearscreen();
			}// Close updatedata function

		$scope.deletedata=function(){
			//alert($scope:name);
			$scope.successvalue= "";
			$http.post("deletedata.php", {'userid':$scope.userid, 'username':$scope.username, 'pass':$scope.pass, 'level':$scope.level, 'status':$scope.status    }).
				success(function(data, status, header, config){
				 $scope.successvalue = data;

				});
				$scope.refreshtable();
				$scope.clearscreen();
			}// Close deletedata function

		$scope.showdata=function(){
			//alert($scope:name);
			$scope.successvalue= "";
			$http.post("showdata2.php", {'userid':$scope.userid }).
				success(function(data, status, header, config){

					var obj = data;
						$scope.userid = obj.userid;
						$scope.username = obj.username;
						$scope.pass = obj.password;
						$scope.level = obj.userlevel;
						$scope.status = obj.status;

					$scope.successvalue = data;
				});
			}// Close showdata function


		$scope.showdataclick = function(a){
			myService.setUserid(a);
			$scope.successvalue= "";
			$http.post("showdata2.php", {'userid':myService.getUserid() }).
				success(function(data, status, header, config){

					var obj = data;
						$scope.userid = obj.userid;
						$scope.username = obj.username;
						$scope.pass = obj.password;
						$scope.level = obj.userlevel;
						$scope.status = obj.status;

					$scope.successvalue = "";

				});
			//}// Close showdata function

		};


		$scope.refreshtable=function(){
			$scope.filename="usermaster.php";
			  $http.get($scope.filename)
			  .then(function(response) {
				  $scope.myData = response.data;
			  });
		}// Close refreshtable(); function

		$scope.clearscreen=function(){
			$scope.userid = " ";
			$scope.username = " ";
			$scope.pass = " ";
			$scope.level = " ";
			$scope.status = " ";
		}// Close refreshtable(); function

	}); // Close Controller


 	app.factory('myService', function(){
    	var userid = null;//the object to hold our data
     	return {
		 getUserid:function(){
		   return userid;
		 },

		 setUserid:function(value){
		  userid = value;
		 }
      }
	 });

</script>