Extracting Gmail messages and importing them onto MySQL: Possible?

[FForce2195]

Hello.  I have accomplished several goals thanks to nice people here though I've been writing PHP scripts for just 2 weeks and a few days.  I have a small project to work with for the next few days.  Then I'm thinking about learning how to extract Google's Gmail messages and importing them onto MySQL.  Actually, I don't know if that's possible with PHP.  I suppose it is.  I have seen a website where they sell a library or something for extracting Gmail messages.  I think I ended up with that website after asking a guy named Google or something.  I also searched this place with 'Gmail extract' and didn't get precise hits.

 

If you know where I can go to get information on accessing a Gmail account and extracting messages, please let me know.  If you can give me a brief overview of what to do, that will be great, too.

 

Thanks a lot.

[MadTechie]

your need to readup on imap

heres a basic example

<?php
// Connection
$server = "imap.gmail.com:993"; // server & port
$user   = "USERNAME@gmail.com";
$pass   = "PASSWORD";
$mbox   = imap_open("{".$server."/imap/ssl}INBOX", $user, $pass) or die("Error: " . imap_last_error());

echo "<h1>Mailboxes</h1>\n";
$folders = imap_listmailbox($mbox, "{".$server."}", "*");

if ($folders == false) {
    echo "Call failed<br />\n";
} else {
    foreach ($folders as $val) {
        echo $val . "<br />\n";
    }
}

echo "<h1>Headers in INBOX</h1>\n";
$headers = imap_headers($mbox);

if ($headers == false) {
    echo "Call failed<br />\n";
} else {
    foreach ($headers as $val) {
        echo $val . "<br />\n";
    }
}

imap_close($mbox);
?>

[FForce2195]

Whoa...  That's very nice.

 

Thanks a lot, MadTechie.

[MadTechie]

Well its a starting point i won't write the whole thing but that should give you a jump start..

 

as a side note.. i have a static IP at home and at the office but i hear theirs a problem with using gmails imap on a server with a dynamic external IP.. (just something to keep in mind)

[FForce2195]

Okay.  Thanks for the reminder, MadTechie.