CodeIgniter Temel Veritabanı İşlemleri (CRUD) - I

Tablo:

announcements

[sourcecode language="sql"]

CREATE TABLE IF NOT EXISTS `announcements` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(50) NOT NULL,
`body` text NOT NULL,
`date` int(11) NOT NULL,
`status` char(1) NOT NULL,
`position` varchar(10) NOT NULL,
`color` varchar(15) NOT NULL,
`password` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[/sourcecode]

Dizin Yapısı:

application/models/announcements_model.php
application/views/announcements/recors.php
application/views/announcements/form.php
application/controllers/announcements.php
application/libraries/layout.php
application/views/layout_main.php
/css/style.css