php - HTML 登录表单连接到数据库

Question

我在将 HTML 表单连接到数据库时遇到问题。我对此很陌生。请帮帮我。这是 HTML 登录表单代码注销.html

<form name="form" onsubmit="submit1()" action="connectivity-sign-up.php" method="POST" >
   <div id="errorBox"></div>
    <input type="text" name="Name" value="" placeholder="First Name"  class="input_name" >
    <input type="text" name="LastName" value="" placeholder="Last Name" class="input_name" >

  </div>
  <div id="email_form">
    <input type="text" name="Email" value=""  placeholder="Your Email" class="input_email">
  </div>
  <div id="Re_email_form">
    <input type="text" name="enterEmail" value=""  placeholder="Re-enter Email" class="input_Re_email">
  </div>
  <div id="password_form">
    <input type="password" name="Password" value=""  placeholder="New Password" class="input_password">
  </div>
  <!--birthday details start-->
  <div>
    <h3 class="birthday_title">Birthday</h3>
  </div>
  <div>
    <select name="birthday_month" >
      <option value="" selected >Month</option>
      <option value="1">Jan</option>
      <option value="2">Feb</option>
      <option value="3">Mar</option>
      <option value="4">Apr</option>
      <option value="5">May</option>
    </select>
    &nbsp;&nbsp;
    <select name="birthday_day" >
      <option value="" selected>Day</option>
      <option value="1">1</option>
      <option value="2">2</option>
      <option value="3">3</option>
      <option value="4">4</option>
      <option value="5">5</option>
    </select>
    &nbsp;&nbsp;
    <select name="birthday_year">
      <option value="" selected>Year</option>
      <option value="2013">2013</option>
      <option value="2012">2012</option>
      <option value="2011">2011</option>
      <option value="2010">2010</option>
      <option value="2009">2009</option>
    </select>
  </div>
  <!--birthday details ends-->
  <div id="radio_button">
    <input type="radio" name="radiobutton" value="Female">
    <label >Female</label>
    &nbsp;&nbsp;&nbsp;
    <input type="radio" name="radiobutton" value="Male">
    <label >Male</label>
  </div>
   <div>
    <p id="sign_user" onClick="Submit()" value= "Submit" >Sign Up </p>
    <input type="submit" value="Submit">
  </div>
 </form>

Submit1() 函数是验证函数。当我单击提交时，它应该首先验证然后将数据发送到表单。现在验证函数可以正常工作，但我该如何调用它，以便它在验证后发送数据。这是 PHP 连接部分文件名:connectivity-sign-up.php

    <?php define('DB_HOST', 'localhost'); 
define('DB_NAME', 'customerdb'); 
define('DB_USER','root'); 
define('DB_PASSWORD',''); 
$con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error()); 
$db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " . mysql_error()); 
function Signin() 
{ 
 $fname = $_POST['Name']; 
 $lname = $_POST['LastName']; 
 $email = $_POST['Email']; 
 $password = $_POST['Password']; 
 $query = "INSERT INTO custtable (fname,lname,email,password) VALUES ('$fname','$lname','$email','$password')"; 
 $data = mysql_query ($query)or  die(mysql_error()); 
 if($data) 
  { 
    echo "YOUR REGISTRATION IS COMPLETED..."; 
  } 
}

 ?>

Answer 1

当用户点击提交按钮调用 Signin() 功能。

if (isset($_POST['submit'])) {
    Signin();
}

-

<?php define('DB_HOST', 'localhost');
define('DB_NAME', 'customerdb');
define('DB_USER', 'root');
define('DB_PASSWORD', '');
$con = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error());
$db = mysql_select_db(DB_NAME, $con) or die("Failed to connect to MySQL: " . mysql_error());

if (isset($_POST['submit'])) {
    Signin();
}

function Signin()
{
    $fname = $_POST['Name'];
    $lname = $_POST['LastName'];
    $email = $_POST['Email'];
    $password = $_POST['Password'];
    $query = "INSERT INTO custtable (fname,lname,email,password) VALUES ('$fname','$lname','$email','$password')";
    $data = mysql_query($query) or die(mysql_error());
    if ($data) {
        echo "YOUR REGISTRATION IS COMPLETED...";
    }
}

?>

更新 html:<input type="submit" name="submit" value="Submit">

    <!--birthday details ends-->
    <div id="radio_button">
        <input type="radio" name="radiobutton" value="Female">
        <label>Female</label>
        &nbsp;&nbsp;&nbsp;
        <input type="radio" name="radiobutton" value="Male">
        <label>Male</label>
    </div>
    <div>
        <p id="sign_user" onClick="Submit()" value="Submit">Sign Up </p>
        <input type="submit" name="submit" value="Submit">
    </div>
</form>