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 . ')';

preferences:
81.49 ms | 1946 KiB | 5 Q