php - 如何使生成的代码在输入几次后过期(PHP)？

Question

我一直在尝试用 PHP 编写一段代码，生成随机代码，将其存储在数据库中并要求用户输入它。如果该代码输入超过 3 次，则该代码需要过期。这是我的代码:

<?php
include("ProcessCode.php"); 
$con = mysqli_connect("localhost","root","") ;
if(mysqli_select_db($con,"login"))
{
echo 'database  selected' ;
}

$rand=rand();
echo $rand ;

$sql = "INSERT INTO random (number) VALUES ('$rand') "  ;

if(mysqli_query($con,$sql))
{
   echo 'inserted'  ;
}

?>
    $CodeCheck=$_POST['code'];

     //Establishing Connection with server
     $conn = mysqli_connect("localhost", "root", "");

      //Selecting Database
      $db = mysqli_select_db($conn, "login");

       //sql query to fetch information of registerd user and finds user match.
      $query = mysqli_query($conn, "select * from random WHERE number='$CodeCheck'");

       $rows = mysqli_num_rows($query);

      if (mysqli_num_rows($query) > 0)
         {
          echo " Code exists already.";
         }

      if($rows == 1)
       {
        header("Location: Success.php");

       }
     else
     {
      $error = " Code is Invalid";
      echo $error;
     }

您能解释一下如何实现过期部分吗？

Answer 1

在你的表中你可以有一个计数字段。当使用登录且登录错误时，将计数加+1。当用户登录成功后，重置计数。如果计数满足+3，则重置代码。