<?php include('../../config/main_function.php'); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); $username = mysqli_real_escape_string($connection , $_POST['check_mail']); $find_email = "SELECT COUNT(username) as duplicate FROM tbl_member WHERE username = '$username';"; $rs_email = mysqli_query($connection , $find_email); $row_email = mysqli_fetch_array($rs_email); if($row_email['duplicate'] > 0){ $arr['result'] = 1; } else { $arr['result'] = 0; } echo json_encode($arr); mysqli_close($connection);