确实可以提供一些帮助。所以我有两个像这样的数组
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/