Below is a PHP script that I run daily (via a cron job) to check my imap email statistics. It generates a report like below. I use this statistic report to tell me how behind I am on my emails. It also reports a distribution of the emails for the last few weeks. You can run it on the web browser or run it on php command line (command: “php imap.php”)

Derek's INBOX Statistics:
Total number of mails = 2842
Month 2007-08 has an email count of       528   ( 15.9 MB)
Month 2007-09 has an email count of      1210   ( 76.7 MB)
Month 2007-10 has an email count of      1104   ( 79.7 MB)
Week[-8] has an email count of     81   (  3.1 MB)
Week[-7] has an email count of    186   (  5.8 MB)
Week[-6] has an email count of    200   (  5.6 MB)
Week[-5] has an email count of    198   (  6.8 MB)
Week[-4] has an email count of    298   ( 19.5 MB)
Week[-3] has an email count of    336   ( 21.4 MB)
Week[-2] has an email count of    339   ( 26.8 MB)
Week[-1] has an email count of    530   ( 33.6 MB)
Week[-0] has an email count of    674   ( 49.7 MB)
Total mail box size = 172.3 MB
Maximum email size  =   2.9 MB
Earliest email date = 08/14/2007 (58 days ago)
Elapsed time = 2 seconds

================ imap.php ========================================
<?php
global $tdate, $today;
$tdate = getdate();
$today = $tdate[0];
$php_out = 0; /* =1 if html format is desired. =0 for std text output */
$max_msg_size = -10.0;
$earliest_date = $tdate[0];

$start_time = time(); /* capture the start time for elapsed time calculation */
if ($php_out) {
   print "\n";
   print "<h1>Derek's INBOX Statistics:</h1>\n";
}
print "Derek's INBOX Statistics:\n";
$total_size = 0.0;
/* Replace the following line for your application */
$mbox = imap_open("{yourhost.com:993/imap/ssl/novalidate-cert}INBOX", "username", "your_password");
$n_msg = imap_num_msg($mbox);
if ($php_out)
   echo "<h2>Total number of mails = ".$n_msg."</h2>\n";
else
   echo "Total number of mails = ".$n_msg."\n";

for ($i=1; $i<=$n_msg; $i++) {
  $header = imap_headerinfo($mbox,$i);
  if ($header == false) {
     echo "Call failed
\n";
     break;
  }
  else {
          $size = (float) $header->Size;
          if ($size > $max_msg_size)
             $max_msg_size = $size ;
          $msg_date=strtotime($header->Date);
          if ($msg_date < $earliest_date)
             $earliest_date = $msg_date;
          $month_key = date('Y-m',$msg_date);
          if ( is_null($msg_month[$month_key]))  {
                  $msg_month[$month_key] = 0;
                  /* $msg_size[$month_key] = 0.0; */
          }
          $msg_month[$month_key] += 1;
          $msg_week[getweektodate($msg_date)] += 1;
          $msg_week_size[getweektodate($msg_date)] += $size;
          $msg_size[$month_key] += $size;

  }
}
foreach ($msg_month as $key => $mon ){
        $size = $msg_size[$key]/1e6;
        $total_size += $size;
        printf ("Month %s has an email count of         %5d     (%5.1f MB)\n",$key, $mon, $size);
}
foreach ( $msg_week as $key => $num ) {
   printf ( "Week[-%d] has an email count of    %5d     (%5.1f MB)\n",$key,$num,$msg_week_size[$key]/1e6);
}
printf ("Total mail box size = %5.1f MB\n",$total_size);
unset ($key,$mon);
$time_elapsed = time() - $start_time;
printf("Maximum email size  = %5.1f MB\n",$max_msg_size/1e6);
printf("Earliest email date = %s (%d days ago)\n",date('m/d/Y', $earliest_date),($tdate[0]-$earliest_date)/60/60/24)
;
print ("Elapsed time = $time_elapsed seconds\n");
imap_close($mbox);
if ($php_out)
   print "";

function getdaystodate($indate) {
  return ($tdate[0]-$indate)/60/60/24;
}
function getweektodate($indate) {
  global $today;
  /* echo  "Indate= $indate, today = $today\n";  */
  return ((int) ($today-$indate)/60/60/24/7);
}
?>

My work was in need of a simple inventory management system to keep track of the prototype components. I have been given a small budget to buy one. So I went on Internet to search for a reasonably priced inventory management system. Most of the solutions are a bit too powerful for what we need, thus are too expensive.

Three weeks ago, I came across an open-source inventory management system. So I downloaded the source files (mostly php files) and started running it. I ran into several issues but was able to resolve most of them – due to file/directory privilege and dos/unix file transfer issues. All except one: the default “date” in a part transaction are all showing up as “{NAME}” instead of the numbers on the month/day/year fileds. What’s going on there? This plunged me into the world of php, xml, ajax, css and etc. I borrowed books from library like “PHP/MySQL for dummies” and “PHP 5 Advanced” by Larry Ullman . Both were very nice books in helping me to understand the intricate interaction between PHP and MySQL. I learned a lot of object-oriented programming (OOP) and a little bit on Ajax. But having learned the basic probably helps me to start a small project on my own. Tackling a full-blown sophisticated software like IMS that I downloaded was a totally different story.

By far the worst part about developing or debugging a PHP software/module is the fact that you’re dealing with a software running on a remote host and displaying the output on a browser. It’s difficult to insert variable dumps along the way to keep pace with the program flow because there is no console screen and showing the raw variable values on the browser may screw up your display. Not an easy thing to do. So I searched the net to find a debugger. The most popular debugger is NuSphere’s PhpEd. I downloaded the trial version and started debugging. I never used a debugger before so I needed to get used to the interface plus interrogating the variables values while tracing the program steps. Overall, the software does its job well and is fairly powerful. I don’t think I could have found the bug without its help. I think I’ll buy the software. See below for the exact bug.

After tracing this software code, I was very impressed with the author’s programming style and his modular approach. Modular is nice because it’s readily expandable but it’s very difficult to follow due to the jumping around among the classes/files.

By working with the debugger, I now understands a little bit about how the program works. I was then able to modify the titles and changed the fields slightly to meet our needs. Proudly, I demo’ed the tool to my technician crew who will be using the software to track our inventory. And guess what? They wanted to add a “project” field and a search function. That’ll teach me a lesson to download a freeware. 🙂 I did learn a few things along the way but may end up supporting/expanding the software for the rest of my career 🙁

=======================================================================
Here’s the bug I found around line 122 on “lib/html.php”:

if (is_array($extra_vars[$key])) {
$repl_array = array_merge($repl_array,$extra_vars[$key]); }
/* In the above “is_array($extra_vars)” got changed to “is_array($extra_vars[$key])” by Derek Tsai,
$repl_array kept getting NULL’ed due to array_merge with a NULL variable */