<?php
//Database connection
$host="localhost";
$user="root";
$password="";
$db="flex";
$mysql = mysql_connect($host, $user, $password) or die(mysql_error());
mysql_select_db($db);
$output="";
//asign the data passed from Flex to variables
$username = mysql_real_escape_string($_POST["username"]);
$password = mysql_real_escape_string($_POST["password"]);
//Checking Duplicate record code
$qry1 = "SELECT * FROM flex1 WHERE username='".$username."' ";
$result=mysql_query($qry1) or die("Error1 in jay2.php".mysql_error() );
$num=mysql_num_rows($result);
if($num)
{
	$output .= "Not Saving, Record $username Allready Exist";
}
else
{
	$query = "INSERT INTO flex1 SET username='".$username."', password = '".$password."'";
	$result=mysql_query($query);
	if($result)
	{
		$output .= "Congrates Data saved Successfully";
	}
	else
	{
		$output .= "Sorry, Data Not saved, some unexpected error";
	}
}
$sendtoFlex .= "<result_from_php>";
$sendtoFlex .= $output;		
$sendtoFlex .= "</result_from_php>";
print ($sendtoFlex);
?>