<?php
include("Admin/Includes/db.php");

if(isset($_POST['regi_submit'])){

$bid = $_GET['id'];
extract($_POST);

     $query = "SELECT * FROM `tbl_user` WHERE  id='$bid' and otp='$otp'";

    

    $result = mysqli_query($con, $query);

    $return_array = array();

    if (mysqli_num_rows($result) > 0)

     {
        //  $sql_row = mysqli_fetch_assoc($result);
        //   $SQL1 = "update  tbl_user set otp_verified='1' where id='$bid'";

        // $sql_res1 = mysqli_query($con, $SQL1) or die(mysqli_error($con));
        
          $_SESSION['flash_message'] = 'userverify';
                        
                         echo "<script>;
                alert('User Verifed  Succesfully');
                window.location.href='login.php';

                </script>";

    } else {
        
        $_SESSION['flash_message'] = 'invalid';

         echo "<script>;
                 alert('invalid Otp');
                window.location.href='otp_veify.php?id=$bid';

                // </script>";

       

    }
}