Check if email address exists in the data base and sending message

Question

Im trying to check if the email exist in the ddbb, so my code is:

<?php
include 'connection.php';
$email=addslashes ($_POST['cEmail']);
$sqlEmail = "select cEmail from Client where cEmail = '$email'";
$exist = mysql_fetch_row($sqlEmail); 

if (isset($_POST['submit']))
    {
        if($exist == false){
            $name = addslashes ($_POST['cName']);   
            $surname=addslashes ($_POST['cSurname']);
            $email=addslashes ($_POST['cEmail']);
            $phone=addslashes ($_POST['cPhone']);
            $otherPhone=addslashes($_POST['cOtherPhone']);
            $languages=implode(' | ', $_POST['cLanguages']);
            $address=addslashes ($_POST['cAddress']);
            $neighborhood=addslashes ($_POST['cNeighborhood']);
            $pswd=addslashes($_POST['cPswd']);
            $service= addslashes ($_POST['cService']);

            $sql = "INSERT INTO Client(cName, cSurname, cEmail, cPhone, cOtherPhone, cLanguages, cAddress, cNeighborhood, cPswd, cService) 
                VALUES ('$name', '$surname', '$email', $phone, $otherPhone, '$languages', '$address', '$neighborhood', '$pswd', '$service')";

            if ($conn->query($sql) === TRUE) {
                echo "New record created successfully";
            }
        }else{
            echo "the email exists";
        }
    }

?>

So the problem becomes when the email address exist in the database, is not giving any message. Any ideas?

Thanks!

you're not checking for errors via PHP and MySQL. and the HTML form for this is unknown — Funk Forty Niner, Aug 27 '16 at 13:50
possible duplicate of [Can I mix MySQL APIs in PHP?](http://stackoverflow.com/questions/17498216/can-i-mix-mysql-apis-in-php) — Funk Forty Niner, Aug 27 '16 at 13:51
**Side note:** SQL Injection prone. The `addslashes()` does not guard against injection. — Rasclatt, Aug 27 '16 at 13:51
You shouldn't use `$_POST['email]` before `if(isset($_POST['submit']))`. — Barmar, Aug 27 '16 at 13:57
**General note:** The logic is somewhat confusing. You have the `if` statement at the top, but the top 4 lines are all required to have the `$_POST` happen as well. — Rasclatt, Aug 27 '16 at 13:57
possible duplicate of [check if row exists with mysql](http://stackoverflow.com/questions/22252904/check-if-row-exists-with-mysql) — Funk Forty Niner, Aug 27 '16 at 13:58

score 0 · Answer 1 · answered Aug 27 '16 at 14:29

Hi @AlguienEnEsteMundo,

Your code is incorrect so it is generating warning "mysql_fetch_row() expects parameter 1 to be resource, string given"(please check your php ini setting to display the warning message). Following is the correct code, please update your code with:

include 'connection.php';
$email=addslashes ($_POST['cEmail']);
$sqlEmail = "select cEmail from Client where cEmail = '$email'";
$res = mysql_query($sqlEmail);
$exist = mysql_fetch_row($res);

Hope this may fix your issue...

Check if email address exists in the data base and sending message

1 Answers1