在数据库codeigniter中向表插入多行

<?php
class Your_model extends CI_Model {
    public function insert_rows($data) {
        $this->db->insert_batch('your_table_name', $data);
    }
}

<?php
class Your_controller extends CI_Controller {
    public function insert_multiple_rows() {
        $this->load->model('Your_model');
        
        $data = array(
            array(
                'column1' => 'value1',
                'column2' => 'value2',
                'column3' => 'value3'
            ),
            array(
                'column1' => 'value4',
                'column2' => 'value5',
                'column3' => 'value6'
            ),
            // 添加更多行...
        );
        
        $this->Your_model->insert_rows($data);
    }
}

<form action="<?php echo site_url('Your_controller/insert_multiple_rows'); ?>" method="post">
    <!-- 表单字段 -->
    <input type="submit" value="插入多行">
</form>