如何从像facebook这样的php中的多个字段中检查登录用户名

Question

This is my login form. I want to check username from company name or by nik_name, and password is mandatory field. As like facebook in which we can login from contact number or email, as like that i want to login from either company name or nick name.

<input type="text" class="form-control login-field" value=""
       placeholder="Username / Company Name" id="login-name"  name="email" />
<input type="password" class="form-control login-field" value=""
       placeholder="Password" id="login-pass" name="password" />

This is my SQL query to check nickname and password:

SELECT *
FROM buyers_login
WHERE nik_name = "' . mysql_real_escape_string($loginEmail) . '"
  AND password = MD5("' . $loginPassword . '")
LIMIT 1

What will be the SQL query to check companyname or nickname with password ???

Answer 1

Modify your sql query to this

$loginEmail = trim($_POST['email']);  
$loginPassword  = trim($_POST['password']);  

SELECT * FROM buyers_login WHERE (nik_name = "'.
mysql_real_escape_string($loginEmail).'" OR email = "'.
mysql_real_escape_string($loginEmail).'") AND password = MD5("' .
$loginPassword . '") LIMIT 1

where {text_email_or_company} is taken from your post request, you can also change name fo you email input to username_or_company

UPDATE

if your provided query in question correct and working for you, then use this query but instead company use appropriate field from your buyers_login table

SELECT * FROM buyers_login WHERE (nik_name = "' . mysql_real_escape_string($loginEmail) . '" OR company = "' . mysql_real_escape_string($loginEmail) . '"  )  AND password = MD5("' . $loginPassword . '") LIMIT 1