lundi 22 décembre 2014

Cannot insert data to databse in codeigniter

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