/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

1 vote161 views1 answer
Oracle user last connection date
SQL
0 vote137 views1 answer
Mariadb search columns
SQL
0 vote137 views1 answer
Add multiple field in table sql
SQL
1 vote134 views1 answer
Sql headers delphi
SQL
0 vote125 views1 answer
Inser into example
SQL
0 vote136 views1 answer
Sql get count without group by
SQL
0 vote132 views1 answer
What are the aggregate function in sql
SQL
3 votes179 views3 answers
Restart mysql mac
SQL
1 vote131 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote135 views1 answer
Mysql function variable
SQL