<?php
error_reporting(0);
 $servername = "localhost";
	$username = "smihalovskih";
	$password = "testing123";

$conn = mysql_connect($servername, $username, $password);
$email =  $_GET['email'];


$sqldata = mysql_query("SELECT * FROM testmasu.users WHERE testmasu.users.email='$email'");


$rows = array();
while($r = mysql_fetch_assoc($sqldata)) {
     $rows['id'] = $r['id'];
     $rows['name'] = $r['first_name'];
     $rows['lastname'] = $r['last_name'];
     $rows['email'] = $r['email'];
     $rows['mobile'] = $r['phone'];

}

echo json_encode($rows);
mysql_close($conn);

?>