i have this program cannot insert data but is always redirect to "else" and show massage error "Data Unit ID Sudah Digunakan"
this is my controller
$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 jumlah 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 as status, fleet_member.unit_id as unit
from fleet, fleet_member
where fleet_member.unit_id = '$unit_id' AND fleet.id_fleet = '$fleet'");
$ans2 = $query->row();
if ($ans->jumlah > 0)
{
$this->session->set_flashdata('message', generateErrorMessage('Data Fleet ID Sudah Digunakan'));
redirect(site_url('fleet_member'));
}
else
{
if (!($check == FALSE)) {
$this->session->set_flashdata('message', generateErrorMessage('Data Unit ID Sudah Digunakan'));
redirect(site_url('fleet_member'));
}
else
{
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'));
}
}
this program can insert when unit id its not use in the same fleed id..
can you help to solve insert data in this program?
Aucun commentaire:
Enregistrer un commentaire