Bug Features - Free bug report and feature request service for your Web site.

Zend Mail mangles email text

Dan — Mon, 18 Jan 2010 00:10:34 GMT

Had this strange problem ever since we upgraded a Symfony site from 1.0 to 1.2 - the emails being logged to the database were being mangled.

The problem turns out to be simply that the symfony 1.2 swToolkit plugin uses Zend Mail instead of phpMailer and Zend Mail spits out encoded text when you ask it for the email text or HTML contents.

So the simple fix is to wrap the data you get out of Zend Mail with the obscure quoted_printable_decode() function as shown here:

$message = quoted_printable_decode($zendEmail->getBodyHtml()->getContent());
$text = quoted_printable_decode($zendEmail->getBodyText()->getContent());

There, that gets rid of all those =0D=0A characters everywhere!

Note that you would think you could avoid this simply by passing the line ending explicitly, but it does not work:

//this does *NOT* work!
$message = $zendEmail->getBodyHtml()->getContent("\r\n");
$text = $zendEmail->getBodyText()->getContent("\r\n");

Sendmail woes

Dan — Thu, 14 Jan 2010 03:46:12 GMT

I have battled postfix, qmail and sendmail for years - and my latest trouble involved sendmail trying to route emails to local (non-existant) users, even though the domains in question were not in the local domains config.

After running around in config circles for a couple of hours it turns out that if you set the server's hosts to include your domains, sendmail will assume local delivery for those domains.

That is even if you have sendmail configured not to (ie: in /etc/mail/local-host-names). It even ignores your virtusertable with explicit instructions to forward mail for those domains elsewhere.

Go figure. Hope this helps someone.

Restore single table from HUGE mysqldump file

Dan — Wed, 18 Nov 2009 07:23:20 GMT

That's one of the problems with 'enterprise' websites - huge databases. Knowing that everything is backed up, it is occasionally tempting to run some ad-hoc handmade 'looks about right' SQL statements every now and then - and occasionally they don't work out too well.

As it happens, restoring a table from a 5GB SQL backup can actually be a pretty time consuming task, not to mention tedious.

Faced with this slightly daunting task I did what I usually do when faced with daunting tasks - checked how other people did it :)

So a big thanks to ThatsLinux for sharing a nice little shell script that takes the pain out of extracting one little table from a mammoth sql script. Kudos.

ThatsLinux

Chrome Explorer

Dan — Fri, 25 Sep 2009 00:41:19 GMT

All right now Google are installing Chrome inside Internet Explorer so now Microsoft can claim to have a standards compliant browser. But what I'm excited about is viewing it all inside Firefox with the ieTab plugin!

That's Firefox rendering Internet Explorer rendering Chrome.

Now somebody create a chrome plugin that uses the Opera rendering engine or - even better - the Firefox rendering engine!

Whoop!

Integrated framework commands

Dan — Tue, 15 Sep 2009 23:32:12 GMT

When I get the urge to run a symfony command from an explorer window I have a few options...

Command prompt here
Well this is handy but you still have to type out your command. Fortunately I have PowerCmd which lets you save common commands and make them toolbar buttons.

Directory Opus
My favourite explorer replacement lets me type commands directly into the toolbar - and it *remembers* the history of commands. Nice.

XYplorer
Another good file manager - and a bit more lightweight than Directory Opus - has a great scripting engine. Check this out:

::if (confirm("propel-build-ALL?!")){
run 'php symfony propel-build-all',
}

That's not bad. And you can make it a favourite (category) that will execute on the current activated folder. Again, nice.

PhpEd
Well this isn't exactly an explorer replacement, but seeing as though I never close my IDE it is technically a file manager ;) And as I posted here, you can add scripts to the right-click menu. The biggest drawback is that you can't put < characters in your scripts, which means you can't load sql files into mysql without requiring a seperate DOS batch file.

Modify view for an environment

