PHP - Php - How To Compare And Eliminate Repeated Data Set Of Arrays?

Hi there,

I am wanting to insert post data into my DB, this is guest information

if i do a 

 $safePost = filter_input_array(INPUT_POST);
        print_r($safePost);

i get the following output.

Array

(

[action] => addGuestInfo

[guestno] => 2

[bookingid] => 151

[customerid] => 22

[Guestname-0] => Jamie

[Guestname-1] => Joe

[GuestAge-0] => 4-3

[GuestInfo-0] => celiac

[GuestAge-1] => 18

[GuestInfo-1] => wheat

)

normally the guestname-0, guestage-0, guestinfo-0 would be in correct order but we have to ensure the just incase it isns't (see output above) we cater for that aswell, we can have upto 6 guest details coming in at once.

so I need to loop through the data and insert into my DB. I have tried various for / foreach loops but cant seem to get it to group the data together

I have tried things like below, but it inserts each record multiple times.

$safePost = filter_input_array(INPUT_POST);
foreach($safePost as $key => $value){                 
            $exp_key = explode('-', $key);
          // for ($i =0; $i <= $guestcount; $i++) {
      switch ($exp_key[0]) {
        case 'Guestname':
            $booking->guestno = $exp_key[1];
            $booking->guestname = $val;
        break;
        case 'GuestAge':
            $booking->guestno = $exp_key[1];
            $booking->guestage = $val;

        break;
        case 'GuestInfo':
            $booking->guestno = $exp_key[1];
            $booking->guestinfo = $val;

        break;
        default:
        break;
  }
 //CALLS FUNCTION TO INSERT TO DB result = lastInsertId();
  $result= $booking->insertGuestDetails();
//}
}

Hi There all, having an issue with simple xml... hopefully someone will be able to shed some light on this. 

I have this data in an xml feed from an API: 

<ID>job no 1 </ID>
    <Name>job name</Name>
    <State>job status</State>    
    <Tasks>
      <Task>
         <Name>task name 1</Name>
      </Task>
      <Task>
          <Name>task name 2</Name>       
                </Task>
              
<ID>job no 2</ID>
     <Name>job name</Name>
     <State>job status</State>    
     <Tasks>
        <Task>
           <Name>task name 1</Name>
        </Task>
        <Task>
           <Name>task name 2</Name>       
         </Task>

I would like to display these in a table pretty much as it is shown above.

Job no 1     job name    job status

                             job 1 task name 1

                            job 1 task name 2

Job no 2     job name    job status

                             job 2 task name 1

                            job 2 task name 2

etc

my code looks like this : $required is narrowing down specific states not shown for clarity 

 $xml_current=simplexml_load_string($jobs_task_response) or die("Error: Cannot create object");
     
    foreach($xml_current->Jobs->Job as $item_current) {
        if (in_array((string)$item_current->State, $required)) {     
            $projects_current[] = array(
                'job_no'          => (string)$item_current->ID,
                'job_name'        => (string)$item_current->Name,
                'job_status'      => (string)$item_current->State,
            );
            foreach($item_current->Tasks->Task as $current_tasks){
                $projects_task[] = array(
                'job_tasks'       => (string)$current_tasks->Name,
                );
            }
        }         
    } 

 
    foreach ($projects_current as $proj_current) {
        $job_no =$proj_current['job_no'];
        $job_name =$proj_current['job_name'];
        $job_status =$proj_current['job_status'];       
        $clr_current = $colors[$job_status];
        $project_id = $job_no;  

        $tdata_1 .= "<tr id='current' class='card-body collapse-show'>";
        $tdata_1 .= "<td class='th-sm-1 bg-white '><a href='../details/index.php?pid=$job_no' class='text-left ml-1'>$job_no</a></td>";
        $tdata_1 .= "<td data-target='#" . $job_no . "' data-toggle='collapse' class='th-sm-2 bg-white text-left ml-1'>$job_name</td>"; 
        $tdata_1 .= "<td class='th-sm-2 " . $clr_current . " text-left ml-1 '>$job_status</td>";
      
        foreach ($projects_task as $proj_tasks){
        $job_tasks =$proj_tasks['job_tasks']; 
        $tdata_1 .= "</tr>";
        $tdata_1 .= "<tr id='" . $job_no . "' class='card-body collapse'> ";
        $tdata_1 .= "<td class='th-sm bg-white text-left ml-1'></td>";
        $tdata_1 .= "<td class='th-sm bg-white text-left ml-1'></td>";
        $tdata_1 .= "<td class='th-sm " . $clr_current . " text-left ml-1'>$job_tasks</td>";
        $tdata_1 .= "</tr>";
        }

    }

 what I get with this code however is;

