Combine two array in php

Question

I am new in php. I want to combine two array data into one table. My first array is given below:

https://i.sstatic.net/GzeFl.png

My second array is given below :

https://i.sstatic.net/6tpZ0.png

My output will be:

Name Date Start time End time

Billal 1-14-15 11:29 AM 8:30 Pm

Emrul 1-14-15 2:21 PM 8:34 pm

Limon 1-14-15 11:26 AM

Mamun 1-14-15 11:47 AM 8:32 pm

Masum 1-14-15 12:12 PM 8:33 pm

Shahed 1-14-15 11:30 Am

Emrul 1-15-15 11:29 AM 8:30 Pm

Limon 1-15-15 11:47 AM 8:32 pm

Masum 1-15-15 12:12 PM 8:33 pm

Here start time will be 10 am to 2 pm and rest are end time. when start/end time two data found fast data will be counted

How are the end time is getting in the output? It is not in images of arrays though. — Disha V.
– Disha V., Commented Jul 25, 2015 at 6:00
1st array's time will be start time and 2nd array's time will be end time. I want to make another array in which name,date,star and end time will be there In output same name and date start and end time will combined. @Disha V. — Alien
– Alien, Commented Jul 25, 2015 at 6:22

Purinda Gunasekara · Accepted Answer · 2015-07-25 06:33:55Z

3

Looks like what you need here is to combine two arrays you have given and order the result based on the time taken.

Here are some best practices to approach your problem.

If you ever need to calculate date/time do not use strings, use timestamps because it is just a one big number which you can use to easily manipulate (in your case you just need to subtract start date/time from end date/time to get the total time taken) using simple math.
If you store the data in a SQL database then don't retrieve them and calculate the time taken in PHP, instead calculate the durations using SQL before retrieving data. It will massively reduce the application overhead. You also can use SQL sorting to sort your result set.

Please don't attach screenshots of your xdebug output in future, instead paste on to the editor.

edited Jul 25, 2015 at 6:33

answered Jul 25, 2015 at 6:12

Purinda Gunasekara

1651 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JOE LEE · Accepted Answer · 2015-07-25 06:28:40Z

2

$array1a = array_chunk($array1, 3);
$array2a = array_chunk($array2, 3);

 $table =array();
foreach($array1a as $v1){
   $tmp = array(
   'name'=>$v1[0],
    'date' => $v1[1],
     'time1' => $v1[2]
    );

  foreach($array2a as $v2){
      if($v2[1] == $v1[1] && $v2[0] == $v1[0]){
        $tmp['time2']=$v2[2];
       }
   }
  $table[] =   $tmp;
}

hope it help

answered Jul 25, 2015 at 6:28

JOE LEE

1,0581 gold badge6 silver badges6 bronze badges

Comments

Syam Danda · Accepted Answer · 2015-07-25 05:36:45Z

0

array_merge() is an useful function for merging two arrays. Here is a simple example.

<?php
 $array1 = array("color" => "red", 2, 4);
 $array2 = array("a", "b", "color" => "green", "shape" => "trapezoid", 4);
 $result = array_merge($array1, $array2);
 print_r($result);
?>

answered Jul 25, 2015 at 5:36

Syam Danda

5873 gold badges12 silver badges36 bronze badges

Collectives™ on Stack Overflow

Combine two array in php

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related