duan20081202 2014-12-22 14:07
浏览 32

错误检查将数据插入codeigniter中的数据库

i have form in put input fleet ID and multiple check unit ID. but in one date just use one unit_id.

i check with this code but data can not insert.

$fleet = $this->input->post('id_fleet');
$unit_id = $this->input->post('unit_id');

$records = array();

for ($i=0; $i < count($unit_id) ; $i++) { 
    $records[] = array('id_fleet' => $fleet,
                    'unit_id' => $unit_id[$i]);
}

$query = $this->database_three->query("select count(id_fleet_member) as unit from fleet_member  where id_fleet = '$fleet' AND unit_id = '$unit_id' group by fleet_member.id_fleet");
$ans = $query->row();

$check = $this->database_three->query("select fleet.fleet_status, fleet_member.unit_id from fleet Left join fleet_member 
                on fleet.id_fleet=fleet_member.id_fleet AND fleet_member.unit_id = '$unit_id' AND fleet.fleet_status = '$id_fleet'");

if ($ans->unit > 0) {
    $this->session->set_flashdata('message', generateErrorMessage('Data Fleet ID Sudah Digunakan'));
    redirect(site_url('fleet_member'));     
} else {
    if ($check == FALSE) {
        foreach ($records as $data) {
            $query = "insert into fleet_member (id_fleet, unit_id) values ('".$data['id_fleet']."','".$data['unit_id']."')"; 
            $this->database_three->query($query);
        }
        $this->session->set_flashdata('message', generateSuccessMessage('Data berhasil ditambah'));
        redirect(site_url('fleet_member'));
    } else {
        $this->session->set_flashdata('message', generateErrorMessage('Data Unit ID Sudah Digunakan'));
        redirect(site_url('fleet_member'));
    }
}

Can you tell me how to solved this problem?

thank you,

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 微信小程序协议怎么写
    • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
    • ¥20 怎么用dlib库的算法识别小麦病虫害
    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题,求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看