kodunuz şöyle olabilirdi
***$email = $_POST['email'];
***$sifre = $_POST['password'];
***$ad = $_POST['ad'];
***$cep = $_POST['cep'];
****
***$result = mysqli_query($conn, "SELECT COUNT(*) as miktar FROM uye WHERE email='" . $email . "'")
****$row = mysqli_fetch_assoc($result);** 
****if ($row['miktar'] == 0) { 
****echo "email already exists";
***}
***else
***{
***$sql2 = "INSERT INTO uye (email,sifre,ad,cep) VALUES ('$email','$sifre','$ad','$cep')";
***if ($conn->query($sql2) === TRUE) {
****echo "New record created successfully";
***} else {
****echo "Error: " . $sql . "<br>" . $conn->error;
***}
***}