Anonymous
Я не могу добавить новые данные в базу данных, как это исправить
Сообщение
Anonymous » 07 окт 2024, 17:17
У меня возникла проблема, ошибка не появляется, форма не может добавить данные в базу данных. может кто-нибудь помочь с моей проблемой
Контроллер Finalpendiddikan
**
Код: Выделить всё
class Finalpendidikan extends CI_Controller {
public function __construct() {
parent::__construct();
$this->load->database();
$this->load->model('Pendidikan_model');
}
public function index()
{
$data['title'] = 'Input Data Pendidikan';
$data['user'] = $this->db->get_where('user', ['pn' => $this->session->userdata('pn')])->row_array();
$data['inputPendidikan'] = $this->db->get("data_pendidikan")->result_array();
if($this->form_validation->run() == false) {
$this->load->view('templates/header', $data);
$this->load->view('templates/sidebar', $data);
$this->load->view('templates/topbarmobile', $data);
$this->load->view('addpendidikan', $data);
$this->load->view('templates/footer');
} else {
$data = [
'academy' => $this->input->post('academy'),
'nama_pendidikan' => $this->input->post('nama_pendidikan'),
'kode_pelatihan' => $this->input->post('kode_pelatihan'),
'batch' => $this->input->post('batch'),
'total_pemanggilan' => $this->input->post('total_pemanggilan'),
'total_kehadiran' => $this->input->post('total_kehadiran'),
'tgl_pelaksanaan' => $this->input->post('tgl_pelaksanaan'),
'anggaran' => $this->input->post('anggaran'),
'learning_officer' => $this->input->post('learning_officer'),
'upload_file' => $this->input->post('upload_file')
];
$this->db->insert('data_pendidikan', $data);
$this->session->set_flashdata('message', 'New pendidikan added!');
redirect('addpendidikan');
}
Модель_образования
**
Код: Выделить всё
class Pendidikan_model extends CI_Model
{
private $_table = "events"; //nama tabel
//nama kolom di tabel, harus sama huruf besar dan huruf kecilnya!!!
public $id;
public $academy;
public $nama_pendidikan;
public $kode_pelatihan;
public $batch;
public $total_pemanggilan;
public $total_kehadiran;
public $tgl_pelaksanaan;
public $anggaran;
public $learning_officer;
public $upload_file;
public function rules()
{
return [
[
'field' => 'id',
'label' => 'Id',
'rules' => 'Required|trim'
],
[
'field' => 'academy',
'label' => 'Academy',
'rules' => 'Required|trim'
],
[
'field' => 'nama_pendidikan',
'label' => 'Nama Pendidikan',
'rules' => 'Required|trim'
],
[
'field' => 'kode_pelatihan',
'label' => 'Kode Pelatihan',
'rules' => 'Required|trim'
],
[
'field' => 'batch',
'label' => 'Batch',
'rules' => 'Required|trim'
],
[
'field' => 'total_pemanggilan',
'label' => 'Total Pemanggilan',
'rules' => 'required|trim'
],
[
'field' => 'total_kehadiran',
'label' => 'Total Kehadiran',
'rules' => 'required|trim'
],
[
'field' => 'tgl_pelaksanaa',
'label' => 'Tanggal Pelaksanaan',
'rules' => 'required|trim'
],
[
'field' => 'anggaran',
'label' => 'Anggaran',
'rules' => 'required|trim'
],
[
'field' => 'learning_officer',
'label' => 'Learning Officer',
'rules' => 'required|trim'
],
[
'field' => 'upload_file',
'label' => 'Upload FIle',
'rules' => 'required|trim'
],
];
}
public function addNewData()
{
$data = [
"id" => $this->input->post('id', true),
"academy" => $this->input->post('academy', true),
"nama_pendidikan" => $this->input->post('nama_pendidikan', true),
"kode_pelatihan" => $this->input->post('kode_pelatihan', true),
"batch" => $this->input->post('batch', true),
"total_pemanggilan" => $this->input->post('total_pemanggilan', true),
"total_kehadiran" => $this->input->post('total_kehadiran', true),
"tgl_pelaksanaan" => $this->input->post('tgl_pelaksanaan', true),
"anggaran" => $this->input->post('anggaran', true),
"learning_officer" => $this->input->post('learning_officer', true),
"upload_file" => $this->input->post('upload_file', true),
];
$this->db->insert('data_pendidikan', $data);
}
Мои представления добавляют данные
Не кажется ли что-то неправильным в моих представлениях или есть ли что-то, что нужно добавить в мои представления?
Код: Выделить всё
Подробнее здесь: [url]https://stackoverflow.com/questions/79062288/i-cant-add-new-data-to-database-how-to-fix-it[/url]
1728310677
Anonymous
У меня возникла проблема, ошибка не появляется, форма не может добавить данные в базу данных. может кто-нибудь помочь с моей проблемой Контроллер Finalpendiddikan [code]this my controller function[/code]** [code]class Finalpendidikan extends CI_Controller { public function __construct() { parent::__construct(); $this->load->database(); $this->load->model('Pendidikan_model'); } public function index() { $data['title'] = 'Input Data Pendidikan'; $data['user'] = $this->db->get_where('user', ['pn' => $this->session->userdata('pn')])->row_array(); $data['inputPendidikan'] = $this->db->get("data_pendidikan")->result_array(); if($this->form_validation->run() == false) { $this->load->view('templates/header', $data); $this->load->view('templates/sidebar', $data); $this->load->view('templates/topbarmobile', $data); $this->load->view('addpendidikan', $data); $this->load->view('templates/footer'); } else { $data = [ 'academy' => $this->input->post('academy'), 'nama_pendidikan' => $this->input->post('nama_pendidikan'), 'kode_pelatihan' => $this->input->post('kode_pelatihan'), 'batch' => $this->input->post('batch'), 'total_pemanggilan' => $this->input->post('total_pemanggilan'), 'total_kehadiran' => $this->input->post('total_kehadiran'), 'tgl_pelaksanaan' => $this->input->post('tgl_pelaksanaan'), 'anggaran' => $this->input->post('anggaran'), 'learning_officer' => $this->input->post('learning_officer'), 'upload_file' => $this->input->post('upload_file') ]; $this->db->insert('data_pendidikan', $data); $this->session->set_flashdata('message', 'New pendidikan added!'); redirect('addpendidikan'); } [/code] Модель_образования [code]this my model[/code]** [code]class Pendidikan_model extends CI_Model { private $_table = "events"; //nama tabel //nama kolom di tabel, harus sama huruf besar dan huruf kecilnya!!! public $id; public $academy; public $nama_pendidikan; public $kode_pelatihan; public $batch; public $total_pemanggilan; public $total_kehadiran; public $tgl_pelaksanaan; public $anggaran; public $learning_officer; public $upload_file; public function rules() { return [ [ 'field' => 'id', 'label' => 'Id', 'rules' => 'Required|trim' ], [ 'field' => 'academy', 'label' => 'Academy', 'rules' => 'Required|trim' ], [ 'field' => 'nama_pendidikan', 'label' => 'Nama Pendidikan', 'rules' => 'Required|trim' ], [ 'field' => 'kode_pelatihan', 'label' => 'Kode Pelatihan', 'rules' => 'Required|trim' ], [ 'field' => 'batch', 'label' => 'Batch', 'rules' => 'Required|trim' ], [ 'field' => 'total_pemanggilan', 'label' => 'Total Pemanggilan', 'rules' => 'required|trim' ], [ 'field' => 'total_kehadiran', 'label' => 'Total Kehadiran', 'rules' => 'required|trim' ], [ 'field' => 'tgl_pelaksanaa', 'label' => 'Tanggal Pelaksanaan', 'rules' => 'required|trim' ], [ 'field' => 'anggaran', 'label' => 'Anggaran', 'rules' => 'required|trim' ], [ 'field' => 'learning_officer', 'label' => 'Learning Officer', 'rules' => 'required|trim' ], [ 'field' => 'upload_file', 'label' => 'Upload FIle', 'rules' => 'required|trim' ], ]; } public function addNewData() { $data = [ "id" => $this->input->post('id', true), "academy" => $this->input->post('academy', true), "nama_pendidikan" => $this->input->post('nama_pendidikan', true), "kode_pelatihan" => $this->input->post('kode_pelatihan', true), "batch" => $this->input->post('batch', true), "total_pemanggilan" => $this->input->post('total_pemanggilan', true), "total_kehadiran" => $this->input->post('total_kehadiran', true), "tgl_pelaksanaan" => $this->input->post('tgl_pelaksanaan', true), "anggaran" => $this->input->post('anggaran', true), "learning_officer" => $this->input->post('learning_officer', true), "upload_file" => $this->input->post('upload_file', true), ]; $this->db->insert('data_pendidikan', $data); } [/code] Мои представления добавляют данные Не кажется ли что-то неправильным в моих представлениях или есть ли что-то, что нужно добавить в мои представления? [code] Подробнее здесь: [url]https://stackoverflow.com/questions/79062288/i-cant-add-new-data-to-database-how-to-fix-it[/url]