[eluser]freelife[/eluser]
Hello fellows,
Does it right logic to name form fields as table column in db?
Ex.
<input name="logFields" type="text" />
AND DB
users column "logFielsds"
Code:
function CreateLog($options = array())
{
// required values
if(!$this->_required(array('logType'), $options)) return false;
$qualificationArray = array('logType',
'logAction',
'logDate',
'logUserId'
);
foreach($qualificationArray as $qualifier)
{
if(isset($options[$qualifier])) $this->db->set($qualifier, $options[$qualifier]);
}
if(isset($options['logFields']))
{ //print_r($options['logFields']);
//$this->db->set('logFields', $options['logFields']);
}
// Execute the query
$this->db->insert('adv_logging');
// Return the ID of the inserted row, or false if the row could not be inserted
return $this->db->insert_id();
}
$data = array(
'logType' => 'info',
'logAction' => 'update',
'logDate' => date("Y-m-d H:i:s"),
'logFields' => $_POST,
'logUserId' => $this->session->userdata['userId']
);
$this->logging_model->CreateLog($data);
Thank you.