query($sql);
$data = $rows->fetch_assoc();
if($data['TOTAL'] > 0)
{
echo "Email Alrady Exists";
$con->close();
exit;
}
//check mobile number Exists or not
$sql = "SELECT COUNT(`client_table`.`client_id`) AS 'TOTAL' FROM `client_table` WHERE `client_table`.`mobile_no` = '$mo_no'";
$rows = $con->query($sql);
$data = $rows->fetch_assoc();
if($data['TOTAL'] > 0)
{
echo "Mobile Number Alrady Exist";
$con->close();
exit;
}
//Insert Logic
$sql = "INSERT INTO `client_table` (`client_id`, `name`, `surname`, `profil_pic`, `e_mail`, `mobile_no`, `password`, `address`, `pincode`, `fcm_id`, `last_seen`) VALUES (NULL, '$fname', '$lname', NULL, '$email', '$mo_no', '$pass', '$add', '$pin', '$fcm', NULL)";
if($con->query($sql) == TRUE)
{
$sql = "SELECT `client_table`.`client_id` AS 'ID' FROM `client_table` WHERE `client_table`.`e_mail` = '$email'";
$rows = $con->query($sql);
$data = $rows->fetch_assoc();
echo $data['ID'];
$con->close();
exit;
}
else
{
echo "ERROR";
$co