检查用户并使用mysql传递 [英] check user and pass with mysql

问题描述

我输出0

如何理解用户o传递是否正确？

 $ user_name = $ _POST ['  user_name']; 
 $ password = md5（$ _ POST ['  password']）; 
 $ con = mysql_connect（  localhost，  root，  22646146 ）; 
 
 mysql_select_db（  bs，$ con）; 
 $ query =   select * from login其中user_name ='$ user_name'和password ='$ password'限制1; 
 $ result = mysql_query（$ query）; 
 
  if （$ result）
 {
 $ num_rows = mysql_num_rows（$ result）; 
 echo $ num_rows; 
} 
  else  
 {
 echo mysql_error（）; 
} 
？>  

解决方案

user_name =

_POST [' user_name'];

密码= MD5（

i give "0" for output
how i can understand the user o pass is correct or not?

$user_name=$_POST['user_name'];
$password=md5($_POST['password']);
$con=mysql_connect("localhost","root","22646146");

mysql_select_db("bs",$con);
$query="select* from login  where user_name='$user_name' and password='$password'  LIMIT 1"; 
$result= mysql_query($query);

if($result)
{
     $num_rows=mysql_num_rows($result);
     echo $num_rows ;
}
else
{
     echo mysql_error();
}
?>

解决方案

user_name=

_POST['user_name'];

password=md5(

这篇关于检查用户并使用mysql传递的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！