CodeIgniter新增租户信息插入功能失效问题求助

Got it, let's work through fixing your CodeIgniter tenant data insertion issue. I've dealt with similar legacy CodeIgniter setups before, so here's a step-by-step breakdown to get things working:

1. Verify Your Tenant Model Basics #

First, make sure your new tenant model is set up correctly—this is where most initial issues happen:

• Ensure the model extends CI_Model and loads the database properly in its constructor:

  <?php
  class Tenant_model extends CI_Model {
      // Match this to your exact table name (watch for prefixes if enabled!)
      protected $table = 'tblprojectstenant';
  
      public function __construct() {
          parent::__construct();
          $this->load->database(); // Critical for database access
      }
  }
  

• Double-check that the $table value matches your actual database table name (case-sensitive depending on your DB setup).

2. Validate Data Flow & Form Input #

Next, confirm you're capturing and passing the tenant data correctly from the form to the model:

• In your registration controller, explicitly grab the new tenant fields using CodeIgniter's input helper:

  // Get tenant-specific fields from the form
  $tenant_data = $this->input->post([
      'tenant_name', 
      'tenant_gender', 
      'tenant_age', 
      // Add all your new tenant fields here
  ]);
  

• Don't skip form validation—it catches bad data and prevents silent failures:

  $this->form_validation->set_rules('tenant_name', 'Tenant Name', 'required|trim');
  $this->form_validation->set_rules('tenant_age', 'Tenant Age', 'required|integer');
  
  if (!$this->form_validation->run()) {
      // Show validation errors to the user
      $this->load->view('registration_form', ['errors' => validation_errors()]);
      return;
  }
  

3. Fix the Insert Method Implementation #

Your model's insert function needs to be straightforward and return meaningful feedback:

• Add this method to your Tenant_model:

  public function insert_tenant($data) {
      // Optional but smart: Filter data to only include columns that exist in the table
      $allowed_columns = ['project_id', 'tenant_name', 'tenant_gender', 'tenant_age'];
      $filtered_data = array_intersect_key($data, array_flip($allowed_columns));
  
      // Execute the insert and return the result (true/false) + error info if needed
      if ($this->db->insert($this->table, $filtered_data)) {
          return ['success' => true, 'tenant_id' => $this->db->insert_id()];
      } else {
          return ['success' => false, 'error' => $this->db->error()];
      }
  }
  

• In your controller, call this method and handle the result explicitly:

  // First, insert the main project data into tblprojects
  $project_data = $this->input->post(['name', 'status', 'description', 'gender', 'age']);
  $this->db->insert('tblprojects', $project_data);
  $new_project_id = $this->db->insert_id(); // Get the ID of the newly created project
  
  // Attach the project ID to the tenant data (critical for foreign key linking!)
  $tenant_data['project_id'] = $new_project_id;
  
  // Load the tenant model and attempt insertion
  $this->load->model('Tenant_model');
  $insert_result = $this->Tenant_model->insert_tenant($tenant_data);
  
  if ($insert_result['success']) {
      // Success! Redirect to a confirmation page
      redirect('registration/success');
  } else {
      // Log the error for debugging and show a user-friendly message
      log_message('error', 'Tenant insert failed: ' . $insert_result['error']['message']);
      $this->load->view('registration_form', ['error' => 'Failed to save tenant information. Please try again.']);
  }
  

4. Check Database Table & Permissions #

Don't overlook the database itself:

• Confirm tblprojectstenant has all the fields you're trying to insert, with matching data types (e.g., age should be INT, not VARCHAR).
• If you're using a foreign key to link to tblprojects, make sure project_id exists in tblprojectstenant and matches the data type of id in tblprojects.
• Verify your database user has INSERT permissions on tblprojectstenant—this is a common silent failure cause.

5. Debug with SQL Logs #

If you're still stuck, let CodeIgniter show you exactly what SQL it's trying to run:

• Right after calling insert(), print the last executed query:

  echo $this->db->last_query();
  

• Run this SQL directly in your database tool (phpMyAdmin, MySQL Workbench) to see if it throws an error—this will pinpoint issues like missing fields or invalid data.

内容的提问来源于stack exchange，提问作者Carlvic Lim