Home > Backend Development > PHP Tutorial > PHP验证数据库密码问题

PHP验证数据库密码问题

WBOY
Release: 2016-06-23 13:28:51
Original
1026 people have browsed it

[/img] [/img]
我是php初学者,写了一个到数据库验证用户的简单代码,无论输对的还是错的账号密码都不能通过验证。求高手指点


回复讨论(解决方案)

$res= mysqli_query($conn,$sql);
if($row= mysql_fetch_assoc($res)){

mysql 和 mysqli 是平行的两个扩展,不能混用!

$res= mysqli_query($conn,$sql);
if($row= mysql_fetch_assoc($res)){

mysql 和 mysqli 是平行的两个扩展,不能混用!


请问应当怎么写可以解决问题

$res= mysqli_query($conn,$sql);
if($row= mysql_fetch_assoc($res)){

mysql 和 mysqli 是平行的两个扩展,不能混用!


改成了if ($row=mysqli_fetch_assoc($res))解决了问题,感谢大神

header("Content-type: text/html; charset=utf-8");class cls_Mysqli{    private $db_host="localhost";    private $db_user="root";     private $db_password="root";    private $db_name="test";    protected $sql;    public $password;        function __construct($id,$password){    	  $this->password = $password;    	  $this->sql = "select password from admin where id = $id";    }          function checkPassword(){    	  global $link;        $link = mysqli_connect($this->db_host, $this->db_user, $this->db_password, $this->db_name) or die("数据库错误: " . mysqli_connect_error());        $res  = mysqli_query($link,$this->sql);        if ($row_val = mysqli_fetch_row($res)){              if ($this->password == $row_val[0]){                  return true;              }else{                  return false;              }                      }    }}$query = new cls_Mysqli(1,'123');print $query->checkPassword();mysqli_close($link);
Copy after login

@xuzuning
if 结构执行了return,这个mysqli资源要怎么释放才合理。

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template