Dan — Thu, 27 Aug 2009 11:26:52 GMT

This is something that has been discussed in the Symfony google groups but was unresolved - how to modify a view configuration based on the environment. Some developers say you should not be doing this, as the view should be the same in all environments, but let me explain why I needed do do it...

I have some javascripts loaded from google to speed up my sites - anyone who has used the Yahoo YSlow plugin for FireBug will be familiar with the "F" rating for content delivery networks (CDN) score. But I have a developer on my team who works offline and wants to be able to develop locally without having to constantly modify all the view.yml files (and there are a few!) for each app.

So, although it would be nice to be able to specify an environment in the view.yml the same way you can in the settings.yml, some folks forget that you can put PHP code in your view.yml to be evaluated at runtime (or at least read from the cache at runtime!).

So, this is how we manage to serve google's minified high speed Javascript libraries in the "live" environment but use local copies elsewhere:

default:
 javascripts:
    - 
    -

Damn, that was easy, wasn't it?
:-)

Scalability and frameworks - Part 2

Dan — Sun, 09 Aug 2009 12:58:09 GMT

Well, in case you were wondering, I managed to get around my scalability problem by focussing on PHP's strengths and side-stepping it's weaknesses. So in this particular problem I was facing 2 primary bottlenecks - yaml parsing and propel memory leaks.

I got around the yaml issue by using some custom string hacking - and PHP's string functions are pretty quick. By using split() and strpos() I could slice up my big yaml file into more digestible sizes (see previous post).

The propel issue, however, was always going to be more problematic. I considered removing all my ORM calls and either using delayed inserts or LOAD DATA INFILE statements. Both of which I have used successfully in the past, but implementing it in this case meant a complete rewrite of over 2000 lines of tested code.

So, I decided to use a similar approach to the ORM. Like YAML, Propel 1.2 is very good at what it does inside small to medium processes. It just isn't very efficient when used in big jobs - like inside large loops. So instead of trying to process my massive array that I managed to construct from the original yaml, I sliced it up and sent smaller yaml files back into the queue.

What this means is that instead of having a single item of 13,000 recipients sitting in the queue I have 130 items of 100 instead. My queue processing task can now batch 100 emails at a time and then terminate, thereby freeing up memory for the next batch. While there is some extra overhead in writing files to disk and duplicating some of the yaml, the benefits are well worth it. The end result is a scalable, fast and robust system that can handle almost any request by simply slicing it up into manageable chunks. TIme and money saved, client happy :)

Scalability and frameworks

Dan — Fri, 07 Aug 2009 21:26:08 GMT

This is a problem I often come up against - sending email to thousands of recipients. The way I usually handle it is to do as little as possible in the master loop.

