Welcome Guest, Not a member yet? Register   Sign In
db insert fails without any error message
#1

[eluser]bhakti.thakkar[/eluser]
I am trying to perform an insert but its not happening. there is no error message also. can some one figure it out why?
Controller:

Code:
// Insert a new product in the db
    function insert_product()
    {

    $Product_ID = $this->input->post('Product_ID');
    $TradeName_VC = $this->input->post('TradeName_VC');
    $ProductionYear_SI = $this->input->post('ProductionYear_SI');
    $GrossQuantity_DC = $this->input->post('GrossQuantity_DC');
    $NetQuantity_DC = $this->input->post('NetQuantity_DC');
    $LotBatchNumber_VC = $this->input->post('LotBatchNumber_VC');
    $PackedIn_VC = $this->input->post('PackedIn_VC');

  $now = date("Y-m-d H:i:s");


    $data=array(
        'Product_ID' => $Product_ID,
        'TradeName_VC' => $TradeName_VC,
        'ProductionYear_SI' => $ProductionYear_SI,
        'GrossQuantity_DC' => $GrossQuantity_DC,
        'NetQuantity_DC' => $NetQuantity_DC,
        'LotBatchNumber_VC' => $LotBatchNumber_VC,
        'PackedIn_VC' => $PackedIn_VC,
        'InsertBy_SI' => $this->session->userdata('sregistration_id'),
        'InsertBy_NV' => $this->session->userdata('suserid'),
        'InsertDate_DT' => $now
        );

    $result = $this->db->insert('TempTable_TransactionCertificate_Product_T', $data);
print $result;


    }
the db is already autoloaded in the config.php :

$autoload['libraries'] = array('database', 'site_sentry', 'session');
#2

[eluser]bhakti.thakkar[/eluser]
Sorry for the post. i was cross-checking the wrong DB. The inserts are fine

Thanks




Theme © iAndrew 2016 - Forum software by © MyBB