PHP - Array Created In 1 Place But Used Separately

<?php
if (isset($_POST['submit'])) {
    $j = 0; //Variable for indexing uploaded image 
    
	$target_path = $_SERVER['DOCUMENT_ROOT'] . "/ubergallery/multiple_image_upload/uploads/"; //Declaring Path for uploaded images
    for ($i = 0; $i < count($_FILES['file']['name']); $i++) {//loop to get individual element from the array

        $validextensions = array("jpeg", "jpg", "png");  //Extensions which are allowed
        $ext = explode('.', basename($_FILES['file']['name'][$i]));//explode file name from dot(.) 
        $file_extension = end($ext); //store extensions in the variable
        
		$target_path = $target_path . md5(uniqid()) . "." . $ext[count($ext) - 1];//set the target path with a new name of image
        $j = $j + 1;//increment the number of uploaded images according to the files in array       
      
	  if (($_FILES["file"]["size"][$i] < 100000) //Approx. 100kb files can be uploaded.
                && in_array($file_extension, $validextensions)) {
            if (move_uploaded_file($_FILES['file']['tmp_name'][$i], $target_path)) {//if file moved to uploads folder
                echo $j. ').<span id="noerror">Image uploaded successfully!.</span><br/><br/>';
            } else {//if file was not moved.
                echo $j. ').<span id="error">please try again!.</span><br/><br/>';
            }
        } else {//if file size and file type was incorrect.
            echo $j. ').<span id="error">***Invalid file Size or Type***</span><br/><br/>';
        }
    }
}
?>

Hi guys,

I really hope this will make sense.

I am creating a dynamic field on a button click for Pickup Location. That works fine and submitting the form to the database works fine. However, instead of one entry, each time I submit the form with multiple Pickup Locations, it creates multiple separate database entries.

Here is the PHP for submitting:

if(isset($_POST['new']) && $_POST['new']==1){
$pickups = '';
foreach($_POST['pickups'] as $cnt => $pickups)
    $pickups .= ',' .$pickups;
	$locations = count($_POST["pickups"]);
	
	if ($locations > 0) {
	    for ($i=0; $i < $locations; $i++) { 
		if (trim($_POST['pickups'] != '')) {
			
    $name = mysqli_real_escape_string($con, $_POST['name']);
    $price = mysqli_real_escape_string($con, $_POST['price']);
    //$origin = $_POST['origin'];
    $pickups = $_POST["pickups"][$i];
    $destination = mysqli_real_escape_string($con, $_POST['destination']);
    $dep_date = mysqli_real_escape_string($con, $_POST['dep_date']);
    $ret_date = mysqli_real_escape_string($con, $_POST['ret_date']);
    $fleet_number = mysqli_real_escape_string($con, $_POST['fleet_number']);
    $driver = mysqli_real_escape_string($con, $_POST['driver']);
    $itinerary = mysqli_real_escape_string($con, $_POST['itinerary']);
    $submittedby = mysqli_real_escape_string($con, $_SESSION["username"]);
    $trn_date = mysqli_real_escape_string($con, date("Y-m-d H:i:s"));
    

    $query="insert into tours (`name`, `price`, `pickups`, `destination`, `dep_date`, `ret_date`, `fleet_number`, `driver`, `itinerary`, `submittedby`, `trn_date`)values ('$name', '$price', '$pickups', '$destination', '$dep_date', '$ret_date', '$fleet_number', '$driver', '$itinerary', '$submittedby',  '$trn_date')";
    mysqli_query($con,$query)
    
    or die(mysqli_error($con));
    if(mysqli_affected_rows($con)== 1 ){
    $message = '<i class="fa fa-check"></i> - Record Inserted Successfully';
    }
}
}
}
}

