Codeigniter数据库插入 - 不使用数组

Question

I'm trying to insert some data into a database via codeigniter but am getting some strange errors. Does anyone know the cause:

My insert array ($datainsert) is the following when printed:

Array ( [online_name] => Discount Store 
        [online_nameKey] => d 
        [storeGroup_ID] => 
        [CJ_ID] => 123456 
        [online_tag] => Health and Medical 
        [online_businessType] => 0 
        [online_businessTypeSub] => 0 
        [online_homepage] => http://www.discountstore.com 
        [store_ChainID] => 
        [savingsdotcom_ID] => 0 ) 

Trying to print the insert I use:

echo $DB1->_insert('stores_online', $datainsert);

Which results in:

INSERT INTO stores_online (Discount Store, d, , 123456, Health and Medical, 0, 0, http://www.discountstore.com, , 0) VALUES ()

I can't figure out why its not using the array keys for the first () and the values correctly.

Answer 1

Try this code

$datainsert=Array ( [online_name] => Discount Store,
                    [online_nameKey] => d,
                    [storeGroup_ID] => something,
                    [CJ_ID] => 123456 ,
                    [online_tag] => Health and Medical ,
                    [online_businessType] => 0 ,
                    [online_businessTypeSub] => 0 ,
                    [online_homepage] => http://www.discountstore.com ,
                    [store_ChainID] => ,
                    [savingsdotcom_ID] => 0 
                 ) ;

$this->db->insert('stores_online', $datainsert);