/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 vote184 views1 answer
Describe table in sql
SQL
0 vote268 views1 answer
Bigrock database connection string
SQL
0 vote172 views1 answer
Get number of tables in database sql
SQL
1 vote185 views1 answer
Add current timestamp in mysql
SQL
0 vote166 views1 answer
Add colum date in sql
SQL
1 vote183 views1 answer
How to set up a trigger in sql
SQL
0 vote267 views1 answer
Select milliseconds mysql
SQL
0 vote184 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote209 views1 answer
Mysql limit order by
SQL
10 votes218 views6 answers
Mysql set root password
SQL