Codeigniter向数据库联系人发送邮件时报错求助

Hey there, let's break down what's going on here and fix those email issues step by step!

This error is screaming that your email function isn't getting a valid recipient address when pulling data from the database. Since hardcoding an email works fine, your core email logic is solid—you just have a problem with how you're fetching or passing database-based recipients.

Here's what to check first:

• Verify your database data: Dump the recipient list you're pulling from the database (use var_dump($your_recipient_array) or print_r()) to confirm:
  • Are there any empty values or malformed emails (missing @, extra spaces, etc.)?
  • Did you actually retrieve any data at all? Maybe your database query is returning an empty result set without you noticing.
• Check your loop/recipient assignment: If you're sending to multiple contacts in a loop, make sure you're properly setting the recipient for each iteration. For example, in CodeIgniter (since the error points to libraries/Email.php), you need to call $this->email->to($valid_email) for each recipient, and use $this->email->clear(TRUE) between sends to reset the recipient list.

The PHP mail() function is notoriously finicky because it relies on your server's local sendmail configuration, which is often misconfigured or disabled on shared hosts. The fix here is to switch to SMTP-based sending—it's more reliable and easier to troubleshoot.

In CodeIgniter, update your config/email.php (or initialize the config dynamically) with SMTP settings:

$config['protocol'] = 'smtp';
$config['smtp_host'] = 'your-smtp-provider.com'; // e.g., smtp.gmail.com for Gmail
$config['smtp_port'] = 587;
$config['smtp_user'] = 'your-sender-email@example.com';
$config['smtp_pass'] = 'your-app-specific-password'; // Use app password if using Gmail
$config['smtp_crypto'] = 'tls';
$config['mailtype'] = 'html'; // Or 'text' if you prefer plain text
$config['charset'] = 'utf-8';

Here's a cleaned-up CodeIgniter example that combines fixing both issues:

// Load dependencies
$this->load->library('email');
$this->load->database();

// Fetch valid recipients from database (add a WHERE clause to filter out bad emails!)
$recipients = $this->db->where('email IS NOT NULL')->where('email != ""')->get('contacts')->result_array();

// Initialize SMTP config
$smtp_config = [
    'protocol' => 'smtp',
    'smtp_host' => 'smtp.yourprovider.com',
    'smtp_port' => 587,
    'smtp_user' => 'your-email@example.com',
    'smtp_pass' => 'your-app-password',
    'smtp_crypto' => 'tls',
    'mailtype' => 'html',
    'charset' => 'utf-8'
];
$this->email->initialize($smtp_config);

// Loop through recipients and send
foreach ($recipients as $contact) {
    // Reset email instance for each send
    $this->email->clear(TRUE);
    
    // Set email details
    $this->email->from('your-sender-email@example.com', 'Your Brand Name');
    $this->email->to($contact['email']); // Ensure 'email' matches your DB column name
    $this->email->subject('Your Custom Subject');
    $this->email->message('Hi ' . $contact['name'] . ', this is your email content!');
    
    // Send and debug if needed
    if (!$this->email->send()) {
        echo "Failed to send to {$contact['email']}: " . $this->email->print_debugger();
    } else {
        echo "Successfully sent to {$contact['email']}!<br>";
    }
}

• Always validate email formats before sending (use CodeIgniter's valid_email validation rule on your DB data).
• If you're using Gmail, make sure you've enabled less secure apps (or better, use an app-specific password with 2FA enabled).

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