I am facing a challenge and need help solving it. I have a project that involves interacting with a database, where I created a CRUD HTML table for data manipulation. There are 15 tables in the relative database, and I need to insert, delete, and edit records within these tables. The main issue I'm encountering is how to ensure that when I insert values into a specific table in my HTML form, those values are accurately inserted into the corresponding table in the database.
Below is a snippet of the controller code:
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
Additionally, here is a glimpse of the model code which is still a work in progress:
<?php
class Main_model extends CI_Model {
function getClass() {
$query = $this->db->select('*')
->from('class')
->get();
return $query->result();
}
...
The model consists of various functions for fetching data from different tables in the database.