Save data to the database using Form in Cakephp

Question

I’m trying to make a tool for the administrator, the site I’m building, that will allow you to upload images to a folder on the server, so that they appear posthumously in the gallery. The image upload is working correctly, however its name is not entered in the database. This should be inserted in the "gallery_images" table, in the "path" field. How to solve this problem?

I’m using Cakephp 2.4.4

Controller

    <?php
class AdminsController extends AppController{

    public $components = array('RequestHandler');
    public function admin_index(){
        if(!$this->Session->check('Admin')){
        $this->Session->setFlash('Está a aceder a uma zona restrita. Por favor faça Login.');
        $this->redirect(array(
                                'controller' => 'admins',
                                'action' => 'login'));
        }
        $this->layout='admin_index';
    }
    public function add_foto() {            
        if(!$this->Session->check('Admin')){
        $this->Session->setFlash('Está a aceder a uma zona restrita. Por favor faça Login.');
        $this->redirect(array(
                                'controller' => 'admins',
                                'action' => 'login'));
        }
        $this->layout='admin_index';
        $file=$this->request->data['gallery_images']['path'];
        if($this->request->is('post') || $this->request->is('put')){
                $this->Admin->create();
            $this->Admin->save($file);
            move_uploaded_file($this->data['gallery_images']['path']['tmp_name'], $_SERVER['DOCUMENT_ROOT'] . '/html/PushUp_app/app/webroot/img/gallery/' . $this->data['gallery_images']['path']['name']);
                     if($this->Admin->save($this->request->data)){
                     $this->Session->setFlash(__('Ficheiro carregado com sucesso!'));
            }
        }
        //$this->Admin->id = $id;
        //$this->Post->save($data=array($this->data['Admins']['path']), $params=array('fieldList'=>'path'));
        //$this->Post->saveField('path', $this->data['Admins']['path']);
            /*if ($this->ModelName->save($this->request->data)) {
                $this->Session->setFlash('Data Saved!');
            }*/
        //if($this->request->is('post')){
        //  $this->Admin->save($this->request->data);
            //}
        //}
    }
}
    ?>

View

    <h2>Adicionar Fotografia</h2>
    <?php
echo "<br>";
echo $this->Form->create('Admin',array('type'=>'file'));
echo $this->Form->file('gallery_images.path');
echo "<br>";
//echo $this->Form->submit();
echo $this->Form->end('Guardar');

    ?>

Table gallery_images

Table admins

Código Certo

Controller

    <?php
    class GalleryController extends AppController {

    public function admin_upload_image(){
        $this->layout = 'admin_index';
        if($this->request->is('post') || $this->request->is('put')) {
          /*  $file = $this->request->data['gallery_images']['path']['name'];*/
        $file = array(
                'GalleryImage' => array(
                'path' => $this->request->data['gallery_images']['path']['name']
                                        )
                );
            move_uploaded_file($this->data['gallery_images']['path']['tmp_name'], $_SERVER['DOCUMENT_ROOT'] . '/html/PushUp_app/app/webroot/img/gallery/' . $this->data['gallery_images']['path']['name']);

            $this->loadModel('GalleryImage');
            $this->GalleryImage->create();

            if($this->GalleryImage->save($file)){
                $this->Session->setFlash(__('Ficheiro carregado com sucesso!'));
            }
            else{
                $this->Session->setFlash(__('Erro ao carregar o ficheiro!'));
            }
        }
    }
}
?>

View

    <h2>Adicionar Fotografia</h2>
    <?php
echo "<br>";
echo $this->Form->create('GalleryImage',array('type'=>'file'));
echo $this->Form->file('gallery_images.path');
echo "<br>";
//echo $this->Form->submit();
echo $this->Form->end('Guardar');

    ?>

Model

    <?php
App::uses('AppModel', 'Model');
class GalleryImage extends AppModel{
    public $displayField ='path';
    public $useTable = 'gallery_images';
}
    ?>

Answer 1

