/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

0 vote128 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
24 votes118 views4 answers
Postgres remove database
SQL
0 vote109 views1 answer
Select all same column value in sql
SQL
-1 vote117 views1 answer
Add column alter table default value
SQL
0 vote122 views1 answer
Query string starts with vowels
SQL
0 vote122 views1 answer
Table user postgres
SQL
18 votes123 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote118 views3 answers
Between keyword sql
SQL
0 vote117 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
1 vote127 views5 answers
What is in operator in sql
SQL