<?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); $placeholders = implode(',', array_fill(0, count($tableValues), '?')); $tableColumns = '`' . implode('`,`', $rego_columns) . '`'; $query = 'INSERT INTO table_name (' . $tableColumns . ') VALUES(' . $placeholders . ')'; echo $query;
You have javascript disabled. You will not be able to edit any code.