Let’s go in pieces.

1 - Who is your Model?

• Admin?
• gallery_images?

If it is gallery_images is completely incorrect by Cakephp standards.

The right thing would be Galleryimage.

---

2 - You are trying to save the image in which MODEL?

In the Admin model?

If it is in the Admin, you must fix your array $file, to meet your need:

$file = array(
  'Admin' => array(
    'path' => $this->request->data['gallery_images']['path']['name']
  )
);

Remembering that you should validate yourself in your model Admin has the property:

public $table = 'gallery_images';

In the Galleryimage model?

If it is Galleryimage, should also corrode it:

$file = array(
  'GalleryImage' => array(
    'path' => $this->request->data['gallery_images']['path']['name']
  )
);

Remembering that I’m a model Galleryimage should follow the model below:

<?php
App::uses('AppModel', 'Model');
/**
 * GalleryImage Model
 *
 */
class GalleryImage extends AppModel {

  public $displayField = 'name';
  public $useTable = 'gallery_images';

}

---

3 - why to change the $file?

From what I understand, in your code you’re doing the following:

$file = $this->request->data['gallery_images']['path']['name'];

With this you created a variable with 1 value x and is saving her.

The problem is you’re not telling Cakephp, what field is this, much less to which Model belongs. Then the right thing would be:

$file = array(
  'NomeDoModel' => array(
    'nome_do_campo' => 'valor_do_campo'
  )
);

With this you’ve assembled/created the array correctly and Cakephp can now understand that you want to save fields A, B and C in the X model.

---

4 - Why are you running 2 birds? [Doubt]

In your code you run $this->Admin->save($file); and then $this->Admin->save($this->request->data);.

I really don’t understand the need for this. But what you’re doing is:

• Insert
• Update of the already inserted record

---

5 - Image upload

I recommend using the library Wide Image to upload, upload and resize your images.

It’s incredibly easy to implode in Cakephp, whether or not it’s integrated with commiserate.

6 - Code corrected**

Your code should look something like this, depending on whether you’re using the model Admin or Galleryimage, whether the last lines (save) are correct or not:

public function add_foto() {            
  if(!$this->Session->check('Admin')) {

    $this->Session->setFlash('Está a aceder a uma zona restrita. Por favor faça Login.');
    $this->redirect(array(
      'controller' => 'admins',
      'action' => 'login'));
  }

  $this->layout = 'admin_index';

  $file = array(
    'GalleryImage' => array(
      'path' => $this->request->data['gallery_images']['path']['name']
    )
  );

  if($this->request->is('post') || $this->request->is('put')) {

    $this->loadModel('GalleryImage');
    $this->GalleryImage->save($file);

    move_uploaded_file($this->data['gallery_images']['path']['tmp_name'], $_SERVER['DOCUMENT_ROOT'] . '/html/PushUp_app/app/webroot/img/gallery/' . $this->data['gallery_images']['path']['name']);

    // Não sei o que você está tentando fazer aqui, por isso comentei o código
    // if($this->Admin->save($this->request->data)) {
      $this->Session->setFlash(__('Ficheiro carregado com sucesso!'));
    //}

  }
}

---

---

---

Administrative Routes

Based on the assumption that there is a clear difficulty regarding the understanding of administrative area (Administrative Routes), I will try to explain the correct way in the simplest and most practical way possible how it really works.

Setting up the main route /admin

Let’s say you wanted the route /admin is only visible to users present in the group (profile) Administrator, and with it, display login when accessing any sub-route.

To make this work as well as possible, we will use prefixes.

What you must do then is... in your app/Config/routes.php, add the following code:

Router::connect('/admin', array('controller' => 'pages', 'action' => 'dashboard', 'admin' => true));

So I’m saying: when accessing the url http://www.example.com/admin, Cakephp should call the action dashboard controller’s pages, but this route has the admin prefix before the name, which would be in case this:

class PagesController extends AppController {
  public function admin_dashboard() {
    // código aqui
  }
}

