trying to check if email already exists but my code is not working

Question

Passy 0 Newbie Poster

5 Years Ago

                $sql="SELECT * FROM `customer_information_table` WHERE `email`='{email}'";
                $result = $db->query($sql);
                      if($db->error)
                        {
                            exit("SQL error.
                                 <a href = './register.php'>return</a>");
                        }

                      if($result->num_rows!==0)
                      {
                        exit("email address already exists.
                             <a href = './register.php'>return</a>");
                      }

php

Edited 5 Years Ago by Passy

2 Contributors
1 Reply
128 Views
2 Hours Discussion Span
Latest Post 5 Years Ago Latest Post by AndreRet

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

AndreRet 526 Senior Poster · Answer 1 · 2020-03-25T10:25:14+00:00

I picked up a few lines that might not have the desired return you want, try the following...

$email = here@there.com; //Sample and not checked for validation...
$sql="SELECT * FROM `customer_information_table` WHERE `email`='".$email."'";
                $result = $db->query($sql);
                      if($db->error)
                        {
                            exit("SQL error.
                                 <a href = './register.php'>return</a>");
                        }
                      if(count($result) > 0)
                      {
                        exit("email address already exists.
                             <a href = './register.php'>return</a>");
                      }