การทำ Login Form และ Update MySQL Data ผ่าน Web Service ด้วย PHP (NuSoap)

CREATE TABLE `customer` (
  `CustomerID` varchar(4) NOT NULL,
  `Username` varchar(30) NOT NULL,
  `Password` varchar(30) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Email` varchar(50) NOT NULL,
  `CountryCode` varchar(2) NOT NULL,
  `Budget` double NOT NULL,
  `Used` double NOT NULL,
  PRIMARY KEY  (`CustomerID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `customer`
-- 

INSERT INTO `customer` VALUES ('C001', 'win', 'win001', 'Win Weerachai', '[email protected]', 'TH', 1000000, 600000);
INSERT INTO `customer` VALUES ('C002', 'john', 'john002', 'John  Smith', '[email protected]', 'EN', 2000000, 800000);
INSERT INTO `customer` VALUES ('C003', 'jame', 'jame003', 'Jame Born', '[email protected]', 'US', 3000000, 600000);
INSERT INTO `customer` VALUES ('C004', 'chalee', 'chalee004', 'Chalee Angel', '[email protected]', 'US', 4000000, 100000);

<?php
		require_once("lib/nusoap.php");
		 
		//Create a new soap server
		$server = new soap_server();
		 
		//Define our namespace
		$namespace = "http://localhost/nusoap/WebServiceServer_Login.php";
		$server->wsdl->schemaTargetNamespace = $namespace;
		 
		//Configure our WSDL
		$server->configureWSDL("CustomerLogin");
		 
		//Register our method and argument parameters
        $varname = array(
                   'strUsername' => "xsd:string",
				   'strPassword' => "xsd:string"
        );
		
		// Register service and method
		$server->register('chkCustomerLogin',$varname, array('return' => 'tns:ArrayOfString'));
		
		//Add ComplexType with Array
		$server->wsdl->addComplexType("ArrayOfString", 
						 "complexType", 
						 "array", 
						 "", 
						 "SOAP-ENC:Array", 
						 array(), 
						 array(array("ref"=>"SOAP-ENC:arrayType","wsdl:arrayType"=>"xsd:string[]")), 
						 "xsd:string");  
		 
		function chkCustomerLogin($strUsername,$strPassword)
		{

				$objConnect = mysql_connect("localhost","root","") or die(mysql_error());
				$objDB = mysql_select_db("mydatabase");
				$strSQL = "
					SELECT * FROM customer WHERE 1  
					AND Username = '".$strUsername."'
					AND Password = '".$strPassword."'
				";
				$objQuery = mysql_query($strSQL) or die (mysql_error());
				$objResult = mysql_fetch_array($objQuery);
				if($objResult)
				{
					$arr[0] = true;
					$arr[1] = $objResult["CustomerID"];
					$arr[2] = null;
				}
				else
				{
					$arr[0] = false;
					$arr[1] = null;
					$arr[2] = "Invalid username or password";
				}
				
				/***
					$arr[0] // Return Status Login false or true
					$arr[1] // Return CustomerID
					$arr[2] // Return Error Message
				*/
				mysql_close($objConnect);

				return $arr;
		}
		 
		// Get our posted data if the service is being consumed
		// otherwise leave this data blank.
		$POST_DATA = isset($GLOBALS['HTTP_RAW_POST_DATA']) ? $GLOBALS['HTTP_RAW_POST_DATA'] : '';
		 
		// pass our posted data (or nothing) to the soap service
		$server->service($POST_DATA);
		exit(); 
?>

<?php
		require_once("lib/nusoap.php");
		 
		//Create a new soap server
		$server = new soap_server();
		 
		//Define our namespace
		$namespace = "http://localhost/nusoap/WebServiceServer_Show.php";
		$server->wsdl->schemaTargetNamespace = $namespace;
		
		//Configure our WSDL
		$server->configureWSDL("getCustomer");
		
		//Add ComplexType
		$server->wsdl->addComplexType( 
			'DataList', 
			'complexType', 
			'struct', 
			'all', 
			'', 
			   array( 
					'CustomerID' => array('name' => 'CustomerID', 'type' => 'xsd:string'), 
					'Username'  => array('name' => 'Username', 'type'  => 'xsd:string'),
					'Password'  => array('name' => 'Password', 'type'  => 'xsd:string'),
					'Name'  => array('name' => 'Name', 'type'  => 'xsd:string'),
					'Email'  => array('name' => 'Email', 'type'  => 'xsd:string'),
					'CountryCode'  => array('name' => 'CountryCode', 'type'  => 'xsd:string'),
					'Budget'  => array('name' => 'Budget', 'type'  => 'xsd:float'),
					'Used'  => array('name' => 'Used', 'type'  => 'xsd:float')
		   ) 
		); 
		
		//Add ComplexType
		$server->wsdl->addComplexType( 
			'DataListResult', 
			'complexType', 
			'array', 
			'', 
			'SOAP-ENC:Array', 
			array(), 
			array( 
				array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType'=>'tns:DataList[]') 
			), 
			'tns:DataList' 
		); 

		//Register our method and argument parameters
        $varname = array(
                   'strCustomerID' => "xsd:string"
        );
		
		// Register service and method
		$server->register('resultCustomer',    // method name 
			$varname, // input parameters 
			array('return' => 'tns:DataListResult')); 

		 
		function resultCustomer($strCustomerID)
		{
				$objConnect = mysql_connect("localhost","root","") or die(mysql_error());
				$objDB = mysql_select_db("mydatabase");
				$strSQL = "SELECT * FROM customer WHERE 1 AND CustomerID = '".$strCustomerID."' ";
				$objQuery = mysql_query($strSQL) or die (mysql_error());
				$intNumField = mysql_num_fields($objQuery);
				$resultArray = array();
				while($obResult = mysql_fetch_array($objQuery))
				{
					$arrCol = array();
					for($i=0;$i<$intNumField;$i++)
					{
						$arrCol[mysql_field_name($objQuery,$i)] = $obResult[$i];
					}
					array_push($resultArray,$arrCol);
				}
				mysql_close($objConnect);
				return $resultArray;
		}
		 
		// Get our posted data if the service is being consumed
		// otherwise leave this data blank.
		$POST_DATA = isset($GLOBALS['HTTP_RAW_POST_DATA']) ? $GLOBALS['HTTP_RAW_POST_DATA'] : '';
		 
		// pass our posted data (or nothing) to the soap service
		$server->service($POST_DATA);
		exit(); 
?>

<?php
		require_once("lib/nusoap.php");
		 
		//Create a new soap server
		$server = new soap_server();
		 
		//Define our namespace
		$namespace = "http://localhost/nusoap/WebServiceServer_Save.php";
		$server->wsdl->schemaTargetNamespace = $namespace;
		 
		//Configure our WSDL
		$server->configureWSDL("UpdateCustomer");
		 
		//Register our method and argument parameters
        $varname = array(
                   'strCustomerID' => "xsd:string",
				   'strPassword' => "xsd:string",
				   'strName' => "xsd:string",
				   'strEmail' => "xsd:string",
				   'strCountryCode' => "xsd:string",
				   'strBudget' => "xsd:float",
				   'strUsed' => "xsd:float"
        );
		
		// Register service and method
		$server->register('saveUpdateCustomer',$varname, array('return' => 'tns:ArrayOfString'));
		
		//Add ComplexType with Array
		$server->wsdl->addComplexType("ArrayOfString", 
						 "complexType", 
						 "array", 
						 "", 
						 "SOAP-ENC:Array", 
						 array(), 
						 array(array("ref"=>"SOAP-ENC:arrayType","wsdl:arrayType"=>"xsd:string[]")), 
						 "xsd:string");  
		
		 //Method update
		function saveUpdateCustomer($strCustomerID,
			$strPassword,
			$strName,
			$strEmail,
			$strCountryCode,
			$strBudget,
			$strUsed)
		{

				$objConnect = mysql_connect("localhost","root","") or die(mysql_error());
				$objDB = mysql_select_db("mydatabase");
				$strSQL = "
					UPDATE customer SET
						Password = '".$strPassword."',
						Name = '".$strName."',
						Email = '".$strEmail."',
						CountryCode = '".$strCountryCode."',
						Budget = '".$strBudget."',
						Used = '".$strUsed."'
					WHERE CustomerID = '".$strCustomerID."'
				";
				$objQuery = mysql_query($strSQL);
				if($objQuery)
				{
					$arr[0] = true;
					$arr[1] = null;
				}
				else
				{
					$arr[0] = false;
					$arr[1] = mysql_error();
				}
				/***			
					$arr[0] // Return Status Update
					$arr[1] // Return Error Message
				*/
				mysql_close($objConnect);

				return $arr;
		}
		 
		// Get our posted data if the service is being consumed
		// otherwise leave this data blank.
		$POST_DATA = isset($GLOBALS['HTTP_RAW_POST_DATA']) ? $GLOBALS['HTTP_RAW_POST_DATA'] : '';
		 
		// pass our posted data (or nothing) to the soap service
		$server->service($POST_DATA);
		exit(); 
?>

<?php
ob_start();
session_start();
session_destroy();

session_start();
?>

<html>
<head>
<title>ThaiCreate.Com</title>
</head>
<body>

<form action="?Action=Login" method="post" name="frmMain" id="frmMain">
  Login Form <br>

  <?php
	if($_GET["Action"] == "Login")
	{
		include("lib/nusoap.php");
        $client = new nusoap_client("http://localhost/nusoap/WebServiceServer_Login.php?wsdl",true); 
        $params = array(
                   'strUsername' => $_POST["txtUsername"],
				   'strPassword' => $_POST["txtPassword"]
        );
		$data = $client->call("chkCustomerLogin",$params); 
		if($data[0] == true)
		{
			$_SESSION["strCustomerID"] = $data[1];
			header("location:WebServiceClient_Show.php");
		}
		else
		{
			echo "<font color='red'>".$data[2]."</font>";
			$_SESSION["strCustomerID"] = null;
		}
	}
  ?>

  <table width="374" border="1" cellpadding="2" cellspacing="2">
    <tr>
      <td width="89">Username</td>
      <td width="144"><input name="txtUsername" type="text" id="txtUsername"></td>
    </tr>
    <tr>
      <td>Password</td>
      <td><input name="txtPassword" type="password" id="txtPassword"></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input name="btnLogin" type="submit" id="btnLogin" value="Login">
		<input name="btnReset" type="reset" id="btnReset" value="Reset"></td>
    </tr>
  </table>
</form>

</body>
</html>

<?php
session_start();
if($_SESSION["strCustomerID"] == "")
{
	header("location:WebServiceClient_Login.php");
	exit();
}
?>

<html>
<head>
<title>ThaiCreate.Com</title>
</head>
<body>

<?php
		include("lib/nusoap.php");
		$client = new nusoap_client("http://localhost/nusoap/WebServiceServer_Show.php?wsdl",true); 
		$params = array(
				   'strCustomerID' => $_SESSION["strCustomerID"]
		);
		$data = $client->call('resultCustomer', $params);
?>

Welcome <b><?php echo $data[0]["Name"];?></b>..... Your information.<br><br>
  <table width="374" border="1" cellpadding="2" cellspacing="2">
    <tr>
      <td width="89">CustomerID</td>
      <td width="144"><?php echo $data[0]["CustomerID"];?></td>
    </tr>
    <tr>
      <td width="89">Username</td>
      <td width="144"><?php echo $data[0]["Username"];?></td>
    </tr>
    <tr>
      <td width="89">Password</td>
      <td width="144"><?php echo $data[0]["Password"];?></td>
    </tr>
    <tr>
      <td width="89">Name</td>
      <td width="144"><?php echo $data[0]["Name"];?></td>
    </tr>
    <tr>
      <td width="89">Email</td>
      <td width="144"><?php echo $data[0]["Email"];?></td>
    </tr>
    <tr>
      <td width="89">CountryCode</td>
      <td width="144"><?php echo $data[0]["CountryCode"];?></td>
    </tr>
    <tr>
      <td width="89">Budget</td>
      <td width="144"><?php echo $data[0]["Budget"];?></td>
    </tr>
    <tr>
      <td width="89">Used</td>
      <td width="144"><?php echo $data[0]["Used"];?></td>
    </tr>
  </table>
  <br>
  <a href="WebServiceClient_Profile.php">Edit Your Profile</a>
  |
  <a href="WebServiceClient_Login.php">Logout</a>

<?php
	$data = null;
?>
</body>
</html>

<?php
session_start();
if($_SESSION["strCustomerID"] == "")
{
	header("location:WebServiceClient_Login.php");
	exit();
}
?>

<html>
<head>
<title>ThaiCreate.Com</title>
</head>
<body>

<form action="WebServiceClient_Save.php" method="post" name="frmMain" id="frmMain">
<?php
		include("lib/nusoap.php");
		$client = new nusoap_client("http://localhost/nusoap/WebServiceServer_Show.php?wsdl",true); 
		$params = array(
				   'strCustomerID' => $_SESSION["strCustomerID"]
		);
		$data = $client->call('resultCustomer', $params);
?>

Update Profile for : <b><?php echo $data[0]["Name"];?></b>..... <br><br>
	
  <table width="374" border="1" cellpadding="2" cellspacing="2">
    <tr>
      <td width="89">CustomerID</td>
      <td width="144"><?php echo $data[0]["CustomerID"];?>
	  <input name="txtCustomerID" type="hidden" id="txtCustomerID" value="<?php echo $data[0]["CustomerID"];?>">
	  </td>
    </tr>
    <tr>
      <td width="89">Username</td>
      <td width="144"><?php echo $data[0]["Username"];?></td>
    </tr>
    <tr>
      <td width="89">Password</td>
      <td width="144"><input name="txtPassword" type="password" id="txtPassword" value="<?php echo $data[0]["Password"];?>"></td>
    </tr>
    <tr>
      <td width="89">Name</td>
      <td width="144"><input name="txtName" type="text" id="txtName" value="<?php echo $data[0]["Name"];?>"></td>
    </tr>
    <tr>
      <td width="89">Email</td>
      <td width="144"><input name="txtEmail" type="text" id="txtEmail" value="<?php echo $data[0]["Email"];?>"></td>
    </tr>
    <tr>
      <td width="89">CountryCode</td>
      <td width="144"><input name="txtCountryCode" type="text" id="txtCountryCode" value="<?php echo $data[0]["CountryCode"];?>"></td>
    </tr>
    <tr>
      <td width="89">Budget</td>
      <td width="144"><input name="txtBudget" type="text" id="txtBudget" value="<?php echo $data[0]["Budget"];?>"></td>
    </tr>
    <tr>
      <td width="89">Used</td>
      <td width="144"><input name="txtUsed" type="text" id="txtUsed" value="<?php echo $data[0]["Used"];?>"></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input name="btnSubmit" type="submit" id="btnSubmit" value="Save">
		<input name="btnReset" type="reset" id="btnReset" value="Reset"></td>
    </tr>
  </table>
  <br>

<?php
	$data = null;
?>
</form>
</body>
</html>

<?php
session_start();
if($_SESSION["strCustomerID"] == "")
{
	header("location:WebServiceClient_Login.php");
	exit();
}
?>

<html>
<head>
<title>ThaiCreate.Com</title>
</head>
<body>

  <?php
		include("lib/nusoap.php");
        $client = new nusoap_client("http://localhost/nusoap/WebServiceServer_Save.php?wsdl",true); 
        $params = array(
                   'strCustomerID' => $_POST["txtCustomerID"],
				   'strPassword' => $_POST["txtPassword"],
				   'strName' => $_POST["txtName"],
				   'strEmail' => $_POST["txtEmail"],
				   'strCountryCode' => $_POST["txtCountryCode"],
				   'strBudget' => $_POST["txtBudget"],
				   'strUsed' => $_POST["txtUsed"]
        );
		$data = $client->call("saveUpdateCustomer",$params); 

		if($data[0] == true)
		{
			echo "Update Successfully ... <a href='WebServiceClient_Show.php'>Back to menu</a>";
		}
		else
		{
			echo "Update Failed error...".$data[1];
		}

  ?>

</body>
</html>