PHP not sending form to MySQL database

Question

I've been able to connect to my database. manual insert data to a table by using my own inputs with the VALUES ('$name', '$email', '$userPassword')"; code but for some reason when I try to pass the above variables to my database it will input blank data into my table. this is my PHP for my welcome.php page:

<?php
  $servername = "localhost";
  $username = "root";
  $password = "@Password";
  $dbname = "accounts";

  // Create connection
  $conn = mysqli_connect($servername, $username, $password, $dbname);
  // Check connection
  if (!$conn) {
      die("Connection failed: " . mysqli_connect_error());
  }



  $name = mysqli_real_escape_string($link, $_POST['Ausername']);
  $email = mysqli_real_escape_string($link, $_POST['email']);
  $userPassword = mysqli_real_escape_string($link, $_POST['Apassword']);

  $sql = "INSERT INTO users (username, email, password)
  VALUES ('$name', '$email', '$userPassword')";

  if (mysqli_query($conn, $sql)) {
      echo "New record created successfully";
  } else {
     echo "Error: " . $sql . mysqli_error($conn);
  }

  mysqli_close($conn);
?>

note that on the welcome page the below code will pass the info from my form and display it appropriately but will not add it to my database:

<html>
<body>
    Welcome <?php echo $_POST["Ausername"]; ?><br>
    Your email address is: <?php echo $_POST["email"]; ?><br>
    password is <?php echo $_POST["Apassword"]; ?>
</body>
</html>

my form code:

<form class="form-inline" action="welcome.php" method="post">

                        <div class="input-group">
                            <span class="input-group-addon"><i class="fa fa-user"></i></span>
                            <input type="text" class="form-control" id="Ausername" placeholder="Username" name="Ausername" required>
                        </div>
                        <br>
                        <br>
                        <div class="input-group">
                            <span class="input-group-addon"><i class="glyphicon glyphicon-envelope"></i></span>
                            <input type="text" class="form-control" id="email" placeholder="Email" name="email" required>
                        </div>
                        <br>
                        <br>
                        <div class="input-group">
                            <span class="input-group-addon"><i class="glyphicon glyphicon-lock"></i></span>
                            <input type="text" class="form-control" id="Apassword" placeholder="Password" name="Apassword" required>
                        </div>
                        <br>
                        <br>                
                        <br>
                        <button type="submit" class="btn btn-primary" id="button" name="submit" value="submit">
                            <i class="fa fa-user-plus"></i>
                            Sign Up
                        </button>
                        <br>
                        <br>
                    </form>

Change $link to $conn in the escape calls

user2182349
– user2182349

2017-09-16 01:58:07 +00:00
Commented Sep 16, 2017 at 1:58 — user2182349
– user2182349, Commented Sep 16, 2017 at 1:58

Johnny Dew · Accepted Answer · 2017-09-16 04:02:36Z

1

$link has not been defined in your code, your are using $conn to create your connection to the database, so you need to change

$name = mysqli_real_escape_string($link, $_POST['Ausername']);
$email = mysqli_real_escape_string($link, $_POST['email']);
$userPassword = mysqli_real_escape_string($link, $_POST['Apassword']);

to

$name = mysqli_real_escape_string($conn, $_POST['Ausername']);
$email = mysqli_real_escape_string($conn, $_POST['email']);
$userPassword = mysqli_real_escape_string($conn, $_POST['Apassword']);

answered Sep 16, 2017 at 4:02

Johnny Dew

9912 gold badges13 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP not sending form to MySQL database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related