Configuring other administrative routes

Besides, let’s say this one user in the Administrator group, can also upload images (Galleryimage). So let’s create the action:

class GalleryImagesController extends AppController {
  public function admin_upload_image() {
    // código aqui
  }
}

class GalleryImage extends AppModel {
  public $table = 'gallery_images';
  public $displayField = 'name';
  // código aqui
}

With that we have the route:

http://www.example.com/admin/gallery_images/upload_image

If you wanted to customize this route, just do the following on your Routes:

Router::connect('/admin/galeria-de-imagens/enviar', array('controller' => 'gallery_images', 'action' => 'upload_image', 'admin' => true));

With that we now have the route:

http://www.example.com/admin/galeria-de-imagens/enviar

To create more administrative routes on different controllers, just follow the example above.

Limiting access only to logged in users

But doing just that I’m making sure of something? NAY!.

Now we have to tell app/Config/AppController.php, administrative routes require login. For this we will use 2 methods:

-beforeFilter() of Cakephp himself -isPrefix() only to help get the current URL prefix

public function beforeFilter() {
  if($this->isPrefix('admin')) {

    // Seta o layout admin para as rotas administrativas
    $this->layout = 'admin';

  } else {

    // Utilizando o método abaixo, permite o acesso as URLs 
    // sem o login (Auth do CakePHP)
    $this->Auth->allow();

  }
}

public function isPrefix($prefix) {
  return isset($this->request->params['prefix']) 
    && $this->request->params['prefix'] == $prefix;
}

Briefly explaining the above code: beforeFilter (which is called before call action) checks which URL prefix is called using the method isPrefix. After detecting the URL, it checks whether the prefix is admin, if it is, arrow the layout admin, if access to all urls through the method $this->Auth->allow();.

Clearly, for this to work you must have yours Auth configured in the AppController, as in the example below:

public $components = array(
  'Auth' => array(
    'authenticate' => array(
      'Form' => array(
        'fields' => array('username' => 'password')
      )
    ),
    'loginAction' => array('controller' => 'users', 'action' => 'login', 'admin' => false),
    'logoutAction' => array('controller' => 'users', 'action' => 'logout', 'admin' => false),
    'loginRedirect' => '/admin',
    'logoutRedirect' => array('controller' => 'users', 'action' => 'login', 'admin' => false),
    'authError' => 'Acesso não permitido.'
  ),
  'Session',
  'RequestHandler',
  'Paginator'
);

With everything configured as shown above, your Urls using the prefix admin are secure, IE, need user login.

Limiting only users of the Administrator group

The simplest way to do this to meet your need is as follows.

Change the method beforeFilter() for him to check the group_id of the logged in User (if it is logged in of course), and if it is the id desired, you allow access to URL.

public function beforeFilter() {
  if($this->isPrefix('admin')) {

    // Com a instrução abaixo, eu verifico se o usuário está logado
    if ($this->Auth->loggedIn()) {

      // Se estiver, verifico se está setado o group_id dele
      if ($this->Session->check('Auth.User.group_id')) {

        // Se ele tem um group_id, verifico se é igual ao desejado
        // Por exemplo: id do Administrador = 1
        if ($this->Session->read('Auth.User.group_id') == 1) {

          // Permite que ele acesse a URL

        } else {

          // Não permite o acesso a URL e redireciona o usuário
          // para uma página específica, neste caso a raiz do site
          $this->Session->setFlash(__('Você não tem permissão para acessar essa URL'));
          $this->Redirect('/');

        }
      }
    }

    // Seta o layout admin para as rotas administrativas
    $this->layout = 'admin';

  } else {

    // Utilizando o método abaixo, permite o acesso as URLs 
    // sem o login (Auth do CakePHP)
    $this->Auth->allow();

  }
}

I believe that’s it.

It’s long, but I think you can now follow the right path using Cakephp

---

I hope it helped.

Any questions, please insert a comment below.