insert using array

test-array-insert.php

<?php

function insert($table, $fields, $data)
{
    $SQL = "INSERT INTO {$table} (".implode(', ', $fields).") VALUES (".implode(', ', array_intersect_key($data, array_flip($fields))).")";
    echo $SQL;
    // lanjutkan peng-query-an disini
}

insert('mahasiswa', array('nim', 'nama', 'jk'), array('nim'=>'1088', 'nama'=>'andi', 'jk'=>'l', 'alamat'=>'jln.sendok'));