- Ian Bullard asserts that you should never use the RAND() function. The Ayn Rand Google Ad is pretty funny.
- The new Zend Server is coming out as a web stack. Although it can be easier to install a Xampp style web stack on your development machine, if you’re a web developer, you’re better off installing each component separately. In the long run it’s less buggy in my opinion, and what you learn in the process of doing it yourself is priceless.
- With the Zend Framework 1.75 release, Zend View has an important security fix in it, that is somewhat incompatible with previous version. Check it out if you are upgrading.
- Google has finally lost some market share…to Yahoo!. Despite all the bad press Yahoo! has gotten lately, they have some great Semantic Web products. Including Search Monkey, which I plan to post about soon in anticipation of our Semantic Web Meetup next week with Peter Mika presenting.
- Eric Meyer provides feedback on some long awaited CSS3 features. It will be very cool to use shapes in css.
- Congratulations to WordPress on their new datacenter.
- Interesting to learn (via Baron) that there’s a MySQL Federal Migration Bootcamp. Good idea. I hope to soon see a “Don’t Waste Taxpayer’s Bailout Money Bootcamp” too
- Sad to hear that Ma.gnolia lost all their data. A good DBA and backup strategy is vital to the success of any startup. Very impressive that it was basically a one man operation though. Kudos for getting as far as he did…
Since I’m creating a new install of a development environment on an XP gaming machine, I thought I’d just document the process for posterity.
- Make sure you are running at least Service Pack 2.
- Here is the version I’m installing: http://www.apache.org/dist/httpd/binaries/win32/apache_2.2.11-win32-x86-no_ssl.msi
- I won’t repeat details that are on other websites already, so just follow the instructions from here, then I’ll tell you what I did differently
- Instead of adding “php5apache2.dll” to “LoadModule php5_module”, since we are on Apache 2.2, point it to filename “php5apache2_2.dll”.
- Install Webyog. Make sure to search for the community edition. While phpMyAdmin is great, it can be buggy sometimes and you should really develop with a proper client.
- Download the all in one Eclipse Zend PDT package.
- Download Zend Framework.
- Install phpMyAdmin. When you configure it, you may get complaints about mcrypt, bzip2, timezone and zip not being enabled. Fix it all and more by editing php.ini and
// change the following lines from ...
// ... to
extension = php_bz2.dll
extension = php_zip.dll
date.timezone = America/Los_Angeles
(note that you should pick your own timezone)
- I chose to enable mysqli extensions (extension=php_mysqli.dll) and disable mysql. Also, you may want to enable the pdo and pdo_mysql extensions.
- For development, it’s best to turn this on in php.ini:
error_reporting = E_ALL | E_STRICT
- Depending on how your application is used, you may want to turn on short tags:
short_open_tag = On
- Add include path to Zend library in php.ini…e.g.
include_path = ".;C:\Documents and Settings\Administrator\My Documents\Zend\ZendFramework-1.7.5\library"
- To make sure that index.php shows in case there is no index.html, go to httpd.conf, and under <IfModule dir_module> add “index.php” after “index.html”.
- In httpd.conf, uncomment
# Virtual hosts
then add your path to docroot to that file
- If you are setting up more than one docroot, and you probably are going to do this if you’re installing Eclipse and Zend Framework, you need to configure the proper directives for the .htaccess to work, so find the Directory section and copy this part to httpd.conf:
# Possible values for the Options directive are "None", "All",
# or any combination of:
# Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
# Note that "MultiViews" must be named *explicitly* --- "Options All"
# doesn't give it to you.
# The Options directive is both complicated and important. Please see
# for more information.
Options Indexes FollowSymLinks Includes ExecCGI
# AllowOverride controls what directives may be placed in .htaccess files.
# It can be "All", "None", or any combination of the keywords:
# Options FileInfo AuthConfig Limit
# Controls who can get stuff from this server.
Allow from all
- Make sure to enable mod_rewrite in httpd.conf:
LoadModule rewrite_module modules/mod_rewrite.so