在PHP中专门格式化数组

Question

I have the following PHP code on my website:

<?php
    $FirstName = array("Jacob", "Noah", "Frank");
    $LastName = array("Collins", "Little", "Allen");
    $BirthDay = array(19, 31, 06);
?>

And I want it to be output like so:

("Jacob", "Collins", 19), ("Noah", "Little", 31), ("Frank", "Allen", 06)

for an SQL string, which will be:

INSERT INTO Users (FirstName, LastName, BirthDay) VALUES ("Jacob", "Collins", 19), ("Noah", "Little", 31), ("Frank", "Allen", 06);

I am quite new to PHP (only started yesterday) and was wondering how I would do this.

Thanks.

Answer 1

Simply, If you have same count of $FirstName, $LastName and $BirthDay,

using for loop and array_push you can do it like this:

$data = array();
$count = count($FirstName);

for($i = 0; $i < $count; $i++ ){

    $insert = [$FirstName[$i],$LastName[$i], $BirthDay[$i]];
    array_push($data,$insert);

}

The $data gives you formatted array.