Select Statement in PHP Script

Question

I have created a registration page in PHP and MySQL.

How to prevent user from registering again with the following details: "fname,lname,user_name,email,bikeno,mobileno".

I tried with the following select statement, but its not working.

$sql="select * from user_registration where fname='".$fname."' and lname='".$lname."' and user_name='".$user_name."' and  email='".$email."' and bikeno='".$bikeno."' and mobileno='".$mobileno."'";

What I need is if the user gives any duplicate details in these columns the user is not registered.

If you want to avoid duplicates on individual columns use OR instead of AND — phobia82
– phobia82, Commented Nov 30, 2016 at 12:39
you should not allow user with same bike number or same mobile number or user name,, Users may have same first name or last name — Nishant Solanki
– Nishant Solanki, Commented Nov 30, 2016 at 12:39
Before inserting use select statement if result is 1 then prompt user already created else use insert statement. — Abhishek Gurjar
– Abhishek Gurjar, Commented Nov 30, 2016 at 12:40
On an additional note, you should not store passwords as plain text — phobia82
– phobia82, Commented Nov 30, 2016 at 12:49

Abhishek Gurjar · Accepted Answer · 2016-11-30 14:10:19Z

1

$sql="select * from user_registration where fname='".$fname."' or lname='".$lname."' or user_name='".$user_name."' or  email='".$email."' or bikeno='".$bikeno."' or mobileno='".$mobileno."'";

//After select query check if users exist or not as

$result = $con->query($sql);

if($result->num_rows > 0)
{
    //Here Prevent the user registration with the same details
}
else
{
    //Here Insert record into the table
}

edited Nov 30, 2016 at 14:10

Abhishek Gurjar

7,47610 gold badges41 silver badges47 bronze badges

answered Nov 30, 2016 at 12:50

ChandraShekar

3865 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sam · Accepted Answer · 2016-11-30 12:53:05Z

1

Try this code

$res = mysqli_query($con,"$sql="select * from user_registration where fname='".$fname."' and lname='".$lname."' and user_name='".$user_name."' and  email='".$email."' and bikeno='".$bikeno."' and mobileno='".$mobileno."'";
");

if(mysqli_num_rows($res) > 1)
echo "User Already Exist";
else
// run insert query

answered Nov 30, 2016 at 12:53

sam

6982 gold badges13 silver badges36 bronze badges

Collectives™ on Stack Overflow

Select Statement in PHP Script

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related