php - Codeigniter 插入批处理不起作用

Question

我的功能是:

function saveproduct($p_arrProductInfo,$p_arrProductLangInfo){
        $this->db->trans_start();       
        $this->db->insert_batch('t_product', $p_arrProductInfo);    
        $this->db->insert_batch('t_productlang', $p_arrProductLangInfo); 
        $this->db->trans_complete();    
}

我的错误是:

INSERT INTO t_productlang (a_active, a_availablefororder, a_categorydefaultid, a_condition, a_createdby, a_createddate, a_ean13, a_ecotax, a_manufacturerid, a_onlineonly, a_onsale, a_price, a_productid, a_quantity, a_reference, a_showprice, a_styleguideurl, a_supplierid, a_upc, a_weight, a_wholesaleprice, a_createdby, a_createddate, a_description, a_descriptionshort, a_lang, a_linkrewrite, a_metadescription, a_metakeywords, a_metatitle, a_name, a_productid, a_shopid, a_tags) VALUES ('1','2013-03-28 07:10:24','<p>With a contemporary approach to the latest fashion trends, <strong>People</strong> is a brand that gives a completely modern spin to ethnic wear for women.</p><p>This <strong>3/4 sleeved, printed, short kurta</strong> boasts of a <strong>printed yoke</strong> and a <strong>pleated front</strong>. Pair it with a fitted churidar for a style statement that will definitely make heads turn wherever you go. Buy online now!</p>','Featuring People's Ethnic, All-over print Short Kurta with a Band Collar, 3/4th sleeve and . It comes in Regular Fit. Wash as indicated on label.','1','printed-band-collar-kurta','Buy PEOPLE Dupatta & Kurta for women at Trendin.com - Shop online for Printed Band Collar Kurta for women at best price with Free Shipping & 15 days Exchange policy','printed band collar kurta, women kurta, women dupatta, buy kurta online, buy dupatta online, kurta dupatta online shop, buy kurta for women, kurtis online, online kutis for sale, trendin','PEOPLE Kurta & Dupatta Online -Printed Band Collar Kurtaat Trendin.com','Printed Band Collar Kurta',3629,'1',''), ('1','2013-03-28 07:10:24','<p>With a contemporary approach to the latest fashion trends, <strong>People</strong> is a brand that gives a completely modern spin to ethnic wear for women.</p><p>This <strong>3/4 sleeved, printed, short kurta</strong> boasts of a <strong>printed yoke</strong> and a <strong>pleated front</strong>. Pair it with a fitted churidar for a style statement that will definitely make heads turn wherever you go. Buy online now!</p>','Featuring People's Ethnic, All-over print Short Kurta with a Band Collar, 3/4th sleeve and . It comes in Regular Fit. Wash as indicated on label.','1','printed-band-collar-kurta','Buy PEOPLE Dupatta & Kurta for women at Trendin.com - Shop online for Printed Band Collar Kurta for women at best price with Free Shipping & 15 days Exchange policy','printed band collar kurta, women kurta, women dupatta, buy kurta online, buy dupatta online, kurta dupatta online shop, buy kurta for women, kurtis online, online kutis for sale, trendin','PEOPLE Kurta & Dupatta Online -Printed Band Collar Kurtaat Trendin.com','Printed Band Collar Kurta',3629,'2',''), ('1','2013-03-28 07:10:24','<p>With a contemporary approach to the latest fashion trends, <strong>People</strong> is a brand that gives a completely modern spin to ethnic wear for women.</p><p>This <strong>3/4 sleeved, printed, short kurta</strong> boasts of a <strong>printed yoke</strong> and a <strong>pleated front</strong>. Pair it with a fitted churidar for a style statement that will definitely make heads turn wherever you go. Buy online now!</p>','Featuring People's Ethnic, All-over print Short Kurta with a Band Collar, 3/4th sleeve and . It comes in Regular Fit. Wash as indicated on label.','1','printed-band-collar-kurta','Buy PEOPLE Dupatta & Kurta for women at Trendin.com - Shop online for Printed Band Collar Kurta for women at best price with Free Shipping & 15 days Exchange policy','printed band collar kurta, women kurta, women dupatta, buy kurta online, buy dupatta online, kurta dupatta online shop, buy kurta for women, kurtis online, online kutis for sale, trendin','PEOPLE Kurta & Dupatta Online -Printed Band Collar Kurtaat Trendin.com','Printed Band Collar Kurta',3629,'3',''), ('1','2013-03-28 07:10:24','<p>With a contemporary approach to the latest fashion trends, <strong>People</strong> is a brand that gives a completely modern spin to ethnic wear for women.</p><p>This <strong>3/4 sleeved, printed, short kurta</strong> boasts of a <strong>printed yoke</strong> and a <strong>pleated front</strong>. Pair it with a fitted churidar for a style statement that will definitely make heads turn wherever you go. Buy online now!</p>','Featuring People's Ethnic, All-over print Short Kurta with a Band Collar, 3/4th sleeve and . It comes in Regular Fit. Wash as indicated on label.','1','printed-band-collar-kurta','Buy PEOPLE Dupatta & Kurta for women at Trendin.com - Shop online for Printed Band Collar Kurta for women at best price with Free Shipping & 15 days Exchange policy','printed band collar kurta, women kurta, women dupatta, buy kurta online, buy dupatta online, kurta dupatta online shop, buy kurta for women, kurtis online, online kutis for sale, trendin','PEOPLE Kurta & Dupatta Online -Printed Band Collar Kurtaat Trendin.com','Printed Band Collar Kurta',3629,'4',''), ('1','2013-03-28 07:10:24','<p>With a contemporary approach to the latest fashion trends, <strong>People</strong> is a brand that gives a completely modern spin to ethnic wear for women.</p><p>This <strong>3/4 sleeved, printed, short kurta</strong> boasts of a <strong>printed yoke</strong> and a <strong>pleated front</strong>. Pair it with a fitted churidar for a style statement that will definitely make heads turn wherever you go. Buy online now!</p>','Featuring People's Ethnic, All-over print Short Kurta with a Band Collar, 3/4th sleeve and . It comes in Regular Fit. Wash as indicated on label.','1','printed-band-collar-kurta','Buy PEOPLE Dupatta & Kurta for women at Trendin.com - Shop online for Printed Band Collar Kurta for women at best price with Free Shipping & 15 days Exchange policy','printed band collar kurta, women kurta, women dupatta, buy kurta online, buy dupatta online, kurta dupatta online shop, buy kurta for women, kurtis online, online kutis for sale, trendin','PEOPLE Kurta & Dupatta Online -Printed Band Collar Kurtaat Trendin.com','Printed Band Collar Kurta',3629,'5',''), ('1','2013-03-28 07:10:24','<p>With a contemporary approach to the latest fashion trends, <strong>People</strong> is a brand that gives a completely modern spin to ethnic wear for women.</p><p>This <strong>3/4 sleeved, printed, short kurta</strong> boasts of a <strong>printed yoke</strong> and a <strong>pleated front</strong>. Pair it with a fitted churidar for a style statement that will definitely make heads turn wherever you go. Buy online now!</p>','Featuring People's Ethnic, All-over print Short Kurta with a Band Collar, 3/4th sleeve and . It comes in Regular Fit. Wash as indicated on label.','1','printed-band-collar-kurta','Buy PEOPLE Dupatta & Kurta for women at Trendin.com - Shop online for Printed Band Collar Kurta for women at best price with Free Shipping & 15 days Exchange policy','printed band collar kurta, women kurta, women dupatta, buy kurta online, buy dupatta online, kurta dupatta online shop, buy kurta for women, kurtis online, online kutis for sale, trendin','PEOPLE Kurta & Dupatta Online -Printed Band Collar Kurtaat Trendin.com','Printed Band Collar Kurta',3629,'6','')

实际上第一个和第二个 arr 键和值在事务中合并它显示发生数据库错误

   Error Number: 1136 Column count doesn't match value count at row 1

Answer 1

很简单，错误清除说明了这一点。

我看到您对记录 1 的查询提到了 34 列并且只给出了 27 列值。不匹配。