PHP& MySql登录错误 [英] PHP & MySql Login Error

问题描述

我创建了一个PHP& MySql登录但它无法正常工作。就像我输入正确或错误的用户名/密码每次都显示错误的用户名或密码。



这是我的编码。

< br $>
Login.html表格编码

 <  表格    id   =  form1   名称  =  form1   方法  =  post    action   =  login.php >  
 <   div     class   =  form-group col-md-6 >  
 <   label     class   =  sr-只有      =  exampleInputEmail1 > 用户名：* <   / label  >  
 < ;  输入   必需    type   =  text    class   =  form-control    id   =  username    name   = 用户名   占位符  = 用户名：* >  
 <   / div  >  
 <   div     class   =  form-group col-md-6 >  
 <  标签    class   =  sr-only    for   =  exampleInputEmail1 > 密码：* <   / label  >  
 <   input     required    类型  = 密码    class   = 表格控制    id   = 密码   名称  = 密码   占位符  = 密码：*  >  
 <   / div  >  
& nbsp;& nbsp;& nbsp;& nbsp;& nbsp; 
 <  输入   < span class =code-attribute> id   =  submit   类型  = 提交    class   =  btn btn-lg btn-primary    value   = 提交   < span class =code-attribute> style   =  width：130px >  
忘记用户名或密码？<   / form  >  <   / div  >  

login.php页面编码

 <？php  
 session_start（）; 
 
 ob_start（）; 
 
  $ conn  = mysqli_connect（  localhost，  root， ，  hct_db< /跨度>）; 
  if （mysqli_connect_errno（））
 {
  echo   无法连接到MySQL：。 mysqli_connect_error（）; 
} 
  //  定义$ myusername和$ mypassword  
 $ username = $ _ POST ['  username']; 
 $ password = $ _ POST ['  password']; 
 
 
  //  保护MySQL注入（有关MySQL注入的更多细节） 
  $ username  = stripslashes（$ username）; 
  $ password  = stripslashes（$ password）; 
  $ username  = mysqli_real_escape_string（$ conn，$ username）; 
  $ password  = mysqli_real_escape_string（$ conn，$ password）; 
 $ sql =   SELECT用户名，密码FROM admin ORDER BY username; 
 $ result = mysqli_query（$ conn，$ sql）; 
 
  //   Mysql_num_row正在计算表格行 
 $ count = mysqli_num_rows（$结果）; 
 
  //  如果结果与$ myusername和$ mypassword匹配，则表格行必须为1行 
 if（$ count == 1）{
 
  //  注册$ myusername，$ mypassword并重定向到文件login_success.php 
 session_register（ 用户名）; 
 session_register（  password）; 
 header（  location：admin / index.php）; 
} 
 其他 {
  echo   用户名或密码错误; 
} 
 ob_end_flush（）; 
 ？>  

请帮助我

解决方案

conn = mysqli_connect（ localhost， root， ， hct_db）;
if （mysqli_connect_errno（））
{
echo 无法连接到MySQL：。 mysqli_connect_error（）;
}
// 定义

myusername和

输入mypassword

I have created a PHP & MySql login but its not working. Like if i put right or wrong username/password Its showing "Wrong Username or Password" everytime.

here is my coding.

Login.html form coding

<form id="form1" name="form1" method="post" action="login.php">
          <div class="form-group col-md-6">
              <label class="sr-only" for="exampleInputEmail1">User Name: *</label>
              <input required type="text" class="form-control" id="username" name="username" placeholder="User Name: *">
            </div>
<div class="form-group col-md-6">
              <label class="sr-only" for="exampleInputEmail1">Password: *</label>
              <input required type="password" class="form-control" id="password" name="password" placeholder="Password: *">
            </div>
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <input id="submit" type="submit" class="btn btn-lg btn-primary" value="Submit" style="width: 130px">
          Forgot Username or Password ?</form></div>

login.php page coding

<?php
session_start();

ob_start();

$conn = mysqli_connect("localhost","root","","hct_db");
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
 // Define $myusername and $mypassword
$username=$_POST['username'];
$password=$_POST['password'];


// To protect MySQL injection (more detail about MySQL injection)
$username = stripslashes($username);
$password = stripslashes($password);
$username = mysqli_real_escape_string($conn, $username);
$password = mysqli_real_escape_string($conn, $password);
$sql="SELECT username, password FROM admin ORDER BY username";
$result=mysqli_query($conn,$sql);

// Mysql_num_row is counting table row
$count=mysqli_num_rows($result);

// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){

// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("username");
session_register("password");
header("location:admin/index.php");
}
else {
echo "Wrong Username or Password";
}
ob_end_flush();
?>

Please Help ME

解决方案

conn = mysqli_connect("localhost","root","","hct_db"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // Define

myusername and

mypassword

这篇关于PHP&amp; MySql登录错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！