Oracle Press

PHP Database Class
Fri, 24 May 2013 05:25:28 +0000
PHP namespaces are new to PHP 5.3 (2012), but PHP class files have been around since PHP 5 was introduced. However, a couple students had problems creating working code from the many fragments published else where. Here’s my attempt to qualify it in a single post, running Zend Server Community Edition 6 and Oracle Database [...]

MySQL Book in Chinese
Fri, 24 May 2013 03:58:06 +0000
One of my old students and lab assistants stopped by to show his fiancée the BYU-Idaho campus. It was a long trip since he lives in Macao, China. He kindly brought me a copy of my Oracle Database 11g and MySQL 5.6 Developer Handbook in simplified Chinese. He’s holding it in the photo. That makes [...]

Zend 6 & Timezones
Thu, 23 May 2013 17:21:53 +0000
Just went through all my PHP testing against a fresh instance of Oracle with Zend Server Community Edition 6, and found these warnings, guess that’s pretty clean for the Oracle part of the installation. I didn’t notice it before because generally I do most of my PHP development against a MySQL database. I should have [...]

ActivePerl on Windows
Fri, 26 Apr 2013 16:48:25 +0000
I actively maintain virtual test instances for my writing and teaching on Windows 7, Red Hat Enterprise Linux, Fedora, and Solaris. Perl on Windows is always interesting. I use ActivePerl on Windows 7 rather than Strawberry Perl, and it was interesting to see this note after I upgraded to the most current Community Edition of [...]

MySQL Triggers with Logging
Fri, 26 Apr 2013 05:01:10 +0000
Somebody asked why you can’t implement MySQL triggers that write information when you want to stop the DML statement, like autonomous procedures in Oracle. The question was a surprise but I didn’t find anything on it, so here’s how you can do it. This is more or less like an autonomous process by leveraging both [...]

MySQL 5.6 Install Steps
Thu, 25 Apr 2013 20:00:05 +0000
My install instructions on the web site were old, somebody wanted me to publish another set of screen capture for the MySQL 5.6 install and configuration. This is it for Windows 7 using the downloadable MSI file. Installation Steps The installation from MySQL’s perspective is actually the installation and configuration of MySQL. For your convenience [...]