如何使用mysql数据库验证get方法表单

dauxcl2d 于 2021-06-20 发布在 Mysql

关注(0)|答案(2)|浏览(407)

我想通过mysql数据库检查udise代码是否已经存在…我的代码如下。。。如何验证此字段？请帮忙

<?php 
  include('logprocess.php') ?>
     <html>
    <head>
      <title>Login Form </title>
      <link rel="stylesheet" href="stylelogin.css">
    </head>
    <body>
    </body>
    <form action="regnew.php" method="GET" id="register_form">
        <h1>---- </br>
        <br> 
        LOGIN</br></h1>
       <div>
        <input type="number" placeholder="Enter Your UDISE Code "maxlength="11"  id="udise"  name="udise">
        </div>
        <br>
        <div>
        <button type="submit"  name="register"  id="reg_btn">Enter</button>
        </div>
        </br>
    <span class="footer"></span>
    </form>
    </body>
    </html>

我的php代码如下。。我已将其保存为不同的文件，并使用include选项调用该文件。但什么都没用

<?php
  // Grab User submitted information
// Connect to the database
$con = mysql_connect("localhost","root","");
// Make sure we connected successfully
if(! $con)
{
    die('Connection Failed'.mysql_error());
}
 $udise = "";
// Select the database to use
$db = mysql_select_db("workspace",$con);
  if (isset($_POST['register'])) {
$sql_udise = "SELECT * FROM udise WHERE schcd='$udise'" or die (mysql_error());
$res_udise = mysqli_query($db, $sql_udise) or die(mysql_error());
    $row = mysqli_fetch_assoc($res_udise);
    $fields = array( 'udise');
$error = false; //No errors yet
foreach($fields AS $fieldname) { //Loop trough each field
  if(!isset($_POST[$fieldname]) || empty($_POST[$fieldname])) {
    echo '<script language="javascript">
    alert("Pls Enter All Fields");
    </script>';  //Display error with field
    $error = true; //Yup there are errors
  }
}
if(!$error) {
    if($row["udise"]==$udise ){
   echo '<script language="javascript">
  top.location.href = "updatewp.php"; //the page to redirect
    </script>';
}else {
   echo '<script language="javascript">
    alert("Sorry... UDISE Mismatch pls try again ");
     href = "login.php"; //the page to redirect
    </script>';}
{
   echo '<script language="javascript">
         href = "login.php"; //the page to redirect
    </script>';
}
    mysql_close($con);
}}
?>

如何将此添加到登录表单验证

mysql php Html

来源：https://stackoverflow.com/questions/51511857/how-to-validate-a-get-method-form-using-mysql-database

2条答案

按热度按时间

jhkqcmku1#

试试这个代码。

<html><head><title>Login Form </title><link rel="stylesheet" href="stylelogin.css"></head><body></body><form method="GET" id="register_form"><h1>---- </br><br> LOGIN</br</h1><div>
<input type="number" placeholder="Enter Your UDISE Code "maxlength="11"  id="udise"  name="udise">
</div>
<br>
<div>
<button type="submit"  name="register"  id="reg_btn">Enter</button>
</div>
</br><span class="footer"></span></form><?php if(isset($_GET['register'])){$udise = $_GET['udise'];
 //connect to the database  $servername = 'localhost';
    $username = 'root';
    $password = '';
    $db = 'yourdb';
    $conn = new mysqli($servername, $username, $password, $db); // Check connection if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);} 
$check=mysqli_query($conn,"select * from udise where udise='$udise'");
$checkrows=mysqli_num_rows($check); if($checkrows>0) {
  echo '<div style="color: #a94442;
background-color: #f2dede;
border-color: #ebccd1;padding: 15px;
margin-bottom: 20px;
border: 1px solid transparent;
border-radius: 4px;">
 already exist </div>'; } else {  
//insert results from the form input
  $query = "INSERT INTO udise(udise) VALUES('$udise')";
  $result = mysqli_query($conn, $query) or die('Error querying database.');
  mysqli_close($conn);
  echo '<div style="color: #3c763d;
background-color: #dff0d8;
border-color: #d6e9c6;padding: 15px;
margin-bottom: 20px;
border: 1px solid transparent;
border-radius: 4px;">
 POSTED </div>' ;
}}?>  </body> </html>

展开查看全部

赞(0）回复(0）举报 2021-06-21

e37o9pze2#

试试这个代码。

<?php session_start();
//Your Mysql Config
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "yourdb";
//Create New Database Connection
$conn = new mysqli($servername, $username, $password, $dbname);
//Check Connection
if($conn->connect_error) {
die("Connection Failed: ". $conn->connect_error);
}
if(isset($_GET['login']))
{
    $sql = "SELECT * FROM udise WHERE udise='".$_GET['udise']."'";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
    $extra="profile.php";
    $_SESSION['login']=$_GET['udise'];
    $_SESSION['id']=$num['id'];
    echo "<script>window.location.href='".$extra."'</script>";
    exit();
    }
    } else {
    $_SESSION['action1']="*Invalid usercode";
    $extra="log.php";
    echo "<script>window.location.href='".$extra."'</script>";
    exit();
     }
    $conn->close();
    }
    ?>
    <form method="GET">
     <input type="number" placeholder="Enter Your UDISE Code "maxlength="11"  id="udise"  name="udise">
                                     <p style="color:#F00; padding-top:20px;" align="center"><?php echo $_SESSION['action1'];?><?php echo $_SESSION['action1']="";?></p>
                        <input class="small button search-btn" type="submit" value="Log In" name="login">
                        </form>

展开查看全部

赞(0）回复(0）举报 2021-06-20

我来回答

如何使用mysql数据库验证get方法表单

2条答案

相关问题

热门标签

最新问答