CakePHP is an open source PHP framework built around Model-View-Controller (MVC). We will begin to create a small application that will do some basic Create, Read, Update, Delete (CRUD) operations on our database.

View, add, edit and delete functionality. You can download the full tutorial here.

Step1: The Database Structure

To create a database and table:

  1. CREATE TABLE IF NOT EXISTS `demomovies` (
  3. `id` char(36) NOT NULL,
  5. `title` varchar(255) DEFAULT NULL,
  7. `genre` varchar(45) DEFAULT NULL,

  9. `rating` varchar(45) DEFAULT NULL,
  11. `format` varchar(45) DEFAULT NULL,
  13. `length` varchar(45) DEFAULT NULL,
  15. `created` datetime DEFAULT NULL,
  17. `modified` datetime DEFAULT NULL,
  19. PRIMARY KEY (`id`)
  21. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  1. INSERT INTO `demomovies` (`id`, `title`, `genre`, `rating`, `format`, `length`, `created`, `modified`) VALUES
  3. ('54d9874c-ae74-4451-b54a-14f01bafaffa', 'secondfirst', 'sdfsd', '4.5', 'sdf', 'sdf', '2015-02-10 05:21:32', '2015-02-10 05:34:01'),
  5. ('54d98aa7-d65c-40cd-8b7f-14f01bafaffa', 'second', 'firest', '5.4', 'dsf', 'sadf', '2015-02-10 05:35:51', '2015-02-10 05:35:51');
    Step 2: Create Model, Controller and View

    Create a demomovie.php file and save it in the following path.

    C:\xampp\htdocs\cakephp_example\app\Model

    Open the demomovie.php file.

    1. <?php
    2. class Demomovie extends AppModel {
    4. var $name = 'demomovie';
    6. var $validate =array(

    8. 'title' =>array(
    10. 'alphaNumeric' =>array(
    12. 'rule' => array('minLength',2),
    14. 'required' => true,
    16. 'message' => 'Enter should be minimum 2 only')
    18. ),
    20. 'genre' =>array(
    22. 'alphaNumeric' =>array(
    24. 'rule' => array('minLength',4),
    26. 'required' => true,
    28. 'message' => 'Enter should be minimum 4 only')
    30. ),
    32. 'rating' =>array(
    34. 'alphaNumeric' =>array(
    36. 'rule' => array('minLength',2),
    38. 'required' => true,
    40. 'message' => 'Enter should be minimum 4 only')
    42. )
    44. );
    46. }
    48. ?>
    Save it.

    Controller

    Create DemomoviesController.php and save it in the following path.

    C:\xampp\htdocs\cakephp_example\app\Controller


    Open DemomoviesController.php files and paste in the following code.

    1. <?php
    2. class DemomoviesController extends AppController {
    4. public $components = array('Session');
    6. public function index()
    8. {
    10. $movies = $this->Demomovie->find('all');
    12. $this->set('demomovies', $movies);
    14. }
    16. public function add()
    18. {
    20. if (!emptyempty($this->data)) {
    22. $this->Demomovie->create($this->data);
    24. if ($this->Demomovie->save()) {
    26. $this->Session->setFlash('The movie has been saved');
    28. $this->redirect(array('action' => 'add'));
    30. } else {
    32. $this->Session->setFlash
    34. ('The movie could not be saved. Please, try again.');
    36. }
    38. }
    40. }
    42. public function delete($id = null)
    44. {
    46. if (!$id) {
    48. $this->Session->setFlash('Invalid id for movie');
    50. $this->redirect(array('action' => 'index'));
    52. }
    54. if ($this->Demomovie->delete($id)) {
    56. $this->Session->setFlash('Movie deleted');
    58. } else {
    60. $this->Session->setFlash(__('Movie was not deleted',
    62. true));
    64. }
    66. $this->redirect(array('action' => 'index'));
    68. }
    70. function edit($id = null) {
    72. if (!$id && emptyempty($this->data)) {
    74. $this->Session->setFlash('Invalid movie');
    76. $this->redirect(array('action' => 'index'));
    78. }
    80. if (!emptyempty($this->data)) {
    82. if ($this->Demomovie->save($this->data)) {
    84. $this->Session->setFlash('The movie has been saved');
    86. $this->redirect(array('action' => 'index'));
    88. } else {
    90. $this->Session->setFlash('The movie could not be saved. Please, try again.');
    92. }
    94. }
    96. if (emptyempty($this->data)) {
    98. $this->data = $this->Demomovie->read(null, $id);
    100. }
    102. }
    104. function view($id = null) {
    106. if (!$id) {
    108. $this->Session->setFlash('Invalid movie');
    110. $this->redirect(array('action' => 'index'));
    112. }
    114. $this->set('movie', $this->Demomovie->findById($id));
    116. }
    118. }
    120. ?>
    View

    Create a Demomovies folder.

    C:\xampp\htdocs\cakephp_example\app\View

    Create add.ctp , edit.ctp , index.ctp , view.ctp files

    C:\xampp\htdocs\cakephp_example\app\View\Demomovies

    Set route

    Open routes.php with the following pat.

    1. Router::connect('/', array('controller' => 'demomovies', 'action' => 'index', 'home'));

    Save it.

    The following are screen shots of view, add, edit, and delete.

    View

    Add


    Edit

    After edit form: