0

so I have been trying to successfully build a register form using PHP and SQL, but I am new and I suck. Here is the code, it outputs no error at all, in fact it just doesn't run at all.

<?php
if (isset($_POST['signup-submit'])){

require 'includes/dbh.inc.php';

$username = $_POST['uid'];
$password = $_POST['pwd'];

if (empty($username) || empty($password)){
  header("Location: ../register.php?error=emptyfields");
  exit();
} else {

  $sql = "SELECT uidUsers FROM Users WHERE uidUsers=?";
  $stmt = mysqli_stmt_init($conn);

  if (!mysqli_stmt_prepare($stmt, $sql)){

    header("Location: ../register.php?error=sqlerror");
    exit();

  } else {

    mysqli_stmt_bind_param($stmt, "s", $username);
    mysqli_stmt_execute($stmt);

    mysqli_stmt_store_result($stmt);
    $resultCheck = mysqli_stmt_rum_rows($stmt);

    if ($resultCheck > 0){
      header("Location: ../register.php?error=usernametaken");
      exit();

    } else {

      $sql = "INSERT INTO Users (uidUsers, pwdUsers) VALUES (?, ?)";

      $stmt = mysqli_stmt_init($conn);

      if (!mysqli_stmt_prepare($stmt, $sql)){
        header("Location: ../register.php?error=sqlerror");
        exit();
      } else {

        $hashedPwd = password_hash($password, PASSWORD_DEFAULT);

        mysqli_stmt_bind_param($stmt, "ss", $username, $hashedPwd);
        mysqli_stmt_execute($stmt);

        header("Location: ../register.php?signup=success");
        exit();
      }
    }

  }
}

mysqli_stmt_close($stmt);
mysqli_close($conn);
} else {
header("Location: ../register.php");
exit(); }?>

I am quite confused as to why it is returning a blank result,so please help me out. Thanks! :D

Dharman
  • 30,962
  • 25
  • 85
  • 135

0 Answers0