Job no 1     job name    job status

                             job 1 task name 1

                            job 1 task name 2

                            job 2 task name 1 

                            job 2 task name 2

Job no 2    job name   job status

                          job 1 task name 1

                          job 1 task name 2

                          job 2 task name 1

                          job 2 task name 2       

I'm sure there is a simple answer to this, I just can't seem to put my finger on it. 

Can anyone help please? Much appreciated thanks in advance!

if(isset($_POST['action']))

    {                        

        $functionSelected = $_POST["action"];

    }



if(isset($functionSelected)){

    switch($functionSelected){

        case "insert":

            $initialize_flag = "N";

            // Store POST(ed) user-entered values into memory variables

            $store_name = $_POST['store_name'];    

            $item_description = $_POST['item_description'];    

            $qty_pkg = $_POST['qty_pkg'];    

            $pkg_of = $_POST['pkg_of'];    

            $price = $_POST['price'];    

            $flyer_page = $_POST['flyer_page'];    

            $limited_time_sale = $_POST['limited_time_sale'];    

            $flyer_date_start = $_POST['flyer_date_start'];    

            $nos_to_purchase = $_POST['nos_to_purchase'];    

                                    

            // Setup customized query

            $sql = "INSERT INTO shoplist

                        (store_name, item_description, qty_pkg, pkg_of, price, flyer_page, limited_time_sale, flyer_date_start, nos_to_purchase, shopper1_buy_flag, shopper2_buy_flag, purchased_flag, purchase_later_flag)

                    VALUES

                        (:store_name, :item_description, :qty_pkg, :pkg_of, :price, :flyer_page, :limited_time_sale, :flyer_date_start, :nos_to_purchase, :shopper1_buy_flag, :shopper2_buy_flag, :purchased_flag, :purchase_later_flag)";



            try {

                $statement = $conn->prepare($sql);

                                    

                $statement->bindParam(':store_name', $store_name);

                $statement->bindParam(':item_description', $item_description);

                $statement->bindParam(':qty_pkg', $qty_pkg);

                $statement->bindParam(':pkg_of', $pkg_of);

                $statement->bindParam(':price', $price);

                $statement->bindParam(':flyer_page', $flyer_page);

                $statement->bindParam(':limited_time_sale', $limited_time_sale);

                $statement->bindParam(':flyer_date_start', $flyer_date_start);

                $statement->bindParam(':nos_to_purchase', $nos_to_purchase);

                $statement->bindParam(':shopper1_buy_flag', $initialize_flag);

                $statement->bindParam(':shopper2_buy_flag', $initialize_flag);

                $statement->bindParam(':purchased_flag', $initialize_flag);

                $statement->bindParam(':purchase_later_flag', $initialize_flag);                                        



                // Execute the query

                $statement->execute();                            

                $statement->closeCursor();

                $functionSelected = "";     // WILL THIS STATEMENT NOT SERVE TO INITIALIZE/RESET THE OPERATION???

                break;

            } catch (PDOException $e) {

                print "Error!: " . $e->getMessage() . "<br/>";

            }

        case "update-delete":    

            ...

            ...

            ...