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 ......
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