<?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 . ')';
You have javascript disabled. You will not be able to edit any code.