确实可以提供一些帮助。所以我有两个像这样的数组

Array
(
    [0] => UK
    [1] => UK
    [2] => USA
    [3] => USA
    [4] => USA
    [5] => France
)
Array
(
    [0] =>  London
    [1] =>  Manchester
    [21] => New York
    [22] => Florida
    [23] => Hawaii
    [24] => Paris
)


我需要像这样将其插入mysql数据库

Country  City
UK       London, Manchester
USA      New York, Florida, Hawaii
France   Paris


我对PHP没问题,但我真的对这一门感到困惑。没有任何代码可显示,因为我完全不知道如何完成此操作。有人可以帮我实现这一目标。先谢谢您的帮助。

最佳答案

$countries = array("UK","UK","USA","USA","USA","FRANCE");
$cities = array(0=>"London",1=>"Manchester",23=>"New York",24=>"Florida",25=>"Hawaii",26=>"Paris");

$combined = array();
$cities = array_values($cities);
foreach ($countries as $index => $country)
{
    $combined[$country][] = $cities[$index];
}

foreach ($combined as $country => $cityList)
{
    $sql = sprintf("INSERT INTO `MyTable` (Country,City) VALUES ('%s','%s')",$country,implode(',',$cityList));

关于php - PHP数组插入,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/10547847/

10-11 23:05
查看更多