时间戳

首页 > 解决方案 > 用户信息未发送到 MYSQL 数据库

php - 用户信息未发送到 MYSQL 数据库

问题描述

我正在尝试制作：为网站创建帐户页面。问题是没有数据被发送到数据库。

这是我放的：

include 'databaseconnection.php';
if (isset($_POST['submitbutton'])) {

  include 'databaseconnection.php';

  $first = mysqli_real_escape_string($conn, $_POST['first']);
  $last = mysqli_real_escape_string($conn, $_POST['last']);
  $password = mysqli_real_escape_string($conn, $_POST['password']);
  $email = mysqli_real_escape_string($conn, $_POST['email']);
  $username = mysqli_real_escape_string($conn, $_POST['username']);

  //error handlers
  // check for empty feilds

  if (empty($first) || empty($last) || empty($password) || empty($email) || empty($username)) {
      header("Location: signupcode.php");
      exit();
  } else {
      if (!preg_match("/ˆ[a-zA-Z]*$/",$first) || !preg_match("/ˆ[a-zA-Z]*$/",$last)) {
          header("Location: signupcode.php?signup=empty");
          exit();
      } else {
          //email check
          if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
              header("Location: signupcode.php?error");
              exit();
          } else {
              $sql = "SELECT * FROM users WHERE username='$username'";
              $result = mysqli_query($conn, $sql);
              $resultcheck = mysqli_num_rows($result);
              if ($resultcheck > 0) {
                  header("Location: signupcode.php?error");
                  exit();
              }  else {
                  $sql = "SELECT * FROM users WHERE email='$email'";
                  $result = mysqli_query($conn, $sql);
                  $resultcheck = mysqli_num_rows($result);
                  if ($resultcheck > 0) {
                      header("Location: signupcode.php?error");
                      exit();
                  } else {
                      //hashing the Password
                      $hasedpassword = password_hash($password, PASSWORD_DEFAULT);

                      $sql = "INSERT INTO users (username, firstname, lastname, password, email)
                            VALUES ('$username', '$first', '$last', '$hasedpassword', '$email');";
                      $dbservername= "localhost";
                      $dbusername= "root";
                      $dbpassword= "";
                      $dbname = "landingpage-login";

                      $conn = mysqli_connect($dbservername, $dbusername, $dbpassword, $dbname);

                      mysqli_query($conn, $sql);
                      header("Location: signupcode.php");
                      exit();
                 }
            }
        }
    }
  }

}

 ?>

问题是，当我转到 localhost:8080/php 我的管理员时，我的表中没有显示任何内容：数据库中的用户：landingpage-login。每次我检查它，它都是空的，用户名，密码等什么都没有......

标签： phpmysql

解决方案

首先，任何编程语言都不能有多个else语句。您的代码到达第一个else并执行该块。

尝试拥有

 else if (!preg_match("/ˆ[a-zA-Z]*$/",$first) || !preg_match("/ˆ[a-zA-Z]*$/",$last)){//Code}

推荐阅读