The best technique I have found is to defer database writes by writing to a temporary textfile in memory (using php://memory) and then using LOAD DATA INFILE to write contents to the database. That puts all the email data into a database queue, allowing a cron task to send the emails - say 50 per minute.

Using this technique I can send 50,000+ emails quite easily. The queue function takes under a minute to run and the cron job hacks away at the queue for about 24 hours or so.

The problem I have with this technique is that it evolved via a process of whittling away at the various framework layers used in my "enterprise applications". Framework layers supposedly designed to provide scalability.

Now you can probably tell from this blog that I use Symfony extensively (although I have dabbled with other frameworks, I always come back to Symfony). Perhaps it is due to the fact that my largest projects (over 1,000,000 lines of code) are locked into Symfony 1.0 and - more importantly - Propel 1.2. Arguably, what I should be doing is writing a Symfony plugin that performs large data processing using the techniques I've described, but it seems a shame to have a detailed, documented and unit-tested ORM that can only be used for serving small jobs like "web pages", and must be bypassed for any data intensive stuff. Isn't that a core requirement of "enterprise level" scalability?

Anyway, I'll try to end the rant with some code. Last night I wrote a custom yaml parser because the sfYaml::load() method in Symfony 1.0 (which uses spyc) was taking over 20 minutes to load a 1MB yaml file. I managed to load it in about 5 seconds. Now, I'll admit it's not really a yaml parser but more of a key-pair extractor but because it doesn't use any regex it is waay faster than the old sfYaml.

(NB: I couldn't install syck on my CentOS4 server and the newer sfYaml component from 1.2 failed to load yaml collections in the format shown below).

The yaml (multiply this by 10,000):

Recipients:
  - title: 'Mr'
    firstname: 'Bob'
    lastname: 'Dobbs'
    company: 'Subgenius Network'
    email: 'bob@subgenius.com'
  - title: 'Mrs'
    firstname: 'Jane'
    lastname: 'Dobbs'
    company: 'Subgenius Network'
    email: 'jane@subgenius.com'

The recipient extractor method:

  public static function extractRecipients($yaml)
  {
    //separate recipients from yaml
    $recipients_string = "Recipients:";
    $recipients_start = strpos($yaml,$recipients_string);
    $recipients_end = strpos($yaml,"bcc:");
    $recipients_yaml = substr($yaml,$recipients_start,
                      ($recipients_end-$recipients_start));
    $yaml_start =  substr($yaml,0,$recipients_start);
    $yaml_end =  substr($yaml,$recipients_end);
    $yaml = $yaml_start . $yaml_end;
    
    //load yaml
    $yaml_array = sfYaml::load($yaml);
    
    //get recipients array
    $recipients_yaml = str_replace($recipients_string,"",
                       $recipients_yaml);
    $recipients_array = split("-",$recipients_yaml);
    //loop over recipients to get getails as array
    $recipients_list = array();
    foreach ($recipients_array as $r1) {
      //loop over each line item
      $r1_array = split("\r\n",$r1);
      $my_recipient = array();
      foreach ($r1_array as $r2) {
        if (strpos($r2,":")!==false){
          //extract key pair from line item
          $r2_array = split(":",$r2);
          if (sizeof($r2_array) == 2){
            $key = str_replace("''","'",
                   trim(trim($r2_array[0]),"'"));
            $value = str_replace("''","'",
                     trim(trim($r2_array[1]),"'"));
            $my_recipient[$key] = $value;
          }
        }
      }
      if (sizeof($my_recipient) > 1){
        //add this recipient to list
        $recipients_list[] = $my_recipient;
      }
    }
    //add recipients to yaml data
    $yaml_array[trim($recipients_string,":")] = $recipients_list;
    
    //return yaml data
    return $yaml_array; 
  }

BugFeatures blog open for comments!

Dan — Thu, 30 Jul 2009 23:35:18 GMT

I have enabled comments on the blog after a few requests for it... play nice!

Symfony and PhpBB3 integration

Dan — Thu, 30 Jul 2009 22:56:49 GMT

I recently had to integrate a forum into a Symfony 1.0 app and, having selected PhpBB3 for the job, went about writing an authentication module. Here's how...

1. Create the auth module

Lets say I want to call the module 'symfony'. I create a file called auth_symfony.php and drop it in the phpbb /includes/auth folder.

2. Write the autologin method

Because I want my forums to be on the same domain, I have saved the phpbb files in web/forum. This way I have access to the session variables stored in my symfony app. So when a user goes into the forums, the autologin method can be used to interrogate my smyfony session.

In a nutshell, the autologin method needs to verify the user's session, grab their details and log them into phpbb. So as to avoid having to manage forum users from my symfony app, I also create new phpbb users here if one doesn't already exist for the current user.

Note that phpbb needs its own session, so we need to switch between sessions here as well.

/**
* Autologin function
*/
function autologin_symfony()
{
  include_once('includes/functions_user.php');
  global $db, $config, $user;

  $sess = session_name();
  session_name('symfony');
  session_start();
  
  $sfSession = $_SESSION['symfony/user/sfUser/attributes']['userData'];

  @session_name($sess);
  @session_start();

  
   if (isset($_REQUEST['admin'])){
    $_SESSION['admin'] = $_REQUEST['admin'];
   }


  if (isset($_SESSION['data'])){
   return $_SESSION['data'];    
  }elseif (!isset($sfSession['username']) && 
    !isset($_SESSION['admin'])){
    header("Location: /");
    exit;
  }elseif (isset($sfSession['username'])){
    $user_row = array(
      'username'              => $sfSession['username'],
      'user_password'         => phpbb_hash($sfSession['username']),
      'user_email'            => $sfSession['email'],
      'user_type'             => USER_NORMAL,
      'group_id'              => 2
    );
    
    $sql ='SELECT *
      FROM ' . USERS_TABLE . "
      WHERE user_email = '" 
       . $db->sql_escape(utf8_clean_string($sfSession['email']))
       ."'";
    $result = $db->sql_query($sql);
    $row = $db->sql_fetchrow($result);
    $db->sql_freeresult($result);

    if ($row){  
      // Successful login...
      $data =  array_merge($row,array(
        'status'       => LOGIN_SUCCESS,
        'error_msg'    => false,
        'autologin'    => 1,
        'user_row'     => $row
      ));
      $_SESSION['data'] = $data;
      return $data;
    }else{
      //check for existing name
      $sql ='SELECT *
      FROM ' . USERS_TABLE . "
      WHERE username_clean = '" 
       . $db->sql_escape(utf8_clean_string($sfSession['username']))
       ."'";
      $result = $db->sql_query($sql);
      $row = $db->sql_fetchrow($result);
      $db->sql_freeresult($result);
       if ($row){
         //randomise username if duplicate found
         $user_row['username'] = $user_row['username'] 
         . " - " . rand(1000,9999);
       }
      //create new user
      $user_id = user_add($user_row); 
      $user_row['user_id'] = $user_id;
      $data = array_merge($user_row,array(
        'status'      => LOGIN_SUCCESS_CREATE_PROFILE,
        'error_msg'   => false,
        'autologin'   => 1,
        'user_row'    => $user_row,
        'user_type'   => USER_NORMAL,
        'group_id'    => 2
      ));
      $_SESSION['data'] = $data;
      return $data;
    }
  }
}

Note also that the $_SESSION['data'] array is used to avoid hitting the database everytime the user loads a new page in phpbb.

3. Create admin login

You might have noticed that the above code looks for a session var called 'admin'. I use this to track whether a user has come from the backend. This is used to display the phpbb login form. Otherwise the user is simply sent back to the symfony app login.

/**
* Login function
*/
function login_symfony($username, $password)
{   
  global $db, $config, $user;

     $sql ='SELECT * FROM ' . USERS_TABLE 
       . " WHERE username_clean = '"
       .$db->sql_escape(utf8_clean_string($username))
       ."' and user_password = '".md5($password)."'";
    $result = $db->sql_query($sql);
    $row = $db->sql_fetchrow($result);
    $db->sql_freeresult($result);

    if ($row){
      
      $data = array_merge($row,array(
        'status'      => LOGIN_SUCCESS,
        'error_msg'   => false,
        'user_row'    => $row
      ));
      
      $_SESSION['data'] = $data;
      return $data;
      
    }else{
  
      return array(
        'status'    => LOGIN_ERROR_PASSWORD,
        'error_msg' => 'LOGIN_ERROR_PASSWORD',
        'user_row'  => array('user_id' => ANONYMOUS),
      );
    }
}

4. Create logout method

This simply wipes both sessions and redirects the user to the symfony app homepage.

/**
* Logout function
*/
function logout_symfony($user_row)
{
  $sess = session_name();
  session_name('symfony');
  session_start();
  session_destroy();
  
  @session_name($sess);
  @session_start();
  @session_destroy();
  header("Location: /");
  exit;
}

5. Create validate session method

Last but not least this method is used to check that the current user session is valid. Not 100% required, but a good precaution.

/**
* Validate session function
*/
function validate_session_symfony()
{
  $sess = session_name();
  session_name('symfony');
  session_start();
  $auth = $_SESSION['symfony/user/sfUser/authenticated'];
  
  @session_start($sess);
  @session_start();
  //always redirect to home
  $admin = isset($_SESSION['admin']);
  if ($admin || $auth){
    return true; 
  }
  
  return false;

}

6. Configure

You'll need to log into the phpbb ACP and set the authentication module to your custom module. Then you need to bypass symfony in the .htaccess for the /forum URL

RewriteRule ^forum/.*$ - [PT]
RewriteCond %{REQUEST_URI} !^/forum

And that's basically it :)

Something nice to say about EFI-X

Dan — Thu, 23 Jul 2009 07:48:57 GMT

A lot of people moan about EFI-X so I thought I'd tell a good story. I got my EFI-X chip about 6 months ago. After a botched OS X 10.5.7 update the chip fried. I sent it back. In the interim I toyed with every OSx86 kernel out there without any success. Then today my chip arrived back from Taiwan (desplite the "made in Holland" insignia). I popped it back into the PC and installed OSX again from a retail DVD first time no trouble at all. To be honest, I doubted I'd ever see that chip again, but now I'm feeling better...

Send JWPlayer flashvars from shadowbox

Dan — Wed, 22 Jul 2009 03:52:51 GMT

Shadowbox is a great way to play FLV videos in a lightbox, but it is a little shortsighted in terms of the parameters it expects you'll want to pass onto JWPlayer. So here's a little workaround I came up with.

If you want to send a playlist position and repeat variable you need to modify the shadowbox-flv.js file as follows:

var D=["file="+this.obj.content,"height="+F,"width="+I,
"autostart="+C,"displayheight="+K,"showicons="+H,
"backcolor=0x000000","frontcolor=0xCCCCCC","lightcolor=0x557722",
'repeat='+(this.obj.repeat?this.obj.repeat:'false'),
'playlist='+(this.obj.playlist?this.obj.playlist:'none')]

Then you can send the params from your JS code:

 Shadowbox.open({
        player:     'flv',
        title:      'FLV',
        content:    'playlist.xml',
        height:      400,
        width:       550,
        autostart:   true,
        repeat:     'list',
        playlist:   'right'

    });

Die IE6 DIE6!

Dan — Tue, 14 Jul 2009 21:39:25 GMT

I look forward to the day IE6 is wiped from the face of the internet like doomsday cults await their rapturous glory. I have read rumours - and I tend to agree - that IE6 is costing the world economy millions of dollars - I would like to see the figure properly researched, it could be billions!

Slowly we see big sites like YouTube phasing out IE6 support, slowly. Alas, I have client sites with 20% of visitors using IE6 so the end is not yet in sight...

The Tech Crunch story

What Ajaxian had to say about it

Join the list of sites not supporting IE6

OnChange Radio Buttons - Symfony, Prototype and me

Dan — Sun, 12 Jul 2009 22:18:46 GMT

Using Symfony's observe_field() on radio buttons will work only the first time the value is changed. If a user changes the values more than once the onchange event stops firing. To get around this you need to use the onclick event instead (as observer_field() uses onchange - and to support keyboard events you need to add an onkeyup handler as well).

A solution was posted at Symfony nerds in the comments suggesting a hardcoded onclick Ajax call in the radiobutton() method. I suggest using the remote_function() instead to simplify the code, avoid duplication and allow the helper to do the work. After all, that's what helpers are for...

echo radiobutton_tag(
  "tt_product",
  1,
  true,
  'onclick=toolPref(1)'
); 
?>

   echo javascript_tag("
     function toolPref(val){
       ".remote_function(array(
       'url'  => 'user/tallypref',
       'with' => "'tally_product='+val"))."
     }"
   );
  ?>

