Skip to content

Instantly share code, notes, and snippets.

@raessafathulalim

raessafathulalim/insert_inyong.sql

Created June 17, 2019 19:13
Show Gist options
  • Save raessafathulalim/31db883fd345708e1300b8459c17caf0 to your computer and use it in GitHub Desktop.
Save raessafathulalim/31db883fd345708e1300b8459c17caf0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
insert_inyong.sql
function insert_inyong(array $data) {
$_prepared = array();
foreach ($data as $col => $val)
$_prepared[$col] = $this->db->escape($val);
$this->db->query('INSERT INTO `data` (`'.implode('`,`',array_keys($_prepared)).'`) VALUES('.implode(',',array_values($_prepared)).');');
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment