Zend Framework Tutorial 1 - Start here

November 15, 2006 on 4:26 pm | In Zend Framework | No Comments
After the infrastructure has been set up, I start my project. At the very beginning, I would like make the thing as simple as possible. Only one table in the database at this moment.

Due to the restriction by my web host, I only can name the database as

backupdi_bmdb

I only can change the part after ‘backupdi_‘,namely bmdb for this case.

The table name will be

bm_bmark

which I can name it myself. bmbmark is made of the first alphabet of book and mark. So, the MySQL schema would be stands for bookmark,

Code (mysql)
  1. CREATE DATABASE `backupdi_bmdb`;
  2. CREATE TABLE `bm_bmark` (
  3.   `bm_id` BIGINT(20) NOT NULL,
  4.   `bm_name` VARCHAR(64) DEFAULT NULL,
  5.   `bm_url` VARCHAR(128) DEFAULT NULL,
  6.   `bm_kword` VARCHAR(20) DEFAULT NULL,
  7.   `bm_des` VARCHAR(128) DEFAULT NULL COMMENT ‘Description’,
  8.   `bm_atime` DATETIME DEFAULT NULL COMMENT ‘add time’,
  9.   `bm_lmtime` DATETIME DEFAULT NULL COMMENT ‘last modify time’,
  10.   `bm_lvtime` DATETIME DEFAULT NULL COMMENT ‘last visit time’,
  11.   PRIMARY KEY  (`bm_id`)
  12. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  13.  

Save this SQL schema file as mysql_schema.sql to \bookmark\app\install


Infrastructure 2 - get the ZF and setup the file structure

November 14, 2006 on 2:53 pm | In Zend Framework | 1 Comment


On Windows XP,download Zend Framework from here . On linux command line,

  • $ wget hppt://framwork.zend.com/download/tgz
  • $ tar-zvxf ZendFramework-0.2.0.tar.gz

Note: use the right version to replace 0.2.0 if it is updated. Continue reading Infrastructure 2 - get the ZF and setup the file structure…

Infrastructure 1 - LAMP and WAMP

November 13, 2006 on 9:00 pm | In Zend Framework | 2 Comments

In this "Quick Start" post, I would like introduce my developing environment first. As an open source developer, I believe this part is very important and sometime it is crucial. Ok, long story short, I have four work places:

  • Web host
    • Linux (so far, I don’t what distribution and version it is)
    • Apache 1.3.37
    • PHP 5.1.6
    • MySQL 5.0. 24

This configuration is out of my control, The web host told me that I only have two choices, php4 package or php5 package. For the sake of the requirement of Zend Framework, I have to choose php5. That means I have no choice. BTW, a lot of web hosts still use Apache 1.3.37, the last stable version of Apache Version 1, so does mine.

  • My host
    • Fedora Core 3
    • Apache 1.3.37
    • PHP 5.1.6
    • MySQL5.0.24

This is the Linux server that is running at my home. All configurations keep the same with the web host except the Linux distribution and version. Because of two reasons:

    • I don’t know what Linux box my web host uses
    • Before I upload my application into my web host, I use this as my final test bed
        • Dev1
          • Windows XP Pro SP2
          • Apache 2.0.59
          • PHP 5.1.6
          • MySQL 4.1.13
        • Dev2
          • Windows XP Home SP2
          • Apache 1.3.37
          • PHP 5.1.6
          • MySQL 5.0.26

        I intentionally use diversified version of WAMP(Windows,Apache, MySQL, PHP. This is my invention. By far,I’ve not found anyone uses it ,(sorry, when I do a google search, there are a lot of WAMP, I am not the first person use it, update Nov 17, 2006 ) on my Windows boxes because I want to see if my applications are robust.
        Note: Zend PlatForm 2.2.2/2.2.3 can not work with PHP 5.2.0 under windows XP,you may download php 5.1.6 from here

Since May 6,2007 We have Visitors
dog ramps

Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds. Valid XHTML and CSS. ^Top^