topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

professional-sql-03-scripts-digest.php / php



  #! /usr/bin/php
  <?php
  // include shared code
  include '../lib/config.php';
  include '../lib/db.php';
  include '../lib/POP3Client.php';
  
  // retrieve users to receive digest messages
  query = sprintf('SELECT EMAIL_ADDR FROM \%sMAILLIST_USER WHERE IS_DIGEST = 1',
      DB_TBL_PREFIX);
  result = mysql_query(query, GLOBALS['DB']);
  
  // open digest file
  time = strtotime('-1 day');
  digest = QUEUE_DIR . '/digest-' . date('Ymd', time) . '.txt';
  if (!file_exists(digest))
  {
      // no digest file
      mysql_free_result(result);
      exit();
  }
  body = file_get_contents(digest);
  
  // send mail to each recipient
  while (row = mysql_fetch_assoc(result))
  {
      mail(row['EMAIL_ADDR'], 'List Digest for ' . date('m/d/Y', time),
          body,
          'From: ' . LIST_EMAIL . "\r\n" .
          'Reply-To: ' . LIST_EMAIL . "\r\n");
  }
  mysql_free_result(result);
  mysql_close(GLOBALS['DB']);
  
  // delete digest file
  unlink(digest);
  ?>
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.