Hi! I’m Starx

vvr

if only one array is there for example

$values = array(x, y, z);

i am adding them into database like this

    foreach ($values as $value)
    {
        $insertFunction = addValues($value);
    }

my arrays:

$array1 = Array ( 1, 2, 1, 2, 1, 2, 1, 2, 1, 2 );

$array2 = Array ( fb1, or1, fb2, or2, fb3, or3, fb4, or4, fb5, or5 );

But i want both array to combine and insert them into database.
How can i do this please help me

Updated:

When i am printing the POST values i am getting out put like this

Array ( [0] => 1 [1] => 2 [2] => 1 [3] => 2 [4] => 1 [5] => 2 [6] => 1 [7] => 2 [8] => 1 [9] => 2 )

Array ( [0] => fb1 [1] => or1 [2] => fb2 [3] => or2 [4] => fb3 [5] => or3 [6] => fb4 [7] => or4 [8] => fb5 [9] => or5 )

when i tried with array_merge my out put is like this

Array ( [0] => 1 [1] => 2 [2] => 1 [3] => 2 [4] => 1 [5] => 2 [6] => 1 [7] => 2 [8] => 1 [9] => 2 [10] => fb1 [11] => or1 [12] => fb2 [13] => or2 [14] => fb3 [15] => or3 [16] => fb4 [17] => or4 [18] => fb5 [19] => or5 ) 

How to insert them in separate columns in a table $array1 and $array2

my database table is like this

1.id
2.username
3.network_id

id is primary key
network_id values coming in array1
username values coming in array2

Justin Petty

I should start of by saying that I’m still pretty green when it comes to PHP, so please be patient with me. I’m trying to figure out the distance between two latitudes and longitudes using php. I found a bunch of scripts online but, however when I try to test them I get the same distance no matter what latitudes and longitudes I use. I’m sure it’s something probably on my part, so I’ll just post what I have so far.

$lat1 = "29.140762";
$lon1 = "-91.639243";

$lat2 = "29.136275";
$lon2 = "-91.635524";

function distance($lat1, $lon1, $lat2, $lon2, $unit) {
    $theta = $lon1 - $lon2;
    $dist = sin(deg2rad($lat1)) * sin(deg2rad($lat2)) +  cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * cos(deg2rad($theta));
    $dist = acos($dist);
    $dist = rad2deg($dist);
    $miles = $dist * 60 * 1.1515;
    $unit = strtoupper($unit);

    if ($unit == "K") {
        return ($miles * 1.609344);
    } else if ($unit == "N") {
        return ($miles * 0.8684);
    } else {
        return $miles;
    }
}

// Miles
echo distance(32.9697, -96.80322, 29.46786, -98.53506, "m") . " miles<br><br>";

//Kilometers
echo distance(32.9697, -96.80322, 29.46786, -98.53506, "k") . " kilometers<br><br>";

//Nautical miles
echo distance(32.9697, -96.80322, 29.46786, -98.53506, "n") . " nautical miles";