Difference between revisions of "6CC001 Workshop - week 04"
From mi-linux
Jump to navigationJump to searchLine 15: | Line 15: | ||
(17, 'Test 1', 'Hello world!', '2009-07-27 15:06:29'), | (17, 'Test 1', 'Hello world!', '2009-07-27 15:06:29'), | ||
(18, 'Test 2', 'Hiya', '2009-07-27 15:06:38'); | (18, 'Test 2', 'Hiya', '2009-07-27 15:06:38'); | ||
+ | </pre> | ||
+ | |||
+ | == Create index.php file == | ||
+ | |||
+ | <pre> | ||
+ | // The index simply calls the front controller | ||
+ | require("Controller.php"); | ||
+ | Controller::run(); | ||
</pre> | </pre> | ||
Revision as of 15:10, 27 July 2009
Main Page >> Web Application Development >> Workbook >> Week 04
Create and populate database
CREATE TABLE IF NOT EXISTS `messages` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL, `message` text NOT NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ; INSERT INTO `messages` (`id`, `title`, `message`, `date_added`) VALUES (17, 'Test 1', 'Hello world!', '2009-07-27 15:06:29'), (18, 'Test 2', 'Hiya', '2009-07-27 15:06:38');
Create index.php file
// The index simply calls the front controller require("Controller.php"); Controller::run();
Create Registry class
//############################################################################ // Registry class, used to store values to be used across whole application //############################################################################ class Registry { private static $values = array(); //############################################################################ // Store a value //############################################################################ static function set($key, $val) { self::$values[$key] = $val; } //############################################################################ // Get a value //############################################################################ static function get($key) { if(isset(self::$values[$key])) { return self::$values[$key]; } return null; } }