使用CodeIgniter开发REST API批量插入MySQL失败求助

Hey there! Let's troubleshoot this batch insert API issue together. Based on what you shared and common pitfalls with CodeIgniter POST APIs and batch inserts, here are the most likely fixes to check:

1. Double-Check Postman Request Setup #

• First, confirm you're sending data in the right format:
  • If using raw JSON, set the Content-Type header to application/json and structure your payload as an array of product objects:

    [
      {"product_name": "Wireless Headphones", "quantity_per_pack": 2},
      {"product_name": "USB Charger", "quantity_per_pack": 10}
    ]
    

  • If using x-www-form-urlencoded, name fields like products[0][product_name], products[0][quantity_per_pack], products[1][product_name], etc., to pass an array of products.

2. Fix Input Handling in Your Controller #

Your current code grabs individual fields ($product_name = $this->post('product_name');) which won't work for batch inserts. You need to capture the entire array of products instead, and make sure you're using the correct input method for your CodeIgniter version:

For CodeIgniter 3: #

public function addProducts_post() {
    // Get the full array of products from the request
    $products = $this->input->post('products');
    
    // Debug: Check if data is being received
    log_message('debug', 'Received products: ' . print_r($products, true));
    
    // Pass to model for batch insert
    $inserted = $this->ProductModel->insert_batch_products($products);
}

For CodeIgniter 4: #

public function addProducts_post() {
    // Get the full array of products from the request
    $products = $this->request->getPost('products');
    
    // Debug: Check if data is being received
    log_message('debug', 'Received products: ' . print_r($products, true));
    
    // Pass to model for batch insert
    $inserted = $this->ProductModel->insertBatch($products);
}

3. Verify Your Model's Batch Insert Logic #

Make sure your model has a valid batch insert method that matches your CodeIgniter version:

CodeIgniter 3 Model: #

class ProductModel extends CI_Model {
    public function insert_batch_products($products) {
        // Ensure array keys match your database column names exactly
        return $this->db->insert_batch('products', $products);
    }
}

CodeIgniter 4 Model: #

namespace App\Models;
use CodeIgniter\Model;

class ProductModel extends Model {
    protected $table = 'products';
    protected $allowedFields = ['product_name', 'quantity_per_pack'];

    public function insert_batch_products($products) {
        return $this->insertBatch($products);
    }
}

• Critical: The keys in your $products array must exactly match the column names in your MySQL table (case-sensitive if your table uses case-sensitive collation).

4. Enable Debugging to Catch Hidden Errors #

• Turn on CodeIgniter's error logging to see what's failing:
  • For CI3: In application/config/config.php, set $config['log_threshold'] = 2;
  • For CI4: In app/Config/App.php, set public $logThreshold = 2;
• Check the log files (CI3: application/logs/, CI4: writable/logs/) for database errors, input validation issues, or missing data.

5. Rule Out CSRF & Database Permission Issues #

• If CSRF protection is enabled, you need to include the CSRF token in your Postman request:
  • CI3: Fetch the token name and hash from $this->security->get_csrf_token_name() and $this->security->get_csrf_hash(), then add them as parameters in your request.
  • CI4: Add the X-CSRF-TOKEN header with the token value (you can get it from the cookie set by CodeIgniter).
• Confirm your database user has INSERT permissions on the target table, and your database config (in config/database.php or Config/Database.php) is correct.

If you can share the full controller code and your model's implementation, that would help pinpoint the exact issue even faster!

内容的提问来源于stack exchange，提问作者Jayshree patnaik