3v4l.org

run code in 500+ PHP versions simultaneously
<?php $rego_columns = [ "make", "model", "year", "rego", ]; $record = ['make' => 'A', 'model' => 'B', 'year' => 'C', 'rego' => 'D']; $tableValues = array_map(function($r) use ($record) { return $record[$r]; }, $rego_columns); $tableColumns = '`.' . implode('.`,`.', $rego_columns) . '.`'; $tableValues = '"' . implode('","', $tableValues) . '"'; echo 'INSERT INTO table_name (' . $tableColumns . ') VALUES (' . $tableValues . ')';
Output for 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.34, 8.2.0 - 8.2.30, 8.3.0 - 8.3.30, 8.4.1 - 8.4.18, 8.5.0 - 8.5.3
INSERT INTO table_name (`.make.`,`.model.`,`.year.`,`.rego.`) VALUES ("A","B","C","D")
preferences:
107.22 ms | 1947 KiB | 4 Q