MySQL Replication - what to do when a slave fails

Dan — Wed, 08 Jul 2009 05:16:47 GMT

Thought this was worth posting as it could save someone a lot of grief. I had a slave MySQL server stop updating without warning. A SELECT SLAVE STATUS showed there was an error due to an existing record. This would have occurred when a SELECT DATA INFILE populated 50,000 records and things went a little haywaire. The solution was quite simple:

1. STOP SLAVE;
2. TRUNCATE TABLE table_name;
3. START SLAVE;

This wipes out all data in the table with errors and allows the master to rebuild it from scratch. If you have foreign keys you might need to turn them off first...

Using gmail SMTP with Swift Mailer

Dan — Mon, 06 Jul 2009 06:06:16 GMT

Want your web app to send email from your gmail or google apps hosted email account? This way your messages are stored in your sent box. Here's how to do it with a failover to localhost (in case there is a problem with the gmail server or authentication)...


      try{
        $connection = new Swift_Connection_SMTP(
          sfConfig::get("app_gmail_host"), 
          Swift_Connection_SMTP::PORT_SECURE, 
          Swift_Connection_SMTP::ENC_TLS
        ); 
        $connection->setUsername(sfConfig::get("app_gmail_username"));
        $connection->setPassword(sfConfig::get("app_gmail_password"));
        $connection->attachAuthenticator(
          new Swift_Authenticator_PLAIN()
        );
        $mailer = new Swift($connection);
        $mailer->disconnect();
        echo "Using gmail..." . PHP_EOL;
        unset($mailer);
      } catch (Exception $e)    {
        echo "Using localhost..." . PHP_EOL;
        $connection = new Swift_Connection_NativeMail();      
      }
      
      //use our working mailer
      $mailer = new Swift($connection);

