Android Insert Data to Server via Web Service

CREATE TABLE `member` (
  `MemberID` int(2) NOT NULL auto_increment,
  `Username` varchar(50) NOT NULL,
  `Password` varchar(50) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Tel` varchar(50) NOT NULL,
  `Email` varchar(150) NOT NULL,
  PRIMARY KEY  (`MemberID`),
  UNIQUE KEY `Username` (`Username`),
  UNIQUE KEY `Email` (`Email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `member`
-- 

INSERT INTO `member` VALUES (1, 'weerachai', 'weerachai@1', 'Weerachai Nukitram', '0819876107', '[email protected]');
INSERT INTO `member` VALUES (2, 'adisorn', 'adisorn@2', 'Adisorn Bunsong', '021978032', '[email protected]');
INSERT INTO `member` VALUES (3, 'surachai', 'surachai@3', 'Surachai Sirisart', '0876543210', '[email protected]');

<?
ob_start();
		require_once("lib/nusoap.php");
		 
		//Create a new soap server
		$server = new soap_server();
		 
		//Define our namespace
		$namespace = "https://www.thaicreate.com/android/insertMemberData.php";
		$server->wsdl->schemaTargetNamespace = $namespace;
		 
		//Configure our WSDL
		$server->configureWSDL("insertMember");
		 
		// Register our method and argument parameters
        $varname = array(
                   'strUsername' => "xsd:string",
				   'strPassword' => "xsd:string",
				   'strName' => "xsd:string",
				   'strEmail' => "xsd:string",
				   'strTel' => "xsd:string"
        );
		$server->register('insertMember',$varname, array('return' => 'xsd:string'));
		 
		function insertMember($strUsername,$strPassword,$strName,$strEmail,$strTel)
		{

				$objConnect = mysql_connect("localhost","root","root");
				$objDB = mysql_select_db("mydatabase");

				/*** Check Username Exists ***/
				$strSQL = "SELECT * FROM member WHERE Username = '".$strUsername."' ";
				$objQuery = mysql_query($strSQL);
				$objResult = mysql_fetch_array($objQuery);
				if($objResult)
				{
					$arr['StatusID'] = "0"; 
					$arr['Error'] = "Username Exists!";	

					header('Content-type: application/json');
					mysql_close($objConnect);

					return json_encode($arr);
				}

				/*** Check Email Exists ***/
				$strSQL = "SELECT * FROM member WHERE Email = '".$strEmail."' ";
				$objQuery = mysql_query($strSQL);
				$objResult = mysql_fetch_array($objQuery);
				if($objResult)
				{
					$arr['StatusID'] = "0"; 
					$arr['Error'] = "Email Exists!";	

					header('Content-type: application/json');
					mysql_close($objConnect);

					return json_encode($arr);
				}

				
				/*** Insert ***/
				$strSQL = "INSERT INTO member (Username,Password,Name,Email,Tel) 
					VALUES (
						'".$strUsername."',
						'".$strPassword."',
						'".$strName."',
						'".$strEmail."',
						'".$strTel."'
						)
					";

				$objQuery = mysql_query($strSQL);
				if(!$objQuery)
				{
					$arr['StatusID'] = "0"; 
					$arr['Error'] = "Cannot save data!";	
				}
				else
				{
					$arr['StatusID'] = "1"; 
					$arr['Error'] = "";	
				}

				/**
					$arr['StatusID'] // (0=Failed , 1=Complete)
					$arr['Error'] // Error Message
				*/
				
				mysql_close($objConnect);
				
				header('Content-type: application/json');
				return json_encode($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(); 
?>

<TableLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:id="@+id/tableLayout1"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent">
 
   	<TableRow
      android:id="@+id/tableRow1"
      android:layout_width="wrap_content"
      android:layout_height="wrap_content" >
     
     <TextView
        android:id="@+id/textView1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:gravity="center"
        android:text="Register Form (Web Service)"
        android:layout_span="1"
        android:textAppearance="?android:attr/textAppearanceLarge" />
  	        
 	</TableRow>

	<View
		android:layout_height="1dip"
		android:background="#CCCCCC" />
 
  <TableLayout 
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_weight="0.1"
        android:orientation="horizontal">

      <TextView
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:text="Input Username :"
          android:textAppearance="?android:attr/textAppearanceMedium" />

      <EditText
          android:id="@+id/txtUsername"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:ems="10" >
      </EditText>

      <TextView
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:text="Input Password/Confirm Password :"
          android:textAppearance="?android:attr/textAppearanceMedium" />
		<TableRow>
      <EditText
          android:id="@+id/txtPassword"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:ems="6"
          android:inputType="textPassword" >
      </EditText>
      <TextView
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:text=" Again " />

      <EditText
          android:id="@+id/txtConPassword"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:ems="7"
          android:inputType="textPassword" >
      </EditText>
      </TableRow>
      
      <TextView
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:text="Input Name :"
          android:textAppearance="?android:attr/textAppearanceMedium" />

      <EditText
          android:id="@+id/txtName"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:ems="10" >
      </EditText>
      
      <TextView
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:text="Input Email :"
          android:textAppearance="?android:attr/textAppearanceMedium" />

      <EditText
          android:id="@+id/txtEmail"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:inputType="textEmailAddress"
          android:ems="10" >
      </EditText>
      
      <TextView
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:text="Input Tel :"
          android:textAppearance="?android:attr/textAppearanceMedium" />

      <EditText
          android:id="@+id/txtTel"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:inputType="phone"
          android:ems="10" >
      </EditText>

		<Button
		    android:id="@+id/btnSave"
		    android:layout_width="wrap_content"
		    android:layout_height="wrap_content"
		    android:text="Save" />
		
  	        
 	</TableLayout >

	<View
		android:layout_height="1dip"
		android:background="#CCCCCC" />
   		  
   	<LinearLayout
      android:id="@+id/LinearLayout1"
      android:layout_width="wrap_content"
      android:layout_height="wrap_content"
      android:padding="5dip" >

   		<TextView
   		    android:id="@+id/textView2"
   		    android:layout_width="wrap_content"
   		    android:layout_height="wrap_content"
   		    android:text="By.. ThaiCreate.Com" />

	</LinearLayout>
	
</TableLayout>