/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 vote213 views1 answer
How to combine rows in sql server procedure
SQL
2 votes180 views1 answer
Sqlplus clear screen
SQL
1 vote180 views1 answer
How to delete data from sql database in android
SQL
0 vote178 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote187 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote184 views1 answer
Sql server alter table column nullable
SQL
2 votes141 views2 answers
Mysql get last character of string
SQL
0 vote187 views1 answer
Mysql find missing values
SQL
0 vote186 views1 answer
Mysql subdate
SQL
0 vote210 views1 answer
Sql max of two values
SQL