Note you need to disconnect, destroy and recreate your SMTP mailer or else gmail will accuse you of trying to change identity!

Assign an environment to a subdomain in Symfony

Dan — Mon, 08 Jun 2009 01:55:07 GMT

I have a couple of symfony sites that my clients like to test without messing up their data (go figure). By modifying the controller a little I can detect the subdomain from the URL and then switch the syfmony environment accordingly. Then, using a filter, I can put a demo stylesheet in place to make the site look different as well...

By using this technique you can have exact copies of an application without duplicating a single file!

Step 1 - Set up the subdomain

Create a new subdomain in the DNS and configure apache to accept it as an alias for the live site.


  ServerName site.com
  ServerAlias www.site.com demo.site.com
  DocumentRoot "/var/www/"

Step 2 - Create a new database for the subdomain and configure the databases.yml file


test:
  propel:
    class:          sfPropelDatabase
    param:
      dsn:          mysql://root:pass@localhost/live

demo:
  propel:
    class:          sfPropelDatabase
    param:
      dsn:          mysql://root:pass@localhost/demo

Step 3 - Modify the controller

Symfony 1.0:

//check for DEMO site
$env = "live";
$debug = false;
$domain = $_SERVER['HTTP_HOST'];
if (strpos($domain,"demo") !== false){
  $env = "demo"; 
  $debug = true;
}

