Welcome Guest, Not a member yet? Register   Sign In
Does it right logic?
#1

[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.




Theme © iAndrew 2016 - Forum software by © MyBB