<?php
$user='';
$pass='';
$db='';
$dbserver='';


$conn = mysqli_connect($dbserver, $user, $pass, $db);

// Check connection
if (!$conn) {
 die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";

?>

<?php

 include('database2.php');

 if (isset($_SERVER['HTTP_ORIGIN'])) {
    header("Access-Control-Allow-Origin: *");
    header('Access-Control-Allow-Credentials: true');
    header('Access-Control-Max-Age: 86400');    // cache for 1 day
}

// Access-Control headers are received during OPTIONS requests
if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {

    if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD']))
        header("Access-Control-Allow-Methods: GET, POST, OPTIONS");

    if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']))
        header("Access-Control-Allow-Headers:        {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}");

    exit(0);
}

$conn = mysqli_connect($dbserver, $user, $pass, $db);

// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

echo "Connected successfully";

 $postdata = file_get_contents("php://input");
if (isset($postdata)) {
 $request = json_decode($postdata);
 $username = $request->username;
 $userpass = $request->userpass;
 $sql = sprintf("SELECT * FROM account_info   where a_username='%s' ",
 //WHERE User_Name='%s' AND User_Pass='%s'
        mysqli_real_escape_string($conn,$username),
        mysqli_real_escape_string($conn,$userpass));
$result=$conn->query($sql);
if ($result->num_rows>0)
{  $UserID=0;
  while($row=$result->fetch_assoc())
  {$UserID=$row["acc_id"];
  }
   $myobj=array();
   array_push($myobj,array('isloggedin'=>'true','userid'=>$UserID));
   echo json_encode($myobj);
}

  else
  {
    $myobj=array();
   array_push($myobj,array('isloggedin'=>'false'));
   echo json_encode($myobj);
   }
   }
?>

Login()
{
console.log(this.UserName);
console.log(this.UserPass);
this.Loading();
var body=JSON.stringify({username:this.UserName,userpass:this.UserPass});

var link=this.links.getLink()+"login.php";

this.http.post(link,body)

  .subscribe(re=>{

  try
  {   let s=re.json();
    console.log(re.json());
    if(s[0].isloggedin=="true")
    {
      this.loading.dismiss();
      this.shareu.setUser(s[0].userid,this.UserName);
      this.showAlert2('Sign in');
    }
    else {this.loading.dismiss();this.showAlert('Wrong Credentials for Username :'+this.UserName);
    }
  }
  catch(e)
  {this.loading.dismiss();
    console.log(re['_body']);
    this.showAlert('Something Went Wrong!');
  }

 });
}