PHP数组到SQL

Question

$array = array
        (
            53 => array('num' => 20,'name' => 'aaa'),
            10 => array('num' => 20,'name' => 'bbb')
        );

$sql ="插入数据(id,num,name) VALUES('53','20','aaa'),('10','20','bbb') ";

如何将 $array 转换为 ('53','20','aaa'),('10','20','bbb')？

谢谢

Answer 1

implode()可以帮助您做到这一点，但您需要遍历并将其应用于每个单独的数组:

 $resultStrings = array();
 foreach ($array as $key => $values) {
    $subarrayString = "('$key','" . implode($values, "','") . "')";
    $resultStrings[] = $subarrayString;
 }

 $result = implode($resultStrings, ",");