Tuesday, December 30, 2008

Step by Step

1. create database
CREATE TABLE IF NOT EXISTS `post` (
`id` int(10) unsigned NOT NULL auto_increment,
`sysuser_id` int(10) unsigned NOT NULL,
`title` varchar(100) NOT NULL,
`content` text NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `sysuser` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`logon` varchar(50) NOT NULL,
`password` varchar(32) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2.
- download program zip file.
- unzip to a folder.


3.
- select your framework's generator (codeigniter_generator.php), also change the the setting.




4.
- run command "php codeigniter_generator.php".


5.
after run "php codeigniter_generator.php", it will create MVC folder and file.
copy to codeigniter controllers, models and views folder.









6.
edit codeigniter
system\application\config\autoload.php
from
$autoload['libraries'] = array();
to
$autoload['libraries'] = array('database');

system\application\config\config.php
$config['base_url'] = "http://{i dont know wo}/";

system\application\config\database.php
$db['default']['username'] = "i dont know wo";
$db['default']['password'] = "i dont know wo";
$db['default']['database'] = "i dont know wo";

system\application\config\routes.php
from
$route['default_controller'] = "welcome";
to
$route['default_controller'] = "sysuser";

7.
list page.



create page.


validator.


foreign key field's selection box.


and ......

3 comments:

  1. Anonymous9/2/09 09:15

    great way for doing scaffolding bro. Thanks a lot.

    ReplyDelete
  2. Anonymous17/9/09 20:34

    Can you please explain , how do you create CRUD based pages for a test DB?

    Thanks
    Vinay

    ReplyDelete
  3. Anonymous17/9/09 20:38

    Hey i got it.

    Thanks a lot.

    Vinay

    ReplyDelete