define('SF_ROOT_DIR',    realpath(dirname(__FILE__).'/../..'));
define('SF_APP',         'my_app');
define('SF_ENVIRONMENT', $env);
define('SF_DEBUG',       $debug);

Or in Symfony 1.2:

$configuration = ProjectConfiguration::getApplicationConfiguration('my_app', $env, $debug);
sfContext::createInstance($configuration)->dispatch();

Step 4 - Create the filter

My favourite bit - save it in your lib folder:

 
class demoFilter extends sfFilter
{
  public function execute ($filterChain)
  {   

    if (SF_ENVIRONMENT == "demo" && $this->isFirstCall())
    {
      $this->getContext()->getResponse()->addStylesheet('demo','last');
    }
 
    // execute next filter
    $filterChain->execute();
  }
}
?>

Step 5 - Add your stylesheet & images etc

The above filter adds demo.css to each page, so create the file and any images it requires and upload to your existing css and images folders and you're done.

Working with MySQL replication in PHP

Dan — Tue, 26 May 2009 02:03:59 GMT

I recently set up mySQL replication for a client and thought I'd share this quick and easy way of distributing database load over a few machines.

First, set up replication - it's very simple. Here's a simplified list of tasks based on the info at mysql.com:

http://forums.gentoo.org/viewtopic.php?t=241123

