How to add multiple textbox in PHP using buton and then store in phpmyadmin

See more:

CSS

HTML

PHP

jQuery

Dear Exports,

I made a job application form which is use for apply online at particular vacancy and stores applicant data

it include qualification portion in which user can feed multiple qualification using add more button

and i used 4 tables behind this scenario.

so my problems are:
1) How can store data in 4 tables using prepare statement.

2)How to add multiple qualifications in database when user want to add

kinldy help me for this


Thanks in advance

What I have tried:

<div style="font-size: 18px; margin-top: 50px; font-family: Helvetica,Arial,sans-serif; font-weight: bolder;">
        <label>Work History</label><span style="font-size: 12px;">(Start With Most Recent)</span>
        </div>

<table class="table table-bordered" id="dynamicTable1">
      <tr>
          <th style="background-color: grey; width:135px;border:1px solid black; margin-right: 1px; ">Position Held</th>
          <th style="background-color: grey; width:220px;border:1px solid black; margin-right: 1px;">Organization Name</th>
          <th style="background-color: grey; width:130px;border:1px solid black; margin-right: 1px;">From Date</th>
          <th style="background-color: grey; width:130px;border:1px solid black; margin-right: 1px;">To Date</th>
          <th style="background-color: grey; width:70px;border:1px solid black; margin-right: 2px;">Service in Year</th>
          <th style="background-color: grey; width:90px;border:1px solid black; margin-right: 1px;">Last Drawn Gross Salary</th>
          <th style="background-color: grey; width:130px;border:1px solid black; margin-right: 1px;">Reason For Leaving</th>
      </tr>
      <tr>
          <td  style=" width:135px;margin-right: 2px;margin-top: 1px;">
          <input type="text" name="positionheld[]" style = "width : 135px;  font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 28px; padding-left: 3px;"></td>
<td style=" width:219px;margin-right: 1px;margin-top: 1px;">
<input type="text" name="orgname[]" style = "width: 220px;font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 28px;padding-left: 3px;">    
</td>
<td style=" width:130px;margin-right: 1px;margin-top: 1px;">
<input type="date" name="fromdate[]" style = "width: 125px; font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 28px;">    
</td>
<td style=" width:130px;margin-right: 1px;margin-top: 1px;">
<input type="date" name="todate[]" style = "width: 125px; font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 28px;">    
</td>
<td style=" width:70px;margin-right: 2px;margin-top: 1px;">
<input type="number" name="serviceyear[]" pattern="[-+]?[0-9]*[.,]?[0-9]+" style = "width: 52px;font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 20px;">    
</td>
<td style=" width:90px;margin-right: 1px;margin-top: 1px;">
<input type="text" name="lastgrosssal[]" pattern="[-+]?[0-9]*[.,]?[0-9]+" style = "width: 90px;font-size : 13px ; border-radius : 5px; padding-left: 3px; border: 1px solid gray; height: 28px;">    
</td>
<td style=" width:130px;margin-right: 1px;margin-top: 1px;">
<input type="text" name="reason[]" style = "width: 130px;font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 28px; padding-left: 3px;">    
</td>
<td style="width: 85px;margin-right: 1px;margin-top: 1px; border:none;"><button type="button" name="add1" id="add1" class="btn btn-success">Add More</button></td>

      </tr>
  </table> 

Jquery code

<script type="text/javascript">
     var i = 0;
       
    $("#add1").click(function(){
   
        ++i;
   
        $("#dynamicTable1").append('<tr><td  style=" width:135px;"><input type="text" name="positionheld[]" style = "width : 135px;  font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 28px;"></td><td style=" width:220px;"><input type="text" name="orgname[]" style = "width: 220px;font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 28px;"></td><td style=" width:130px;"><input type="date" name="fromdate[]" style = "width: 125px; font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 28px;"></td><td style=" width:130px;"><input type="date" name="todate[]" style = "width: 125px; font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 28px;"></td><td style=" width:70px;"><input type="number" name="serviceyear[]" pattern="[-+]?[0-9]*[.,]?[0-9]+" style = "width: 52px;font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 20px;"></td><td style=" width:90px;"><input type="number" name="lastgrosssal[]" pattern="[-+]?[0-9]*[.,]?[0-9]+" style = "width: 74px;font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 20px;"></td><td style=" width:130px;"><input type="text" name="reason[]" style = "width: 130px;font-size : 13px ; border-radius : 5px; border: 1px solid gray; height: 28px;"></td><td style="width:85px;"><button type="button" class="btn btn-danger remove-tr1">Remove</button></td></tr>');
    });
   
    $(document).on('click', '.remove-tr1', function(){  
         $(this).parents('tr').remove();
    }); 

php code need to improve

<?php 

include 'db.php';
$id = $_POST['id'];
$name = $_POST['name'];
$fathername= $_POST['fathername'];
$cnic= $_POST['cnic'];
$gender=$_POST['gender'];
$maritalstatus= $_POST['maritalstatus'];
$religion=$_POST['religion'];
$dob=$_POST['dob'];
$paddress=$_POST['paddress'];
$province=$_POST['province'];
$city=$_POST['city'];
$phone=$_POST['phone'];
$mob=$_POST['mob'];
$email=$_POST['email'];
$expected_salary = $_POST['expectslry'];
$job_id = "";
$status = "";
$degree1 = $_POST['degree1'];
$institute1 = $_POST['institute1'];
$institute1city = $_POST['institute1city'];
$discipline = $_POST['discipline'];
$year1 = $_POST['year1'];
$obtainmarks = $_POST['obtainmarks'];
$totalmarks = $_POST['totalmarks'];
$CGPA = $_POST['CGPA'];
$certificatename = $_POST['certificatename'];
$certificateins = $_POST['certificateins'];
$completionyear = $_POST['completionyear'];
$certificatespec = $_POST['certificatespec']; 




if(isset($_POST['submit'])){

$sql = "INSERT into job_application (`application_id`, `name`, `father_name`, `cnic`, `marital_status`, `gender`, `dob`, `religion`, `address`, `province`, `city`, `phone`, `mobile`, `email`, `expected_salary`) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
        INSERT INTO `job_application_qualification`(`application_id`, `degree_name`, `institute_name`, `institute_city`, `discipline`, `pass_year`, `obtain_marks`, `total_marks`, `grade`, `cert_name`, `cert_inst_name`, `cert_pass_year`, `cert_discipline`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?); " ;
$stmt = mysqli_stmt_init($con);
if(!mysqli_stmt_prepare($stmt,$sql)){

	echo ("Database Error".mysqli_connect_error());
	exit();
}
else{
mysqli_stmt_bind_param($stmt,"sssisssssiisssiissssisssssis",$id,$name,$fathername,$cnic,$maritalstatus,$gender,$dob,$religion,$paddress,$province,$city,$phone,$mob,$email,$expected_salary,last_insert_id(),$degree1,$institute1,$institute1city,$discipline,$year1,$obtainmarks,$totalmarks,$CGPA,$certificatename,$certificateins,$completionyear,$certificatespec);


mysqli_stmt_execute($stmt);
echo "Data inserted Successfully";

}

}

?>