<?php
public function updateRecord($table, $fields)
{
if (!is_array($fields) or (count($fields) < 1)) {
throw new \Exception('Record set (update) requires one or more fields to be provided');
}
array_map('htmlentities', $fields);
if (isset($fields['id'])) {
$id = $fields['id'];
unset($fields['id']);
} else {
throw new \Exception('Record set (update) requires a row id to be provided');
}
$values = array();
foreach ($fields as $key => $value) {
$values[] = "`{$key}` = '{$value}'";
}
$q = 'UPDATE '.$table.' SET '.implode($values, ', ')." WHERE `id`='{$id}'";
return $q;
}
echo updateRecord('kognito_groups', array('id' => 1, 'test' => 'beep', 'name' => 'test'));