Hello could anyone assist me on this issue. Im getting connection failed each time I enter this code, and I'm unsure why.
<?php include "includes/conn.php" ?>
<?php
if (isset($_POST['submit'])) {
  $firstname = $_POST['fName'];
  // echo $firstname;
  $lastname = $_POST['lName'];
  $email = $_POST['email'];
  $phone = $_POST['phone'];
  $date_ob = date('Y-m-d', strtotime($_POST['DOB']));
  $gender = $_POST['Gender'];
  $ethnicity = $_POST['Ethnicity'];
  $insert_query = "INSERT `alumni_table`(fName,lName,email,phone,DOB,Gender,Ethnicity) VALUES ('$firstname', '$lastname', '$email', '$phone', '$date_ob', '$gender', '$ethnicity') ";
  $result = mysqli_query($conn, $insert_query);
  if ($result) {
    echo "Data inserted successfully";
  } else {
    die("Connection failed: " . $conn->connect_error);
  }
}
Below is my form data
<div class="container my-5">
    <form action="" method="post">
      <div class="form-group">
        <label>First Name</label>
        <input type="text" required="required" autocomplete="off" placeholder="Enter your First Name" name="fName" id="fName" class="form-control">
      </div>
      <div class="form-group">
        <label>Last Name</label>
        <input type="text" required="required" autocomplete="off" placeholder="Enter your Last Name" name="lName" id="lName" class="form-control">
      </div>
      <div class="form-group">
        <label>Email</label>
        <input type="email" required="required" autocomplete="off" placeholder="Enter your Email" name="email" id="email" class="form-control">
      </div>
      <div class="form-group">
        <label>Phone #</label>
        <input type="text" required="required" autocomplete="off" placeholder="Enter your Phone #" name="phone" id="phone" class="form-control">
      </div>
      <div class="form-group">
        <label>DOB</label>
        <input type="date" autocomplete="off" placeholder="Enter your Date of Birth" name="DOB" id="DOB" class="form-control">
      </div>
      <div class="form-group">
        <label>Gender</label>
        <input type="text" required="required" autocomplete="off" placeholder="Enter your Gender" name="Gender" id="Gender" class="form-control">
      </div>
      <div class="form-group">
        <label>Ethnicity</label>
        <input type="number" required="required" autocomplete="off" placeholder="Enter your Ethnicity" name="Ethnicity" id="Ethnicity" class="form-control">
      </div>
      <div class="row">
        <div class="col-sm-6 col-sm-offset-3">
          <input type="submit" name="submit" id="submit" tabindex="4" class="form-control btn btn-dark" value="Update User">
        </div>
    </form>
  </div>
Here is my conn.php file
$servername = "localhost";
$username = "root";
$password = "root";
$database = "example_test";
// Create connection
$conn = new mysqli($servername, $username, $password, $database);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
And Below is my MySQL phpMyadmin column names and values associated with it
fName type =varchar(45),
lName type = varchar(45),
email type = varchar(45),
phone type = varchar(12),
DOB   type = date,
Gender type = char(1),
Ethnicity type = tinyint(1)
I apologize if the code is sloppy this is my first time asking on here. Would appreciate the help
 
    