See, this job is importing data from a huge XML file into MySQL. After it is done, we want to compare the data we just added/updated to the data in the table so we can deactivate any data we did not update. [...] We then compared the two arrays by looping one array and using in_array() to check if the value was in the second array. [...] So, that was running for hours with about 400k items. Our data did not contain the value as the key, but it could as the value was unique.

He method, replacing the in_array call that had to do a full array scan for each time through the loop with an isset/unset combo on the unique key, changed the execution time down from about 4 hours to 0.8 seconds.

I recently came by this site WorldTimeEngine where users can search the local time of any place using the name, street address or just latitude and longitude. Since that time I was thinking how easily you can make your own. As long there are some good people over there (For Geocoding API) - its a not a big deal, you know?

His script pulls the location of the place (latitude/longitude) from the Yahoo! geocoding API and passes that back into the geonames web service to get the local time. The result is an array with the lat/long, address you submitted and the time output in a standard string.

I understood the merits of the approach, but it struck me that a relative time might be a little more useful for many situations. For example, in a fast moving discussion, a short timestamp (e.g. 8:30 AM) as well as a verbal summary of how long ago the time was (e.g. "4 hours ago", "20 minutes ago") are most useful to the user. [...] Now, I figured this could be achieved very easily in PHP - and it could.

His code is included showing a series of if/else comparisons that change the values to their hour/minute/second counterparts. He also recommends the PEAR Numbers_Words package to help with readability.

There are 4 relatively easy ways by which you can speed up the time it takes a browser to download a page. Following on from my post on joining CSS and JavaScript files, I have written a PHP script which will automatically do all of the above.

He gives example code of the class in action and includes some screenshots of the benchmarks from the YSlow Firefox extension showing the improvements.

Cal Evans from the Zend DevZone - being the awesome guy that he is - has graciously offered to mail out to the first 10 people who donate to PHPWomen $50 or more, a PHP elePHPant. Yep - you get one of the hard to find and much sought after plushy PHP elePHPants.

You can find out more about the goals for their fund raising in this other post to the PHPWomen.org blog as well as information on submitting whatever you feel like donating (time or money).

I'm going back to the basics here, you know, when you wrote your first PHP script and saw an ugly-ass error message pop up on your screen? Error messages are the best tool a programmer has.

She talks about how to set up the error reporting first, making sure that you're getting things up and useful. From there she describes some of the common errors that you might see including:

• Parse errors
• MySQL Result source errors
• Stream errors
• Max Execution Time errors

Check out the rest of the post for more types.

One of the relatively new features in PHP 5.2, is the DateTime class/functions. It has a few useful functions (date_parse, date_date_set, date_time_set etc) which make dealing with dates and times easier (date_parse provides some useful error info too).

He also mentions the ability of the functionality to handles dates before 1970 or after 2038, a common problem with PHP's native date functionality. He illustrates how it's useful by describing the change they made in Propel store DateTime objects instead of the integer timestamps like before.

Minify is a PHP library that attempts to fix this problem by combining multiple CSS or JavaScript files into one download. By default, it also removes comments and unnecessary whitespace to decrease the amount of data that must be sent to the browser. Most importantly, it does all of this on the fly and requires only a few simple changes to your existing web pages.

He gives a before and after example of the things it can do - mainly combining multiple tags (like link and script) and their information into one. Check out its page on the Google Code site for more information.

So started Donald McArthur's work on creating a simple, easy to use calendaring system to be used in a popup inside an application. He provides all the code you'll need - the PHP code and the HTML layout/functionality you'll need to get it working.

He helps you visualize the structure of the end result HTML table with a simpler version (three cells by five cells) and explains the date functions the code uses to figure out the dates and days of the selected month.