基于现有访客IP获取PHP代码，如何实现将网站页面访客IP数据保存至Excel文件并附带该文件发送邮件？

Great news—you can absolutely save visitor IPs to an Excel file and send that file via email using PHP. Let’s walk through the entire process with practical code examples that build on your existing IP function.

Step 1: Save IPs to an Excel File #

To handle Excel files reliably in PHP, we’ll use PhpSpreadsheet (the successor to PHPExcel), which makes creating/editing Excel files straightforward.

First, install it via Composer:

composer require phpoffice/phpspreadsheet

Then, here’s how to integrate it with your IP function to log data:

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

// Your existing IP function (with a small fix for proxy chains)
function getUserIpAddr(){
    if(!empty($_SERVER['HTTP_CLIENT_IP'])){
        $ip = $_SERVER['HTTP_CLIENT_IP'];
    }elseif(!empty($_SERVER['HTTP_X_FORWARDED_FOR'])){
        // HTTP_X_FORWARDED_FOR can return multiple IPs (comma-separated) — grab the first one
        $ip = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR'])[0];
    }else{
        $ip = $_SERVER['REMOTE_ADDR'];
    }
    return trim($ip);
}

// Get current visitor data
$visitorIp = getUserIpAddr();
$visitTime = date('Y-m-d H:i:s');

// Define where to save the Excel file
$excelFile = 'visitor_ips.xlsx';

// Check if the file already exists; if not, create a new spreadsheet with headers
if (file_exists($excelFile)) {
    $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($excelFile);
    $sheet = $spreadsheet->getActiveSheet();
    $nextRow = $sheet->getHighestRow() + 1; // Find the next empty row
} else {
    $spreadsheet = new Spreadsheet();
    $sheet = $spreadsheet->getActiveSheet();
    // Add header row for clarity
    $sheet->setCellValue('A1', 'Visitor IP');
    $sheet->setCellValue('B1', 'Visit Timestamp');
    $nextRow = 2;
}

// Write the new visitor data to the spreadsheet
$sheet->setCellValue('A' . $nextRow, $visitorIp);
$sheet->setCellValue('B' . $nextRow, $visitTime);

// Save the updated Excel file
$writer = new Xlsx($spreadsheet);
$writer->save($excelFile);

// Clean up memory
$spreadsheet->disconnectWorksheets();
unset($spreadsheet);

Quick Notes for This Step: #

• Make sure the directory where you’re saving visitor_ips.xlsx has write permissions (use chmod 755 on the folder if you’re on a Linux server).
• The fix to HTTP_X_FORWARDED_FOR handles cases where a visitor is behind multiple proxies, which can return a comma-separated list of IPs.

Step 2: Send the Excel File via Email #

For reliable email sending (especially with attachments), PHPMailer is far more dependable than PHP’s native mail() function.

Install PHPMailer via Composer:

composer require phpmailer/phpmailer

Here’s the code to send the email with your Excel attachment:

require 'vendor/autoload.php';

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\SMTP;
use PHPMailer\PHPMailer\Exception;

$mail = new PHPMailer(true);

try {
    // Configure your SMTP settings (adjust these to match your email provider)
    $mail->isSMTP();
    $mail->Host = 'smtp.yourprovider.com'; // e.g., smtp.gmail.com for Gmail
    $mail->SMTPAuth = true;
    $mail->Username = 'your-email@example.com';
    $mail->Password = 'your-email-password'; // Use an app-specific password if using Gmail with 2FA
    $mail->SMTPSecure = PHPMailer::ENCRYPTION_SMTPS;
    $mail->Port = 465;

    // Set sender and recipient
    $mail->setFrom('your-email@example.com', 'Website Visitor Logger');
    $mail->addAddress('your-target-email@example.com', 'You'); // Replace with your desired recipient

    // Attach the Excel file
    $mail->addAttachment('visitor_ips.xlsx');

    // Email content
    $mail->isHTML(true);
    $mail->Subject = 'Latest Website Visitor IP Logs';
    $mail->Body    = 'Hi,<br><br>Please find the latest visitor IP logs attached.<br><br>Thanks,<br>Your Website';
    $mail->AltBody = 'Hi,\n\nPlease find the latest visitor IP logs attached.\n\nThanks,\nYour Website';

    $mail->send();
    echo 'IP logged and email sent successfully!';
} catch (Exception $e) {
    echo "Oops, something went wrong. Email error: {$mail->ErrorInfo}";
}

Quick Notes for This Step: #

• For Gmail users: Enable 2FA and generate an app-specific password (instead of using your regular password) for better security.
• Double-check the file path in addAttachment() to ensure it points to the correct location of your Excel file.

Putting It All Together #

Combine both code blocks into a single script (or include them in your page’s existing logic) to log the visitor’s IP and send the email automatically whenever someone visits your target page.

内容的提问来源于stack exchange，提问作者The Digital Futur