CakePHP Working with Database - CakePHP

How to work with Database using CakePHP?

Running with database in CakePHP could be very clean. we will apprehend the CRUD (Create, read, update, Delete) operations on this chapter. before we continue, we need to create the following users’ table within the database.

CREATE TABLE users ( id int(11) NOT NULL AUTO_INCREMENT, username varchar(50) NOT NULL, password varchar(255) NOT NULL, PRIMARY KEY (id) ) ENGINE = InnoDB AUTO_INCREMENT = 7 DEFAULT CHARSET = latin1

similarly, we additionally need to configure our database in config/app.php report.

Insert a Report

To insert a document in database, we first need to get hold of a table the usage of TableRegistry elegance. we are able to fetch the instance out of registry the usage of get() approach. The get() method will take the name of the database table as a controversy.

This new example is used to create new entity. Set essential values with the example of recent entity. we've to name the save() technique with TableRegistry elegance’s instance with the intention to insert new document in database.

Example

Make changes in the config/routes.php report as shown inside the following software.

config/routes.php

<?php use CakeCorePlugin; use CakeRoutingRouteBuilder; use CakeRoutingRouter; Router::defaultRouteClass('DashedRoute'); Router::scope('/', function (RouteBuilder $routes) { $routes->connect('/users/add', ['controller' => 'Users', 'action' => 'add']); $routes->fallbacks('DashedRoute'); }); Plugin::routes();

Create a UsersController.php record at src/Controller/UsersController.php. replica the following code in the controller record.

src/controller/UsersController.php

<?php namespace AppController; use AppControllerAppController; use CakeORMTableRegistry; use CakeDatasourceConnectionManager; use CakeAuthDefaultPasswordHasher; class UsersController extends AppController{ public function add(){ if($this->request->is('post')){ $username = $this->request->data('username'); $hashPswdObj = new DefaultPasswordHasher; $password = $hashPswdObj->hash($this->request->data('password')); $users_table = TableRegistry::get('users'); $users = $users_table->newEntity(); $users->username = $username; $users->password = $password; if($users_table->save($users)) echo "User is added."; } } } ?>

Create a listing customers at src/Template and below that directory create a View report called upload.ctp. replica the following code in that report.

src/Template/Users/add.ctp

echo $this->Form->create("Users",array('url'=>'/users/add')); echo $this->Form->input('username'); echo $this->Form->input('password'); echo $this->Form->button('Submit'); echo $this->Form->end();

Execute the above example through travelling the subsequent URL.

http://localhost:85/CakePHP/customers/add

Output

Upon execution, you may obtain the following output.