Claus Witt

A couple of weeks ago I had to rename the file extension of several view scripts from html (from my own mvc framework) to phtml (zend framework). I found, as always, bash to be my friend.

for i in *
do
  ( file $i | grep html ) && mv $i $(echo $i | sed s/html$/phtml/)
done

I have just used 20 minutes on testing my php5 skills before taking the actual certification exam in the future.

Exam Result

As expected, by me at least, I lack some skills in arrays, string manipulation and regular expressions. I knew this. I always look up details when I use this. Database access questions are all based on PDO, which I have never used – so no surprise there either. What Web Features and Design covers, I do not know? But I am happy that I have an excellent grade in the things I use everyday.

The overall rating was however that I passed, which I find a bit strange, since 5 out of twelve subjects were failed. Well, I know which subjects I have to study before taking the actual exam.

With the excellent PHPExcel library it is possible to write Excel data to Google Docs Spreadsheets. Maarten Balliauw has written a post about Saving a PHPExcel spreadsheet to Google Documents a method which uses the ZEND_GData module from Zend Framework.