fetch_emails.php

<?php
// Script to fetch emails from Gmail mailbox via IMAP and insert into contact_messages table

// Configuration
$hostname = '{imap.gmail.com:993/imap/ssl}INBOX';
$username = 'booker_library_staff@gmail.com'; // Your Gmail address
$password = 'jbai gevm jtgl ucvx'; // Your Gmail app password

// Connect to mailbox
$inbox = imap_open($hostname, $username, $password) or die('Cannot connect to Gmail: ' . imap_last_error());

// Search for all unseen emails
$emails = imap_search($inbox, 'UNSEEN');

if ($emails) {
    include 'connection.php';

    foreach ($emails as $email_number) {
        // Fetch email overview and body
        $overview = imap_fetch_overview($inbox, $email_number, 0)[0];
        $structure = imap_fetchstructure($inbox, $email_number);
        $message = '';

        if (!isset($structure->parts)) {
            $message = imap_body($inbox, $email_number);
        } else {
            // multipart message
            foreach ($structure->parts as $part_number => $part) {
                if ($part->type == 0) { // text
                    $message .= imap_fetchbody($inbox, $email_number, $part_number + 1);
                }
            }
        }

        // Decode message if base64 or quoted-printable
        if ($part->encoding == 3) {
            $message = base64_decode($message);
        } elseif ($part->encoding == 4) {
            $message = quoted_printable_decode($message);
        }

        // Extract sender email and name
        $from = $overview->from;
        $from_address = '';
        $from_name = '';
        if (preg_match('/(.*)<(.+)>/', $from, $matches)) {
            $from_name = trim($matches[1], "\" ");
            $from_address = $matches[2];
        } else {
            $from_address = $from;
            $from_name = $from;
        }

        // Prepare data for insertion
        $name = $from_name ?: 'Unknown';
        $email = $from_address;
        $phone = ''; // No phone info from email
        $staff_email = $username;
        $subject = $overview->subject ?? '';
        $date = date('Y-m-d H:i:s', strtotime($overview->date));

        // Insert into contact_messages table
        $stmt = $db->prepare("INSERT INTO contact_messages (name, email, phone, message, staff_email, submitted_at) VALUES (?, ?, ?, ?, ?, ?)");
        if ($stmt) {
            $stmt->bind_param("ssssss", $name, $email, $phone, $message, $staff_email, $date);
            $stmt->execute();
            $stmt->close();
        }

        // Mark email as seen
        imap_setflag_full($inbox, $email_number, "\\Seen");
    }
}

imap_close($inbox);
echo "Email fetch completed.\n";
?>