ArrayMap example

generateInsertSQL.php

<?php

function generateInsertSQL($table, $fields) {
  $sql = "insert into `" . $table . "` ";

  $sql .= "(" . implode(
    ", ",
    array_map(
      function($f) { return "`" . $f . "`"; },
      array_keys($fields[0])
    )
  ) . ") values\n";

  $sql .= "  ". implode(
    ",\n  ",
    array_map(
      function($field) {
        return "(" . implode(
          ", ",
          array_map(
            function($v) {
              if ($v === (int)$v) { return $v; }
              if ($v === (float)$v) { return $v; }
              return '"' . str_replace('"', "'", $v) . '"';
            },
            array_values($field)
          )
        ) . ")";
      },
      $fields
    )
  ) . "\n;";

  return $sql;
}


$users = array(
  array(
    'name' => "Amy Wang",
    'age' => 29,
    'weight' => 58.7
  ),
  array(
    'name' => "Andy Roye",
    'age' => 23,
    'weight' => 64
  ),
  array(
    'name' => "John's Son",
    'age' => 53,
    'weight' => 59.9
  ),
  array(
    'name' => 'Peter "The Phoenix" Thomson',
    'age' => 42,
    'weight' => 114.2
  )
);

echo generateInsertSQL('users', $users), "\n";

insert into `users` (`name`, `age`, `weight`) values
  ("Amy Wang", 29, 58.7),
  ("Andy Roye", 23, 64),
  ("John's Son", 53, 59.9),
  ("Peter 'The Phoenix' Thomson", 42, 114.2)
;