Hello,
I've been playing with CRUD lately and I have this kind of problem that I didn't know how to fixed. I'm researching in the web to fixed this. Can someone tell me what is the error with this. I got an error
A Database Error Occurred Error Number: 1048
My form:
Code:
<div class="activity-item">
<form action="" id="form" enctype="multipart/form-data" class="form-horizontal">
<input type="hidden" value="" name="id" />
<div class="form-body">
<div class="form-group">
<div class="col-md-9">
<input name="agencyname" placeholder="Agency Name" class="form-control" type="text">
<span class="help-block"></span>
</div>
</div>
<div class="form-group">
<div class="col-md-9">
<input name="category" placeholder="Category" class="form-control" type="text">
<span class="help-block"></span>
</div>
</div>
<div class="form-group">
<div class="col-md-9">
<input name="address" placeholder="Address" class="form-control" type="text">
<span class="help-block"></span>
</div>
</div>
<div class="form-group">
<div class="col-md-9">
<input name="acronym" placeholder="Acronym" class="form-control" type="text">
<span class="help-block"></span>
</div>
</div>
</div>
</form>
<button type="button" id="btnSave" onclick="save()" class="btn btn-primary">Save</button>
</div>
SCript:
Code:
<script type="text/javascript">
function save() {
$('#btnSave').text('saving...');
$('#btnSave').attr('disabled', true);
var url;
if (save_method == 'add') {
url = "<?php echo site_url('agency/add')?>";
} else {
url = "<?php echo site_url('agency/update')?>";
}
$.ajax({
url: url,
type: "POST",
data: $('#form').serialize(),
dataType: "JSON",
success: function(data) {
if (data.status) //if success close modal and reload ajax table
{
reload_table();
} else {
}
$('#btnSave').text('save'); //change button text
$('#btnSave').attr('disabled', false); //set button enable
},
error: function(jqXHR, textStatus, errorThrown) {
alert('Error adding / update data');
$('#btnSave').text('save'); //change button text
$('#btnSave').attr('disabled', false); //set button enable
}
});
}
</script>
Controller:
Code:
public function add()
{
$this->_validate();
$data = array(
'name' => $this->input->post('agencyname'),
'category' => $this->input->post('category'),
'address' => $this->input->post('address'),
'acronym' => $this->input->post('acronym'),
);
$insert = $this->agency->save_agency($data);
echo json_encode(array("status" => TRUE));
}
Model:
Code:
public function save_agency($data)
{
$this->db->insert($this->agencyTbl, $data);
return $this->db->insert_id();
}
Attached Files
Thumbnail(s)