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 ......
Tuesday, December 30, 2008
Subscribe to:
Post Comments (Atom)
great way for doing scaffolding bro. Thanks a lot.
ReplyDeleteCan you please explain , how do you create CRUD based pages for a test DB?
ReplyDeleteThanks
Vinay
Hey i got it.
ReplyDeleteThanks a lot.
Vinay