Then you need to adapt your site to use the master server for all write operations and distribute the read load across your slaves (and master if you like).

My setup was moving from a single server to 2 servers. The primary server runs apache and the master database. The secondary server takes all the database read traffic (high CPU low bandwidth) and also serves up media files (low CPU high bandwidth).

The way I set up the config for the databases was to allow for failover from the slave back onto the master. Now this site was built in 2003 and uses some very old PEAR classes (remember PEAR? ;-), but you get the idea:

$options = array(
'debug'       => 2,
'portability' => DB_PORTABILITY_ALL,
);

$dsn = array(
'phptype'  => 'mysql',
'username' => def_user,
'password' => def_pass,
'hostspec' => def_host,
'database' => def_dbname,
);

$db_master =& DB::connect($dsn, $options);
if (PEAR::isError($db_master)) {
  showError($db_master->getMessage());
}
$db_master->setFetchMode(DB_FETCHMODE_OBJECT);


//use 2nd database server if available
//otherwise duplicate original as failover
if (defined('def_host2')){
  $dsn2 = array(
  'phptype'  => 'mysql',
  'username' => def_user2,
  'password' => def_pass2,
  'hostspec' => def_host2,
  'database' => def_dbname2,
  );
  $db =& DB::connect($dsn2, $options);
  if (PEAR::isError($db)) {
    $db = $db_master;
  }else{
    $db->setFetchMode(DB_FETCHMODE_OBJECT);
  }
}else{
  $db = $db_master;
}

Then the next step was to modify the pages that included DELETE, UPDATE or INSERT queries to use $db_master instead of $db. The whole process took a little over an hour and the site was only offline for 20 minutes :)

Add Symfony CLI commands to PhpEd

Dan — Mon, 20 Apr 2009 00:51:32 GMT

How to add a Symfony command to PhpEd:

1. Menu: Tools->Settings
2. Go to Tools -> Integration
3. Click "Add Menu"
4. Enter "Symfony cc" in menu name
5. Select "Shell" from Execute with list
6. Enter php @ProjRoot@/symfony cc in command line
7. Select checkbox next to "Show this command in Workspace" group
8. Deselect "for files" checkbox
9. Select "for directories and projects"

Save and then try right-clicking on a project to run your command from the context menu.

You can also direct the output of the command line back into PhpEd's log panel - this is a good way to ensure your CLI commands are executing without errors - as the windows command prompt has a tendency to flash and disappear before your eyes...

Abort PHP cron job if another job is running

Dan — Thu, 02 Apr 2009 10:13:05 GMT

This has come in handy for a couple of mail queues I have built and thought it was worth sharing. Basically it's a small check for PHP in the running system processes. If *any* PHP script is running (besides itself) we abort the script. It would be nice to know *which* script was running but I haven't managed to do that yet :)

if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN') {
  //windows, can't do thread detection
  $threads = 1;
}else{
  //check for PHP PID and abort
  $pids = preg_split('/\s+/', `ps -o pid --no-heading -C php`);
  $threads = 0;
  foreach($pids as $pid) {
    if(is_numeric($pid)) {
      $threads++;
      echo "Process " . $pid." found\r\n";
    }
  } 
}