I have a form on my index page that is linked to a php page to insert the data into my sql. When I submit the form, the data remains on the form but you see the form do something. it adds a record in my database but all variables are blank in the database. Info still shows on the form like nothing happened after submitting and nothing passes to PHP variables. Any help would be greatly appreciated.
FORM
<form action="insert.php" method="post" role="form" class="contactForm">
<div id="sendmessage">Your message has been sent. Thank you!</div>
<div id="errormessage"></div>
<div class="row">
<div class="col-md-12 mb-3">
<div class="form-group">
<input type="text" name="name" class="form-control" id="name" placeholder="Your Name" data-rule="minlen:4" data-msg="Please enter at least 4 chars" />
<div class="validation"></div>
</div>
</div>
<div class="col-md-12 mb-3">
<div class="form-group">
<input type="email" class="form-control" name="email" id="email" placeholder="Your Email" data-rule="email" data-msg="Please enter a valid email" />
<div class="validation"></div>
</div>
</div>
<div class="col-md-12 mb-3">
<div class="form-group">
<input type="text" class="form-control" name="subject" id="subject" placeholder="Subject" data-rule="minlen:4" data-msg="Please enter at least 8 chars of subject" />
<div class="validation"></div>
</div>
</div>
<div class="col-md-12 mb-3">
<div class="form-group">
<textarea class="form-control" name="message" rows="5" data-rule="required" data-msg="Please write something for us" placeholder="Message"></textarea>
<div class="validation"></div>
</div>
</div>
<div class="col-md-12">
<button type="submit" class="button button-a button-big button-rouded" name ="insert">Send Message</button>
</div>
</div>
</form>
insert.php
$server = "locahost";
$user = "user";
$password = "";
$dbname = "";
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect($server,$user,$password,$dbname);
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Escape user inputs for security
$name = mysqli_real_escape_string($link, $_POST['name']);
$email = mysqli_real_escape_string($link, $_POST['email']);
$subject = mysqli_real_escape_string($link, $_POST['subject']);
$message = mysqli_real_escape_string($link, $_POST['message']);
// Attempt insert query execution
$sql = "INSERT INTO contact (name, email, subject, message) VALUES ('$name', '$email', '$subject','$message')";
if(mysqli_query($link, $sql)){
echo "Records added successfully.";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($link);