Here is the HTML form:

                          <form role="form" method="post" name="add_tour" id="add_tour" action"">
                                <input type="hidden" name="new" value="1" />
                            <div class="modal-body">
                                
                          <div class="row form-group">
                              <div class="col-6">
                                <div class="form-group"><label for="name" class=" form-control-label">Name</label><input type="text" id="name" name="name" placeholder="Tour Name" class="form-control">
                                </div>
                                </div>
                              <div class="col-6">
                                <div class="form-group"><label for="price" class=" form-control-label">Price</label><input type="text" id="price" name="price" placeholder="0.00" class="form-control">
                                </div>
                                </div>
                                </div>
                                
                                <div class="row form-group">
                                    <div class="col-6">
                        <div class="form-group origin" id="pickupsfield"><label for="pickups" class=" form-control-label">Pickup Location</label><input type="text" id="pickups" name="pickups[]" placeholder="Start Typing..." class="form-control"></div>
    <button type="button" class="btn btn-success add-field" id="add" name="add">Add New Location &nbsp; 
      <span style="font-size:16px; font-weight:bold;">+ </span>
    </button>
                        </div>

                        <div class="col-6">
                        <div class="form-group"><label for="destination" class=" form-control-label">Destination</label><input type="text" id="destination" name="destination" placeholder="Start Typing..." class="form-control"></div>
                        </div>
                        </div>
                          <div class="row form-group">
                              <div class="col-6">
                        <div class="form-group"><label for="dep_date" class=" form-control-label">Departure Date</label><input type="date" id="dep_date" name="dep_date" placeholder="" class="form-control"></div>
                        </div>
                              <div class="col-6">
                           <div class="form-group"><label for="ret_date" class=" form-control-label">Return Date</label><input type="date" id="ret_date" name="ret_date" placeholder="" class="form-control"></div>
                          </div>
                          </div>
                          <div class="row form-group">
                              <div class="col-6">
                        <div class="form-group"><label for="fleet_number" class=" form-control-label">Fleet Number</label>
                           <select class="form-control" id="fleet_number" name="fleet_number">
                               <option value="Select">== Select Fleet Number ==</option>
<?php
$sql = "SELECT fleet_number FROM fleet";
$result = $con->query($sql);
        while(list($fleet_number) = mysqli_fetch_row($result)){
          $option = '<option value="'.$fleet_number.'">'.$fleet_number.'</option>';
          echo ($option);
        }
          ?>
                           </select>
                        </div>
                        </div>
                              <div class="col-6">
<?php

    ?>
                           <div class="form-group"><label for="driver" class=" form-control-label">Driver</label>
                           <select class="form-control" id="driver" name="driver">
                               <option value="Select">== Select Driver ==</option>
<?php
$sql = "SELECT name FROM drivers";
$result = $con->query($sql);
        while(list($driver) = mysqli_fetch_row($result)){
          $option = '<option value="'.$driver.'">'.$driver.'</option>';
          echo ($option);
        }
          ?>
                           </select>
                           </div>
                          </div>
                          </div>
                            <div class="form-group"><label for="itinerary" class=" form-control-label">Itinerary</label>
                            <textarea class="form-control" id="itinerary" name="itinerary"></textarea>
                            </div>

                            <div class="modal-footer">
                                <button type="reset" class="btn btn-warning">Clear Form</button>
                                <button type="submit" name="submit" id="submit" class="btn btn-primary">Confirm</button>
                            </div>
                            </form>

And the Javascript for adding the new fields:

<script>
  $(document).ready(function(){

    var i = 1;

    $("#add").click(function(){
      i++;
      $('#pickupsfield').append('<div id="row'+i+'"><input type="text" name="pickups[]" placeholder="Enter pickup" class="form-control"/></div><div><button type="button" name="remove" id="'+i+'" class="btn btn-danger btn_remove">X</button></div>');  
    });

    $(document).on('click', '.btn_remove', function(){  
      var button_id = $(this).attr("id");   
      $('#row'+button_id+'').remove();  
   });

    $("#submit").on('click',function(){
      var formdata = $("#add_tour").serialize();
      $.ajax({
        url   :"",
        type  :"POST",
        data  :formdata,
        cache :false,
        success:function(result){
          alert(result);
          $("#add_tour")[0].reset();
        }
      });
    });
  });
</script>

Anyone have any idea where I am going wrong?

Before you say it, Yes, I know, Use Prepared statements 😷