<?php 
include("db_config.php");   
if($_SERVER['REQUEST_METHOD']=='POST'){	
	//var_dump($_POST);
	extract($_POST);  
	date_default_timezone_set('Asia/Kolkata');
       $date = date('Y-m-d H:i:s');
	$email = $_POST['email'];
	$password = $_POST['password'];
	$sql = "SELECT count(*) as num FROM user_profile WHERE email = '$email' AND password='$password'";
	$result = mysqli_query($conn, $sql) or die(mysqli_error($conn));
	$res= mysqli_fetch_array($result);
    $count=$res['num']; 
    $sql_qry = "SELECT id FROM user_profile WHERE email = '$email'";
	$ress = mysqli_fetch_array(mysqli_query($conn,$sql_qry));
	$user_id = $ress['id'];
    if($count > 0 )
    { 
         $response['user_id']=$user_id;
		$response['status']=1;
	}else{
          $sql1 = "INSERT INTO user_profile(email,fname,created_date) values ('$email','$name','$date')";
		$result1 = mysqli_query($conn, $sql1) or die(mysqli_error($conn));
		 $last_id= mysqli_insert_id($conn);
		$response['user_id']=$last_id;
          $response['status']=2;
	}
	echo json_encode($response);
	mysqli_close($conn);
}