data not inserted

shrish · Aug 30, 2021

database is connected succesfully but the query is not getting inserted through form.
index.php file:-

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" ></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" >   

<link rel="stylesheet" href="style.css"type="text/css">
    <title>Document</title>
</head>
<body>
  <div class="box">
    

  <form class="needs-validation container" novalidate style="max-height:1px; margin-top:10px; margin-left:5px;margin-right:5px;" action="" method="POST">
  <div class="form-row">
    <div class="col-md-4 mb-3">
      <label for="validationCustom01">First name</label>
      <input type="text" name="firstname" class="form-control" id="validationCustom01" placeholder="First name" required>
      <div class="valid-feedback">
        Looks good!
      </div>
    </div>
    <div class="col-md-4 mb-3">
      <label for="validationCustom02">Last name</label>
      <input type="text" name="lastname" class="form-control" id="validationCustom02" placeholder="Last name"  required>
      <div class="valid-feedback">
        Looks good!
      </div>
    </div>
    <div class="col-md-4 mb-3">
      <label for="validationCustomUsername">Email Id</label>
      <div class="input-group">
        <div class="input-group-prepend">
          <span class="input-group-text" id="inputGroupPrepend">@</span>
        </div>
        <input type="email"  name="email" class="form-control" id="validationCustomUsername" placeholder="email" aria-describedby="inputGroupPrepend" required>
        <div class="invalid-feedback">
          Please choose an .
        </div>
      </div>
    </div>
  </div>
  <div class="form-row">
    <div class="col-md-6 mb-3">
      <label for="validationCustom03">City</label>
      <input type="text"  name="city" class="form-control" id="validationCustom03" placeholder="City" required>
      <div class="invalid-feedback">
        Please provide a valid city.
      </div>
    </div>
    <div class="col-md-3 mb-3">
      <label for="validationCustom04">Job Post</label>
      <input type="text" name="jobpost" class="form-control" id="validationCustom04" placeholder="Post" required>
      <div class="invalid-feedback">
        Please provide a valid post.
      </div>
    </div>
    <div class="col-md-3 mb-3">
      <label for="validationCustom05">Phone Number</label>
      <input type="number" name="mobile" class="form-control" id="validationCustom05" placeholder="Phone" required>
      <div class="invalid-feedback">
        Please provide a valid Phone.
      </div>
    </div>
  </div>
  <div class="form-group">
    <div class="form-check">
      <input class="form-check-input" type="checkbox" value="" id="invalidCheck" required>
      <label class="form-check-label" for="invalidCheck">
        Agree to terms and conditions
      </label>
      <div class="invalid-feedback">
        You must agree before submitting.
      </div>
    </div>
  </div>
  <div class="container">
    <input type="submit"  name="submit" value="submit" class="btn btn-primary" style="margin-bottom:0px;"/>
  

  </div>
</form>

<script>
// Example starter JavaScript for disabling form submissions if there are invalid fields
(function() {
  'use strict';
  window.addEventListener('load', function() {
    // Fetch all the forms we want to apply custom Bootstrap validation styles to
    var forms = document.getElementsByClassName('needs-validation');
    // Loop over them and prevent submission
    var validation = Array.prototype.filter.call(forms, function(form) {
      form.addEventListener('submit', function(event) {
        if (form.checkValidity() === false) {
          event.preventDefault();
          event.stopPropagation();
        }
        form.classList.add('was-validated');
      }, false);
    });
  }, false);
})();

</script>



  </div>

  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>

</body>
</html>
<?php
include 'connection.php';
if(isset($_POST['submit']))
{

  $firstname = $_POST['firstname'];
  $lastname = $_POST['lastname'];
  $email = $_POST['email'];
  $city = $_POST['city'];
  $jobpost = $_POST['jobpost'];
  $mobile = $_POST['mobile'];

  $insertquery = " INSERT INTO `jobregistration` (`id`, `firstname`, `lastname`, `mobile`, `email`, `city`, `jobpost`) VALUES (NULL, 'akgjkl', 'andkfj', '70108347', 'hfkajh@gmial.com', 'chennai', 'webd') ";
  $res = mysqli_connect($con,$insertquery);
  if($res)
  {
    ?>
    <script>
      alert("data inserted successfully");
      </script>
      <?php


  }
  else{
    ?>
    <script>
      alert("data not inserted ");
      </script>
      <?php
  }
}
?>
//connection.php file
$con= mysqli_connect($server,$username,$password,$db);


if($con)
{
   // echo"Connection Successful";
   ?>
<script>
    alert("Connection Successfull");
</script>
<?php
}
else
   echo"NO CONNECTION";





?>

please help

Moderator: added \[code]…[/code] tags

NogDog · Aug 30, 2021

This code...

  $res = mysqli_connect($con,$insertquery);
  if($res)
  {
    ?>
    <script>
      alert("data inserted successfully");
      </script>
      <?php
  }

...does not execute the query. You would use mysqli_query(), instead -- after you do the mysqli_connect() further down in the code. Note however that if/when you want to actually include the form data in the query, you are going to want to use prepared statements and bound parameters in order to avoid possible SQL injection errors/attacks; as opposed to directly using mysqli_query().

shrish · Aug 30, 2021

NogDog
i did ...
$insertquery = " INSERT INTO jobregistration (id, firstname, lastname, mobile, email, city, jobpost) VALUES (1, 'akgjkl', 'andkfj', '70108347', 'hfkajh@gmial.com', 'chennai', 'webd') ";
$res = mysqli_connect($con,$insertquery);
mysqli_query($con,$insertquery);
if($res)
{
?>
<script>
alert("data inserted successfully");
</script>
<?php
...
changes as u said . still the alert message was data not inserted and no data was inserted.

shrish · Aug 30, 2021

NogDog
thank u so much
i did it
it worked ...
thanks

NogDog · Aug 30, 2021

You have to do the connection first, as you have further down in the code:

//connection.php file
$con= mysqli_connect($server,$username,$password,$db);

Then after that is done, do your mysqli_query(). So, you might want to do all the connection stuff first, starting at that line and the if/else check to make sure you are successfully connected, then do the query and check the result:

$con= mysqli_connect($server,$username,$password,$db);
if($con)
{
    $insertquery = "INSERT INTO jobregistration (id, firstname, lastname, mobile, email, city, jobpost) VALUES (1, 'akgjkl', 'andkfj', '70108347', 'hfkajh@gmial.com', 'chennai', 'webd') ";
    $res = mysqli_query($con,$insertquery);
    if($res)
   {
    ?>
    <script>
      alert("data inserted successfully");
      </script>
      <?php
  }
  else{
    ?>
    <script>
      alert("data not inserted ");
      </script>
      <?php
  }
}
else
{
    echo "NO CONNECTION";
}

Untested, so may be typos/mistakes.

data not inserted

Sshrish

NogDog

Sshrish

Sshrish

NogDog