/SQL/Sql query for login with email or username

Sql query for login with email or username

if($_POST['username'] != '' && $_POST['password'] != ''){$name = $_POST['username'];$pass = md5($_POST['password']);$check_email = Is_email($name);if($check_email){// email & password combination$query = mysql_query("SELECT * FROM `users` WHERE `email` = '$name' AND `password` = '$pass'");} else {// username & password combination$query = mysql_query("SELECT * FROM `users` WHERE `username` = '$name' AND `password` = '$pass'");}$rows = mysql_num_rows($query);if($rows > 0){//successfull login$_SESSION['username'] = $name;} else {$msg = "Invalid Login Credentials";}mysql_close($connection);} else {$msg = "Please Provide All Details";}

Source: w3lessons.info

Similar codes

15 votes114 views5 answers
Show tables in oracle
SQL
1 vote102 views1 answer
Update from select join
SQL
0 vote163 views1 answer
Connect google bigquery connect using sqirrel
SQL
1 vote106 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote94 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
6 votes107 views3 answers
Oracle all dates between two dates
SQL
15 votes253 views2 answers
How to sort names in alphabetical order in sql
SQL
2 votes120 views1 answer
Mysql shell insert into
SQL
0 vote102 views1 answer
Mysql set column equal to another automatic
SQL
0 vote108 views1 answer
Azure sql server check foreign key
SQL